SAP Knowledge Base Article - Preview

2592985 - DB6: SQL0104N An unexpected token "." was found when accessing RSDCUBE and RSDODSO

Symptom

There are a lot of Database errors 104 in System log(SM21):

Database error -104 at OPC

> SQL0104N An unexpected token "." was found following "SELECT


> OBJVES FROM". Expected tokens may include: "FROM".

> SQLSTATE=42601

dev_w*:


C  &+     dsql_db6_open( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N  An unexpected token "." was found

C  &+      following "SELECT OBJVERS FROM".  Expected tokens may include:  "FROM".  SQLSTATE=42601

C  &+

C  &+     SELECT OBJVERS FROM .RSDCUBE WHERE OBJVERS = 'A' FETCH FIRST ROW ONLY


C  &+       cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, read_only=0

C  &+

C  &+     dsql_db6_open( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N  An unexpected token "." was found

C  &+      following "SELECT OBJVERS FROM".  Expected tokens may include:  "FROM".  SQLSTATE=42601

C  &+

C  &+     SELECT OBJVERS FROM .RSDODSO WHERE OBJVERS = 'A' FETCH FIRST ROW ONLY


C  &+       cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, read_only=0

C  &+


Error SQL0204N happened when accessing SAPSR3DB.RSDCUBE and SAPSR3DB.RSDODSO:


C  &+     dsql_db6_open( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N  "SAPSR3DB.RSDCUBE" is an undefine

C  &+     d name.  SQLSTATE=42704

C  &+

C  &+     SELECT OBJVERS FROM SAPSR3DB.RSDCUBE WHERE OBJVERS = 'A' FETCH FIRST ROW ONLY

C  &+       cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, read_only=0

C  &+

C  &+     dsql_db6_open( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N  "SAPSR3DB.RSDODSO" is an undefine

C  &+     d name.  SQLSTATE=42704

C  &+

C  &+     SELECT OBJVERS FROM SAPSR3DB.RSDODSO WHERE OBJVERS = 'A' FETCH FIRST ROW ONLY

C  &+       cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, read_only=0

C  &+


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

SQL0104N, SQL0204N, RSDCUBE, RSDODSO, DBA Cockpit, BW system, BI_CONT, InfoCube, InfoProvider, DataStore, DSO, SM21, System log, Java system, ABAP System, Non-ABAP System, undefined name, unexpected token , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-CCM , CCMS/Database Monitors , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.