Symptom
- 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]
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
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
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.