Verifying the Table Conversion Process

To verify that the table conversion process completed successfully:

• Understanding Table Conversion Dependencies

• Verifying Table Conversions

• Understanding Table Format Verification

• Understanding UDO Table Conversions

• Verifying Table Formats in Oracle

• Altering the Oracle Database Rollback Segment

• Rerunning Table Conversion Programs

For each Table Conversion that runs locally, you will see error messages in jde.log similar to the following:

• TAMInitX (path\jdeblc.xdb): Error opening index file "path\jdeblc.xdb" : The system cannot find the path specified. WinErrNum=3.

  The path name will vary by environment and release, where references to TAM are only applicable to releases prior to Release 8.12, at which point TAM is superceded by Metadata.

• 2248\2420 Thu Dec 26 11:18:36.326 ODBC_U1.C823 ODB0000154 - SQLPrepare failed. Table F00926, ODBC DSN JDE_DEV.

• 2248\2420 Thu Dec 26 11:18:36.326 JDBODBC.C2695 ODB0000027 - JDBODBC_DescribeTable failed. Table F00926.

  The exact syntax varies by database type and environment.

• Because they do not affect the table conversion, you can disregard any error messages for these tables:

  • F00921

  • F00926

  • F98830

  • F9100TCTEMP

• If you receive an error regarding F0092L that table may or may not exist in the previous environment, depending on whether you installed Tools 9.2 in previous environment. This error does not stop the process or register as an error in the Workbench itself.

• The F00950W table is converted when you do the Table Conversions. If you applied Tools 9.2 to the previous environment this table would copy successfully. If you did not it will either be missing or have the wrong format. This error does not stop the process or register as an error in the Workbench itself.