topic Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The statement has been terminated. in Product Forum

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The statement has been terminated.

Raviteja.Patchava — Fri, 01 Dec 2023 18:05:00 GMT

Hello Everyone! I am using Blueprism version 7.1 and I am currently getting this error when trying to execute an sql query using Data - SQL Server - Execute Action. Basically this query updates like 1000+rows in the table and it is taking like 20 seconds to complete when I am trying to execute the same query in MS SQL Server. There is no problem identified in connecting to the database but still it is not able to complete the execution. Any help/suggestions are very much appreciated as I am stuck currently at this point.

Thanks in advance 🙂

------------------------------
RAVITEJA PATCHAVA
------------------------------

RE: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The statement has been terminated.

LeonardoSQueiroz — Sat, 02 Dec 2023 22:31:00 GMT

Hello,

Check the solution in this article: https://community.blueprism.com/communities/community-home/digestviewer/viewthread?MessageKey=34e184b7-83ed-4b1c-9e78-5d1ec527429b&CommunityKey=0eb42ccc-db4b-4048-b061-c3608dc3d713&t ab=digestviewer

Apparently the problem is similar.

Regards,

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------

RE: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The statement has been terminated.

harish.mogulluri — Sun, 03 Dec 2023 04:24:00 GMT

HI Ravi Teja Patchava,

I would suggest to use SQL Bulk insert it will be faster and more reliable.

Check below Post

https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&MessageKey=c3a68bf1-db6b-469a-a841-9cbd1a7befcb&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------