Start a conversation Sign in
Start a conversation
  1. Concentric Solutions Ltd
  2. Source Default Category
  3. Source Default Folder

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"


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.
Choose files or drag and drop files
Was this article helpful?
Yes
No

  1. GKontos

  2. Posted

Comments