SAP Knowledge Base Article - Preview

3683108 - Invalid cross-database reference error during online database - SAP ASE

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.