Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Error - Time Out and fail after execution a simple scritp SQL
Topic Summary: Time out error when use conection string to SQL Server-
Created On: 12/15/2017 06:59 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 12/15/2017 06:59 AM
User is offline View Users Profile Print this message

Author Icon
IvarzAlvarez Holguin
n00b (>6 posts)

Posts: 5
Joined: 12/15/2017

when we try to execute an SQL script making a connection type "Connection String" it gives an error and it is cut at 30 seconds when in a normal execution it takes 60 seconds.

We have Automate Enterprise 11 installed.

We have tried by all means trying to set the time out but nothing,

If someone can help, I'll appreciate it.

 



Edited: 12/15/2017 at 07:12 AM by IvarzAlvarez Holguin
 12/15/2017 07:11 AM
User is offline View Users Profile Print this message

Author Icon
Leonard Amabile
HelpSystems

Posts: 5454
Joined: 05/15/2007

Hi Ivarz,

What version of Automate 11 are you running and on what version of Windows? What version of SQL Server are you connecting to? Did this work in previous versions of Automate?




-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665
 12/15/2017 07:21 AM
User is offline View Users Profile Print this message

Author Icon
IvarzAlvarez Holguin
n00b (>6 posts)

Posts: 5
Joined: 12/15/2017

Thanks Leonard,

Automate Version 11.0.1.17

Windows version 64 bit - Windows Server 2012 R2

SQL: 

Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)   Oct 28 2016 18:17:30   Copyright (c) Microsoft Corporation  Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) 

 

No, this is the first time that we are trying to implement BPA in our processes and we have just acquired the product.

 

 12/15/2017 07:28 AM
User is offline View Users Profile Print this message

Author Icon
IvarzAlvarez Holguin
n00b (>6 posts)

Posts: 5
Joined: 12/15/2017

attached image



Click for full image
Click for larger image
Click for full image
Click for larger image

 12/18/2017 03:06 AM
User is offline View Users Profile Print this message

Author Icon
IvarzAlvarez Holguin
n00b (>6 posts)

Posts: 5
Joined: 12/15/2017

HI Leonardo, can you help me with this??

 12/18/2017 02:15 PM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hello,

Would it be possible to set-up a GoToAssist session where we can take a closer look at this issue? If this is possible please send an email over to AutoMate.Support@helpsystems.com with a list of your availability.

Note: Please reference this forum thread in your email.


-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
 12/18/2017 03:18 PM
User is offline View Users Profile Print this message

Author Icon
Devin Cannon
HelpSystems

Posts: 398
Joined: 03/17/2016

Hi Ivarz,

There is currently a bug for this issue in our system.  The bug # is 23622.  We hope to address the bug in the next software release in early 2018.

I apologize for the inconvenience.



-------------------------

Devin Cannon | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665
 12/20/2017 01:55 AM
User is offline View Users Profile Print this message

Author Icon
IvarzAlvarez Holguin
n00b (>6 posts)

Posts: 5
Joined: 12/15/2017

Thanks Ricardo, I will send you a email.

 02/07/2018 11:39 AM
User is offline View Users Profile Print this message

Author Icon
JimBerg
Journeyman (50-99)

Posts: 64
Joined: 03/02/2015

did you try using the Sql Client version 11 instead of the OLEDB client?
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 1260 guests browsing this forum, which makes a total of 1260 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog