Avaya Support Forums

Avaya Support Forums (http://support.avaya.com/forums/index.php)
-   Contact Center Applications (http://support.avaya.com/forums/forumdisplay.php?f=3)
-   -   ACCS Database Integration Report ERROR - ODBC (http://support.avaya.com/forums/showthread.php?t=12230)

haramr 12-06-2016 10:51 AM

ACCS Database Integration Report ERROR - ODBC
 
1 Attachment(s)
I am performing a Custom WS integration with the Integration Database Wizard doing ACCS, however I get no component error.

[D:\Avaya\Contact Center\Manager Server\iccm\bin\nihaiw.exe]

[SQLCODE: <-428>:<Stored procedure not found>]

[Location: <SPPrepare>]

[%msg: <Procedure named WSOESP.WSDIVIDESTRING does not exist>]
2016-12-06 16:46:14.897 0 WARN [24896] Attempting ODBC Reconnect ...!!
2016-12-06 16:46:14.897 0 WARN [24896] Failed to get Database connection : increment fail to connect counter....
2016-12-06 16:46:14.897 0 WARN [24896] DSN Handle is NULL, Try for Connection..!!
2016-12-06 16:46:14.897 0 WARN [24896] DBConnectThread Creation Success
2016-12-06 16:46:14.897 0 INFO [18244] Retrieve the UserName and Password from the registry[SOFTWARE\Nortel\ICCM\HAI\ODBC\TEST\] for [WebServices].
2016-12-06 16:46:14.898 0 INFO [18244] Registry UserName length 5[ccDIW] and Password length 8.
2016-12-06 16:46:14.898 0 INFO [18244] DSN not connected - Connect to DSN WebServices UserName[ccDIW] and Password..
2016-12-06 16:46:14.898 0 WARN [18244] Failed to get Database connection : increment fail to connect counter....
2016-12-06 16:46:14.909 0 WARN [18244] NIHAI_ODBC::printODBCError(): Some ODBC call failure: hndType=2, hnd=8683288, rc=1. Check error string.
2016-12-06 16:46:14.909 0 WARN [18244] SQL State: 01000; Error Text: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
2016-12-06 16:46:14.909 0 WARN [18244] DBConnectThread::HDBC Handle VALID
2016-12-06 16:46:14.909 0 WARN [18244] DBConnectThread::HDBC Handle - 8683288
2016-12-06 16:46:14.909 0 WARN [24896] DBConnectThread Executed Well !!
2016-12-06 16:46:14.909 0 WARN [24896] Execute the SQL statement - FAILED - SQLExecDirect() RetCode: -1
2016-12-06 16:46:14.909 0 WARN [24896] SQL State -> HY000; Error Text: [Cache ODBC][State : S1000][Native Code 428]

[D:\Avaya\Contact Center\Manager Server\iccm\bin\nihaiw.exe]

[SQLCODE: <-428>:<Stored procedure not found>]

[Location: <SPPrepare>]

[%msg: <Procedure named WSOESP.WSDIVIDESTRING does not exist>]
2016-12-06 16:46:14.910 0 WARN [24896] Execute the statement - Failed.
2016-12-06 16:46:14.910 0 WARN [24896] NIHAI_ODBC::printODBCError(): Some ODBC call failure: hndType=3, hnd=0, rc=-1. Check error string.
2016-12-06 16:46:14.910 0 WARN [24896] executeSQL complete but execution failed..

When I run tests via SOAP-UI, it executes successfully.

tcanla 04-06-2017 06:29 AM

Hey haramr, my team and I have always used custom integration like you. Now though, we decided to try out third-party solutions, and we're currently using Tenfold for integration. So far, so good. http://www.tenfold.com/integrations


All times are GMT -7. The time now is 01:28 AM.