FDMEE Validation Errors Even When Mapping Exists (Doc ID 2293286.1)

Last updated on AUGUST 03, 2017

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

Data rows with unmapped dimensions exist for Period 'Jul-2017'
It was verified that all mapping exist. Still map values are not getting populated for Jul-17 period. This is happening for Prd_Duration dimension. Load is completing successfully for Jun period with same mappings.

PROCESS LOG:

File "<string>", line 1790, in updateTDATASEG_T_TDATASEGW
SQLException: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

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