dwloader.exe - Load has failed - object type conversion error

I'm trying to use dwloader.exe to upload data to PDW. However, the load fails even on a small example

C:\Users\vm>dwloader.exe -i "Z:\droptest.txt" -T databasename.dbo.droptest -R "C:\Users\vm\Desktop\input.bad" -U USERNAME -P "PASSWORD" -S 00.00.00.000
[2015-08-25 11:07:53] Starting Load
[2015-08-25 11:07:55] Connected to Microsoft SQL Server 2012 Parallel Data Warehouse (10.0.7365.0)
[2015-08-25 11:07:55] Load has started
[2015-08-25 11:07:55] Status: Running, Run Id: 76 - Total Rows Processed: 0, Total Rows Rejected: 0
[2015-08-25 11:07:56] Load error: Object of type 'System.Collections.Generic.Dictionary`2[System.Int32,System.String]' cannot be converted to type 'System.String[]'.
[2015-08-25 11:07:56] Load has Failed


In this example, I'm loading small text file containing

asjhasjas
asjdhsajd
08884883d

to the table that was created as

USE [databasename]
CREATE TABLE [dbo].[droptest](
    a nvarchar(10)
)

All attempts to find resolution for this issue have led me to general discussions about type conversions in C++. But I'm not programming here anything, I'm just trying to use dwloader.exe "out-of-the-box". Thank you.

August 25th, 2015 4:25pm

Hi Stark,

Thank you for your question.  

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.  

Thank you for your understanding and support. 

Thanks,

Free Windows Admin Tool Kit Click here and download it now
August 27th, 2015 3:14am

It is parallel data warehouse issue, not Analysis Services issue.

Anyway, can you check the file format of the text file? For example, is it a Unix style text file? (row terminated by LF, not CR+LF)? What's the encoding? dwloader may only recognize windows style text file and proper encoding.

I suggest that you use/convert to windows style text file, and add single row to test first.

Also, make sure your dwloader tool has been updated to the new AU version.

August 27th, 2015 7:44am


Thank you for the comments! Apparently, I was using dwloader from Analytics Platform System Appliance Update 3 which is incompatible with Update 4. Once, I downloaded new version from http://www.microsoft.com/en-us/download/details.aspx?id=48241 - it worked just fine.
  • Marked as answer by Lord_Stark 5 hours 47 minutes ago
Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2015 9:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics