Skip to Content

Workaround when Exception condition “DAY_IN_NOT_VALID” raised In Sales Credit related Load.

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

Be the first to leave a comment
You must be Logged on to comment or reply to a post.