Slow Performing SQL Based SmartObject
kbt145178
PRODUCTK2 blackpearl 4.7
BASED ONK2 blackpearl 4.7
TAGSSmartObjects
SmartObject Designer
End User
Administrator
Designer
Support
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
Issue
When you have a SmartObject created from a Custom SQL SmartObject, you see that the result can take quite a while to come back. This could be around 25 - 30 seconds. This can also happen when applying ADO queries against the SmartObject.Symptoms
You will see the following message:
"Timeout out period elasped prior to completion of Operation or the Server is not responding".
Troubleshooting Steps
After investigating, it appears that it would be best to apply the setting “Use Native SQL Execution” which can be applied via the service instance in the SmartObject tester tool.
Please see:
The setting may be set to false by default. This would need to be set as true. After this setting has been applied, you should be able execute complex queries that have been expressed in an ADO.net format, and further reduce time it takes for it be processed between the DB and K2.
