Skip to main content

Unable to open or save an assessment form.

Guidance when trying to open or save an assessment form, it takes significant time, 30 seconds before loading, or error.

C
Written by Connor Baeza

Raise this issue with the relevant configuration team at your site for review and optimisation.


Issue

Forms may open slowly due to read-only fields configured within the assessment form pulling back large amounts of data. Error:

Description: GenerateScreen@330: showFormIndex()@40: preprocess@435: addLockUnlockData@40: Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. File: /rio/ScreenGenerator2/screengen.asp Line: 230

Cause

This can happen when a read only field does not restrict data using WHERE clauses in its read only SELECT statements, resulting in excessive data retrieval.

Did this answer your question?