List of Essential ETL LOG Message Codes

The following is a list of essential lines that will be imposed into the ETL LOG, even when the number of lines is limited to a positive integer.

Message Code

Log Message

Example or Explanation

ICM18007 

CPU Time: %1

CPU Time : 46

ICM18031

Finished

 
ICM18040

Return Code = xxx

Return Code = 0

ICM18041

-- stats for source file

Statistics about processing of a source file

ICM18072  

Elapsed run time hh:mm:ss

Elapsed run time 0:00:02

ICM18122 

Request - %1 (Owner: %2) submitted.

Request that was saved by the owner is being submitted. The owner is saved in a flow; e.g., control variable in focexec: -*DM_USERID=user1

ICM18237

Ending bulk load procedure

Shown in the LOG when a load type on a target is 'Bulk load utility via a disk file'

ICM18372

-- stats for target file: %1

Statistics about processing of a target file

ICM18514

%1 : %2 accepted by target table

18 : Row(s) accepted by target table

ICM18515

%1 : %2 inserted into target table

18 : Row(s) inserted into target table

ICM18516

%1 : %2 processed by job

18 : Row(s) processed by job

ICM18517

%1 : %2 updated in target table

0 : Row(s) updated in target table

ICM18518

%1 : %2 deleted from target table

0 : Row(s) deleted from target table

ICM18519

%1 : %2 rejected due to format error

0 : Row(s) rejected due to format error

ICM18520

%1 : %2 rejected due to validation errors

0 : Row(s) rejected due to validation errors

ICM18521

%1 : %2 rejected due to no match

0 : Row(s) rejected due to no match

ICM18522

%1 : %2 rejected because duplicate exist

0 : Row(s) rejected because duplicate exist

ICM18744

Ending Load

 
ICM18750

bulkload: DBMS error code at execution

The attempt to start the bulkload failed. Check configuration. It is possible that environmental variables that point to the DBMS bulkload facilities have not been configured.

ICM18751

bulkload: Error found in the bulkload log file %1

Review the log file for DBMS messages that indicate the specific error

ICM18808

%1 : %2 rejected due to DBMS error

2 : Row(s) rejected due to DBMS error

ICM18974 

Start of Log Record for %1/%2

------ Start of Log Record for baseapp/flow1 ------

ICM18975  

End of Log Record for %1/%2

------ End of Log Record for baseapp/flow1 ------

ICM18995 

The configured maximum number of log lines (%1) has been reached.

The message appears to inform a user that the log lines will be reduced as per the value in the sched_log_lines was set

WebFOCUS

Feedback