Changed database tables after running migrateToInstalledFP.sh script

I use Oracle database. After running the migrateToInstalledFP.sh migration scripts, there are tables that were reported as changed by the database verification report. How do I fix them?

Symptoms

After running the migrateToInstalledFP.sh migration scripts, the following tables were reported as changed by the database verification report:

- TCTG_ITA_ITEM_ATTRIBUTES

- TSEC_COT_COMPANY_ATTRIB

- TSEC_SCU_USER

Causes

This is not a result of migration to any of the currently supported versions of the product. Instead, it is caused by preexisting issues in the database schema.

Resolving the problem

Following are the steps to fix these tables.

TCTG_ITA_ITEM_ATTRIBUTES

Check if the $TOP/logs/default/ipm.log has the following entry:

[main] INFO  com.ibm.ccd.common.util.SystemDB - Information: COLUMN LENGTH ITA_VALUE_STRING 3000 4000

Here 3000 refers to the existing length of the ITA_VALUE_STRING column while 4000 is the length required by the product. Run the following command to change this length.

perl $PERL5LIB/runSQL.pl --sql_command="alter table TCTG_ITA_ITEM_ATTRIBUTES modify (ita_value_string VARCHAR2(4000));"

TSEC_COT_COMPANY_ATTRIB

Check if the $TOP/logs/default/ipm.log has the following entry.

[main] INFO  com.ibm.ccd.common.util.SystemDB - Information: COLUMN LENGTH COT_COMPANY_ID 10,0 9,0

This should be ignored, no modification is necessary. Existing precision "number (10,0)" is higher than the required precision "number(9,0)".

TSEC_SCU_USER

Check if the $TOP/logs/default/ipm.log has the following entry.

[main] INFO  com.ibm.ccd.common.util.SystemDB - Information: COLUMN LENGTH SCU_USER_EMAIL 40 100

Here 40 refers to the existing length of the SCU_USER_EMAIL column while 100 is the length required by the product.

Run the following Perl SQL to change this length.

perl $PERL5LIB/runSQL.pl --sql_command="alter table TSEC_SCU_USER modify (SCU_USER_EMAIL VARCHAR2(100));"