cancel
Showing results for 
Search instead for 
Did you mean: 

VBR 6.6.2 - A217: S0: Data rejected by server - SQL Anywhere Error -194: No primary key value for foreign key

Hello there,

We got the error as shown below on our VBR 6.6.2 and this error is  showing on "Show Agent Data Transmission Problems".  I had done the Load under the Force Load many times and the error will disappear and then it re-appears again after data collected.

Does any knows what this error is and is there a fix or resolution for it?

----------------
A217: S0: Data rejected by server: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: SQL Anywhere Error -194: No primary key value for foreign key 'backupSubJobDirectoryObjectID_fk' in table 'BackupSubJob'
-------------------

Help is much appreciated.
1 Solution

Accepted Solutions
Accepted Solution!

A case was opened with Symantec and the problem finally fixed

A case was opened with Symantec and it took a long time and finally the problem was fixed by running series of SQL queries.

View solution in original post

4 Replies

Does this TechNote help?

Any old cruft in your spooler directory?

Spooler Files from previous versions of VBR are not processed by upgrade version if remaining in spooler directory
 
http://support.veritas.com/docs/327606

Good luck!

Worked for me!

I tried these steps to remove the error I was seeing & this method cleared out the error.

Thanks smiley

There was no old spool files

Originally VBR server was used as an agent for the backup master and we deleted spool files from spooler directly many times but did not solve the problem.  Then we made a media server into agent for the same backup master but the problem still there.
Accepted Solution!

A case was opened with Symantec and the problem finally fixed

A case was opened with Symantec and it took a long time and finally the problem was fixed by running series of SQL queries.

View solution in original post