on 03-08-2015 7:28 PM
Hi Experts,
We are getting below error in our Solman system after upgrade from SPS 8 to SPS12.
Can anyone please help us to get the rid of the issue?
Solution Manager 7.1
Platform AIX/Oracle 11g
ORA-00923: FROM keyword not found where expected [dbds 492]
WP trace from SM50 as below..
Sun Mar 8 11:02:45 2015
OCIStmtExecute() failed with -1=OCI_ERROR
SQL error 923:
*** ERROR => Error 923 in stmt_fetch() from oci_execute_stmt(), orpc=0
[dbsloci.c 18321]
{root-id=54FC04A65A3E18E0E1008000AAE67CA8}_{conn-id=00000000000000000000000000000000}_0
*** ERROR => ORA-00923 occurred at SQL stmt (parse error offset=720896)
[dbsloci.c 18324]
{root-id=54FC04A65A3E18E0E1008000AAE67CA8}_{conn-id=00000000000000000000000000000000}_0
Dump statement cache (after SQL error):
sc_p=1145e5588,no=133,idc_p=(nil),con=0,act=1,slen=74,smax=256,#vars=2,stmt=11511a750,table=
SELECT TOP 1 * FROM e2e_icidb_usag WHERE ACCESS_DATE BETWEEN :A0 AND :A1 ;
statement for table ' ':
SELECT TOP 1 * FROM e2e_icidb_usag WHERE ACCESS_DATE BETWEEN :A0 AND :A1
stmt_fetch() -> orc=923, 99=DBSL_ERR_DB
Dump statement cache (rc=99=DBSL_ERR_DB):
sc_p=1145e5588,no=133,idc_p=(nil),con=0,act=1,slen=74,smax=256,#vars=2,stmt=11511a750,table=
Dumping stmt. cache (DBSL private attributes):
sch=8, scp=0, ups_sch=, stp=8, r_c=0
prep=0, lit=0, nsql=1, lobret_cnt=0, fae_cnt=0, xop=1, dbcount=0
IN : col_cnt=2, row_max=1, row_xcnt=0, row_pcnt=0, row_i=0, row_total=0,
row_upto=4294967295, row_size=32, vda_max=32, bound=1, itp=0, vda_arr=0
lob_anz=0, lob_max=0, lob_pw=0, lobarr=, rows_ret=0
OUT: col_cnt=2, row_max=4062, row_xcnt=4062, row_pcnt=0, row_i=0, row_total=0,
row_upto=4294967295, row_size=28, vda_max=32, bound=1, itp=0, vda_arr=0
lob_anz=0, lob_max=0, lob_pw=0, lobarr=, rows_ret=0
SELECT TOP 1 * FROM e2e_icidb_usag WHERE ACCESS_DATE BETWEEN :A0 AND :A1 ;
head_p=fffffffffff9068: dbsl err=99=DBSL_ERR_DB -> dbds err=1=DS_SQLERR, dbdsoci.c:1185
*** ERROR => ^^ Ds_fetch() -> err=1=DS_SQLERR
[dbdsoci.c 1265]
{root-id=54FC04A65A3E18E0E1008000AAE67CA8}_{conn-id=00000000000000000000000000000000}_0
***LOG BY2=> sql error 923 performing FET [dbds 492]
***LOG BY0=> ORA-00923: FROM keyword not found where expected [dbds 492]
***LOG BY1=> sql error 923 [dbacds 1823]
Hi Guys,
Thanks for the quick update, we will update you once implement the SNote in our landscape..
Thank you very much.
Regards,
Rishi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rishiraj,
Hope your issue have already been resolved,if not you could refer SAP Note 2068061 - System log (SM21) error messages ORA-00923 (Oracle) or SQL0104N (DB6) in relation to repo...
Hope this will help you.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rishiraj ,
Please check the following Note and apply the correction
2064671 - SQL error caused by iCI function module E2E_ICIDB_USAGE_REPORTING
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.