After migrating to TIBCO Collaborative Information Manager 8.0, adding related record throws "Catalog 0 not found" error.
book
Article ID: KB0088827
calendar_today
Updated On:
Products
Versions
TIBCO Collaborative Information Manager
-
Not Applicable
-
Description
Resolution: Description: ============
After migrating to TIBCO Collaborative Information Manager 8.0, adding related record throws "Catalog 0 not found" error.
Environment: ========== TIBCO Product name and version: TIBCO Collaborative Information Manager 8.0.0
Operating System(s): ================= All Operating Systems
Symptoms: ======== After migrating to TIBCO Collaborative Information Manager (CIM) 8.0, the following error is thrown for the use case below:
1). Add a record 2). Click Relationship tab 3). Click on a self-contained relationship 4). Click create record
It gives a "Catalog 0 not found" error.
Cause: ====== The RELATIONSHIPCATALOGID column in the RELATIONSHIPDEFINITION table for the relationships is NULL.
Resolution: ======== To resolve this issue, please try the following steps:
1). Run the following sql on the CIM database schema. UPDATE RELATIONSHIPDEFINITION SET RELATIONSHIPCATALOGID = -1 WHERE RELATIONSHIPCATALOGID IS NULL; COMMIT; 2). Restart the application server.
Issue/Introduction
After migrating to TIBCO Collaborative Information Manager 8.0, adding related record throws "Catalog 0 not found" error.