In NuGenesis LMS, "Document with Audit Trail" does not load - WKB123506

SYMPTOMS

• When trying to view a "Document with Audit Trail" report for an LMS document, the following error appears: "Document audit trail report for document [xxxx] could not be generated"

ENVIRONMENT

• NG8 SR2

CAUSE

The exception is related to maximum open cursors exceeded. By increasing this limit on the database (to at least 1000), the "Document with Audit Trail" report can then be generated.

FIX or WORKAROUND

To increase the number of cursors, run this sql while connected as sys: 

alter system set open_cursors = 1000 scope=both;

ADDITIONAL INFORMATION

CRI-3025 was generated for this issue.