• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
After running ETL for the CASH table, we got the following message in the "p_arc_01_transform.log". We wonder how we could interpret the message:
"NO_PROCESS_DETAILS_LINES
154
1 row selected.
PROCESS_CODE TASK_CODE START_DATE END_DATE ERROR_DESC
no rows selected
NO_PROCESS_DETAILS_LINES
212
1 row selected."

Resolution:
The excerpt that you sent indicates that the process finished with no errors.
Even if the Extract was run on one table, (like cash), the Transform and load are done on all tables.
The log shows you how many processes were done (in your example =154) up till 'p-arc-01-transform' file was updated.
It is updated every 5 minutes. So, every 5 minutes a new line is written indicating how many processes were done till then.
If there were errors in the transform and load processes that were already made, the errors would have been written in that log file.

• Article last edited: 10/8/2013