Scheduling doesnt work (0;0 is not a valid Boolean value)

More
4 years 3 months ago - 2 years 5 months ago #21718 by marsman82
Hi,

We run into a problem where we can no longer execute packages that are planned and that contain transformations.
Running the package manually works without any problems. In the attachment you can see the logs of running both packages (1 with Agent. 1 without using Agent).

We get the following error: 0;0 is not a valid Boolean value.I myself suspect that this has to do with the fact that the agent works with a different version of the software than the Application version see this topic:

www.etl-tools.com/forum/advanced-etl-pro...affect-services.html

I hope you can help us out, bacause right now we cant run any scheduled packages containing a Transformation.
Packages containing a SQL Script seems to run fine.

Kind Regards,
Teun Marsman
Attachments:
Last edit: 2 years 5 months ago by admin.

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

More
4 years 3 months ago #21720 by admin
This is probably because you have new and old versions connected to the same repository.
I assume that you have opened and saved the transformation in the new version and now the old version is not able to execute it.

Please use version control to revert to the old version.

Mike
ETL Architect

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

More
4 years 3 months ago #21721 by marsman82
We have only one version of the application in use (6.3.10.0) but the executionagent itself runs on an older version (6.3.7.24) as described in this topic:
www.etl-tools.com/forum/advanced-etl-pro...-services.html#21719

We tried updating the execution agent (from 6.3.7.24 to 6.3.10.0) version, but without succes.

To exclude your suggestion I created a new package with only 1 transformation step (in the application with version: 6.3.10.0). Running this package manually (without agent) is working, but when I run it with the agent I get the 0;0 Boolean error.

I think updating the executionagent will solve the problem but we are not able to upgrade.

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

More
4 years 3 months ago #21722 by marsman82
We only have 1 version of the repository running on a SQL database (see attached)
Attachments:

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

More
4 years 3 months ago #21723 by marsman82
I installed 6.3.10.0 on another server in out network and the Service is running on version 6.3.10.0 on that machine. If I execute a scheduled task on that machine the package is running fine.

We are desperately looking for a way to upgrade the services on the BM-APP. Can I un-install and re-install the application (including the services) without any problems?

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

More
4 years 3 months ago #21724 by admin
When you installed the software did you select services?

Mike
ETL Architect
Attachments:

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