FDM - Arithmetic Overflow Error In Control Table Periods For Essbase Adapter Code -2147217833 (Doc ID 1274172.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.2.0.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms


Problem while customizing the control table Periods for Essbase adapter ES11X-G4-G.
If change the Essbase adapter entry accordingly:

Period (1/31/2010) / Target Per (P01.2010) / Year Target (Empty)

and click on "Update Grid" after wards receiving the following error:

"Error: Errorcode: -2147217833; Source: clsSQLUpdateMgr.fPOVPeriodAdaptorFromKey Detail: Data access
error"

The error log gives the following details: (complete error log also attached to this SR)

ERROR:
Code............................................. -2147217833
Description...................................... Arithmetic overflow error converting expression to
data type datetime.
SELECT * FROM tPOVPeriodAdaptor WHERE (PeriodKey = N'31.01.2010 00:00:00') AND (IntSystemKey = N'ES11X-
G4-G')
Procedure........................................ clsDataAccess.farsKeySet
Component........................................ upsWDataWindowDM
Version.......................................... 1112
Thread........................................... 7916

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