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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-12-23 06:05 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-12-23 10:31 PM
------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-12-23 04:24 AM
HI Ravi Teja Patchava,
I would suggest to use SQL Bulk insert it will be faster and more reliable.
------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"
Harish Mogulluri
Lead developer
America/New_York TX
------------------------------
If I answered your query. Please mark it as the Best Answer
Harish Mogulluri