BookmarkSubscribeRSS Feed
shoin
Lapis Lazuli | Level 10

WIN 2019 9.4 M7  install, uing SAS ACCESS/ODBC with proper GRANTS by Synapse DBA, yet INSERT statement failing using PROC SQL

 

ERROR: CLI execute error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]111214;An attempt to complete a transaction has
failed. No corresponding transaction found.

I have the sastrace tuned on, part shared

ODBC: ENTER SQLEndTran
                              2 <SQL_HANDLE_DBC>
             0x000000006cbda3b0
                              1 <SQL_ROLLBACK>
ODBC: EXIT SQLEndTran with return code -1 (SQL_ERROR)
                              2 <SQL_HANDLE_DBC>
             0x000000006cbda3b0
                              1 <SQL_ROLLBACK>
ERROR: CLI execute error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]111214;An attempt to complete a transaction has 
       failed. No corresponding transaction found.
ODBC: ENTER SQLFreeStmt
             0x000000006cbdb8d0
                              0 <SQL_CLOSE>

TIA for any suggestion.  I have also asked the DBA to share the Synpase DB GRANT setting.  This particular env is using a service ID to connect and the question to DBA is for GRANT on this service ID.

 

2 REPLIES 2
SASKiwi
PROC Star

Please post the complete SAS log step producing the errors.  

Sajid01
Meteorite | Level 14

As your back end looks like you are having MS SQL Server.
As a first step try running the code in SQL Server Management Studio

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 591 views
  • 0 likes
  • 3 in conversation