Receiving "Error Converting Data Type Nvarchar To Numeric" SQL Message When Importing File In FDMEE

(Doc ID 2338028.1)

Last updated on DECEMBER 12, 2017

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.3.500 to 11.1.2.3.700 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When importing a flat file into FDMEE, I am receiving the following error:
2017-12-11 09:51:40,670 FATAL [AIF]: Error in Comm.doScriptInit
Traceback (most recent call last):
  File "", line 369, in doScriptInit
  File "", line 1079, in getProfileOptionValue
SQLException: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Error converting data type nvarchar to numeric.

This is happening with multiple FDMEE locations/import formats. 

This appears to be happening only on SQL Server database

Changes

 Recently installed 11.1.2.3.500 or higher patch.

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