| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Calling Stored Procedure : ERROR |
« View previous topic :: View next topic » |
| Author |
Message
|
| hellobond070 |
 Posted: Fri May 07, 2010 4:15 pm Post subject: Calling Stored Procedure : ERROR |
 |
|
Centurion
Joined: 18 Nov 2009
Posts: 118
|
Hi,
I am calling a simple STORED PROCEDURE on DB2. The username which I am using to call the procedure has the right to execute the procedure locally when logged in the DB2 machine directly through putty.
IN ESQL CODE
[code]call gicdw.sample2('gij', 'download_validate_mnr.sh', 'cstadd',0)[/code]
[code]CREATE PROCEDURE GetValueDWH(IN P1 CHAR,IN P2 CHAR,IN P3 CHAR,OUT R1 INT)
LANGUAGE DATABASE
EXTERNAL NAME "gicdw.sample2";[/code]
But when the same procedure is called by broker it give me the below error:
) Environment >>>>>>>>>>> ==================================================================================
2010-05-07 18:50:48.189700 Exception List >>>>>>>>>>> ( ['MQROOT' : 0x7e34438]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = 'F:\build\S610_P\src\DataFlowEngine\ImbComputeNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 464 (INTEGER)
(0x03000000:NameValue):Function = 'ImbComputeNode::evaluate' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'freight/MF_CALL_PROC#FCMComposite_1_2' (CHARACTER)
(0x03000000:NameValue):Label = 'freight.MF_CALL_PROC.Compute' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2230 (INTEGER)
(0x03000000:NameValue):Text = 'Caught exception and rethrowing' (CHARACTER)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = 'F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 602 (INTEGER)
(0x03000000:NameValue):Function = 'SqlStatementGroup::execute' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'freight/MF_CALL_PROC#FCMComposite_1_2' (CHARACTER)
(0x03000000:NameValue):Label = 'freight.MF_CALL_PROC.Compute' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2488 (INTEGER)
(0x03000000:NameValue):Text = 'Error detected, rethrowing' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'freight.MF_CALL_PROC_Compute.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '8.3' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'GetValueDWH('gij', 'download_validate_mnr.sh', 'cstadd', R1, R2);' (CHARACTER)
)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = 'F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlRoutine.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 685 (INTEGER)
(0x03000000:NameValue):Function = 'SqlRoutine::invoke' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'freight/MF_CALL_PROC#FCMComposite_1_2' (CHARACTER)
(0x03000000:NameValue):Label = 'freight.MF_CALL_PROC.Compute' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2934 (INTEGER)
(0x03000000:NameValue):Text = 'Error occured in procedure' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'GetValueDWH' (CHARACTER)
)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = 'F:\build\S610_P\src\DataFlowEngine\ImbDatabaseManager.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 2391 (INTEGER)
(0x03000000:NameValue):Function = 'ImbDatabaseManager::getDBProcedureParameterInformation' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmDatabaseConnectionManager' (CHARACTER)
(0x03000000:NameValue):Name = 'ComIbmDatabaseConnectionManager' (CHARACTER)
(0x03000000:NameValue):Label = 'ComIbmDatabaseConnectionManager' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2921 (INTEGER)
(0x03000000:NameValue):Text = 'The procedure '&1' with '&2' parameters could not be match with a corresponding Database stored porocedure.' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'giDWDB.giCDW.SAMPLE3' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '5' (CHARACTER)
) |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Fri May 07, 2010 10:57 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Are you sure your post is right?
In the code you refer to sample2 yet the exceptionlist refers to sample3
The line in the ExceptionList that has the procedure name you are trying to call is the key here. Do you by any chance have the wrong or nested/multiple schemas?
Is the name listed 'giDWDB.giCDW.SAMPLE3' really correct?
Is the case relevant?
_________________
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 |
|
|
| hellobond070 |
| Posted: Sat May 08, 2010 2:38 pm Post subject: |
|
|
Centurion
Joined: 18 Nov 2009
Posts: 118
|
I am sorry...the DB programmer had given me two procedures and this is the very first time I am trying to call Procedures through Message broker. So I was trying both the procedures and both do exist in the database.
Because with the Message Broker ID, I have logged in the database and myself ran the PROCEDURES so there is no fault in the parameters or their direction.
I just copy pasted the code and the log collected was an earlier one.
Sorry for the confusion but you consider it to be sample 3 which has 5 parameters passed.
| Code: |
CREATE PROCEDURE GetValueDWH(IN P1 CHAR,IN P2 CHAR,IN P3 CHAR,OUT R1 INT,OUT R2 CHAR)
LANGUAGE DATABASE
EXTERNAL NAME "gicdw.sample3"; |
I have tried calling both the SAMPLE2 and SAMPLE 3 procedures and get the same error. |
|
| Back to top |
|
|
| hellobond070 |
| Posted: Sat May 08, 2010 3:52 pm Post subject: |
|
|
Centurion
Joined: 18 Nov 2009
Posts: 118
|
Hey I was able to resolve the issue.
one of the parameter was INOUT instead of just OUT.
Thanks everyone. |
|
| 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
|
|
|
|
