on 03-22-2007 9:00 PM
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
Hello,
Apply Patch 14 it will solve ur issue.
Thanks,
Kishore
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
Any short dumps in the system giving more information abt the error msg?
Regards,
Sree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.