converting to 64b

More
5 years 1 month ago - 5 years 1 month ago #21143 by alanwjackson
I am trying to upgrade to 64b etl enterprise
My initial tests seemed good
however i have run into a few issues where I need your help
Our main system is a progress database
we have been using the 11.1 32b odbc drivers for a long time
about a year ago we did migrate to the 64b database
I installed the 11.7 64b odbc for the database
the process in the attached works perfectly in 11.1 32b
however will not work in 64bI have included the object, logs, input file and snapshots
I have tried to rewrite the process of creating new objects. Changing it from a file import to process code and insert.
The problem is we do not have any issues at the 32b level
I have multiple similar issues at the 64b level on different objects
how do i determine the cause and determine how to fix it
Last edit: 5 years 1 month ago by admin.

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

More
5 years 1 month ago - 5 years 1 month ago #21145 by Peter.Jonson
Replied by Peter.Jonson on topic converting to 64b
Hi Alan.

I saw this error in the past.

www.etl-tools.com/forum/visual-importer/...sqlexecute-call.html

Please try the following:

1 Use the registry editor to modify the ODBC Data source under section:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
2. Add a new string value named WorkArounds with its data value set to 536870912.

Peter Jonson
ETL Developer
Last edit: 5 years 1 month ago by Peter.Jonson.

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

More
5 years 1 month ago #21146 by alanwjackson
Replied by alanwjackson on topic converting to 64b
problem solved
thank you, thank you, thank you

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

More
5 years 1 month ago #21147 by alanwjackson
Replied by alanwjackson on topic converting to 64b
I have a packages that executes every 15 minutes that pings our servers and related
Works perfect under 32b
100% failure under 64b
the attached shows the same sever being pinged from CMD and etl at the same time, on the same server

Any ideas?
Attachments:

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

More
5 years 1 month ago #21148 by admin
Replied by admin on topic converting to 64b
Hi Alan.

We have reproduced the problem and currently trying to resolve it

Mike
ETL Architect

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

More
5 years 1 month ago #21150 by Peter.Jonson
Replied by Peter.Jonson on topic converting to 64b
Hi Alan

The issue you reported was corrected in the latest release.

Peter Jonson
ETL Developer

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

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save