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

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;'

How to reconstruct the TIBCO BusinessEvents ObjectTable.