System software error a few times a day, the same version of the software on another customer there is no problem... Hope ace in myself,,, don't say this statement has a problem, this statement is for the use of the timer, use N times a day, an error is only a few times,

SQL code: SELECT KH_CH, COUNT (*) AS the FROM CNT T_KSRW WHERE KH_CH IN (15th AND 16th) AND LXFLAG=0 GROUP BY KH_CH
Is converted to: SELECT KH_CH, COUNT (*) AS CNT, T_KSRW. "the ROWID FROM T_KSRW WHERE KH_CH IN (15th AND 16th) AND LXFLAG=0 GROUP BY KH_CH

The following is a ora_4452. TRC file
The Memory (the Avail/Total) : Ph: 107461 m/114617 m, Ph + PgF: 133034 m/140215 m, VA: 2234 m/4095 m
The Instance name: slkm2

Redo thread mounted by this instance: 1

Oracle process number: 58

Windows thread id: 4452, image: ORACLE. EXE (SHAD)


* * * SERVICE NAME: (slkm2) 2020-05-13 15:31:42. 593
* * * the SESSION ID: (54.297) 2020-05-13 15:31:42. 593
* * * 2020-05-13 15:31:42. 593
Ksedmp: internal or fatal error
ORA - 07445: an exception error: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC: 0 x7efc65d0] [ADDR: 0 XFFFFFFFF] [UNABLE_TO_READ] []
ORA - 00979: not GROUP BY expression
The Current SQL statement for this session:
SELECT KH_CH, COUNT (*) AS CNT, T_KSRW. "the ROWID FROM T_KSRW WHERE KH_CH IN (15th AND 16th) AND LXFLAG=0 GROUP BY KH_CH
-- -- -- -- -- the Call Stack Trace -- -- -- -- --
Calling the call entry argument values in hex
The location type point (? Means dubious value)
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
7 efc65d0 00000000
7780013 e CALLrel 7783695 a
603 a723e CALL??? 00000000
603 a79a4 CALLrel 603 a717c F85AB40 D741090 3 d3
_opiosq0 + 5715 CALLrel _kgerse + 0 F85AB40
_kpooprx + 232 CALLrel _opiosq0 + 0 3 E DB1D9AC A4
_kpoal8 + 775 CALLrel _kpooprx + 0 DB1F6CC DB1E184 71 1 0 A4
17 DB1F6C8 _opiodr + 1099 CALLreg 00000000 5 e
60 feff8d CALLreg 00000000 5 e 17 DB1F6C8 7
_opitsk + 1017 CALL??? 00000000
_opiino + 1087 CALLrel _opitsk + 0 0 0
_opiodr + 1099 CALLreg 00000000 3 c 4 DB1FC60
_opidrv + 819 CALLrel _opiodr + 0 3 c 4 DB1FC60 0
_sou2o + 45 CALLrel _opidrv + 0 3 c 4 DB1FC60
_opimai_real + 112 CALLrel _sou2o + 0 DB1FC54 3 c 4 DB1FC60
2 DB1FC8C _opimai + 92 CALLrel _opimai_real + 0
_OracleThreadStart @ CALLrel _opimai + 0
4 + 708
75 aa33c5 CALLptr 00000000
77829 ed0 CALLreg 00000000
77829 the eab 77829 ea0 CALLrel

CodePudding user response:

Here can't add T_KSRW. "the ROWID," the ROWID rather then stored it in the location information in the database, is the only one, is a fixed value in one line, not in the group by ROWID this column was such wrong

CodePudding user response:

SQL syntax format is not right, you will occasionally run a few times a day at the wrong, may be a statement is not a statement, the statement alone out execution is impracticable

CodePudding user response:

SQL code: SELECT KH_CH, COUNT (*) AS the FROM CNT T_KSRW WHERE KH_CH IN (15th AND 16th) AND LXFLAG=0 GROUP BY KH_CH
Was converted into: SELECT KH_CH, COUNT (*) AS CNT, T_KSRW. "the ROWID FROM T_KSRW WHERE KH_CH IN (15th AND 16th) AND LXFLAG=0 GROUP BY KH_CH

CodePudding user response:

This statement code only such,
Just sent to the server to that of the strange, has a lot of customers are using this software, the code is no problem, every time I go here,

CodePudding user response:

Didn't turn syntax can be before, turn after the grammar, in oracle is not through

CodePudding user response:

After the grammar, no group by words, of course, also will be a problem

CodePudding user response:

This kind of error, consider the possibility of a particular oracle version bugs, can look up, to the MOS

CodePudding user response:

Looks like a BUG to stick a publishing this information