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.