1848921 - Errors caused by RSDB2DAL after applying support packages

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

• SAP systems based on an ABAP Netweaver stack

Oracle, 19c, 18c, 12c, 11g, 10g , KBA , BC-CCM-MON-ORA , Database Monitors for Oracle , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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 , BC-DB-SDB-CCM , CCMS/Database Monitors , BC-DB-DB6-CCM , CCMS/Database Monitors , Problem