SAP R3 Problems
Posted: Mon May 02, 2005 9:21 am
cant seem to put a post on this site cant seem to find the link to it.
I have problems with using the SAP R3 stage.
I AM USING BUILD SQL TO GENERATE THE ABAP
When I click on generate ABAP no ABAP code is generated. The second time I click on this it closes my datastage designer client.
For tables without the inner join the ABAP code is generated. Most of the time when the ABAP is generated from a another machine ( That is from the scratch using Build query option) it works fine at times. In general 90% of the time no code is generated. The second time I click on generate programme datstage client is closed automatically.
I am able to get into the BUILD SQL option and build the SQL every time.
Can the error be because my inner joins have an error in them...(But i think it is highly unlikely)...? If i have an error there at least there should be some error returned.? The SQL I generate is after using the search table option. I have not used user defined SQL...THE SQL used is generated by datastage and all the key fields used for the inner joins are in the select criteria. Is it required to have all the keys used in the join in the select criteria...?
I had problems earlier with windows XP - service pack 2 and had to get a patch from ascential. If I open up the design I have done from my client machine on another client machine and try to generate the APAB the error still persists.
The problem is the tool does not return any error and also does not generate the ABAP code.
This is the first time I am working with SAP.
I have problems with using the SAP R3 stage.
I AM USING BUILD SQL TO GENERATE THE ABAP
When I click on generate ABAP no ABAP code is generated. The second time I click on this it closes my datastage designer client.
For tables without the inner join the ABAP code is generated. Most of the time when the ABAP is generated from a another machine ( That is from the scratch using Build query option) it works fine at times. In general 90% of the time no code is generated. The second time I click on generate programme datstage client is closed automatically.
I am able to get into the BUILD SQL option and build the SQL every time.
Can the error be because my inner joins have an error in them...(But i think it is highly unlikely)...? If i have an error there at least there should be some error returned.? The SQL I generate is after using the search table option. I have not used user defined SQL...THE SQL used is generated by datastage and all the key fields used for the inner joins are in the select criteria. Is it required to have all the keys used in the join in the select criteria...?
I had problems earlier with windows XP - service pack 2 and had to get a patch from ascential. If I open up the design I have done from my client machine on another client machine and try to generate the APAB the error still persists.
The problem is the tool does not return any error and also does not generate the ABAP code.
This is the first time I am working with SAP.