My Oracle Support Banner

Migration Application IRR Date Time Format Error: [IBM][CLI Driver][DB2] SQL20448N "2020-04-29 00:32:35" cannot be interpreted using format string "MM/DD/YYYY HH24:MI:SS" for the TIMESTAMP_FORMAT function. SQLSTATE=22007 (Doc ID 2667862.1)

Last updated on MAY 21, 2020

Applies to:

Siebel CRM - Version 19.12 and later
Information in this document applies to any platform.

Symptoms

 Running the Siebel Migration Application IRR (Incremental Repository Migration) with a DB2 Z/OS database, the followings data time format errors occurred while exporting the Siebel Repository.

2020-04-29 00:32:34 Process Name: Repository Import/Export Utility, Status: Started, Parameter: , Message

2020-04-29 00:32:35 SQL Warning, SQL State 22007, -20448, [IBM][CLI Driver][DB2] SQL20448N "2020-04-28 14:10:23" cannot be interpreted using format string "MM/DD/YYYY HH24:MI:SS" for the TIMESTAMP_FORMAT function. SQLSTATE=22007 

2020-04-29 00:32:35 SQL Statement:

SELECT COUNT(*) FROM CQ202002.S_DOCK_OBJECT TBL1

WHERE TBL1.REPOSITORY_ID = '88-1MBZ-1'

AND TBL1.DB_LAST_UPD BETWEEN TIMESTAMP_FORMAT('2020-04-28 14:10:23','MM/DD/YYYY HH24:MI:SS') AND TIMESTAMP_FORMAT('2020-04-28 17:32:37.545642','YYYY-MM-DD HH24:MI:SS:NNNNNN')

2020-04-29 00:32:35 [IBM][CLI Driver][DB2] SQL20448N "2020-04-28 14:10:23" cannot be interpreted using format string "MM/DD/YYYY HH24:MI:SS" for the TIMESTAMP_FORMAT function. SQLSTATE=22007 

2020-04-29 00:32:35

2020-04-29 00:32:35 22007: [IBM][CLI Driver][DB2] SQL20448N "2020-04-28 14:10:23" cannot be interpreted using format string "MM/DD/YYYY HH24:MI:SS" for the TIMESTAMP_FORMAT function. SQLSTATE=22007

2020-04-29 00:32:35

2020-04-29 00:32:35 Failed to fetch records

2020-04-29 00:32:35 Error getting modfied objects from C:\Siebel\fs\migration\88-1W0ELX\dat\repexport_39F30609F950.dat.

2020-04-29 00:32:35 Failed to identify delta for design time data.

2020-04-29 00:32:35 Error in Preparing Where Clause for Incremental D2P

2020-04-29 00:32:35 Error in doExport (<null>).

2020-04-29 00:32:35 Error in Main function...

2020-04-29 00:32:35 Elapsed time: 2 sec.

2020-04-29 00:32:35 (logapi.cpp (184) err=1 sys=0) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.