Hi,

I am trying to add some information to an email:

• Jobname: {JOB(Active|Name)}
  
• Server: {COMPUTER(Name)}
  
• Connection string: {TASK(5cced103-a6df-4bef-91de-347b7f02b44a|ConnectionString)}

But I can't get ConnectionString to work - it appears as "Error in argument".

I have not managed to get a single job to be able to write out the connection string, they all fail with the above error.
The jobs has been imported from VisualCron version 8.0.2 and into the latest version just installed.
In the earlier version mentioned above, there was a "comma" between the guid and the variable name, today it is a pipe, but either of them work.

Thanks.

Update:
Looking at the variables in the Variable Window, the connection string comes out the following way:

• Data Source=[server name,port];Initial Catalog=[database name];Integrated Security=True;Password=

In version 8.0.2, the connection string was looking this way:

• Server=[server name];Database=[database name,port];Trusted_Connection=true;Integrated Security=true;

The two lines are very different.

About connection string format. We have not changed this. I can only guess it is a new/different Connection you created.

About the Error in argument. It "looks" ok and we verified that it should work. First, do you really want to use a Task id? It is probably easier, if you do something generic, if you use it in Notification, that you use PrevTask instead:

{TASK(PrevTask|ConnectionString)}

That being said, if still does no work we would like to know more how and where you reference to it. One test should be:

1. create a Job with a file write Task that writes this value to a file

If above fails, please export this Job, the Connection and the original Job (with the Task that you reference) and send to support@visualcron.com

---

Hi Henrik,

I have created a test job that writes the connection string in a mail and to a file, and both places the result is "Error in argument".
I have exported the job, and tried to import it to a version 8.0.2 VisualCron, which is not possible (error in xml file, it says)
however, the connection did not fail and was imported.

Then I have created a similar job in the 8.0.2 server and pointed to the imported conenction, and the connectionstring came out just fine: "Server=ASERVER.net,12345;Database=Temp_UAT;Trusted_Connection=true;Integrated Security=true;"

I will send the exported XML to you and hopefully you are able to see what is wrong.

Thanks.

Hi Henrik,

I have created a test job that writes the connection string in a mail and to a file, and both places the result is "Error in argument".
I have exported the job, and tried to import it to a version 8.0.2 VisualCron, which is not possible (error in xml file, it says)
however, the connection did not fail and was imported.

Then I have created a similar job in the 8.0.2 server and pointed to the imported conenction, and the connectionstring came out just fine: "Server=ASERVER.net,12345;Database=Temp_UAT;Trusted_Connection=true;Integrated Security=true;"

I will send the exported XML to you and hopefully you are able to see what is wrong.

Thanks.

Ok, we will await your files.

---

Ok, we will await your files.

Hi Henrik,

Where are we with this?
I can't remember if I sent you something or not :-)
But I have the job ready for you - where should I put it please?

Thanks
Peter

Ok, we will await your files.

Hi Henrik,

Where are we with this?
I can't remember if I sent you something or not :-)
But I have the job ready for you - where should I put it please?

Thanks
Peter

Please send files and information to support@visualcron.com

---

Hi,

The job has now been sent.

Thanks.

This looks to have been solved as of the latest versions (9.x)

---