Skip to Content
0

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

Oct 04, 2017 at 10:28 AM

99

avatar image

Hi,

I'm trying an IDOC to JDBC scenario. In JDBC side I have a sql server 2012 and I have stored procedure named CreateOrUpdateItemMaster. But when I trigger an IDOC, PI shows No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure) error. I have attached the screenshots of the mapping. Please help me to resolve this.

mapping1.png (21.6 kB)
mapping2.png (24.5 kB)
mapping3.png (25.5 kB)
mapping4.png (31.2 kB)
mapping5.png (23.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Andrzej Filusz Oct 04, 2017 at 10:50 AM
0

Hi,

The structure of your target message is incorrect. Please check the following link:

https://help.sap.com/saphelp_nwpi711/helpdata/en/44/7b7855fde93673e10000000a114a6b/frameset.htm

  <StatementName>
    <storedProcedureName action=” EXECUTE”>
       <table>realStoredProcedureeName</table>
        <param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>
    </storedProcedureName > 
  </StatementName>

The statement name tag is missing.

Regards,

Andrew

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Andrzej Filusz. Its working fine.

mapping.png (16.1 kB)
0