Error when opening QVD File created by Advanced ETL Processor

More
8 years 2 months ago - 8 years 2 months ago #13272 by eschnadower
Hello, I am evaluating Advanced ETL Processor for a possible purchase.
I just finished doing an extraction of a QVD file. In advanced etl processor it shows that it is sucessful.
In Qlikview, however, the application says "Unknown Error" when I try to open de file.

Is this a compatibility issue between Advanced ETL Processor and the particular QlikView version I am using? Or is there something else?

I attach the word file with all the info.
Attachments:
Last edit: 8 years 2 months ago by eschnadower. Reason: Forfot the attachment

Please Log in or Create an account to join the conversation.

More
8 years 2 months ago #13275 by admin
Can you try placing transformer between reader and writer.

If it still does not work provide us with the QVD file

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
8 years 2 months ago #13276 by eschnadower
It's still not working. How can I send you the QVD file?
It's 55 mb, too large for the forum.

Please Log in or Create an account to join the conversation.

More
8 years 2 months ago #13277 by admin
Well create smaller qvd (add where filter to source SQL for example)

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
8 years 2 months ago - 8 years 2 months ago #13278 by eschnadower
Here is the QVD file generated with only the first 250 rows. (Of about 1 million total)

By the way, QVX files work fine, but we need to generate QVD's.
Attachments:
Last edit: 8 years 2 months ago by eschnadower. Reason: The attachment failed, trying again

Please Log in or Create an account to join the conversation.

More
8 years 2 months ago #13280 by admin
Can you try the following please

1) Reformat the field names (right click ans select format fields names)



2) trim field values


Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.