Resolution:
Environment:
= = = = = = =

TIBCO Product name and version: TIBCO Collaborative Information Manager 8.x
Operating System(s): All Operating Systems

Symptoms:
= = = = = =

The following error is reported while accessing the Synchronization Profiles page in the TIBCO Collaborative Information Manager User Interface:

Unexpected error. Class: 'com.tibco.mdm.ui.repository.syncprofile.CatalogEditionListServlet' and method name: 'list'. Additional information: <MqException: BEGIN>
Code: CAT-1030

Cause:
= = = =

The error indicates that there might be a corrupt synchronization profile in this enterprise.  In order to resolve this issue you will need to:

1). Identify that Synchronization Profile.
2). Remove it from your system.

Resolution:
= = = = = =

To identify that Synchronization Profile, you will need to look into the elink.log file covering the error.  In the elink log, search for the following string:

com.tibco.mdm.ui.repository.syncprofile.CatalogEditionListServlet - CAT-1030

Just above the line containing this string you should see the following (or similar) log entries:

=====
2010-09-06 11:51:09,324 [http-0.0.0.0-8080-2] DEBUG com.tibco.mdm.session.repository.syncprofile.CatalogEditionSsnBean - Found this catalogedition value in cache, id  and Version = 37739, 1
2010-09-06 11:51:09,324 [http-0.0.0.0-8080-2] DEBUG com.tibco.mdm.infrastructure.db.MqDebuggableStatement - Executing Query [ SELECT id, sourceOrganizationID,  name, description, ctSourceOrganizationID, catalogTypeID, active, modmemberid, moddate,  modversion, systemgenerated, productCount, logFile, type, tablename   FROM catalog c1 WHERE    id = -1 AND modversion = ( select max(modversion) from catalog c2 where c1.id = c2.id )]
=====

In the above section it can be seen that the SQL does not return anything which is the cause of the problem.  (The problem is likely because of Sync Profile ID: 37739)

Repeat the search and collect all of the problematic sync profile IDs.

Once the IDs of the problematic sync profile are found, remove them from UI as follows:

UPDATE CATALOGEDITION SET ACTIVE='N' WHERE ID=37739 (run this query for all the sync profiles)

Attachments:
= = = = = = =
None

References:
= = = = = =
None

Error while accessing the Synchronization Profiles page.“Unexpected error. Class:”