After migrating to TIBCO Collaborative Information Manager 8.0, adding related record throws "Catalog 0 not found" error.

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.