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 » Message Broker DataBase Error

Post new topic  Reply to topic
 Message Broker DataBase Error « View previous topic :: View next topic » 
Author Message
paresh
PostPosted: Thu Aug 13, 2009 7:53 pm    Post subject: Message Broker DataBase Error Reply with quote

Newbie

Joined: 13 Aug 2009
Posts: 3
Hi All,

I am trying to acccess database table from mapping node..

I have created ODBC Connection , while creating connection i have provided TNS service Name(from .ora file), User ID.

But when i am accessing data base from mapping node it throws an error.

Need help ... Please..

Error


ExceptionList
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbDataFlowNode.cpp
Line:INTEGER:957
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:Mapping_DBFlow#FCMComposite_1_3.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:Mapping_DBFlow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
DatabaseException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbOdbc.cpp
Line:INTEGER:323
Function:CHARACTER:ImbOdbcHandle::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2393
Text:CHARACTER:Root SQL exception
Insert
Type:INTEGER:2
Text:CHARACTER:-1
Insert
Type:INTEGER:5
Text:CHARACTER:ORCL
DatabaseException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbOdbc.cpp
Line:INTEGER:438
Function:CHARACTER:ImbOdbcHandle::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:28000
Insert
Type:INTEGER:2
Text:CHARACTER:1017
Insert
Type:INTEGER:5
Text:CHARACTER:[Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied
DatabaseException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbOdbc.cpp
Line:INTEGER:438
Function:CHARACTER:ImbOdbcHandle::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:IM006
Insert
Type:INTEGER:2
Text:CHARACTER:0
Insert
Type:INTEGER:5
Text:CHARACTER:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Back to top
View user's profile Send private message
Vitor
PostPosted: Fri Aug 14, 2009 4:43 am    Post subject: Re: Message Broker DataBase Error Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
paresh wrote:
Need help ... Please..


I'd start here...

paresh wrote:
[Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied


I think you need to supply correct/different credentials.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
paresh
PostPosted: Sat Aug 15, 2009 1:48 pm    Post subject: Re: Message Broker DataBase Error Reply with quote

Newbie

Joined: 13 Aug 2009
Posts: 3
Hi,

Thanks for your help..

Now i am able to insert record in oracle data table but with all null value..

even i am specifing values in request and also i have hardcoded value in insert statement but it always insert bank row in data table.

Please help me
Back to top
View user's profile Send private message
smdavies99
PostPosted: Sat Aug 15, 2009 11:00 pm    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
Please obtain a UserTrace (and disable any debug sessions) get the trace formatted output and post the section around your insert operation here.

This may well help us discover your problem.

As an aside, I guess all the columns in the table are defined to allow NULL's then. This is not normally a good idea but I'll leave that to a discussion between yourself and your DBA's.
_________________
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
paresh
PostPosted: Sun Aug 16, 2009 5:27 pm    Post subject: Reply with quote

Newbie

Joined: 13 Aug 2009
Posts: 3
Hi,

I was using Oracle ODBC driver and it was only able to insert numeric value only.

Now I have changed odbc driver to MQSeries DataDirect Technologies 5.30 32-BIT Oracle.

I am able to execurte sql - insert statement from esql.

but when i am using Mapping node to insert value into database , I am getting below error.

ExceptionList
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbDataFlowNode.cpp
Line:INTEGER:957
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:myDemoFlow#FCMComposite_1_3.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:myDemoFlow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp
Line:INTEGER:602
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:myDemoFlow#FCMComposite_1_3.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:myDemoFlow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:.IBM_WBIMB_myDemoFlow_Mapping.MAIN
Insert
Type:INTEGER:5
Text:CHARACTER:3.1
Insert
Type:INTEGER:5
Text:CHARACTER:myDemoFlow_Mapping(InputRoot, InputLocalEnvironment);
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlRoutine.cpp
Line:INTEGER:548
Function:CHARACTER:SqlRoutine::invoke
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:myDemoFlow#FCMComposite_1_3.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:myDemoFlow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2934
Text:CHARACTER:Error occured in procedure
Insert
Type:INTEGER:5
Text:CHARACTER:myDemoFlow_Mapping
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp
Line:INTEGER:602
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:myDemoFlow#FCMComposite_1_3.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:myDemoFlow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:.myDemoFlow_Mapping
Insert
Type:INTEGER:5
Text:CHARACTER:67.2
Insert
Type:INTEGER:5
Text:CHARACTER:INSERT INTO Database.ORCL.KOYANIP.INDIVIDUAL ( LASTNAME, FIRSTNAME ) VALUES (source_body.(XMLNSC.Field)tns:LASTNAME, source_body.(XMLNSC.Field)tns:FIRSTNAME )
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlInsertStmt.cpp
Line:INTEGER:306
Function:CHARACTER:SqlInsertStatement::execute
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:myDemoFlow#FCMComposite_1_3.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:myDemoFlow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2466
Text:CHARACTER:Unsuitable database
Insert
Type:INTEGER:5
Text:CHARACTER:.myDemoFlow_Mapping
Insert
Type:INTEGER:5
Text:CHARACTER:67.2
Insert
Type:INTEGER:5
Text:CHARACTER:ORCL
Insert
Type:INTEGER:5
Text:CHARACTER:DEVDB
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 » Message Broker DataBase Error
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.