on 05-21-2015 6:54 AM
Hello,
I am currently facing a problem where I can not find a solution. I have a incoming flat file that needs to be converted to a xml file. Therefore I have used the content conversion but I am getting the following error and the file is not picked up from the source directory:
The file looks like this and has always only this one line in it:
The message type is created like this:
The content conversion is the following:
Does anyone of you have faced this probem befor and can help me finding a solution for it?
regards
Christian
Hello,
sorry for the delay. I have been working on another procject and didn't had the time for this issue.
I have added the line
ignoreRecordsetName = true
as Eng suggested. But still it is not working. I see the correct mapped file in the monitoring:
But the file is not created with the following error:
The content conversion in the sender adapter is set like that
I really don't have a clue why it is not working
regards
Christian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christian,
For both the target elements which are there in the mapping screenshot, you can try using "map with default" ,i.e., you can map the constant with the target elements via "map with default".
This will in fact not suppress the target element and hence it must get created.
Regards,
Souvik
Hi,
Please check note -
799657 - Error message CANNOT_PRODUCE_ELEMENT in message mapping
Thanks,
Atul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christian
Your Message Type definition does not match the output generated by the FCC configuration. Noticed that there is an additional level with "Recordset" in the XML at MS step. The mapping fails because of the difference between actual payload and structure expected by message mapping.
As I have mentioned in my earlier reply, please add the following to the FCC configuration parameters:-
ignoreRecordsetName = true
Rgds
Eng Swee
Dear Christian,
In flat file fields are more than you declare as i see there are 7 fields in the file and you have declared only 5 fields add two more fields in content conversion it will work
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christian,
Just to add on to what Eng suggested, go through the conversion part of below link once,
SAPTechnical.COM - File Content Conversion
Thanks,
Arthita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christian
For the fieldNames configuration, use comma as a separator instead of ;
If it's just one line, you also don't need the keyFieldValue parameter.
Rgds
Eng Swee
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.