on 09-24-2007 12:54 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.