sap plug-in issue
Posted: Thu Sep 20, 2001 10:59 pm
Hi, all
Some of our DataStage jobs that extract from SAP occasionally would not extract any rows. The DataStage jobs effectively calls an ABAP program in SAP. These jobs just extract all rows from various reference tables in SAP. Therefore, I expect at least the same number of rows as the previous run if not more.
For example, logs from job that calls ZRDSCSKU,
Timestamp:14/09/01 04:51:27
Message:
StagingSAPCSKU.PROCESS: DSD.StageRun Active stage finishing. 950 rows read from csku_extract 950 rows written to csku_staging 0 rows written to csku_reject
Timestamp:17/09/01 04:50:23
Message:
StagingSAPCSKU.PROCESS: DSD.StageRun Active stage finishing.
0 rows read from csku_extract
0 rows written to csku_staging
0 rows written to csku_reject
Notice on the 14th rows were extracted. But on the 17th no rows came through.
These jobs run every day except Sunday
Does anyone have experience of this isuue?
Thanks in advance
Xiong
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.
Some of our DataStage jobs that extract from SAP occasionally would not extract any rows. The DataStage jobs effectively calls an ABAP program in SAP. These jobs just extract all rows from various reference tables in SAP. Therefore, I expect at least the same number of rows as the previous run if not more.
For example, logs from job that calls ZRDSCSKU,
Timestamp:14/09/01 04:51:27
Message:
StagingSAPCSKU.PROCESS: DSD.StageRun Active stage finishing. 950 rows read from csku_extract 950 rows written to csku_staging 0 rows written to csku_reject
Timestamp:17/09/01 04:50:23
Message:
StagingSAPCSKU.PROCESS: DSD.StageRun Active stage finishing.
0 rows read from csku_extract
0 rows written to csku_staging
0 rows written to csku_reject
Notice on the 14th rows were extracted. But on the 17th no rows came through.
These jobs run every day except Sunday
Does anyone have experience of this isuue?
Thanks in advance
Xiong
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose or
use the contents in any way. Please also advise us by return e-mail that you
have received the message and then please destroy. Carter Holt Harvey is not
responsible for any changes made to this message and / or any attachments after
sending by Carter Holt Harvey. We use virus scanning software but exclude all
liability for viruses or anything similar in this email or any attachment.