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 » ODBC return code '-1' while using proven ODBC connection

Post new topic  Reply to topic
 ODBC return code '-1' while using proven ODBC connection « View previous topic :: View next topic » 
Author Message
Adreno
PostPosted: Tue Aug 11, 2009 3:22 am    Post subject: ODBC return code '-1' while using proven ODBC connection Reply with quote

Acolyte

Joined: 05 Jul 2007
Posts: 71
Hi guys,

I´m still working on WMB 6.1.0.3 with Oracle 11g and getting into problems with one of out db connections. A flow is implemented that directly creates entries in an table but every time connection fails with following error:

Aug 11 10:22:05 abgpa047 user:err|error WebSphere Broker v6103[1016016]: (VEMA01.MESAdapter)[6940]BIP2232E: Error detected whilst handling a previous error in node'S_MES_Adapter_SchreibeAuftrag.Request_In.G_SUB_INPUT.SUB_ErrorHandler.SUB_CreateErrorEvent.RollbackForVerification'. : VEMA01.6367eaea-2201-0000-0080-abab34d81e6e: /build/S610_P/src/DataFlowEngine/ImbDataFlowNode.cpp: 769: imbDataFlowNode::logExceptionList: ComIbmThrowNode: S_MES_Adapter_SchreibeAuftrag#FCMComposite_1_3.SUBFLOW/INPUT/G_SUB_INPUT_MQ#FCMComposite_1_1.SUBFLOW/INPUT/G_SUB_INPUT#FCMComposite_1_2.SUBFLOW/ERRORHANDLING/SUB_ErrorHandler#FCMComposite_1_4.SUBFLOW/ERRORHANDLING/SUB_CreateErrorEvent#FCMComposite_1_17

Aug 11 10:22:05 abgpa047 user:err|error WebSphere Broker v6103[1016016]: (VEMA01.MESAdapter)[6940]BIP2230E: Error detected whilst processing a message in node 'S_MES_Adapter_SchreibeAuftrag.Call_MESDB'. : VEMA01.6367eaea-2201-0000-0080-abab34d81e6e: /build/S610_P/src/DataFlowEngine/ImbComputeNode.cpp: 464: ImbComputeNode::evaluate: ComIbmComputeNode: 'MES_Adapter_SchreibeAuftrag#FCMComposite_1_2

Aug 11 10:22:05 abgpa047 user:err|error WebSphere Broker v6103[1016016]: (VEMA01.MESAdapter)[6940]BIP2393E: Database error: ODBC return code '-1' from data source 'FSOA_MES'. : VEMA01.6367eaea-2201-0000-0080-abab34d81e6e: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 323: ImbOdbcHandle::checkRcInner: :

Aug 11 10:22:05 abgpa047 user:err|error WebSphere Broker v6103[1016016]: (VEMA01.MESAdapter)[6940]BIP2322E: Database error: SQL State '21'; Native Error Code '-1'; Error Text '[IBM][ODBC 20101 driver][20101]13114'. : VEMA01.6367eaea-2201-0000-0080-abab34d81e6e: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp:
438: ImbOdbcHandle::checkRcInner: :
Aug 11 10:22:05 abgpa047 user:err|error WebSphere Broker v6103[1016016]: (VEMA01.MESAdapter)[6940]BIP2628E: Exception condition detected on input node 'S_
MES_Adapter_SchreibeAuftrag.Request_In.MQInput'. : VEMA01.6367eaea-2201-0000-0080-abab34d81e6e: /build/S610_P/src/DataFlowEngine/ImbCommonInputNode.cpp: 1
592: ImbCommonInputNode::run: ComIbmMQInputNode: S_MES_Adapter_SchreibeAuftrag#FCMComposite_1_3.SUBFLOW/INPUT/G_SUB_INPUT_MQ#FCMComposite_1_6
Aug 11 10:22:05 abgpa047 user:info WebSphere Broker v6103[1016016]: (VEMA01.MESAdapter)[6940]BIP2176S: Could not find message 4000 in catalogue BIPv610.ca
t, inserts are Normal Rollback in Error Subflow after error message creation - No action requried S_MES_Adapter_SchreibeAuftrag.Request_In.G_SUB_INPUT.SUB
_ErrorHandler.SUB_CreateErrorEvent.RollbackForVerification {2} {3} {4} {5} {6}: VEMA01.6367eaea-2201-0000-0080-abab34d81e6e: /build/S610_P/src/DataFlowEng
ine/BasicNodes/ImbThrowNode.cpp: 265: ImbThrowNode::evaluate: ComIbmThrowNode: S_MES_Adapter_SchreibeAuftrag#FCMComposite_1_3.SUBFLOW/INPUT/G_SUB_INPUT_MQ#FCMComposite_1_1.SUBFLOW/INPUT/G_SUB_INPUT#FCMComposite_1_2.SUBFLOW/ERRORHANDLING/SUB_ErrorHandler#FCMComposite_1_4.SUBFLOW/ERRORHANDLING/SUB_CreateErrorEvent#FCMComposite_1_17

The connection settings were tested and proven with the ora developer client. Also communication is working fine on infrastructure layer.

Any ideas?
_________________
There are two kinds of people in this world: people who s***, and Chuck Norris...
Back to top
View user's profile Send private message
smdavies99
PostPosted: Tue Aug 11, 2009 5:49 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
Have you done a quick google for

oracle 13114

That might shed some light on the problem
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
Adreno
PostPosted: Tue Aug 11, 2009 11:30 pm    Post subject: Reply with quote

Acolyte

Joined: 05 Jul 2007
Posts: 71
Good hint . . .

someone had deleted the tablespace.

Closed . . .
_________________
There are two kinds of people in this world: people who s***, and Chuck Norris...
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 » ODBC return code '-1' while using proven ODBC connection
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.