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 to [Release 11.1]
Information in this document applies to any platform.


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


 Recently installed or higher patch.


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