Database statement execution error encountered. Session ID: ; Dialog ID: ; Repository: 'WorkforceDevelopment'; CLI routine: SysLogin; Message: Failed to retrieve error information!; SQL Statement: ''; SQL variable: ''; SQL State: .

replied on June 12, 2014

Hey Daryl,

Do you know what version of Laserfiche the customer is using? This sounds like an old bug that was fixed several years ago. I'd recommend you check out this KB article and see if it helps at all.

1 1

View 3 previous replies

replied on June 12, 2014

In addition to Brett's advice, has the SQL Server been restarted recently? I've seen Support cases reference similar errors when the SQL Server was restarted and the LF Server service was not. In those cases a restart of the LF Server service cleared up the issues.

2 0

replied on June 13, 2014

Version 9.1.1

0 0

replied on June 13, 2014

No, SQL wasn't restarted, however, we did end up rebooting both the SQL Server and the Laserfiche Server and that seemed to clear up our issue. Going to pay close attention to see if the above errors show back up in the Event Viewer.

0 1

replied on June 24, 2016

I just had this issue today while running a large group of files on OCR:

Database statement execution error encountered. Session ID: 29; Dialog ID: 3254699; Repository: 'MartinezUnified'; CLI routine: SysTrusteeGetInfo; Message: [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.
; SQL Statement: 'select trustee_name, isuser, trustee_flags, privs, uif, auditmask, descrip, readonly, password, salt, last_pwchange, last_login, last_logout, bad_logins, temp_pass from trustee left outer join account_security on trustee.sid = account_security.sid left outer join user_login on trustee.sid = user_login.sid where trustee_id = :trustee_id<int>'; SQL variable: ''; SQL State: 08S01.

Always fails after about 300 or so documents OCRed, then I have to go in and select where I left off. The client also has 9.1.1

I'm going to update their server to 10.1 today.

0 0

replied on September 2, 2016

I had the same issue while doing generate pages and OCR after it. It was a small document 27 pages

Database statement execution error encountered. Session ID: ; Dialog ID: ; Repository: 'database'; CLI routine: SysLoginTrusted; Message: Failed to retrieve error information!; SQL Statement: ''; SQL variable: ''; SQL State: .

0 0

replied on September 6, 2016

I wanted to update this post since updating the clients server to 10.1 and running large OCR groups I was still encountering it failing after a random amount of OCRs. They are at the end of what was needed to OCR but this did cause the process to take weeks more than it should have due to it not running while we thought it was.

0 0

Question

Question

Database statement execution error encountered. Session ID: ; Dialog ID: ; Repository: 'WorkforceDevelopment'; CLI routine: SysLogin; Message: Failed to retrieve error information!; SQL Statement: ''; SQL variable: ''; SQL State: .

Replies

Sign in to reply to this post.