Skip to Content
avatar image
Former Member

Receiver JDBC - Error

Hi,

I am trying to delete the table before inserting and have two structures in my mapping

Delete_item

Insert_item

I have mapped the action field and table correctly in both of these structures.

When i executed , I got the following error in the communication channel.

FATAL ERROR document format: structure 'Delete_tblSAP_Item', no key element found.

My delete_tbl_SAP_Item has the following structure

action = DELETE

table = dbo.item

Please help what went wrong

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 17, 2010 at 01:15 PM

    Hi

    While using the "DELETE" statement Key element should not be "empty". Also check your XI Target structure is created accrodingly.

    http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

    If there is no <key> element, or if there is a <key> element but it is empty, then no condition is specified
    and the entire table is to be deleted. 
    This *may not be permitted by the configuration of the JDBC adapter for security reasons* and
    will therefore result in an error during message processing and an appropriate error message.
    

    Regards

    Ramg

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Stefan Grube

      Stefan,

      This interface runs weekly. Before inserting fresh data, I am deleting all the entries from the table. The Previous data would be processed automatically the next day. So we do not have any risk of losing old data.