cancel
Showing results for 
Search instead for 
Did you mean: 

Exceptions in Substep: Write Data Package

Former Member
0 Kudos

Hi All,

Has anyone encountered this error message in BI7? We just recently applied SP12 and it solved an ABAP dump (SAPSQL_ARRAY_INSERT_DUPREC) we were seeing while trying to load an ODS. However, I'm now seeing a new error message while loading:

Exceptions in Substep: Write Data Package

We have some custom ABAP in an End Routine that is doing some additional processing while loading extractor 2LIS_13_VDKON.

All of this code is working perfectly as a Start Routine in our BW 3.x system, but in BI7, we first had the above SQL error and now this data package error. It appears that it executes the transformation, rules and end routine successfully, (everything is green in the DTS Monitor) but while trying to insert the data into the ODS, it errors out.

I don't know how or what to debug -- I can't even get an Error Stack. Does anyone have any insight or recommendations?

Thanks,

-Mel

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello,

Apply Patch 14 it will solve ur issue.

Thanks,

Kishore

Former Member
0 Kudos

Hi Mel,

I got the same problem ie <b> Exceptions in Substep: Write Data Package</b>

Can you please let me know finally how you solved this problem ?

I strucked here itself for this problem from longtime.

Your suggestions are highly appreciable and points will be awarded .

Best Regards,

Govind.

Former Member
0 Kudos

Please contact BASIS to upgrade your BI7 Support Package to the latest version. Then, re-run your load. If you see the same error, you will need to debug your ABAP code. Remove it and then slowly add it back, piece by piece or use the debugger manually to step through it line-by-line.

Former Member
0 Kudos

Hi Mel,

1. on which Database is your BI system running.

2. Debugging a DTP is possible:

Open the DTP, choose Execute

Processing mode (Serially in the Dialog Process ... for Debugging

a) start a simulation request directly from the DTP-Monitor of the erroneous request

b) Selections (including source requests) are copied from the original request

c) Selections can be changed in a UI similar to the DTP filter

d) Selections can be stored as variants for later use (e.g. in a different support level)

e) Temporary storages and breakpoints can be switched on and off

--> you can set the Breakpoints

--> you can choose "Expertenmodus" (modus for experts), here you can choose the request ID ...

I hope this helps,

Michael

SAP NetWeaver RIG

Former Member
0 Kudos

Hi Michael,

We're running ORACLE.

There are no dumps in ST22, so there's nothing really to go on.ALso, how do I get the Error Stack information? I've tried everything clicking on all of the objects in the DTS Monitor, but there's no info.

I understand that we can debug and I've tried debugging when we saw the SQL error and the issue was on an insert statement on an SAP-specific function, not anything in our End Routine code.

Can we rule out the End Rountine code as it's bombing on the data package insert?

Former Member
0 Kudos

You need to remove/comment the routine from the transformation.

This is the only way.

Michael

Former Member
0 Kudos

Any short dumps in the system giving more information abt the error msg?

Regards,

Sree