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