Error While Configuring Receiver JDBC ADAPTER

[Former Member]

HI Experts,

while configuring the JDBC Receiver(Stored Procedure),I got the the follwing error's .PLease find the used data types and the exceptions (got) as follows.

1.Exception

<SAP:AdditionalText>

com.sap.aii.af.ra.ms.api.DeliveryException:

Error processing request in sax parser: Error when executing statement for table/stored proc.

'PRC_SET_MAIN' (structure 'InsertData'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'PRC_SET_MAIN' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored</SAP:AdditionalText>

-

---

1. Data Type eused.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_Request_In xmlns:ns0="http://XXXXXXX">

- <InsertData>

- <PRC_MAIN action="EXECUTE">

<table>PRC_SET_MAIN</table>

<P_ID isInput="true" type="NUMERIC">245</P_ID>

<P_QID isInput="true" type="NUMERIC">245</P_QID>

</PRC_MAIN>

</InsertData>

</ns0:MT_Request_In>

2. Exception .

com.sap.aii.af.ra.ms.api.DeliveryException:

Error processing request in sax parser:

No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

</SAP:AdditionalText>

2. Datatype used .

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_Request_In xmlns:ns0="http://XXXXXXX">

- <PRC_MAIN action="EXECUTE">

<table>PRC_SET_MAIN</table>

<P_ID isInput="true" type="NUMERIC">245</P_ID>

<P_QID isInput="true" type="NUMERIC">245</P_QID>

</PRC_MAIN>

</ns0:MT_Request_In>

PLease suggest meany ideas (which will be rewarded) to solve the problem.

Thanks and Regards,

Kiran.

[justin_santhanam · Accepted solution]

Kiran,

Your First Data type is correct!! Did u executed the SP in DB, is it working fine?

raj.

[Former Member · Accepted solution]

Actually we don't have the permissions on the DB toi execute the Stored Proc.Will get backtoyou by checking the same.Is there any other (instead of signature mismatch) reasons to get the error.

Thanks and Regards,

Kiran.

[Former Member · Accepted solution]

HI RAj,

Thanks for your input.Here the problem was occured due to insufficient permissions to the user account to access the SP.

Thanks aand Regards,

Kiran.

[Former Member]

Hi,

I am using File to Jdbc (stored procedure) Scenario. Name of the Stored procedure is demoProcedure which inserts four fields (name,id,age,sex) in a table.

Stored Procedure code as follows.

CREATE OR REPLACE PROCEDURE demoProcedure(

name VARCHAR,

id VARCHAR,

age INTEGER,

sex VARCHAR)

AS

BEGIN

INSERT INTO EMPLOYEE (NAME, ID, AGE,SEX)

VALUES (name, id, age, sex);

END demoProcedure;

/

Inbound (Generated XML file During Mapping Test):

<?xml version="1.0" encoding="UTF-8"?>

<ns3:MT_file2JavaProc_Sender xmlns:ns3="http://file2JavaProc">

<name>A</name>

<id>1</id>

<age>25</age>

<sex>Male</sex>

</ns3:MT_file2JavaProc_Sender>

Outbound (Generated XML file During Mapping Test):

<?xml version="1.0" encoding="UTF-8"?>

<ns2:MT_file2JavaProc_Receiver xmlns:ns2="http://file2JavaProc">

<Statement>

<demoProcedure action="EXECUTE">

<name type="VARCHAR">A</name>

<id type="VARCHAR">1</id>

<age type="INTEGER">25</age>

<sex type="VARCHAR">Male</sex>

</demoProcedure>

</Statement>

</ns2:MT_file2JavaProc_Receiver>

I think this will solve your problem.

Thanks

Dipankar

Message was edited by:

Dipankar Sinha Sarkar

[Former Member]

Dipankar ,

the message is successfully sent to the SP(Synchronous call) and the response is coming from the SP(Stored Procedure) which we can see in the MONI in CALL ADAPTER TAB in response message But the problem is it's not getting populated in the Message Source as response.

Thanks ans Regards,

Kiran.

[Former Member]

Hi

Check your response mapping

Thanks

[Former Member]

Hi Kiran,

I am using File as sender so I cant use Synchronous call. If you want to use synchronous call use Http Adapter as sender.

Thanks

Dipankar

[Former Member]

Dipankar,

i am already using SOAP Adapter.

The problem was caused due to the following causes.

1. insufficient authorizations.

2. and the table name should be given with full domain name.

Thanks and regards,

Kiran.

[Former Member]

error is at DB side only,

Pl. check user rights at DB and check the PL/SQL code by executing the proc. at DB.

[Former Member]

Yes You are right.The error is from DB side due to insufficient Authorizations.

Now we are getting response from DB But it's not reflected in the Response message.

I am getting Empty Messsage even the sp is returing the response(which we can see in the Call Adapter : SXMB_MONI).

PLease let me know any suggestions.

[agasthuri_doss]

Hi,

Check it out whether you are using the Parameters and Table name - database name . table name. and mention Access mode like Insert in Constant button in Mapping.

Regards

Agasthuri Doss

[Former Member]

Thanks for the quickResponse Agasthuri Doss.Table name andtablenameare correct (Stored procedure in my case.) and hope there is no Access tag/mode in my case instead i mentioned action as EXECUTE (Constant)and the fieilds as mentioned in the structure.

Thanks and Regards,

Kiran.

[agasthuri_doss]

Hi,

You are right has to be EXECUTE.

Check it whether the 2 Parameters mentioned are Optional one and type is CHAR and other one as True.

Regards

Agasthuri Doss