WF-BATCH generates dump UNCAUGHT EXCEPTION CX_OS_DB_UPDATE

[Former Member]

Dear experts,

In background we keep getting multiple dump every day which are all titled:

UNCAUGHT EXCEPTION CX_OS_DB_UPDATE

If we take a closer look, it looks like the system creates an exception while updating table PPFSTRIGG.

following details of the dump:

64

65 db_dln_ppfstrigg-os_guid = <fs_delete>-oid.

66 APPEND db_dln_ppfstrigg TO db_dtb_ppfstrigg.

67

68 ENDLOOP. "at I_DELETES

69

70 * * Perform DB Operations:

71

72 *<To be completed:

73

74 * * DB Deletes

75 delete PPFtTRIGG from table DB_DTB_PPFSTRIGG.

76 if sy-subrc <> 0.

77 raise exception type cx_os_db_delete

78 exporting

79 table = 'PPFTTRIGG'.

80 endif.

81

82 * * DB Inserts

83 insert PPFtTRIGG from table DB_ITB_PPFSTRIGG

84 accepting duplicate keys.

85 if sy-subrc <> 0.

86 raise exception type cx_os_db_insert

87 exporting

88 table = 'PPFTTRIGG'.

89 endif.

90

91 * * DB Updates

92 update PPFtTRIGG from table DB_UTB_PPFSTRIGG.

93 if sy-subrc <> 0.

>>>>> raise exception type cx_os_db_update

95 exporting

96 table = 'PPFSTRIGG'.

97 endif.

98

99

100 ** delete runtime containers

101 * loop at db_dtb_ppfstrigg into db_dln_ppfstrigg

102 * where not startcont is initial.

103 * l_container = db_dln_ppfstrigg-startcont.

104 * l_condition = db_dln_ppfstrigg-startcond.

105 * call method CL_CONTAINER_SERVICE_PPF=>DELETE_CONTAINER

106 * exporting

107 * ip_container = l_container

108 * ip_condition = l_condition.

109 * endloop.

110 *

111 ENDMETHOD.

ACTIVE CALLS:

8 METHOD CA_TRIGGER_PPF================CP CA_TRIGGER_PPF================CM007 94

CA_TRIGGER_PPF=>MAP_SAVE_TO_DATABASE

7 METHOD CB_TRIGGER_PPF================CP CB_TRIGGER_PPF================CM007 38

CB_TRIGGER_PPF=>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_TASKV01 40

OS_UPDATE_CLASS

4 FORM RSM13000 RSM13000 5456

VB_CALL_FUNC

3 FORM RSM13000 RSM13000 5178

VB_V1_EXEC

2 FORM RSM13000 RSM13000 3951

VB_V1_NORMAL

1 MODULE (PBO) RSM13000 RSM13000 3800

VBEXEC

Has anybody ever seen this before?

Kind Regards,

Tom

[Former Member · Accepted solution]

Hi

Which SRM version are you using ?

<b>Please go through the following SAP OSS Notes -></b>

Note 829303 Messages are not sent to ERP, get stuck in SMQ1

Note 1006956 - Runtime error CX_OS_DB_INSERT w/ cancellatio of WO or WT

Note 1008760 - Runtime error CX_OS_DB_UPDATE when printing HU

Note 857073 - PPF: Runtime error with initial action profile

Note 840293 - PPF: New enqueue logic for the "Execute/Delete" action

Do let me know.

Regards

- Atul