Applied To

SAP BI 7.X

Summary

This article helps to fix the issue caused due to Load failed with the exception condition “DAY_IN_NOT_VALID” in SCR loads (LOAD TO SCR: Snapshot DSO).

Note: This is only the work around not a permanent solution

Scenario    

Suppose there is a load related to Sales credit, where DTP loaded multiple data packages but few failed as
Internal session terminated with runtime error RAISED_EXCEPTION.

/wp-content/uploads/2014/01/2_355233.png

Solution

The above mentioned issue can be solved by analyzing ABAP Dump in T Code – ST22. Where we can get Disrtict ID to find out affected Sales Orders.

Step 1

Check the Dump under T code – ST22, with name RAISE_EXCEPTION”.

Note: If multiple dumps found with name “RAISE_EXCEPTION”, check the timing when data package failed and through dump

/wp-content/uploads/2014/01/1_355234.png

Step 2

Double click on dump and check the details, if the exception
is due to condition “DAY_IN_NOT_VALID”

/wp-content/uploads/2014/01/3_355235.png

Step 3

Under the dump please search field /BIC or /BIC/ZSCRDSTCT to find sales district ID.

/wp-content/uploads/2014/01/4_355236.png

Step 4

Copy the Sales District ID as mentioned below

/wp-content/uploads/2014/01/5_355237.png

Step 5

Now go to failed Data Package and click on data mart button (mentioned below)to access temporary storage area.

/wp-content/uploads/2014/01/6_355241.png

Step 6

Now find out the affected Sales Order by putting filter as, DISTICT_ID = which you copy from dump and  Day32 Flag = Yes,

then copy all sales Order which you will find.

/wp-content/uploads/2014/01/7_355242.png

Step 7

Once you found the affected Sales Orders, then Execute the Delta DTP with Filter Out affected Sales Orders.

Step 8

Once Step 7 completed then execute the full DTP (with setting in Extraction Tab Only retrieve last request) with selecting only affected Sales Orders.

1.PNG

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply