Error processing request in sax parser No 'action' attribute found in XML

[Former Member]

Hi All,

I am doing a FILE to JDBC Scenario. I just want to send a data from file to Sql Db table. For this I have written a stored procedure to insert the row in a table.

This is the message mapping for FILE to JDBC ….

Sender Receiver

*FILESENDER_MT 1..1 FILESENDER_DT * SPRECEIVER_MT 1..1

.NO 1..1 xsd:string * Statement 1..1 string

.Name 1..1 xsd:string *user_PROC 1..1

action 1..1required

*No

isInput 1..1 string

type 1..1 string

*Name

isInput 1..1 string

type 1..1 string

Mapped Values....

Statement is mapped with <b>FILESENDER_MT</b>

action attribute is mapped with "<b>EXECUTE</b>" Constant

No is mapped with <b>NO</b>

Name is mapped with <b>Name</b>

for both isInput is mapped with <b>TRUE</b>

for both type is mapped with <b>CHAR</b>

Here is the my stored procedure.....

CREATE PROCEDURE [dbo].[user_PROC]

@NO char(10), @Name char(10) AS

insert into FILE2JDBC values('a','ab')

GO

when i run this stored procedure in Sql directly it was executed successfully....

I have checked In SXMB_MONI status is showing green...

xml messages from SXMB_MONI ....

this is the message from payloads of Inbound Message

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

- <ns0:FILESENDER_MT xmlns:ns0="http://www.prospectadelhi.com/DELHI_FILE2JDBC">

<NO>111</NO>

<NAME>murthy</NAME>

</ns0:FILESENDER_MT></PRE>

this is the message from payloads of Request Message Mapping

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

- <ns0:SPRECEIVER_MT xmlns:ns0="http://www.prospectadelhi.com/DELHI_FILE2JDBC">

- <Statement>

- <user_PROC>

<action>EXECUTE</action>

- <NO>

<isInput>TRUE</isInput>

<type>CHAR</type>

</NO>

- <Name>

<isInput>TRUE</isInput>

<type>CHAR</type>

</Name>

</user_PROC>

</Statement>

</ns0:SPRECEIVER_MT>

this is the error showing in runtime workbench>component monitoring->communication channel monitoring-->Receiver Communication Channel....

<b>Error while parsing or executing XML-SQL document: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)</b>

Can any body tell me whether the problem is in Mapping or in Data Type Structure..

Please resolve this issue....

Thanks in Advance,

Murthy.

[former_member529475]

Hi Murthy

Check the following thread.. same kind of problem solved here...

Cheers..

Vasu

<i>** Reward points if found useful **</i>

[bhavesh_kantilal]

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

- <ns0:SPRECEIVER_MT xmlns:ns0="http://www.prospectadelhi.com/DELHI_FILE2JDBC">

- <Statement>

<b>- <user_PROC>

<action>EXECUTE</action></b>

- <NO>

<isInput>TRUE</isInput>

<type>CHAR</type>

</NO>

- <Name>

<isInput>TRUE</isInput>

<type>CHAR</type>

</Name>

</user_PROC>

</Statement>

</ns0:SPRECEIVER_MT>

The Action should be a Attribute of Element user_Proc as,

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

- <ns0:SPRECEIVER_MT xmlns:ns0="http://www.prospectadelhi.com/DELHI_FILE2JDBC">

- <Statement>

<b>- <user_PROC action="Execute"></b>- <NO>

<isInput>TRUE</isInput>

<type>CHAR</type>

</NO>

- <Name>

<isInput>TRUE</isInput>

<type>CHAR</type>

</Name>

</user_PROC>

</Statement>

</ns0:SPRECEIVER_MT>

Likewise isInput and Type should be Attributes and not Elements .

Regards

Bhavesh