Hi,
There is an issue i am facing with query databse smart service, Where i am executing a stored procedure which fetches data from multiple tables and insert same data to a table.
- It works if i execute the stored proc with same parameters by SSMS(SQL Server Management Studio)
- By Query Database Smart Service it sometimes gives me error -
attached screenshot for reference
Thanks
Discussion posts and replies are publicly visible
Is there a reason to not use the executeStoredProcedure function?
Yes because in executeStoredProcedure function there is a limit of Max rows per result set 1000 rows, In my case there are around 4000 rows.
Wow, what do you do with 4000 rows in an Appian process !?!
The error above is coming from a timeout. Seems like your SP takes too long.
What is your use case?
1. I need to save this data to a table and use this data on the basis of some filters for diffrent process.
2. Yes there is a timeout for query dayabase, but when i execute the stored proc with same parameters by SSMS(SQL Server Management Studio) manually it inserts rows to table in seconds.
3. I need to prepare data and dump on a table for diffrent filter criteria and use it for a process to make the querying data faster.