Knowledgebase: FDM
Import in FDM "Error: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 45 (Amount)"
Posted by Priya Doyle on 08 February 2011 03:16 PM

Import in FDM "Error: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 45 (Amount)"

 Modified 22-DEC-2010     Type PROBLEM 

Applies to:

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

Symptoms


When importing a gl file into FDM I am receiving the error

"Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 45 (Amount)."

Cause


The regional settings for the FDM Service Account are set to Netherlands rather than English (US).

Solution


1) Log onto the FDM server using the user id specified in the Configuration Managers (Start-> Programs-> Hyperion ->Financial Data Quality Management -> Application Server-> Application Server Config)


2) Start -> Control Panel -> Regional and Language Settings -> Update the Regional setting value from Netherlands to English(US).

3) Save the changes.


(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: