Symptom
- Error messages appear during the execution of the "online database DB" command after restoring the database.
- online of database 'DB' an invalid cross-database reference with constraint id <ID> was found in the 'sysreferences' system * The referencing and referenced database ids are IDDB1
and IDDB2 respectively. - The error messages indicate invalid cross-database references with various constraint IDs found in the 'sysreferences' system catalog.
- Despite the error messages, the database is successfully brought online.
- The user seeks assistance in removing these error messages.
Read more...
Environment
Sybase ASE Database Platform
Product
SAP Adaptive Server Enterprise all versions
Keywords
invalid cross-database reference, sysreferences error, database restoration, sybase ase, online database command, constraint error, drop constraint, restore database, load database, foreign key constraint, database IDs mismatch , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview