Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 04, 2017 at 10:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded