Mapping error: cannot produce target element
I have a JDBC to File scenario. When trying to send a message the data is correctly read from the database but not output file is generated in the receiver.
I checked the monitor and there is an error when the mapping is happening:
Cannot produce target element /ns1:msgT_createBusinessPartner/externalBusinessPartnerID. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd
I have tested the mapping in the design area and it works fine. So I wonder if this have something to do with the format of the datatype I created for the sender? Should it match exactly the format of the xml message generated by the jdbc adapter?
The payload generated by the jdbc adapter has the following format:
I created a new datatype with the same format, but I'm still having the same error.
Thanks in advance,
Aamir Suhail replied
you get "Cannot produce target element" if some mandatory field has not been mapped(this includes the node fields as well) so please make sure that all the fileds including nodes of the receiver have been mapped correctly.
second cause can be that the XML itself is not well formed,please paste the XML structure here via which you are testing the mapping