1848921 - Errors caused by RSDB2DAL after applying support packages | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1848921 - Errors caused by RSDB2DAL after applying support packages

Symptom

After applying basis support packages you see error messages in the system log (SM21) and the developer traces (ST11) which are caused by report RSDB2DAL.
Depending on which relational database management system (= RDBMS) you are using the errors differ, examples are:

  • Oracle - based system:

    OCIStmtExecute() failed with -1=OCI_ERROR

    SQL error 936:
    *** ERROR => Error 936 in stmt_execute() from oci_execute_stmt(), orpc=0

    *** ERROR => ORA-00936 occurred at SQL stmt (parse error offset=3080192)

    DELETE FROM DB2CLINETSTATS WHERE intervalend < current timestamp - 7 days;

    ***LOG BY2=> sql error 936 performing EXE
    ***LOG BY0=> ORA-00936: missing expression
    ***LOG BY1=> sql error 936  


    Database error 936 at EXE
    > ORA-00936: missing expression
    Database error 936

  • Microsoft SQL Server - based system:

    Database error 102 at EXE
    Incorrect syntax near 'timestamp'.
    Program: RSDB2DAL

    ERROR: -1 in function ExeNormalModify (execute)
    (156) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'current'.
    ERROR: -1 in function ExeNormalModify (execute)
    (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.
    invalid syntax near keyword 'current': <DELETE FROM DB2CLINETSTATS WHERE intervalend < current timestamp - 7 days
    /* R3:CL_SQL_STATEMENT==============CP:975 T:DB2CLINETSTATS */
    >
    rewrote statement to <DELETE FROM DB2CLINETSTATS WHERE intervalend < "current" timestamp - 7 days
    /* R3:CL_SQL_STATEMENT==============CP:975 T:DB2CLINETSTATS */
    >
    ERROR: -1 in function ExeNormalModify (execute)
    (102) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'timestamp'.
    ERROR: -1 in function ExeNormalModify (execute)
    (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.
    dbdsmss: DBSL99 SQL102
    Incorrect syntax near 'timestamp'.
    ***LOG BY2=> sql error 102  performing EXE  
    ***LOG BY0=> Incorrect syntax near 'timestamp'.
    ***LOG BY1=> sql error 102

  • MaxDB - based system:

    *** ERROR =>   prepare() of C_0706, rc=1, rcSQL=-3008 (POS(48)
    Invalid keyword or missing delimiter)

    *** ERROR => SQL PREPARE on connection 0, rc=-3008 (POS(48) Invalid keyword or missing delimiter)

    DELETE FROM DB2CLINETSTATS WHERE intervalend < current timestamp - 7 days ;
    ***LOG BY2=> sql error -3008 performing EXE   
    ***LOG BY0=> POS(48) Invalid keyword or missing delimiter
    ***LOG BY1=> sql error -3008


Read more...

Environment

  • SAP systems based on an ABAP Netweaver stack

Product

SAP NetWeaver all versions

Keywords

KBA , BC-CCM-MON-ORA , Database Monitors for Oracle , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-DB-ORA , Oracle , BC-DB-DB4 , DB2 for AS/400 , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-DB-ORA-CCM , CCMS/Database Monitors for Oracle , BC-DB-DB6-CCM , CCMS/Database Monitors for DB2 Universal Database , BC-DB-SDB-CCM , CCMS/Database Monitors for MaxDB , 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.