D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

SysSetConnectionContextInfo related error in PU15

Jump to Best Answer
  • 1.  SysSetConnectionContextInfo related error in PU15

    SILVER CONTRIBUTOR
    Posted Apr 10, 2019 11:00 AM
    ​we are in process of updating D365 F&O on-premise from PU12 to PU15. we have some custom code to export transfer order to third party sql db and update transfer order custom flag. we are getting following error when running this code.

    • data get transferred to sql db, the error seems to happen while updating custom flag in erp.
    • standard erp is working fine
    • we install odbc 17 before running this test, but the error msg refers to odbc driver 13
    • this code working find in PU12


      Cannot execute a stored procedure.
      The SQL database has issued an error.
       Object Server DynamicsAXBatchManagement:
       [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure
      'SysSetConnectionContextInfo'.
       {call SysSetConnectionContextInfo (?,?,?,?)}
       session 1013 (Admin)
       Cannot execute a stored procedure.
      The SQL database has issued an error.
       Object Server DynamicsAXBatchManagement:
       [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure
      'SysSetConnectionContextInfo'.
       {call SysSetConnectionContextInfo (?,?,?,?)}
       session 1013 (Admin)
       Cannot execute a stored procedure.
      The SQL database has issued an error.
       Object Server DynamicsAXBatchManagement:
       [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure
      'SysSetConnectionContextInfo'.
       {call SysSetConnectionContextInfo (?,?,?,?)}
       session 1013 (Admin)
       Cannot execute a stored procedure.
      The SQL database has issued an error.
       Object Server DynamicsAXBatchManagement:
       [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure
      'SysSetConnectionContextInfo'.
       {call SysSetConnectionContextInfo (?,?,?,?)}
       session 1013 (Admin)
       Cannot execute a stored procedure.
      The SQL database has issued an error.
       Object Server DynamicsAXBatchManagement:
       [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure
      'SysSetConnectionContextInfo'.
       {call SysSetConnectionContextInfo (?,?,?,?)}
       session 1013 (Admin)
       Cannot edit a record in Transfer orders (InventTransferTable).
      Update must be performed inside a transaction.


    ------------------------------
    Amer MS
    ------------------------------


  • 2.  RE: SysSetConnectionContextInfo related error in PU15
    Best Answer

    TOP CONTRIBUTOR
    Posted Apr 11, 2019 07:30 AM
    So it looks like multiple errors are going on:

    1) The stored procedure SysSetConnectionContextInfo is being called but is not being found in SQL Server
    - Either copy this from a PU12 environment or change your logic to not use this stored procedure
    2) The update transaction on the Transfer orders (InventTransferTable) table is not being wrapped in a transaction (ttsbegin/ttscommit)
    - Make sure all transactions that change data are wrapped in a transaction


    ------------------------------
    Alex Meyer
    Director of Dynamics AX/365 for Finance & Operations Development
    Fastpath
    Des Moines, IA
    ------------------------------



  • 3.  RE: SysSetConnectionContextInfo related error in PU15

    SILVER CONTRIBUTOR
    Posted Apr 14, 2019 07:34 AM
    ​we fix the issue, which was not having odbc v17 in custom sql.

    ------------------------------
    Amer MS
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role