Solved

CSV File Load Error to MDW

  • 12 April 2023
  • 1 reply
  • 92 views

Badge

Hi I am just testing our V21. I have started with something simple, a 2 column CSV file with an integer key field and a text group code field. There are 18 rows.

I can load it into the ODX fine (running on local SQL Server db) and I can preview the contents in the ODX “Select Tables” Pane.

I can drag it to a Data Warehouse Data Area and it creates and maps the table fine with appropriate field settings.

When I deploy the table in the Data Area that works fine.

When Executing I get an error on the transfer which does not tell me what is happening.

 

The error I get returned is as follows:
 

Transfer table failed

Details:

Transfer table failed
Module: timeXtender
System.Exception
   at TimeXtender.DataManager.StepTransferExecute.DoDataWarehouse(IStepSetup stepSetup, List`1 mergeODXTransferInfromation, VariableResolveObject dynamicResolveObject)
   at TimeXtender.DataManager.StepTransferExecute.DoAbstractStep(IStepSetup stepSetup)

 

That means nothing to me and I cannot determine what I can do to correct.

icon

Best answer by harishkm 12 April 2023, 01:22

View original

1 reply

Userlevel 2
Badge +1

Hello @Paul McLeod Bespoke Analytics ,

 Thank you for your engagement in the TimeXtender community. 

This error could happen due to datatype mismatches.

Can you please try “synchronize data types” under advanced in the Table menu?

This option should give you suggestions if there is a data type miss match and can review and apply the changes. 

 

Please do let us know if this helps.

 

Thanks & regards,

Harish

Reply