Knowledgebase: FDM
Unable To Import a Text File in The FDM Web Client, Error: "There are fewer columns in the INSERT statement than values specified in the VALUES clause"
Posted by Priya Doyle on 08 February 2011 03:56 PM

Unable To Import a Text File in The FDM Web Client, Error: "There are fewer columns in the INSERT statement than values specified in the VALUES clause"

 Modified 24-JAN-2011     Type PROBLEM 

Applies to:

Hyperion Financial Data Quality Management - Version: 9.3.1.0.00 to 11.1.2.0.00 - Release: 9.3 to 11.1
Information in this document applies to any platform.

Symptoms

When attempting to perform an import of a text file into FDM the following error is returned:
Code......................................... -2147217900
Description..................................There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

INSERT INTO tWfdmuse124439123324 (PartitionKey, CatKey, PeriodKey, DataView, Account, Entity, ICP, UD1, UD2, UD3, UD4, UD5, UD6, Desc1, Desc2, Attr1, Attr2, Attr3, Attr4, MemoKey, Amount ) VALUES (748, 12, '20110131', 'YTD', '2644', '2', '00', 'CLO', '2644', 'SE_Input', '2644', '', '', '', '', '', '', '', '', '', 'Reppucci Avv. Teodoro', '', '', '', '','', 0, -17333,00)
Procedure.................................... clsDataManipulation.fExecuteDML
Component.................................... upsWDataWindowDM
ERROR:
Code......................................... -2147217900
Description.................................. Data access error.
Procedure.................................... clsImpDataPump.fProcessSQLInsertValues
Component.................................... upsWObjectsDM
ERROR:
Code......................................... -2147217900
Description.................................. Data access error.
Procedure.................................... clsImpDataPump.fImportTextFile
Component.................................... upsWObjectsDM 

Cause

The numeric format of the amount is incorrect. The Decimal Replacement Configuration Setting was not adjusted correctly. 

Solution

1. Launch the FDM Web Client.
2. Go to 'Administration' menu and select 'Configuration Settings'.
3. Go to Options Combo box and select option 'Decimal Replacement'.
4. Set the value to the default of  'None'.
5. Click Save.


(0 vote(s))
Helpful
Not helpful

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