Self-Solve Knowledge Search

Minimize Maximize
ODBC error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results f...
Title :
ODBC error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt SQLSTate: S1000
Document ID :
KM01778765
Product - Version:
asset manager ;
OS :
Updated :
Tue Aug 11 08:53:45 GMT 2015
Summary :
ODBC error: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt SQLSTate: S1000
Problem
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.