| Author |
Message
|
| mvarghese |
 Posted: Wed Oct 13, 2010 12:43 am Post subject: BIP2322E: Database error: SQL State '20119'; Native Error Co |
 |
|
Centurion
Joined: 27 Sep 2006
Posts: 141
|
Below error throwing from one of the Message Broker, even other Broker have same config /set up to access to external SQL server Database working fine.
SQL server dba saying, he not seen any error on db log side.
Odbc64.ini file and mqsisetdbparms are all set , even ldd command showing all the driver lib correctly...
What else is the possibel reason for below error.
**********
Oct 13 09:20:52 wmbsit1 user:err|error WebSphere Broker v6105[991402]: (*******)[11309]BIP2321E: Database error: ODBC return code '-1'. : STMB02.a3ab32d7-2a01-0000-0080-f7a3070e21d6: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 333: ImbOdbcHandle::checkRcInner: :
Oct 13 09:20:52 wmbsit1 user:err|error WebSphere Broker v6105[991402]: (******)[11309]BIP2322E: Database error: SQL State '20119'; Native Error Code '0'; Error Text '[IBM][ODBC SQL Server Driver]20119'. : STMB02.a3ab32d7-2a01-0000-0080-f7a3070e21d6: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 453: ImbOdbcHandle::checkRcInner
_________________
Jain Varghese |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Wed Oct 13, 2010 1:03 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Please don't double post.
Moderators, can you lock one of them please.
_________________
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 |
|
|
| mvarghese |
| Posted: Wed Oct 13, 2010 1:06 am Post subject: |
|
|
Centurion
Joined: 27 Sep 2006
Posts: 141
|
Sorry,I didn't posted twice, not sure how it came twice, can't able to delete also.
_________________
Jain Varghese |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Oct 13, 2010 1:23 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Are you sure that's the complete error message? it looks chopped off.
Is there a flow deployed that's receiving an exception? If so, put in a trace node and capture the exception tree.
If not, take a user trace. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Oct 13, 2010 2:11 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mvarghese wrote: |
| Sorry,I didn't posted twice, not sure how it came twice, can't able to delete also. |
I can & I have. Could have locked it, but that delete button tempted me....
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Oct 13, 2010 2:12 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
Are you sure that's the complete error message? it looks chopped off.
Is there a flow deployed that's receiving an exception? If so, put in a trace node and capture the exception tree.
If not, take a user trace. |
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mvarghese |
| Posted: Wed Oct 13, 2010 2:56 am Post subject: |
|
|
Centurion
Joined: 27 Sep 2006
Posts: 141
|
Thanks Vitor.
Jeff, this is only related time stamp log
Oct 13 11:37:03 wmbsit1 user:err|error WebSphere Broker v6105[991292]: (****.IVR.DBS.01)[11309]BIP2628E: Exception condition
detected on input node 'IVR_CALLER_CONTEXT_99.EB.IVR.DBS.CALLER.CONTEXT.99.IN'. : STMB02.a3ab32d7-2a01-0000-0080-f7a3070e21d6
: /build/S610_P/src/DataFlowEngine/ImbCommonInputNode.cpp: 1875: ImbCommonInputNode::run: ComIbmMQInputNode: IVR_CALLER_CONTEX
T_99#FCMComposite_1_1
Oct 13 11:37:03 wmbsit1 user:err|error WebSphere Broker v6105[991292]: (***.IVR.DBS.01)[11309]BIP2321E: Database error: ODB
C return code '-1'. : STMB02.a3ab32d7-2a01-0000-0080-f7a3070e21d6: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 333: ImbOdbcH
andle::checkRcInner: :
Oct 13 11:37:03 wmbsit1 user:err|error WebSphere Broker v6105[991292]: (***.IVR.DBS.01)[11309]BIP2322E: Database error: SQL
State '20119'; Native Error Code '0'; Error Text '[IBM][ODBC SQL Server Driver]20119'. : STMB02.a3ab32d7-2a01-0000-0080-f7a30
70e21d6: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 453: ImbOdbcHandle::checkRcInner: :
_________________
Jain Varghese |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Oct 13, 2010 4:00 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mvarghese wrote: |
| Jeff, this is only related time stamp log |
Then you need to get more information. Like a trace.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mvarghese |
| Posted: Wed Oct 13, 2010 4:44 am Post subject: |
|
|
Centurion
Joined: 27 Sep 2006
Posts: 141
|
Vitor, I seen his message earlier itself...but I am waiting for the right team to put message.Thanks
_________________
Jain Varghese |
|
| Back to top |
|
|
|
|
