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

[buddhika_krishantha]

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.

[Andrzej_Filusz · Accepted solution]

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

[buddhika_krishantha · Accepted solution]

Thanks Andrzej Filusz. Its working fine.