cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-00923: FROM keyword not found where expected [dbds 492]

Former Member
0 Kudos

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]

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Guys,

Thanks for the quick update, we will update you once implement the SNote in our landscape..

Thank you very much.

Regards,

Rishi

former_member182657
Active Contributor
0 Kudos

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

manumohandas82
Active Contributor
0 Kudos

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

manumohandas82
Active Contributor
0 Kudos

Hi Rishiraj ,

Is the issue fixed . Please update us the status

Thanks ,

Manu