https://login.veeam.com/en/oauth?client_id=nXojRrypJ8&redirect_uri=https%3A%2F%2Fwww.veeam.com%2Fservices%2Fauthentication%2Fredirect_url&response_type=code&scope=profile&state=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2IxMDc5IiwiaGFzaCI6IjEwMDRiZjdjLTk2YzItNDBlYi05ZDE2LTM3NjBkM2JhMDJmZCJ9
1-800-691-1991 | 9am - 8pm ET
EN

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

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.

KB ID:
1079
Product:
Veeam Backup & Replication
Version:
4.x
Published:
2011-07-19
Last Modified:
2020-08-13
Please rate how helpful this article was to you:
5 out of 5 based on 1 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.

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

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.
Your report was sent to the responsible team. Our representative will contact you by email you provided.
We're working on it please try again later