:: Update getting deactivated while inserting into BSIK table ::

[Former Member]

Hi,

In an ECC system update are continuously getting deactivated.

This problem is happening while every insert for table BSIK in client 011 (Copy of master client 010)

We are manually activating from T code SM13 but again Update getting Deactivated.

Enough free space is available in Table space.

SM21 Logs ::

==================================================

Database error 600 requires database administrator to intervene

The update has been deactivated following a system error

Run-time error "ROLLBACK_IN_POSTING" occurred

==================================================

following dump observed in the system

ROLLBACK_IN_POSTING

==================================================

followed by update De-activation

Even in the oracle trace file we observe the same corresponding incident INSERT INTO "BSIK" VALUES(:A0 ,:A1 ,:A2 ,:A3 ,:A4 ,:A5 ,:A6 ,:A7 ,:A8

,:A9 ,:A10 ,:A11 ,:A12 ,:A13 ,:A14 ,:A15 ,:A16 ,:A17 ,:A18 ,:A19 ,:A20

,:A21 ,:A22 ,:A23

,:A24 ,:A25 ,:A26 ,:A27 ,:A28 ,:A29 ,:A30 ,:A31 ,:A32 ,:A33 ,:A34 ,:A35

,:A36 ,:A37 ,:A38 ,:A39 ,:A40 ,:A41 ,:A42 ,:A43 ,:A44 ,:A45 ,:A46 ,:A47

,:A48 ,:A49 ,

:A50 ,:A51 ,:A52 ,:A53 ,:A54 ,:A55 ,:A56 ,:A57 ,:A58 ,:A59 ,:A60 ,:A61

,:A62 ,:A63 ,:A64 ,:A65 ,:A66 ,:A67 ,:A68 ,:A69 ,:A70 ,:A71 ,:A72 ,:A73

,:A74 ,:A75 ,:A

76 ,:A77 ,:A78 ,:A79 ,:A80 ,:A81 ,:A82 ,:A83 ,:A84 ,:A85 ,:A86 ,:A87

,:A88 ,:A89 ,:A90 ,:A91 ,:A92 ,:A93 ,:A94 ,:A95 ,:A96 ,:A97 ,:A98 ,:A99

,:A100 ,:A101 ,:A

102 ,:A103 ,:A104 ,:A105 ,:A106 ,:A107 ,:A108 ,:A109 ,:A110 ,:A111 ,:A112

,:A113 ,:A114 ,:A115 ,:A116 ,:A117 ,:A118 ,:A119 ,:A120 ,:A121 ,:A122

,:A123 ,:A124

,:A125 ,:A126 ,:A127 ,:A128 ,:A129 ,:A130 ,:A131 ,:A132 ,:A133 ,:A134

,:A135 ,:A136 ,:A137 ,:A138 ,:A139 ,:A140 ,:A141 ,:A142 ,:A143 ,:A144

,:A145 ,:A146 ,:A1

47 ,:A148 ,:A149 ,:A150 ,:A151 ,:A152 ,:A153 ,:A154 ,:A155 ,:A156 ,:A157

,:A158 ,:A159 ,:A160 ,:A161 ,:A162 ,:A163 ,:A164 ,:A165 ,:A166 ,:A167

,:A168 ,:A169 ,

:A170 ,:A171 ,:A172 ,:A173 ,:A174 ,:A175 ,:A176 ,:A177 ,:A178 ,:A179

,:A180 ,:A181 ,:A182 ,:A183 )

==================================================

We have attached the trace file to this discussion.

Need your urgent help why this update is going to de-activation.

This is seriously hampering the UAT testing causing for delay in go-live.

Thank you, Regards

Girish Garje

trace.txt.zip

[Former Member]

Check any critical segments (DB02), extend the tablespace if required.

Check the detailed ABAP dump, if generated (Check for ORA errors).

Regards,

Nick Loy

[Former Member]

Hi,

what is alert log saying?

BR,

Peter