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