Hi Everyone! HELP!
I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server the explain plan is different, and the query succeeds. In PRD, the query is a single-step, and in stage it gets broken out into sub-queries and executed there. I created a report of all the database parameters. There is no difference that cannot be explained by the difference in CPUs, database name, or application paths. They are fundamentally identical. But the query aborts on PRD. I am attaching the top few lines of a typical trace file. ANY help, RTFM references, suggestions, incantations, incense, or holy water will be appreciated. Thanks, Mike *** 2003-07-21 14:52:06.921 *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886 Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x800000016ede9f30, PC: [0x4000000001331c0c, kghfrmrg()+596] Registers: r1: 800000010000d9e8 r22: 6e6178d8 sr4: 7df0c00 rp: 0 arg3: 800000016ede9f28 sr0: 67c9c00 r3: 40000000013319b8 arg2: c00000006e615fa0 sr1: d7db000 r4: 0 arg1: 6e615fa0 sr2: 0 r5: 0 arg0: c0b38f0000001131 sr3: 0 r6: 7ffffffc dp: 80000001000ca608 sr5: 6930000 r7: 0 ret0: 0 sr6: a814c00 r8: 80000001007d3798 ret1: 800000000000000 sr7: 67c9c00 r9: 80000001007d3780 sp: 800003ffbfff6880 cr0: 0 r10: 0 r31: 6 cr8: 77f6368 r11: 0 sar: 38 cr9: 77f6378 r12: 0 pcoqh: 4000000001331c0f ccr: 0 r13: 10000 pcsqh: 6930000 cr12: 494c008 r14: 800003ffbfff48c0 pcoqt: 4000000001331a93 cr13: 4a2b008 r15: 800003ffbfff48c8 pcsqt: 6930000 cr24: 4a2c808 r16: 40000000003f85d0 eiem: ffffffffffffffff cr25: 4a2a808 r17: af0 iir: 72f50010 cr26: 4a2c808 r18: 0 isr: a814c00 mpsfu_hi: 80000001000e36c8 r19: 800000010000d9e8 ior: 800000016ede9f30 mpsfu_lo: 0 r20: 0 ipsw: ff080cff1f mpsfu_ov: 41 r21: 80000001007d2650 goto: 97f68 pad: 0 *** 2003-07-21 14:52:07.811 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown code] [0x800000016EDE9F30] [] [] Current SQL statement for this session: SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :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 , :A76 , :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 , :A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 , :A143 , :A144 , :A145 , :A146 , :A147 , :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 , :A1 80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187 , :A188 , :A189 , :A190 , :A191 , :A192 , :A193 , :A194 , :A195 , :A196 , :A197 , :A198 , :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , :A206 , :A207 , :A208 , :A209 , :A210 , :A211 , :A212 , :A213 , :A214 , :A215 , :A216 , : A217 , :A218 , :A219 , :A220 , :A221 , :A222 , :A223 , :A224 , :A225 , :A226 , :A227 , :A228 , :A229 , :A230 , :A231 , :A232 , :A233 , :A234 , :A23 5 , :A236 , :A237 , :A238 , :A239 , :A240 , :A241 , :A242 , :A243 , :A244 , :A245 , :A246 , :A247 , :A248 , :A249 , :A250 , :A251 , :A252 , :A253 , :A254 , :A255 , :A256 , :A257 , :A258 , :A259 , :A260 , :A261 ) ) AND T_01 . "SPRAS" = :A262 ----- Call Stack Trace ----- --- =========================================================================== Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).