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.