ABAP Extract Stage Issue
Posted: Tue Oct 14, 2014 4:13 am
Hi,
I have a job in DS 8.1 which is using ABAP Extract Stage as source and outputs it to a Dataset. This job accepts start date and end date as parameters and based on these dates the job returns the records. The job is working as expected.
I have got the same job in DS 9.1 but here it always returns the same number of records and the start date and end date are being used in the ABAP Code it seems. I mean, doesnt matter what dates I am providing, it always returns the same number of records.
I have DEV and QA in 8.1 which is fine. I have 9.1 DEV which is fine but the problem is only in 9.1 QA. I have many other jobs and they all work as expected. Problem is only with this one job.
I have compared the ABAP Code as well after saving it to a text file and the code in all the 4 environment is same.
I got the below in IBM Help-
"DataStage jobs that use the ABAP Extract CPI-C data transfer method and contains job parameters does not return data from Unicode SAP R/3 systems running on Intel x86 processors. Another ABAP job that did not use job parameters ran successfully and returned the expected data.
Resolving the problem
This resolution is only valid when SAP Server resides on a system with an Intel x86 processor.
Two alternatives to correct the problem:
Create a new user defined environment variable called SAPIsOnWin and set it equal to 1 in DataStage Administrator for all projects that connect to the SAP server."
My Job has the Start Date and End Date job parameters. I added the ENV VAR SAPIsOnWin =1 but after still no luck.
Can anyone please help me on this.
I have a job in DS 8.1 which is using ABAP Extract Stage as source and outputs it to a Dataset. This job accepts start date and end date as parameters and based on these dates the job returns the records. The job is working as expected.
I have got the same job in DS 9.1 but here it always returns the same number of records and the start date and end date are being used in the ABAP Code it seems. I mean, doesnt matter what dates I am providing, it always returns the same number of records.
I have DEV and QA in 8.1 which is fine. I have 9.1 DEV which is fine but the problem is only in 9.1 QA. I have many other jobs and they all work as expected. Problem is only with this one job.
I have compared the ABAP Code as well after saving it to a text file and the code in all the 4 environment is same.
I got the below in IBM Help-
"DataStage jobs that use the ABAP Extract CPI-C data transfer method and contains job parameters does not return data from Unicode SAP R/3 systems running on Intel x86 processors. Another ABAP job that did not use job parameters ran successfully and returned the expected data.
Resolving the problem
This resolution is only valid when SAP Server resides on a system with an Intel x86 processor.
Two alternatives to correct the problem:
Create a new user defined environment variable called SAPIsOnWin and set it equal to 1 in DataStage Administrator for all projects that connect to the SAP server."
My Job has the Start Date and End Date job parameters. I added the ENV VAR SAPIsOnWin =1 but after still no luck.
Can anyone please help me on this.