Hi All
we have tables that we query from and show in the UI.
There are Stored Procedures/Jobs which are running frequently and updating these tables on a hourly basis.
when there is SP running and the user uses the APPIAN UI - we get this "An error occurred while retrieving the data". This is happening as the query is getting timed out. This happend intermittently. Once the SP is done executing, the UI works without issues.
Is there a way to handle this in the UI without the using seeing an APPIAN error message?
Is there any option like NOLOCK in APPIAN that i can use to query the data (option available at the DB side to query even if there is a LOCK).
Thanks in advance.
Discussion posts and replies are publicly visible
Implement a NOLOCK from your database and the problem will be gone.
Hi Fredrick Omeniho,
We are also facing similar issue and our table is getting locked for longer duration and every screen is failing as we are querying this tables using Query Entity.
We are using SQL Server. Can you please elaborate, how to implement this NOLOCK in database?
Hi Priya,
Have you solved your problem? If so, can you tell us how?
Greetings and thank you
Hi Priya, I was away.The solution is well explained at https://community.appian.com/discussions/f/general/8536/error-occurred-while-retrieving-the-data/71096#71096I thought Appian would have solved the issue or devices a walk around by now.
Thanks Fredrick for giving this details. Will surely look into it. for now we resolved this issue by replacing QE with stored procedure into which we are giving NOLOCK for data selection.
Thank you Priya, I am glad my proposed solution solved your problem.
Please verify that Implementing a NOLOCK is a verified solution/answer so it’s easier for other developers to quickly rectify this issue when anytime it is experienced in the future.