access violation in demo

More
12 years 9 months ago #1260 by stefania
Hello,
Hello

my english is bad, but I will try....

I evaluate your Advanced ETL Processor, but I have a problem.

The problem is an access violation. Please have look at this screenshot

I think, it is a fault in the *.ats-File, which I email.
Application Name Advanced ETL Processor

Exact steps required to reproduce it When I want to run at command line or in GUI, after an illegal(?) change of configuration.

Version number Current

Operation system version Windows XP32

Database version Sybase ASA 9 ODBC

St

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

More
12 years 9 months ago #1262 by admin
Replied by admin on topic Re: access violation in demo
By looking at your transformation script I can that you are using:

select table1.*,table2.* from table1,table2 where ....

have you got duplicated field names between your tables?

Mike

Mike
ETL Architect

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

More
12 years 9 months ago #1263 by stefania
Yes, there are duplicated field names. I have reduced them

Same error again.

Even when I try it with different field names:

Same error again.

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

More
12 years 9 months ago #1264 by admin
Replied by admin on topic Re: access violation in demo
It is definitely related to duplicated fields in sql
I am getting the same error
Can you try the following please
once you got rid of duplications

Open validator and click ok
open transformer and click ok
try running transformation

We will have a look from our site what can we do about it.

Peter

Mike
ETL Architect

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