Skip to main content
Level 3
September 28, 2023

ODBC export error with latest Lacerte update

I'm using pyodbc to pull return data from all modules in order to aggregate reports/dashboards and as of a Lacerte update this morning I'm getting this error:

 

pyodbc.Error: ('HY000', "[HY000] [Lacerte][CLIDSI] (90) Unhandled managed exception caught: System.Exception: Exception of type 'System.Exception' was thrown. (Stack Trace:    at Interop.ClientDataAccess.ITableAccess.MoveToNextRow()\r\n   at f.MoveToNextRow()\r\n   at Simba.CLIDSI.CLIDSIResultSet.Move(CLIDSIResultSet* , DSIDirection in_direction, Int64 in_offset)) (90) (SQLFetch)")

 

I did not personally do the update so I don't know how far back it went (likely August at the earliest)

and it only errs on the Individual and Partnership modules

 

any insight/help would be much appreciated!

    4 replies

    Level 3
    September 28, 2023
    Level 3
    September 28, 2023

    We are working on making changes to SDK, we will share the latest SDK in sometime. Please email to LacerteEncryption@intuit.comso that we will share SDK with you. 

    John Samuel
    Level 6
    September 28, 2023

    Please post the updated SDK to the dedicated resource page, so that we are not tied to having to email somewhere.
      https://developer.intuit.com/app/developer/lacerte-sdk/docs/lacerte-get-started



    Robert

    Level 3
    September 29, 2023

    the updated SDK (1.0.0.417) solved the problem!

     

    thanks, gang