SAP Knowledge Base Article - Preview

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

Symptom

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

1.jpg

Jul19_2.PNG

Jul19_3.PNG

  • 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

Product

SAP enhancement package 1 for SAP NetWeaver 7.3

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.