on 11-22-2007 12:10 PM
Hi All,
I have problems to reprocess Bdoc's with status I04 (Intermediate state).
In a batchprogram I created businesstransactions. But when a central blockade was set on the businessparter, no businesstransaction appear.
In the SM13 I have Update-errors (SAPSQL_ARRAY_INSERT_DUPREC).
In the SMW01 I have Bdoc's (BUS_TRANS_MSG) with status I04.
I'm having problems to reprocess the Bdoc's.
After uncheck all central blockades, the reprocess of the bdoc failed.
After changing the status of the Bdoc from I04 to I01, the bdoc will be reprocessed (green), but the data in the Bdoc will not be written to the database (CDB).
What could be a solution to reprocess the Bdoc's with an update of the CDB (and the businesstransaction appear)?
Thanks!
Hi G. van Doom,
You got a system error: <b>SAPSQL_ARRAY_INSERT_DUPREC</b>, this means that the running process tried to insert to the DB a records that is already existing. Hence it raised this system error.
Reprocessing the BDoc won't solve the issue since you will again try to insert record that already exist.
I would suggest you to maybe check the <b>task</b> you set in the BDoc from your batchprogram, if the records was already existing then you should rather do an update, by using Task = 1. Therefore you must have a logic in your program which can find if the record exist or not in order to set the appropriate task.
Task:
1 - Update
2 - Insert
3 - Delete
Hopping this help.
Sincerely,
Alain Gauthier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.