MQSeries.net :: View topic - DSN Name and Login username is appended to SP

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DSN Name and Login username is appended to SP

DSN Name and Login username is appended to SP

« View previous topic :: View next topic »

Author

Message

Shafikz

Posted: Mon Sep 15, 2014 1:53 am Post subject: DSN Name and Login username is appended to SP

Apprentice

Joined: 12 Apr 2012
Posts: 29

I am getting following exception when trying to call an SP from IIB.

Code:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<NS1:GetLeaveCountResponse xmlns:NS1="http://FDCTK">
<NS1:error>
<NS1:StatusCode>0001</NS1:StatusCode>
<NS1:ErrorDescription>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\MessageServices\ImbDataFlowNode.cpp</File>
<Line>1153</Line>
<Function>ImbDataFlowNode::createExceptionList</Function>
<Type>ComIbmComputeNode</Type>
<Name>gen/FDCServices#FCMComposite_1_92.gen/GetLeaveCount_Request_Response#FCMComposite_1_1</Name>
<Label>gen.FDCServices.gen/GetLeaveCount_Request_Response.ContructResponse</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
<Text>Node throwing exception</Text>
<Insert>
<Type>14</Type>
<Text>gen.FDCServices.gen/GetLeaveCount_Request_Response.ContructResponse</Text>
</Insert>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp</File>
<Line>666</Line>
<Function>SqlStatementGroup::execute</Function>
<Type>ImbESQLManager</Type>
<Name>ImbESQLManager</Name>
<Label>ImbESQLManager</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2488</Number>
<Text>Error detected, rethrowing</Text>
<Insert>
<Type>5</Type>
<Text>gen.GetLeaveCount_Request_Response_Compute.Main</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>15.3</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>BPM_GET_LEAVE_COUNT(leaveReqNum, employeeId, leaveType, Environment.leaves[ ]);</Text>
</Insert>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\ImbRdl\ImbRdlRoutine.cpp</File>
<Line>1362</Line>
<Function>SqlRoutine::invoke</Function>
<Type>ImbESQLManager</Type>
<Name>ImbESQLManager</Name>
<Label>ImbESQLManager</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2934</Number>
<Text>Error occured in procedure</Text>
<Insert>
<Type>5</Type>
<Text>BPM_GET_LEAVE_COUNT</Text>
</Insert>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\MessageServices\ImbDatabaseManager.cpp</File>
<Line>2882</Line>
<Function>ImbDatabaseManager::getDBProcedureParameterInformation</Function>
<Type>ComIbmDatabaseConnectionManager</Type>
<Name>ComIbmDatabaseConnectionManager</Name>
<Label>ComIbmDatabaseConnectionManager</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2920</Number>
<Text>The procedure is unknown to the database and no definition could be found.</Text>
<Insert>
<Type>5</Type>
<Text>PPS_GP_DS.BPMUSR.BPM_GET_LEAVE_COUNT</Text>
</Insert>
</RecoverableException>
</RecoverableException>
</RecoverableException>
</RecoverableException>
</NS1:ErrorDescription>
</NS1:error>
</NS1:GetLeaveCountResponse>
</soapenv:Body>
</soapenv:Envelope>

Why does it append prefix PPS_GP_DS (which is the name of DSN) and BPMUSR (which is login user name) with SP Name. The default schema is mentioned as 'dbo' in sql server. It should append dbo.Store procedure name.

Simbu

Posted: Mon Sep 15, 2014 2:34 am Post subject:

Master

Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India

Hi, login user name is the default schema if one not specified in the code in message broker. please modify with the correct schema and try

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DSN Name and Login username is appended to SP

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