Raw SQL Step
Comments
-
Does your query need to specifically use a raw SQL step? If not, you can create a database query in place of the raw SQL step in order to specify a timeout for your query.
For more information, please view the following documentation pages:Parameterized Queries: [url=https://documentation.decisions.com/parameterized-queries/]https://documentation.decisions.com/parameterized-queries/[/url] Add Query to External Database: [url=https://documentation.decisions.com/add-query-external-database/]https://documentation.decisions.com/add-query-external-database/[/url]
Let me know if you have any additional questions or concerns.
In order to alter the default timeout settings for a query, you will need to make this change in Decisions settings.xml file.
This can be found in C:Program FilesDecisionsDecisions Services ManagerSettings.xml To change the default timeout setting, you will want to open this file (i.e. Notepad) and find the DefaultDatabaseQueryTimeout tag. Here, youll want to change the default number (in my case, the default is 60) to the desired number of seconds. Save. You may need to restart Service Host Manager as well, in order to apply the changes.
Let me know if this is what you are looking for or if you need additional assistance with this issue.
Howdy, Stranger!
Categories
- 4.1K All Categories
- 61 General
- 11 Training
- 201 Installation / Setup
- 1.1K Flows
- 106 Rules
- 260 Administration
- 212 Portal
- 489 General Q & A
- 693 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 51 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 178 Pages
- 5 Process Mining
- New Features
- 178 Datastructures
- 69 Repository
- 219 Integrations
- 28 Multi-Tenant
- 27 SDK
- 76 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 66 Lunch And Learn Questions