- Posts: 17
- Thank you received: 1
Error when opening QVD File created by Advanced ETL Processor
- eschnadower
- Topic Author
- Offline
- New Member
-
Less
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.
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.
Last edit: 8 years 2 months ago by eschnadower. Reason: Forfot the attachment
Please Log in or Create an account to join the conversation.
8 years 2 months ago #13275
by admin
Mike
ETL Architect
Replied by admin on topic Error when opening QVD File created by Advanced ETL Processor
Can you try placing transformer between reader and writer.
If it still does not work provide us with the QVD file
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.
- eschnadower
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 17
- Thank you received: 1
8 years 2 months ago #13276
by eschnadower
Replied by eschnadower on topic Error when opening QVD File created by Advanced ETL Processor
It's still not working. How can I send you the QVD file?
It's 55 mb, too large for the forum.
It's 55 mb, too large for the forum.
Please Log in or Create an account to join the conversation.
8 years 2 months ago #13277
by admin
Mike
ETL Architect
Replied by admin on topic Error when opening QVD File created by Advanced ETL Processor
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.
- eschnadower
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 17
- Thank you received: 1
8 years 2 months ago - 8 years 2 months ago #13278
by eschnadower
Replied by eschnadower on topic Error when opening QVD File created by Advanced ETL Processor
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.
By the way, QVX files work fine, but we need to generate QVD's.
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.
8 years 2 months ago #13280
by admin
Mike
ETL Architect
Replied by admin on topic Error when opening QVD File created by Advanced ETL Processor
Can you try the following please
1) Reformat the field names (right click ans select format fields names)
2) trim field values
1) Reformat the field names (right click ans select format fields names)
2) trim field values
Mike
ETL Architect
Please Log in or Create an account to join the conversation.