HomeForum
Welcome, Guest

access violation in demo
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: access violation in demo

access violation in demo 1 year, 5 months ago #1260

  • stefania
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
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

Re: access violation in demo 1 year, 5 months ago #1262

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2174
  • Karma: 12
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

Re: access violation in demo 1 year, 5 months ago #1263

  • stefania
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
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.

Re: access violation in demo 1 year, 5 months ago #1264

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2174
  • Karma: 12
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
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

"This [Visual Importer ETL] is such a great help. As expected, it has paid for itself within one week!"

Phill Stive,
Oracle DBA, OU,
Newcaste

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top