Parameter is not valid

[lillebi]

When I try to start Veeam Backup console, it comes with the following error:
“Parameter is not valid” (see the attached picture) and the program closes.
When I logged on the Veeam Backup server I noticed that the Veeam Backup console was opened (because I did not close it the other day).
All the backup jobs that I have created were started, even though I have scheduled all jobs to end before another starts.
The Veeam Backup console was “frozen” so I had to force a close.
When I looked after Veeam Backup snapshots of our virtual machines, there were none. So the running Veeam Backup jobs were not real. The Veeam Backup console was “frozen” so I had to force a close.
I have tried to reboot the Veeam Backup server, and repaired the Veeam Backup 4.0 installation, but it did not help.
Is there a way to fix this, or do I have to reinstall everything from scratch?

[Vitaliy S.]

Hello Brian

Have you already opened a support case with us? If no, please open a support ticket with our technical team directly, as it is hard to troubleshoot the issue without seeing full logs and the error screenshot.

Thanks!

[lillebi]

I found the solution:

In case the number of sessions in the sessions history become large Veeam fails to start with described error message box.
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: Select all

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. Save the file to any file, "script.sql" for example.

2. 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.

[Vitaliy S.]

Yes, that script can help if you have a very large number of session records in Veeam DB. Glad that you're up and running now.