search cancel

Error when loading transport case 'U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', '22007', 'Invalid time format''

book

Article ID: 201868

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

The following error is observed when loading a transport case:

20201014/130336.570 - U00021126 Client '0001': Importing object 'AUTOMIC/AUTOMIC' of type 'USER'.
20201014/130336.585 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: f061e0  DB-HDBC: f062c0
20201014/130336.585 - U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
20201014/130336.585 - U00003592 UCUDB - Status: '22007' Native error: '0' Msg: 'Invalid time format'
20201014/130336.585 - U00003594 UCUDB Ret: '3590' opcode: 'INSR' SQL Stmnt: 'INSERT INTO OH (OH_Client, OH_OType, OH_Name, OH_Idnr, OH_Title, OH_CrUserIdnr, OH_CrDate, OH_ModUserIdnr, OH_ModDate, OH_ModCnt, OH_LastUserIdnr, OH_LastCnt, OH_JPP_Count, OH_C0Ref, OH_NoStatUpd, OH_DeleteFlag, OH_ExpFlag, OH_MaxWait, OH_MaxParallel2, OH_MPElse, OH_OpenUserIdnr, OH_MaxRetCode, OH_MrtMethod, OH_Mrt, OH_MrtErt, OH_Frt, OH_Ert, OH_ErtCnt, OH_ErtCorr, OH_ErtIgn, OH_ErtMinCnt, OH_ErtMethod, OH_ErtTrend, OH_LastRuns, OH_Srt, OH_SrtErt, OH_FcstStatus, OH_UC4Priority, OH_RefIdnr, OH_OX_ContentLen, OH_OpenSession, OH_OV_Flag, OH_OV_Mode, OH_OPU_Flag, OH_OEO_Flag, OH_ChildFlags, OH_IsTemplate, OH_RollbackFlag, OH_Inactive, OH_DeactDelay, OH_AEVersion, OH_LastCommitDate, OH_VersioningId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
20201014/130336.585 - U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR   ', '22007', 'Invalid time format'

Resolution

When unloading the transport case make sure the DB Unload utility is the same version as the database. If the DB Unload is a newer version it will create a transport case that is corrupt and cannot be loaded into another system.