My Oracle Support Banner

Unable to Complete Conflict Resolution After IRM Execution Due To Invalid Date Format Error When Doing Insert Into S_INST_UPG_HIST (Doc ID 2667960.1)

Last updated on MAY 07, 2020

Applies to:

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


When attempting to finalize IRM, on the step that updates the upgrade history it fails with SQL Server error saying the date format is incorrect.

The date format in German is DD.MM.YYYY while the query is trying to insert in YYYY-MM-DD, which s is standard format for Siebel queries.
Since they are in different formats the query fails when trying to cast from varchar to datetime types.




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

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