2592985 - DB6: SQL0104N An unexpected token "." was found when accessing RSDCUBE and RSDODSO | SAP Knowledge Base Article

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 for DB2 Universal Database , Problem

About this page

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

Search for additional results

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