A fresh install of TIBCO Active Catalog (AC) 1.2 hotfix 3 on top of TIBCO Collaborative Information Manager (CIM) 8.1.0 hotfix 3 onward leads to an error at the end of the install process that, if ignored, causes AC 1.2 event triggering / workflow firing to fail and hence make AC 1.2 unusable.

If the update errors are ignored, AC 1.2 fails to correctly select and fire workflows after triggering events, so that the whole install becomes unusable.  This is due to an omission in the install documentation and a failure of the deleteDuplicateproductkeys.sh script to detect duplicates in that table


 

Product: TIBCO ActiveCatalog Version: 1.2 OS: Redhat Enterprise Linux 5.x CIM 8.1.0 hotifx 3 onward AC 1.2 hotfix 3

When installing AC 1.2 hotfix 3 from scratch:

1). In ConfigValues.xml, in addition to creating the VELODBTEMP tablespace to handle the temporary tables, there also needs to be created an entry for the VELODBTEMPINDX tablespace to handle temporary table indexes:

&ltConfValue description="The value is the name of a newly created tablespace name, which has to be created by the DBA in case the 'Table Space Create Privilege' has not been enabled. All temporary tables are created will be in this table space." name="Temporary Table Space Name" propname="com.tibco.cim.temp.tablespace" sinceVersion="8.1" visibility="Basic">
    &ltConfString default="VELODBTEMP" value="VELODBTEMP"/>
</ConfValue>
&ltConfValue description="The value is the name of a newly created tablespace name, which has to be created by the DBA in case the 'Table Space Create Privilege' has not been enabled. All temporary table indexes are created will be in this tablespace." name="Temporary Table Index  Table Space Name" propname="com.tibco.cim.temp.indx.tablespace" sinceVersion="8.1" visibility="Basic">
    &ltConfString default="VELODBTEMPINDX" value="VELODBTEMPINDX"/>
</ConfValue>


2). When installing Active Catalog 1.2 Hotfix 3 the deleteDuplicateproductkeys.sh SQL script fails to detect dupicate entries in the PRODUCTKEYS table, so that the subsequent required db_migration81HF3.sh shell script also fails.  Using an SQL execution tool suitable for your database, first check the PRODUCTKEYS table, manually removing any duplicate entries using DELETE / COMMIT, and then execute the following:

CREATE UNIQUE INDEX XIE2PRODUCTKEY ON PRODUCTKEY
{
CATALOGID ASC,
UPPER("NAME") ASC,
UPPER("EXTENSION") ASC
}
TABLESPACE VELODBINDX1;
INSERT INTO release VALUES ('AC 1.2 HF 3','AC 1.2 HF3','Release AC 1.2 HF 3',sysdate);
COMMIT;

Provided you have already removed all (and only) duplicate entries, the above should work correctly and produce the desired outcome for installing AC 1.2 hotifx 3.

As a footnote:

a). You may need to check the ActiveSpaces configuration to make sure it is correct for CIM 8.1.0.  In particular, if using Rendezvous for ActiveSpaces multicasting, using rendezvous for ActiveSpaces multicasting, check the following are correctly defined in COnfigValues.xml:

ActiveSpaces metaspace: 'cim_ms'
ActiveSpaces multicast URL: 'tibrv://7600/;;/7600'  (7600 will likely need replacing with the value appropriate for the system where CIM / AC is being installed)

b). The correct ActiveSpaces spaces, defined in ConfigValues.xml for CIM 8.1.0 / AC 1.2 are:

DATASOURCE, RULEENGINEATRIBUTEINFO, CATALOGFORMATS, ENTERPRISE, CODEDEFNS, RELATIONSHIPMETADATA, RECORDCOLLECTION, CATALOGEDITIONVALUE, WORKITEMFORM, SECUREDATTRIBUTEGROUP, SECURITYPERMISSIONS, DOMAINENTRY, MEMBER, ASSOCSCHEMES, RESOURCEACCESSLIST, PROCESSDEFNSELECTION, CATALOGATTRIBUTEDATATYPES, CONFIGDEFINITIONLIST, MEMBERORG, CATALOG, CONFIGURATIONDOCUMENT, HTTP, OUTPUTMAPLIST, CATALOGINPUTMAP, CATALOGEDITION, (cim, ORGANIZATION, COUNTERS)

the last three being system generated.

A fresh install of TIBCO Active Catalog (AC) 1.2 hotfix 3 on top of TIBCO Collaborative Information Manager (CIM) 8.1.0 hotfix 3 onward leads to an error at the end of the install process that, if ignored, causes AC 1.2 event triggering / workflow firing to fail and hence make AC 1.2 unusable.

ActiveCatalog, AC, 1.2, hotfix 3, install, failure, issue, CIM, 8.1.0, hotfix 3 and above