2823208 - DB6: CLI0113E SQLSTATE 22007 occurs during data extraction in T-cd:RSA3

• The data extraction in T-cd: RSA3 completed succesfully while no data were extracted. And you got the screens like following:

• The following errors can be found in the system log and the dev trace:
  SM21 system log:
  BY 2 Database error -99999 at OPC
  BY 0 > CLI0113E SQLSTATE 22007: An invalid datetime format was
  BY 0 > detected; that is, an invalid string representation or value
  BY 0 > was specified. SQLSTATE=22007 row=1 col=2
  BY 1 Database error -99999
  
  dev trace:
  C *** ERROR in DB6Open[dbdb6.c, 3805] CON = 3 (BEGIN)
  C &+ dsql_db6_open( SQLExecute ): [IBM][CLI Driver] CLI0113E SQLSTATE 22007: An invalid datetime format was detected;
  C &+ that is, an invalid string representation or value was specified. SQLSTATE=22007 row=1 col=2
  C &+
  C &+ SELECT TABNAME,SUBSTR(REPLACE(REPLACE(SUBSTR(VARCHAR(SNAPSHOT_TIMESTAMP),1,19),'.',''),'-',''),1,14), CARD,
  C &+ DATA_OBJECT_P_SIZE+LOB_OBJECT_P_SIZE+LONG_OBJECT_P_SIZE+XML_OBJECT_P_SIZE+COL_OBJECT_P_SIZE, INDEX_OBJECT_P_SIZ
  C &+ E, 0, ' ', ' ' FROM SYSIBM.SYSDUMMY1,SAPTOOLS.DBH_STG_TABLESTO WHERE TABSCHEMA = ? AND SNAPSHOT_TIMES
  C &+ TAMP >= ? AND SNAPSHOT_TIMESTAMP <= ? ORDER BY TABNAME, SNAPSHOT_TIMESTAMP
  C &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=-1, op_type=18, read_only=0
  C &+
  C &+ Input SQLDA:
  C &+ 1 CT=WCHAR T=VARCHAR L=40 P=60 S=0
  C &+ 2 CT=WCHAR T=VARCHAR L=52 P=78 S=0
  C &+ 3 CT=WCHAR T=VARCHAR L=52 P=78 S=0
  C &+
  C &+ Input data:
  C &+ row 1: 1 WCHAR I=12 "SAP<SID>"
  C &+ 2 WCHAR I=2 " "
  C &+ 3 WCHAR I=2 " "
  C &+
  C &+ ABAP location info 'CL_SQL_STATEMENT==============CP', 494
  C &+ SAP user 'xxxx', transaction code 'RSA3'
  C &+
  C *** ERROR in DB6Open[dbdb6.c, 3805] (END)
  B ***LOG BY2=> sql error -99999 performing OPC [dbds 398]
  B ***LOG BY0=> CLI0113E SQLSTATE 22007: An invalid datetime format was detected; that is, an invalid string representation or value was specified. SQLSTATE=22007 row=1 col=2 [dbds 398]
  B ***LOG BY1=> sql error -99999 [dbacds 1843]
  
  

 SAP on IBM Db2 for Linux, UNIX, and Windows

CLI0113E, SQLSTATE 22007,  An invalid datetime format was detected, SAPTOOLS.DBH_STG_TABLESTO, SNAPSHOT_TIMESTAMP , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem