Print Page | Close Window

SQL Server 2017

Printed From: Parker Software Ltd
Category: ThinkAutomation Business Process Automation
Forum Name: ThinkAutomation Version 4
Forum Description: For questions relating to ThinkAutomation Version 4
URL: http://www.parkersoftware.com/forum/forum_posts.asp?TID=9399
Printed Date: 05 Jul 2020 at 11:04pm
Software Version: Web Wiz Forums 11.05 - http://www.webwizforums.com


Topic: SQL Server 2017
Posted By: bmorency
Subject: SQL Server 2017
Date Posted: 16 May 2019 at 3:09pm
Hi,

We are upgrading to MS Sql server 2017 standard and I am wondering is thinkautomation v4.2.1691 will work without issues on this version of SQL server?

Thank you.

Beau



Replies:
Posted By: paul.oconnor
Date Posted: 21 May 2019 at 12:10pm
Hi Beau,

ThinkAutomation currently does support SQL 2017

Regards,
Paul O


-------------
Paul O


Posted By: bmorency
Date Posted: 23 May 2019 at 1:38pm
Hello,

Thank you. I do have a question about the migration though. I am testing the migration and I have been able to move over the thinkautomation databases to a new sql 2017 server.  The software seems to connect properly after I added new login credentials since I am moving the admin console to a new server as well.

My question is for the database I am connecting to to record the data that is parsed from email I get errors saying access denied. But when I open the connection strings inside each trigger and re create them it will connect. Is there any way to fix the connection strings inside each trigger quicker? Each trigger does multiple DB connections so doing this will be time consuming.

Thank you.

Beau


Posted By: paul.oconnor
Date Posted: 23 May 2019 at 3:15pm
Hello Beau,

All trigger action and their properties are stored in the Metadata Database, in the xml column. You can modify the trigger that way. I'm not sure how much faster that will be from the manual process.

I'd highly suggest using constants (global variables) in situationis like this. For more information on constants see:  https://www.thinkautomation.com/help/organizations.htm" rel="nofollow - https://www.thinkautomation.com/help/organizations.htm


-------------
Paul O


Posted By: bmorency
Date Posted: 23 May 2019 at 3:27pm
Hello,

Thank you for the suggestion. I did not realize you can use a variable in that field for the connection string. That would make things very much easier to change.
 
I will look into doing that.

Thank you.

Beau


Posted By: bmorency
Date Posted: 24 May 2019 at 8:03am
Hi,

I am trying to use a constant variable as the connection string. I created the constant variable as DBConnection with the connection string taken from the lookup that I am trying to replace. When I go into the trigger for a lookup I enter my variable as %DBConnection%. When I hit the test button I get an error saying it cannot open the database with the specified connection string and that I should check login info.

Should the test button work with a variable in place of the connection string?

Thank you.

Beau


Posted By: Daniel Horton
Date Posted: 24 May 2019 at 8:07am
The test button will not function with a constant, this is expected. It will only be replaced on execution. 

The best way to test is to place in the connection string in its true form, test, then replace with the variable and test against a full message within the account. 


-------------
Best Regards,



Daniel James Horton

Technical Manager

Parker Software



Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.05 - http://www.webwizforums.com
Copyright ©2001-2016 Web Wiz Ltd. - https://www.webwiz.co.uk