Getting Error While Trying To Load To FDM "Arithmetic overflow error converting expression to data type datetime" (Doc ID 1455014.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.1.3.00 and later
Information in this document applies to any platform.

Symptoms

When attempting to import a csv file into FDM for one specific application the import process fails with error:

"import failed"
"Detail: Data access error"
Issue Clarification

 

Description...................................... Arithmetic overflow error converting expression to data type datetime.

Update tDataArchive Set ArchiveSuperceded = 1, ArchiveSupercededTimeStamp = N'2012-05-02 09:47:40 09:47:40' WHERE ((PartitionKey) = 1009) AND ((CatKey) = 13) AND ((PeriodKey) = N'2012-04-30 00:00:00') AND ((ArchiveSuperceded) = 0)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms