- Posts: 2
- Thank you received: 0
access violation in demo
12 years 9 months ago #1260
by stefania
access violation in demo was created 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
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.
12 years 9 months ago #1262
by admin
Mike
ETL Architect
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
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.
12 years 9 months ago #1263
by stefania
Replied by stefania on topic Re: access violation in demo
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.
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.
12 years 9 months ago #1264
by admin
Mike
ETL Architect
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
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.