Receiving "Error Converting Data Type Nvarchar To Numeric" SQL Message When Importing File In FDMEE
Last updated on DECEMBER 12, 2017
Applies to:Hyperion Financial Data Quality Management, Enterprise Edition - Version 22.214.171.124.500 to 126.96.36.199.700 [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 188.8.131.52.500 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