AutoMate Discussion Forums - SQL Connection

AutoMate Discussion

help : faq : home
Latest News: NA.com -> HS.com	latest topics : statistics

AutoMate Discussion » AUTOMATE BPA SERVER & AUTOMATE ENTERPRISE » Automate Enterprise 11 » SQL Connection - close action error

Hide

Categories

	BETA
·	AutoMate 10 & AutoMate BPA Server 10 - Public Beta
	AUTOMATE
·	Automate 11
·	AutoMate 10
·	AutoMate 9
·	AutoMate 8
·	AutoMate 7
·	AutoMate 6
·	AutoMate 5
	AUTOMATE BPA SERVER & AUTOMATE ENTERPRISE
·	Automate Enterprise 11
·	AutoMate BPA Server 10
·	AutoMate BPA Server 9
·	AutoMate BPA Server 8
·	AutoMate BPA Server 7
	GENERAL
·	General Discussion
·	Sample Tasks
·	Suggestions
·	Lounge
	KNOWLEDGE BASE
·	KB Articles
·	AutoMate / Automate
·	AutoMate BPA Server / Automate Enterprise
·	Triggers / Conditions
·	Actions / Activities
·	Task Builder

Search the Forums

advanced search

AUTOMATE

Automate
AM11	11.0.6.11

AutoMate
AM10	10.7.0.3
AM9	9.0.5.4
AM8	8.0.9.0
AM7	7.1.3.0
AM6	6.2.8.0
AM5	5.5.5.1

AUTOMATE ENTERPRISE

Automate Enterprise
AME11	11.0.6.11

AutoMate BPA Server
BPA10	10.7.0.3
BPA9	9.0.5.4
BPA8	8.0.9.0
BPA7	7.1.3.0

INSITE

Insite
2.2

Topic Title: SQL Connection - close action error
Topic Summary:
Created On: 12/05/2017 06:37 AM
Status: Read Only

Linear : Threading : Single : Branch

Search Topic

Topic Tools

	View similar topics
	Print this topic.

12/05/2017 06:37 AM
JamesLankford Artisan (200-499) Posts: 369 Joined: 11/26/2012	Discovered another issue after converting a v10 task to v11. This particular task opens a SQL Connection to a database and executes some action. At the end of the task, a Close SQL Connection action is executed. On the Error Causes tab, I have 'All except selected' option set, and the 'Session could not be found.' option selected. In v10, the action will not generate an error when executing this action if the session is not open. In v11, it seems to ignore it and generates the error anyway - 'Session <sessionName> not found.' Nothing major for us, just wanted to report it. As a work-around/fix, I simply went to the On Error tab and set the 'After error event:' option to 'Continue to next step.' ------------------------- <html />
Top : Bottom

12/05/2017 01:18 PM
Justin Aucoin HelpSystems Posts: 360 Joined: 02/15/2016	Hi James, We have verified the issue and will be submitting a bug report shortly. Another workaround would be to select the error cause option Selected problems, and leave the 'Session could not be found" error un-selected. ------------------------- Justin Aucoin \| Support Analyst AutoMate \| Division of HelpSystems HelpSystems, LLC \| T: +1.213.738.1700 \| F: +1.213.738.7665
Top : Bottom

12/05/2017 01:22 PM
JamesLankford Artisan (200-499) Posts: 369 Joined: 11/26/2012	Good to know - thanks for the response! ------------------------- <html />
Top : Bottom

12/08/2017 09:54 AM
Justin Aucoin HelpSystems Posts: 360 Joined: 02/15/2016	Hello James, We apologize for the delay regarding this case. This issue has been verified and assigned a bug number #23598. We hope to correct this issue in an upcoming release of the software. You will be notified when the solution is available via email. Please let us know if you have any questions or concerns. Thank you for your help and patience. ------------------------- Justin Aucoin \| Support Analyst AutoMate \| Division of HelpSystems HelpSystems, LLC \| T: +1.213.738.1700 \| F: +1.213.738.7665
Top : Bottom

12/08/2017 09:56 AM
JamesLankford Artisan (200-499) Posts: 369 Joined: 11/26/2012	You're welcome - thanks for the update! ------------------------- <html />
Top : Bottom

AutoMate Discussion » AUTOMATE BPA SERVER & AUTOMATE ENTERPRISE » Automate Enterprise 11 » SQL Connection - close action error

Topic Tools

Statistics

18258 users are registered to the AutoMate Discussion forum.

There are currently 0 users logged in.

The most users ever online was 6686 on 11/01/2020 at 01:24 AM.

There are currently 2810 guests browsing this forum, which makes a total of 2810 users using this forum.