AACC DIW UPDATE error SQL state 24000

[bradleygpalmer]

Using AACC Database Integration Wizard, Im getting an error in CCMS_HAI_ODBC_1.log when using UPDATE but SELECT works without error.

Originally was using SQL Server Odbc version 6.01.7601.17514 and tried ODBC Driver 11 for SQL Server. get same error for both odbc drivers


SELECT query:

2015-10-30 11:09:13.881 0 WARN [15820] Executing an SQL statement...!!
2015-10-30 11:09:13.881 0 WARN [15820] [ODBC] Statement for execution:: size(136) - DECLARE @return_value int EXEC @return_value = [dbo].[spAACCNumberLookupV1_1S] @NumberIn = N'3551' SELECT 'Return Value' = @return_value
2015-10-30 11:09:13.920 0 WARN [15820] Execute the SQL statement - Successful.
2015-10-30 11:09:13.921 0 WARN [15820] Free the handle for the statement.
2015-10-30 11:09:13.921 0 WARN [15820] executeSQL completed successfully..

UPDATE

2015-10-30 11:11:35.298 0 WARN [15820] Executing an SQL statement...!!
2015-10-30 11:11:35.298 0 WARN [15820] [ODBC] Statement for execution:: size(79) - UPDATE DialledNumber SET GetSAIDCurrent = 1 WHERE DialledNumber.Number = '3551'
2015-10-30 11:11:35.301 0 WARN [15820] Execute the SQL statement - Successful.
2015-10-30 11:11:35.301 0 WARN [15820] NIHAI_ODBC:rintODBCError(): Some ODBC call failure: hndType=3, hnd=36224888, rc=-1. Check error string.
2015-10-30 11:11:35.301 0 WARN [15820] SQL State: 24000; Error Text: [Microsoft][ODBC Driver 11 for SQL Server]Invalid cursor state
2015-10-30 11:11:35.301 0 WARN [15820] Free the handle for the statement.
2015-10-30 11:11:35.301 0 WARN [15820] executeSQL completed successfully..

thanks

[bradleygpalmer]

as the sql update completes successfully, I was instructed by Avaya support to ignore the error