session failing Saving part of data to database failed.

Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V

session failing Saving part of data to database failed.

Veeam Logoby phillbl » Wed Mar 19, 2014 4:33 am

Hi,

i am trying to add a vcloud vcentre server to my veeam one installation but iget the following issues when trying to run the seesion to collect stats Saving part of data to database failed. See 'C:\Users\user\AppData\Local\Veeam\Veeam ONE\SchedulingService.log' for details.

from checking the logs it looks like the follwoing is the issue:
INSERT statement conflicted with the FOREIGN KEY constraint "FK_ObjectProperty_Object". The conflict occurred in database "VeeamOne", table "reporter.Object", column 'ID'

i am using sql 2012 enterprise. I have already got one vcentre server that is part of another vsphere installation that works with no issues. I am using 7.0 and i also tried updating to the latest version that supports 5.5 etc and still the same issues when trying to run the session to collect data. I As its not critical i have uninstalled and started from scratch and i still have the same issue. I also have a call logged with support but no luck so far and givin the time difference i seem to have with support we can only get a couple of hours looking at this so just thought i would put it here to see if anyone else has any suggestions.

i have 4 data collections:

data collection vcloud - works
data collection vmware vcentre server (cloud vcentre) - fails
data collection vmware vcentre server - works
data collection backup - works

http://www.veeam.com/kb1638 is for version 6 so does not apply.

i also get this error which maybe related EXCEPTION: Operation failed. The index entry of length 1292 bytes for the index 'IX_Object' exceeds the maximum length of 900 bytes.

Thanks
phillbl
Enthusiast
 
Posts: 37
Liked: 5 times
Joined: Wed Jul 17, 2013 1:57 am
Full Name: phill

Re: session failing Saving part of data to database failed.

Veeam Logoby Vitaliy S. » Wed Mar 19, 2014 6:13 am

Hi Phil,

Can you please tell me your support case number, so that I could take a look at the latest logs?

Thank you!
Vitaliy S.
Veeam Software
 
Posts: 19546
Liked: 1100 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: session failing Saving part of data to database failed.

Veeam Logoby phillbl » Wed Mar 19, 2014 9:12 pm

hi, case number is 00529816

thanks
phillbl
Enthusiast
 
Posts: 37
Liked: 5 times
Joined: Wed Jul 17, 2013 1:57 am
Full Name: phill


Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 5 guests