access violation in advanced etl ent. 3.3.3.5

More
13 years 7 months ago #782 by fabbio
Hello and thanks in advice
i'm evaluating advanced etl enterprise 3.3.3.5.
i created a \"map\" with
read validate transform write operations.
source is an odbc connection (ACUODBC driver).
destination is sqlserver 2008 connected via odbc.

the reader step read about 9100 records.
FIRST ISSUE:
The generated query to evaluate the number of record involved
select Count(*).......
doesn't work, sql error(obvioulsy the odbc driver involved).
Is there any way to set manually the count query?

the validation step check for null in 3 fields and if they contain null the validation step set a blank in it.

the transformation step merge 3 string field in one.

the write populate a table with transf. option set to add new and update old.

i'm executing the etl map from the gui.

When i execute the processing data window throw an access violation error: Access Violation error at 83EC8B55. Read of address 83EC8B55


PLease help me.
PS: i attach the etl map.
Fabio

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

More
13 years 7 months ago #783 by fabbio
fabbio wrote:

Hello and thanks in advice
i'm evaluating advanced etl enterprise 3.3.3.5.
i created a \"map\" with
read validate transform write operations.
source is an odbc connection (ACUODBC driver).
destination is sqlserver 2008 connected via odbc.

the reader step read about 9100 records.
FIRST ISSUE:
The generated query to evaluate the number of record involved
select Count(*).......
doesn't work, sql error(obvioulsy the odbc driver involved).
Is there any way to set manually the count query?

the validation step check for null in 3 fields and if they contain null the validation step set a blank in it.

the transformation step merge 3 string field in one.

the write populate a table with transf. option set to add new and update old.

i'm executing the etl map from the gui.

When i execute the processing data window throw an access violation error: Access Violation error at 83EC8B55. Read of address 83EC8B55


PLease help me.
PS: i attach the etl map.
Fabio

File Attachment:

File Name: clienti_02...enti.zip
File Size:2 KB
Attachments:

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

More
13 years 7 months ago #784 by admin
Looking at it right now

Meantime can you try version 3.3.3.6 please
Perhaps we have already fixed it

Mike

Mike
ETL Architect

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

More
13 years 7 months ago #785 by fabbio
thanks for your fast answer.
but the version check doesn't find a 3.3.3.6.
so i've tried to download manually, but your site tell me that
Concurrent download limit exceeded.

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

More
13 years 7 months ago #786 by admin

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

More
13 years 7 months ago #787 by fabbio
thanks i'll try it asap

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