Sql task bug 8.3.0 - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

thomas
Free support Topic Starter

2017-11-28T12:09:09Z

I assume this is a bug, or a it is a change in implemention I have missed.

This works in 8.2.5

It fails in 8.3.0 with the message 'Must declare the scalar variable "@dt"'. Should be fairly simple to reproduce. When we downgraded to 8.2.5, all our jobs disappeared again, but that has been a problem since 8.2.5 for us.

Edited by moderator 2017-11-29T09:12:03Z | Reason: Not specified

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official support

2017-11-28T12:17:20Z

Hmm..this query work for me. Can you export the Job and send to support@visualcron.com?

About downgrade issues this will disappear from version 8.3.1 where we have added a fallback method for when new properties cannot be read by old version.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

Support
Official support

2017-11-28T12:17:52Z

Also, are you using MSSQL->Direct mode?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

thomas
Free support Topic Starter

2017-11-28T12:22:33Z

Hi

I will have to check out this a bit later. ALl out jobs disappeared when downgrading to 8.2.5, so I'm a tiny bit busy here. My guess from the logs it has something to do with this error (the xml error)

Edited by user 2017-11-28T12:23:08Z | Reason: Not specified

Support
Official support

2017-11-28T12:32:16Z

Originally Posted by: thomas

Hi

I will have to check out this a bit later. ALl out jobs disappeared when downgrading to 8.2.5, so I'm a tiny bit busy here. My guess from the logs it has something to do with this error (the xml error)

Yes, we can help you restoring it if you email the zipped file in question of the log to support@visualcron.com

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

thomas
Free support Topic Starter

2017-11-28T12:32:18Z

I sent you the server_startup logfile on email to support.

Support
Official support

2017-11-28T13:04:25Z

This issue is not related to the lost settings. We need an export of the Job (File->Export) for this specific SQL Task.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

thomas
Free support Topic Starter

2017-11-28T13:09:10Z

Sure, I will send one later today

thomas
Free support Topic Starter

2017-11-28T14:16:27Z

This started working when I replaced the xml I received from you guys. Maybe it was restarting the server that helped. I don't know. Anyway you may close this. Thanks for your help!