CX_OS_DB_INSERT Dump when create SC EXTR documents

[Former Member]

Hi SAP gurus,

Please if somebody has idea what to do it is highly appreciated. We have the Classic scenario and run SRM 7.02. MRP creates a purchase requisition in ECC which is duplicated as shopping cart in SRM. We  have enable no standard SRM workflow approval for external requisitions (for approval) of external requisitions.

For some shopping cart a dumps occurred in SRM backend. This does only occurred when run massively. When run individually the MRP for the same material after the dump it does not generated any dump and the creates shopping. The dumps happens at the moment when saving in the database of the database of the WF corresponding to the shopping cart.

following details of the dump:

129   endloop. "at I_DELETES

130

131 * * Perform DB Operations:

132

133 *< Generated from mapping:

134

135 * * DB Deletes

136   loop at DB_DELETE_TAB into DB_DELETE_ITEM.

137

138     delete from /SAPSRM/D_WF_000

139           where ID = DB_DELETE_ITEM.

140     if sy-subrc <> 0.

141       raise exception type cx_os_db_delete

142         exporting

143           table = '/SAPSRM/D_WF_000'.

144     endif.

145

146   endloop." at DB_DELETE_TAB

147

148   delete /SAPSRM/D_WF_000 from table DB_DTB_/SAPSRM/D_WF_000.

149   if sy-subrc <> 0.

150     raise exception type CX_OS_DB_DELETE

151       exporting

152         table = '/SAPSRM/D_WF_000'.

153   endif.

154

155 * * DB Inserts

156   insert /SAPSRM/D_WF_000 from table DB_ITB_/SAPSRM/D_WF_000

157     accepting duplicate keys.

158   if sy-subrc <> 0.

>>>>     raise exception type CX_OS_DB_INSERT

160       exporting

161         table = '/SAPSRM/D_WF_000'.

162   endif.

163

164 * * DB Updates

165   update /SAPSRM/D_WF_000 from table DB_UTB_/SAPSRM/D_WF_000.

166   if sy-subrc <> 0.

167     raise exception type CX_OS_DB_UPDATE

168       exporting

169         table = '/SAPSRM/D_WF_000'.

170   endif.

171

172 *>

173            "MAP_SAVE_TO_DATABASE>

174 endmethod.

active calls:

8 METHOD       /SAPSRM/CB_WF_PROCESS=========CP    /SAPSRM/CB_WF_PROCESS=========CM009   159

  /SAPSRM/CB_WF_PROCESS=>MAP_SAVE_TO_DATABASE

7 METHOD       /SAPSRM/CB_WF_PROCESS=========CP    /SAPSRM/CB_WF_PROCESS=========CM00P    38

  /SAPSRM/CB_WF_PROCESS=>IF_OS_CA_SERVICE~SAVE_IN_UPDATE_TASK

6 FUNCTION     SAPLOS_UPDATE_TASK                  LOS_UPDATE_TASKU01                     34

  OS_UPDATE_CLASS

5 FORM         SAPLOS_UPDATE_TASK                  LOS_UPDATE_TASKU01                      1

  OS_UPDATE_CLASS

4 FORM         RSM13000                            RSM13000                             5515

  VB_CALL_FUNC

3 FORM         RSM13000                            RSM13000                             5221

  VB_V1_EXEC

2 FORM         RSM13000                            RSM13000                             3952

  VB_V1_NORMAL

1 MODULE (PBO) RSM13000                            RSM13000                             3801

  VBEXEC

Thank you in advance

Pablo

[vinita_kasliwal · Accepted solution]

Hi Pablo

Is this a std SAP code or a custom one?

Refer this link it reports a similar issue and the note

  1594158 - Restoring a backup to a new system fails

workflow not initiating, SRM 7.0 | SCN

Note if this is standard raise is to SAP after checking the note as mentioned

Regards

Vinita

[Former Member · Accepted solution]

Hi Vinita,

Thanks for the reply. The part I have attached is std SAP code. However we have implemented workflow approval for external requisitions (http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/5082a622-7310-2c10-1a9b-ef31dd69a770) which is not standard.

The note does not apply, thanks anyway.

Rgds,

Pablo

[Former Member]

Does anyone more have any idea on how to solve this?

the termination occers here:

Termination occurred in the ABAP program "/SAPSRM/CB_WF_PROCESS=========CP" -
in "MAP_SAVE_TO_DATABASE".
The main program was "RSM13000 ".

In the source code you have the termination point in line 159
of the (Include) program "/SAPSRM/CB_WF_PROCESS=========CM009".
The program "/SAPSRM/CB_WF_PROCESS=========CP" was started in the update
system.

thanking you

rgds,

Pablo