Avaya Support Forums  

Go Back   Avaya Support Forums > Contact Center Applications

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12-06-2016, 11:51 AM
haramr haramr is offline
Member
 
Join Date: May 2015
Location: Brasil
Posts: 3
haramr has 10 reputation points
Default ACCS Database Integration Report ERROR - ODBC

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:rintODBCError(): 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:rintODBCError(): 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.
Attached Files
File Type: docx prints.docx (88.3 KB, 8 views)
Reply With Quote
  #2  
Old 04-06-2017, 07:29 AM
tcanla tcanla is offline
Hot Shot
 
Join Date: Mar 2017
Posts: 10
tcanla has 10 reputation points
Default

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
Reply With Quote
Reply

Tags
accs database

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 11:26 AM.

This Forum is provided solely for the use and convenience of Avaya customers and partners. Use of the Forum is subject to the Terms and Use and Privacy Statement found at www.avaya.com. No other use is permitted. The Forum including all content posted is “AS IS” and Avaya expressly disclaims all warranties and/or guarantees as to its accuracy, reliability, usefulness, quality or non-infringement of intellectual property. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.

Avaya will not be liable for any content posted on this Forum, including, without limitation, any errors or omissions or for any losses or damages of any kind incurred as a result of use or reliance on any content, regardless of its origin.

You expressly understand and agree that you assume all risks associated with use or reliance on this content.