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

[maneeshinfo87]

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.

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

Step 2

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

Step 3

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

Step 4

Copy the Sales District ID as mentioned below

Step 5

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

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.

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.