Workaround when Exception condition “DAY_IN_NOT_VALID” raised In Sales Credit related Load.
SAP BI 7.X
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
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.
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.
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
Double click on dump and check the details, if the exception
is due to condition “DAY_IN_NOT_VALID”
Under the dump please search field /BIC or /BIC/ZSCRDSTCT to find sales district ID.
Copy the Sales District ID as mentioned below
Now go to failed Data Package and click on data mart button (mentioned below)to access temporary storage area.
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.
Once you found the affected Sales Orders, then Execute the Delta DTP with Filter Out affected Sales Orders.
Once Step 7 completed then execute the full DTP (with setting in Extraction Tab Only retrieve last request) with selecting only affected Sales Orders.