ODBC error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt SQLSTate: S1000

  • KM01778765
  • 11-Aug-2015
  • 11-Aug-2015

Summary

ODBC error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt SQLSTate: S1000

Error

When starting the actions included in the workflow "Oracle Installation pre-count", on action "Oracle Database options pre-calculation" we get the following error:ODBC error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt SQLSTate: S1000 ('Line 107 of script ''') ('Line 63 of script 'Oracle Database options pre-calculation'')SQL statement 'SELECT UPPER(I1.Value) FROM amItemListVal I1, amItemizedList I2 WHERE I2.Identifier = ? AND I1.lItemListId=I2.lItemListId ORDER BY I1.Value desc' could not be executed ('Line 107 of script ''') ('Line 63 of script 'Oracle Database options pre-calculation'')Parament 0='amSAMFactorType:0.25' ('Line 107 of script ''') ('Line 63 of script 'Oracle Database options pre-calculation'')Action 'Oracle Database options pre-calculation' failed to execute

Cause

This is a Microsoft bug found in ODBC driver. Reference to MS KB - https://support.microsoft.com/en-us/kb/175313  

Fix

Append to the amdb.ini file the following lines:

 

ConstAsTextForSelect=0
OdbcForwardOnlySelectCursorType=1
Fetchingarraysize=201
importcountercache=1

 

 

These will instruct the ODBC to work normally if the mentioned error is seen. After appending the mentioned lines, logout from AM and login again.