Skip to Content
avatar image
Former Member

Receiver JDBC - Error


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



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

  • Follow
  • Get RSS Feed

1 Answer

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


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

    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.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Stefan Grube


      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.