Hello,
Laserfiche Server 10.2
SQL Server 2016
My users are getting a General Database error when they try to copy an entry or an individual page. The error is occurring when copying in the Windows client, Web Portal and with the SDK. Looking at the logs on the Laserfiche server I'm seeing these two events:
Copy the LF Entry:
An error occurred when executing an SQL query, retrieving the results of a query, or otherwise communicating with the database server. Session ID=103900; Dialog ID=1242169; Repository="LFDocs"; Function=SysEntryCopy; Message="[Microsoft][ODBC Driver 11 for SQL Server]Connection is busy with results for another command"; Statement="select ann_id, attach_storeid from ann where page_id = :pageid<bigint> order by ann_id"; SQL Variable=""; SQL State="HY000".
Copy a LF Page:
An error occurred when executing an SQL query, retrieving the results of a query, or otherwise communicating with the database server. Session ID=89312; Dialog ID=1243112; Repository="LFDocs"; Function=SysPageCopy; Message="[Microsoft][ODBC Driver 11 for SQL Server]Connection is busy with results for another command"; Statement="select ann_id, attach_storeid from ann where page_id = :pageid<bigint> order by ann_id"; SQL Variable=""; SQL State="HY000".
Any idea on what would be causing this?