Error: General ODBC Error: [Microsoft][ODBC SQL][SQL Server]Could not continue scan with NOLOCK due to data movement Native error:601 - when filtering a General Ledger report, Trial Balance or Balance sheet on specific projects

When running a General Ledger report, Trial Balance or Balance sheet filtered on a specific project, a user may receive the error, Error: General ODBC Error: [Microsoft][ODBC SQL][SQL Server]Could not continue scan with NOLOCK due to data movement Native error:601
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

  1. In General Ledger, Reports, Account Reports, highlight General Ledger Report
  2. Click on New
  3. Click on Preview
  4. Note the error
  5. In General Ledger Reports, Financial Statements, highlight Income Statement
  6. Choose the saved report in question
  7. Preview
  8. Note there is no error
  9. Choose the 2nd report noted (filtered on specific projects 
  10. Preview
  11. Note the error

This may happen on the Trial Balance Report. It may also happen on the Balance Sheet when filtering on a specific group of projects.

Environment

 Financial Edge
 7.80.94 patch 0

Was this article helpful?