Parameter is not valid. Failed to open Veeam Backup and Replication.

KB ID:
1079
Product:
Veeam Backup & Replication
Version:
4.x
Published:
Last Modified:
2013-05-02

Challenge

Backup and Replication won't open, but jobs will still continue to run.  Error occurs when opening the Veeam Software.  

"Parameter is not valid"


When opening the Veeam.Backup.Shell.exe, the following error occurs: Parameter is not valid
 

User-added image

When you press OK, the service will shut off again, and Backup and Replication will not open.  Jobs will continue to run in this state.

Cause

The number of sessions in the sessions history within the Veeam database become so large that Veeam fails to start with described error message box.

Solution

To workaround the problem you may use the following script. The script will delete sessions history but it will keep the information about last 1000 session from the database.

Code: 

declare @bsess as table([id] uniqueidentifier)

insert into @bsess(id)
select b.id from BSessions b where b.id not in
(
      select top 1000 id from BSessions order by creation_time DESC
)

delete BSessionInfo
where session_id in (select id from @bsess)

delete BSessions
where id in (select id from @bsess)


To run the script you may use SQL management studio or you may also follow next steps:

1. Stop Veeam services

2. Save the file to any file, "script.sql" for example.

3. Run the following command: sqlcmd -S COMPUTER\INSTANCE -d VeeamBackup -i
PATHTOSCRIPT\script.sql -o c:\resetresult.txt

where COMPUTER is the name of computer with database, INSTANCE is the name of instance (VEEAM for default installation), PATHTOSCRIPT is the path to the script.

4. Start the services

More Information

As always, Veeam recommends backing up the database before running the SQL script as a precaution.

Please be aware that we’re making changes which will restrict access to product updates for users without an active contract.

OK

Rate the quality of this KB article: 
5 out of 5 based on 1 ratings

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.

Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Spelling error in text:

Submit