Verifying Table Formats

To verify table formats:

1. Verify table conversions that have a conversion sequence number of 99 or below by reviewing the .pdf and .log files generated to the printqueue directory.

   These conversions also can be verified by reviewing the log for R8998504.

2. Verify conversions with a conversion sequence number of 100 or above and process type 5 by reviewing the .log file generated in the printqueue directory. The following illustration shows the last few lines of a sample .log file for the R8903B20 report:

   TCEngine Level 1 D:\E920\system\TCEngine\tcinit.c(1581):
       Format F03B20 contains 55 column(s)
   TCEngine Level 1 D:\JDEdwards\E920\system\TCEngine\tcinit.c(1581):
   TCEngine Level 1 D:\JDEdwards\E920\system\TCEngine\tcinit.c(1581):
       Format F03B20 contains 61 column(s)
   TCEngine Level 1 D:\JDEdwards\E920\system\TCEngine\tcinit.c(1581):
   TCEngine Level 1 D:\JDEdwards\E920\system\TCEngine\tcinit.c(1581):
       There is ER logic associated with the event Row Fetched from F03B20
   TCEngine Level 1 D:\JDEdwards\E920\system\TCEngine\tcinit.c(1581):
       System function Insert Row into format F03B20
   TCEngine Level 1 D:\JDEdwards\E920\system\TCEngine\tcinit.c(1581):
   TCEngine Level 1 D:\JDEdwards\E920\system\TCEngine\tcrun.c(689):
       Conversion R8903B20 XJDE0001 done successfully. 
       Elapsed time - 1.843000 Seconds.    
   TCEngine Level 1 D:\JDEdwards\E920\system\TCEngine\tcrun.c(697):
       Fetched 11 rows from F03B20
   TCEngine Level 1 D:\JDEdwards\E920\system\TCEngine\tcrun.c(705):
       Inserted 11 rows, failed to insert 0 rows into F03B20
   

3. Use the information above to verify the conversion program using the following procedures:

   1. If the bottom of the .log file says the conversion was unsuccessful, review the rest of the .log from the beginning for specific errors. Also review the jde.log and jdedebug.log for more specific error information.

   2. If the bottom of the .log file says that the conversion was successful, review the file format of the physical file to see that the number of columns has changed.

      From the example .log shown above, F03B20 should now have 61 columns in the target data source instead of 55.

   3. Verify the record count in the physical file based on the log information.

      From the example .log shown above, F03B20 should now have 11 rows in the target data source.

   4. If the .log file says that there were insert failures, review the jde.log and jdedebug.log for more detailed information.

   5. If the conversion cannot be verified through the above procedures, check the table in Verifying Table Conversions for more specific verification information.