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.2K All Categories
- 67 General
- 11 Training
- 202 Installation / Setup
- 1.1K Flows
- 106 Rules
- 262 Administration
- 212 Portal
- 490 General Q & A
- 695 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 52 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 179 Pages
- 5 Process Mining
- New Features
- 179 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 78 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 83 Lunch And Learn Questions