Skip to Content
0

Data load brings in records but stuck in yellow

Feb 09, 2017 at 03:41 AM

88

avatar image
Former Member

Hi All,

We are using the datasource 0PM_OM_OPA_1 to fetch the plan and actuals cost into BW.

Data Flow : 0PM_OM_OPA_1 >> 0PM_DS04 >> 0PM_C01

We are having an infopackage routine to restrict the data getting pulled only for two years as this datasource does not support Delta update.

We had come across a scenario where we lose some records due to overwriting capability in DSO. To handle that we had made those fields as key fields in the DSO.

One of the field we wanted was in extract structure but not in the datasource. Found that the field was hidden by SAP hence using an ABAP program we had made it visible in ROOSFIELD table.

Questions:

1. While doing this activity, do we need to modify or tweak the code behind ?

2. I believe we dont need to go for an exit as the field is readily available after changing it to visible the datasource. Please confirm.

Issue we are facing:

1. Infopackage load brings data but stuck in yellow.

- Checked the job in source system and found that it gets cancelled.

- ST22 gives a message as "DBSQL_INVALID_CURSOR" as shown in the screenshot below.

2. Infopackage load with a selection on order number does not bring any records even when the records exist in RSA3. These loads bring 0 records with status green.

Kindly let me know your thoughts.

Referred Links:

https://archive.sap.com/discussions/message/14664411?tstart=0#14664411

https://archive.sap.com/discussions/thread/410914

https://archive.sap.com/discussions/thread/1231916

https://archive.sap.com/discussions/message/540154#540154

http://saptechnical.com/Tutorials/BI/Options/Page3.htm

Regards,
Vinoth V

error.jpg (115.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Peter Atkin Feb 10, 2017 at 08:46 AM
0

Vinoth V,

There are quite a few OSS Notes for 0PM_OM_OPA_1.

You might want to see if any of them are suitable.

PeteA

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 11, 2017 at 01:07 PM
0

Hello Vinoth,

What is the status of the background job? Does it get completed or it gets cancelled in source system?

If the background job is complete then check for Tcode SLG1 in source system for Object RSAP and Sub Object RSAP_INFO

You may also try to change the wait time and treatment of warnings in info package (Open IP > Scheduler )

Thanks

Abhishek Shanbhogue

Share
10 |10000 characters needed characters left characters exceeded