ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB ODBC error ImbOdbcConnection::connectNonCoordinated

Post new topic  Reply to topic
 IIB ODBC error ImbOdbcConnection::connectNonCoordinated « View previous topic :: View next topic » 
Author Message
kris01
PostPosted: Thu Jun 04, 2015 3:09 am    Post subject: IIB ODBC error ImbOdbcConnection::connectNonCoordinated Reply with quote

Newbie

Joined: 03 Jun 2015
Posts: 2
Hi,

Could you please help me on the below IIB ODBC error:

We have configured an ODBC connection to SQL server 2014 on RedHat Linux. mqsicvp command returns successful test connection result but while accessing the datasource on compute node throws ImbOdbcConnection::connectNonCoordinated error.

Exception:


Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
Insert
Type:INTEGER:14
Text:CHARACTER:MF_DB_IN.DB_INSERT
DatabaseException
File:CHARACTER:/build/slot1/S900_P/src/DataFlowEngine/MessageServices/ImbDatabaseManager.cpp
Line:INTEGER:1236
Function:CHARACTER:ImbDatabaseManager::getConnection #4
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2348
Text:CHARACTER:Exception connecting to database
Insert
Type:INTEGER:5
Text:CHARACTER:DBECM
Insert
Type:INTEGER:5
Text:CHARACTER:ODBC
Insert
Type:INTEGER:5
Text:CHARACTER:svc_IIBuser
DatabaseException
File:CHARACTER:/build/slot1/S900_P/src/DataFlowEngine/MessageServices/ImbOdbc.cpp
Line:INTEGER:1651
Function:CHARACTER:ImbOdbcConnection::connectNonCoordinated
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2393
Text:CHARACTER:Root SQL exception
Insert
Type:INTEGER:2
Text:CHARACTER:-1
Insert
Type:INTEGER:5
Text:CHARACTER:DBECM
Insert
Type:INTEGER:14
Text:CHARACTER:
DatabaseException
File:CHARACTER:/build/slot1/S900_P/src/DataFlowEngine/MessageServices/ImbOdbc.cpp
Line:INTEGER:1664
Function:CHARACTER:ImbOdbcConnection::connectNonCoordinated
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2347
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:IM002
Insert
Type:INTEGER:2
Text:CHARACTER:0
Back to top
View user's profile Send private message
mqjeff
PostPosted: Thu Jun 04, 2015 4:34 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
Quote:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2347
Means that you can look up the meaning and definition of BIP 2347 in the documentation and get a better idea of what the error means and what kinds of troubleshooting steps may help.
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Jun 04, 2015 4:36 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
Did you try to use it in a flow requiring an XA connection?
Seems to me that what the exception is telling you is that the connection is not XA...
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
kris01
PostPosted: Thu Jun 04, 2015 2:58 pm    Post subject: Reply with quote

Newbie

Joined: 03 Jun 2015
Posts: 2
Thanks for your reply.

Issue is fixed now. Issue was ODBCINI and ODBCSYSINI was not configured as part of the profile during system reboot.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB ODBC error ImbOdbcConnection::connectNonCoordinated
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.