| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| database Insert error in WMQI |
« View previous topic :: View next topic » |
| Author |
Message
|
| ramukurra |
 Posted: Thu Jan 06, 2005 11:28 am Post subject: database Insert error in WMQI |
 |
|
Novice
Joined: 10 Mar 2004
Posts: 18
Location: CT
|
HI,
I am getting an error while trying to insert values from input XML into database table.I am assuming it is with previleges to the user.Can any one help in this regard.What best I can do to solve this.Thank you
My ESQL Code for Insert is like this
IF InputRoot.XML.ClaimstoDWMessage.target ='t_Stage_Misc' THEN
PASSTHRU('INSERT INTO myClaims_Setup.dbo.t_Stage_Misc(EmployeeSSN,ClaimantSeq,ClaimSeq,MiscRemark1,MiscRemark2,MiscRemark3,MiscRemark4,CSILocation,SystemClaimNumber,CommandIndicator)
VALUES(?,?,?,?,?,?,?,?,?,?)',employeessn,claimantseq,claimseq,mr1,mr2,mr3,mr4,csilocation,sysclmnumber,commandindi);
END IF;
Here is the Trace
(
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x3000000)Line = 536
(0x3000000)Function = 'ImbDataFlowNode::createExceptionList'
(0x3000000)Type = 'ComIbmComputeNode'
(0x3000000)Name = '96c2f6bd-0001-0000-0080-dbea970f3e4f'
(0x3000000)Label = 'CRSDW.ECAMS_OUTBOUND.CRSDW.ECAMS_IntializeComp'
(0x3000000)Text = 'Node throwing exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbRdl\ImbRdlExternalDb.cpp'
(0x3000000)Line = 267
(0x3000000)Function = 'SqlExternalDbStmt::executeStmt'
(0x3000000)Type = 'ComIbmComputeNode'
(0x3000000)Name = '96c2f6bd-0001-0000-0080-dbea970f3e4f'
(0x3000000)Label = 'CRSDW.ECAMS_OUTBOUND.CRSDW.ECAMS_IntializeComp'
(0x3000000)Text = 'The following error occurred during execution of an SQL statement'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2519
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '102'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '1'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'CRSDW'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'INSERT INTO myClaims_Setup.dbo.t_Stage_Misc(EmployeeSSN,ClaimantSeq,ClaimSeq,MiscRemark1,MiscRemark2,MiscRemark3,MiscRemark4,CSILocation,SystemClaimNumber,CommandIndicator)
VALUES(?,?,?,?,?,?,?,?,?,?)'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = ''123551234', '00', '0001', 'RemarkLine1', 'RemarkLine2', 'RemarkLine3', 'RemarkLine4', '12', '345678901234567AB', 'U', '
)
(0x1000000)DatabaseException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x3000000)Line = 147
(0x3000000)Function = 'ImbOdbcHandle::checkRcInner'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Root SQL exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2321
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '-1'
)
(0x1000000)DatabaseException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x3000000)Line = 247
(0x3000000)Function = 'ImbOdbcHandle::checkRcInner'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Child SQL exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2322
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = '08004'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '916'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = '[Microsoft][ODBC SQL Server Driver][SQL Server]Server user 'MQSISERV' is not a valid user in database 'myClaims'.'
)
)
)
)
)
) |
|
| Back to top |
|
 |
| JT |
| Posted: Thu Jan 06, 2005 1:24 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Have you or your DBA verified that the broker service id MQSISERV has been assigned the appropriate privileges to access the myClaims database? |
|
| Back to top |
|
|
| ramukurra |
| Posted: Thu Jan 06, 2005 3:27 pm Post subject: |
|
|
Novice
Joined: 10 Mar 2004
Posts: 18
Location: CT
|
Hi JT,
Thanks for your response.Access to database is there as Select Statement in ESQL is working Fine .Moreover database name is
myClaims_Setup.
But error is showing with wrongdatabase name.
[Microsoft][ODBC SQL Server Driver][SQL Server]Server user 'MQSISERV' is not a valid user in database 'myClaims'.'
I appreciate if any one give me clue .Thanks |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Jan 06, 2005 11:54 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Please provide your platform and version details.
What is the ODBC DSN name set for this db?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| ramukurra |
| Posted: Mon Jan 10, 2005 10:09 am Post subject: |
|
|
Novice
Joined: 10 Mar 2004
Posts: 18
Location: CT
|
Hi Kirani,
Ver mqsi 2.1 on Windows
ODBC DSN name set for this db is SQLserver.
Thanks |
|
| Back to top |
|
|
| ramukurra |
| Posted: Wed Jan 12, 2005 10:56 am Post subject: |
|
|
Novice
Joined: 10 Mar 2004
Posts: 18
Location: CT
|
Hi ,
My Proublem is solved.Error is caused due to the triggers on Database Tables in which I am trying to Insert.
Thanks
ram |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
