Description:
How to reconstruct the TIBCO BusinessEvents ObjectTable using the existing base tables in the backingstore.

How to reconstruct the TIBCO BusinessEvents ObjectTable.

The easiest way to populate the object table is:

1). Truncate table ObjectTable.

2). Execute the be-jdbcdeploy tool while setting the following properties in be-jdbcdeploy.tra:

be.jdbc.schemamigration.url=<...>
be.jdbc.schemamigration.user=<...>
be.jdbc.schemamigration.pswd=<...>
be.jdbc.schemamigration.populateObjectTable=true


Note: If there are too many records, it may take a while to run this process. In this case, users can manually execute a SQL query for each main table;

Example for D_Parent table;
INSERT INTO OBJECTTABLE (GLOBALID, SITEID, ID, EXTID, CLASSNAME, ISDELETED) SELECT T.ID$, 0, T.ID$, T.EXTID$, 'be.gen.Concepts.Parent', 0 FROM D_PARENT T;

List of main tables and classnames can be queried with 'select classname, tablename from classtotable where fieldname is null;'