We have a use case where we need to pull data from another system. The only way to access the data in the other system is by querying the data from its MS SQL Server Database. The data is in a view. I've built a CDT and mapped it to the view and created datastore. Query Rules and query entities both timeout before returning the results. If I use a process model and a query DB smart service with a query with a hardcoded condition (ex. select bac, acwp, bcws, bcwp from evm.subprojectevdata where subprojectid = 20321), the query executes perfectly (< 500 ms)...however if i substitute the hardcoded condition for an ACP, the query takes over 2 minutes execute. We are running Appian v7.11...
We are setting up a test environment where we will turn on SQL Trace/Debug logging in JBoss to see how the queries are being formed.
Any thoughts? Any one else experience this behavior?
Discussion posts and replies are publicly visible