on 10-17-2005 2:58 PM
Hello..
I have scenario File- File..
While i'm transfering a file from FTP to FTP..i'm getting the follwing error "09:10:26 Start of test
Cannot produce target element /ns:fileoutput_mt/record/row. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd
09:10:26 End of test"
Please let me know what might be the error..
thanks..
Hi Padma,
check this weblog:
/people/michal.krawczyk2/blog/2005/09/16/xi-how-to-test-your-mapping-in-real-life-scenarios
this is probably because of your mapping program
Regards,
michal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the reply..
I created simple message type as per the web log...
fileinput
record
row
fistname
lastname
and i'm using output message as..
fileoutput
record
row
fistname
lastname
in my message mapping ...row-row,firstname-firstname,lastname-lastname.
I didn't understand what might be the error???
Michel..
I'm not using BPM for this process...when i'm testing in message mappming i'm getting the error..
Cannot produce target element /ns:fileoutput_mt/record/row. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd
Thanks..
Thanks for the reply...
Actually i put only once as occurence initially...but now i canged it to un bounded...but still i'm getting following error in message mapping...
error is..
Messages:
14:06:23 Start of test
Compilation of file_to_file_mm successful
Cannot produce target element /ns:fileoutput_mt/record/row. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd
14:06:28 End of test
Please let me know if something went wrong???
Thanks..
Source Structure Target Structure
fileinput ==> fileoutput
record ==> record
row ==> row
fistname ==> fistname
lastname ==> lastname
I thing the Row in the Target field is a REQUIRED FILED and if your source structure does not contain the corresponding element then it will fail with that error.
To avoid that you need to use the Exists function with the Source field "row" and make the context of the Row as the top of the structure and I think this will definitely resolve your problem.
Padma,
Take the same example which is being discussed here...
Suppose the field row is optional in your source structure (0..1) and mandatory (1..1) in your target structure.In case the field element row does not appear in your source document(since it is optional in source ) the mapping will fail when you are mapping row in a source to row in target structure (since it is mandatory in the target). To avoid this you can use a Exists function i.e if a particular field does not appear in the source you can map with constant or dummy value to avoid the error "Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd".
Hope this clears your doubt..
Refer this thread for more information on Exists function..
Regards
Anand
Padma
Currently you have the mapping like this
Row ---> Row
Change the Mapping like below
Step 1
row ---Exists -
if/Then / Else ---> Row
Step 2
above the Then , connect to Row. for else connect to a literal
step 3
on source row field right click and change the context to the RootNode.
Sorry in the first place I have missed few points.
Thanks Karen..
Even though i used exists function...still i'm getting the error...what i noticed in my analysis was...
The below XML was genarated when i'm testing my message mapping..
<?xml version="1.0" encoding="UTF-8"?>
<ns:fileinput_mt xmlns:ns="http://test">
<record>
<row>
<firstname />
<lastname />
<city />
<country />
</row>
</record>
</ns:fileinput_mt>
but in SXMB_MONI...i'm getting error (main document) is....
<?xml version="1.0" encoding="utf-8"?>
<ns:fileinput xmlns:ns="http://test">
<record>
<row>
<firstname></firstname>
<lastname></lastname>
<city></city>
<country></country>
</row>
</record>
</ns:fileinput>
My question is why there is a differentiation in </ns:fileinput_mt> and </ns:fileinput>....
Thanks...
Padma, are you using file conversion? If you are using file conversion? If you are using file conversion, ensure that you are using the Message type as your document name..
That should fix it..
Download the payload from SXMB_MONI and change the fileinput to FIleInput_mt and test your mapping.. it should work..
Hi, padma.
First of all, just forget the expression of the message "xsd blah, blah". This is just XI-only-knows message
> Cannot produce target
> element /ns:fileoutput_mt/record/row
Usually, this kinds of error happens because that your input record is incorrect w.r.t the structure(not value!).
i recommend you create first very simple input file which can be generated from Integration Repository's mapping test tool.
Good luck.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.