on 11-10-2016 3:27 PM
Hello All,
I am creating FCC plain to xml format. Input is a text file with tab delimited. And output
file should be xml file.
My input file having 15 records but i got only first record in output file.
This is my input file with tab delimited.
This is my output payload.
i got only first record from 15 records.i put Recordset per message in sender channel is" * ".
Please Help Me.
Regards,
s.k.prabhakar.
Hurry..........its working fine
Hello Raghuraman and Evgeniy Thank you very much,
It working fine Thanks A lot to spend your valuble and precious time.
But how can i map to spilt payload based on department at message mapping level.
Thanks and Best Regards,
s.k.prabhakar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Prabhakar,
Since your Emp data is getting created multiple times i.e 0-n no need to change the occurrence in the mapping,change to 0-1 occurrence in the signature tab of mapping,so that the messages node will be removed.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.
Hi Prabhakar!
Try to set '\t' as field separator.
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Evgeniy,
My .xml view having messages and message1 nodes automatically generated by sap.
But in my incoming payload these message and messages not coming is it any difference in that one.
This is my .xml view in mapping level.
This is my incoming payload from monitoring.
<?xml version="1.0" encoding="utf-8"?>
<ns:e10738_payload_msg_input xmlns:ns="http://e10738_payload_msg_spilt_task">
<emp_det>
<emp_id>101</emp_id>
<department>PI</department>
<designation>Developer</designation>
<salary>100</salary>
<experiance>4</experiance>
</emp_det>
could you please help me i am not able to solve issue.
Thanks,
s.k.prabhakar.
Prabhakar check my comments
Hello Prabhakar,
Since your Emp data is getting created multiple times i.e 0-n no need to change the occurrence in the mapping,change to 0-1 occurrence in the signature tab of mapping,so that the messages node will be removed.it will work.
Hello Evgeniy,
My fcc working fine but i get error at mapping level.
.IllegalInstanceException; Cannot create target element /ns0:Messages. Values missing in queue context. Target XSD requires a value for this element, but the target-field mapping does not create one.
why this error coming i am not able to understand.
Thanks,
s.k.prabhakar.
Hello Prabhakar,
But as per the FCC screenshot,the field separator is empty.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Raghuraman,
I put 0x09 as field separator but still all data coming into emp_id field only.
<?xml version="1.0" encoding="utf-8"?>
<ns:e10738_payload_msg_input xmlns:ns="http://e10738_payload_msg_spilt_task">
<emp_det>
<emp_id>101 PI Developer 100 4</emp_id>
</emp_det>
<emp_det>
<emp_id>102 ABAP Developer 100 4</emp_id>
</emp_det>
Regards,
s.k.prabhakar.
Hello Raghuraman,
still no luck all fields date come into empi_id only.
<?xml version="1.0" encoding="utf-8"?>
<ns:e10738_payload_msg_input xmlns:ns="http://e10738_payload_msg_spilt_task">
<emp_det>
<emp_id>101 PI Developer 100 4</emp_id>
</emp_det>.
can i delete all those objects and recreate it.
Thanks,
s.k.prabhakar.
Hello Raghuraman,
Now its came all fields data.
<?xml version="1.0" encoding="utf-8"?>
<ns:e10738_payload_msg_input xmlns:ns="http://e10738_payload_msg_spilt_task">
<emp_det>
<emp_id>101</emp_id>
<department>PI</department>
<designation>Developer</designation>
<salary>100</salary>
<experiance>4</experiance>
</emp_det>
But the error is same.
Cannot create target element /ns0:Messages. Values missing in queue context. Target XSD requires a value for this element, but the target-field mapping does not create one
This is my .xml view in message mapping.But in incomng payload messages and message1 nodes not coming only from message Type it coming. so check it once na my .xml and incoming payload structures.
Thanks,
s.k.prabhakar.
Hello Prabhakar,
Except emp_Id no other fields are generated,tats why this error.
check on the below points.
1.File has the correct contents.
2.If space is the field separator use 0x20 or '0x20' for field separator in the FCC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Prabhakar,
This seems to be missing value for department field.
Can you get the XML formed after FCC in the channel and check in mapping.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hello Raghuraman,
I got xml format in monitoring level and message mapping level.
<?xml version="1.0" encoding="utf-8"?>
<ns:e10738_payload_msg_input xmlns:ns="http://e10738_payload_msg_spilt_task">
<emp_det>
<emp_id>1 ABAP DEV 20 4</emp_id>
</emp_det>
<emp_det>
<emp_id>2 PI DEV 40 6</emp_id>
</emp_det>
</ns:e10738_payload_msg_input>.
Thanks,
s.k.prabhakar.
Hello Prabhkar,
Instead of making the source structure occurence 0-unbounded you should change the emp_det as 0-unbounded.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Raghuraman,
please help me to fix issue because i am working on it from 4 days.
I took soure emp_det is 0.unbound. But my incoming payload coming like this.all fileds data came into one emp_id field.
<?xml version="1.0" encoding="utf-8"?>
<ns:e10738_payload_msg_input xmlns:ns="http://e10738_payload_msg_spilt_task">
<emp_det>
<emp_id>101 PI Developer 100 4</emp_id>
</emp_det>
<emp_det>
<emp_id>102 ABAP Developer 100 4</emp_id>
</emp_det>
<emp_det>
<emp_id>103 PI Developer 300 4</emp_id>
</emp_det>
please tell me how can i fix this issue soon.because i am trying to do this one more than 4 days.
please help to fix this error ASAP.
Thanks and Best Regards,
s.k.prabhakar.
Hello Raguramn,
This is my source and Traget structures in mapping level.
This error i got at message mapping level.
MappingException: Mapping failed in runtimeRuntime Exception when executing application mapping program com/sap/xi/tf/_e10738_op_payload_mapping_; Details: com.sap.aii.mappingtool.tf7. IllegalInstanceException; Cannot create target element /ns0:e10738_payload_msg_onutput/emp_det/department. Values missing in queue context. Target XSD requires a value for this element, but the target-field mapping does not create one.
I am using ICO in ID configuration.
Thanks,
s.k.prabhakar.
Hi Prabhakar!
So that's why you get only one row in your xml. You should set it to * to get all rows from your file.
I guess that you use nested structure with repeating parent node, something like this:
<emp>
<emp_det>
</emp_det>
</emp>
...
<emp>
...
</emp>
Right?
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Evgeniy,
I agree with that one i chaned my file structure like this.
source message structure is 1.1. and Target message stracture is 0..unbound. But my message is in Scheduled state in message mapping level.
when i checked message log I got this error.
Cannot create target element /ns0:Messages. Values missing in queue context. Target XSD requires a value for this element, but the target-field mapping does not create one.
But i used only 1.1 mapping in my message mapping level.
Thanks and Regards,
s.k.prabhakar.
Hi Evgeniy,
This is my input pay load from message monitoring.
<?xml version="1.0" encoding="utf-8"?>
<ns:e10738_payload_msg_input xmlns:ns="http://e10738_payload_msg_spilt_task">
<emp_det>
<emp_id>101</emp_id>
<department>PI</department>
<designation>Developer</designation>
<salary>100</salary>
<experiance>4</experiance>
</emp_det>
<emp_det>
<emp_id>102</emp_id>
<department>ABAP</department>
<designation>Developer</designation>
<salary>100</salary>
<experiance>4</experiance>
</emp_det>
<emp_det>
<emp_id>103</emp_id>
<department>PI</department>
<designation>Developer</designation>
<salary>300</salary>
<experiance>4</experiance>
</emp_det>
<emp_det>
<emp_id>104</emp_id>
<department>HR</department>
<designation>HR</designation>
<salary>400</salary>
<experiance>4</experiance>
</emp_det>
<emp_det>
<emp_id>105</emp_id>
<department>PI</department>
<designation>Developer</designation>
<salary>500</salary>
<experiance>4</experiance>
</emp_det>
This is my source structure in message mapping
Thanks and regards,
s.k.prabhakar.
Hi Evgeniy,
This my .xml view in test tab in message mapping
<?xml version="1.0" encoding="UTF-8"?>
<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">
<ns0:Message1>
<ns1:e10738_payload_msg_input xmlns:ns1="http://e10738_payload_msg_spilt_task">
<emp_det>
<emp_id/>
<department/>
<designation/>
<salary/>
<experiance/>
</emp_det>
</ns1:e10738_payload_msg_input>
</ns0:Message1>
</ns0:Messages>
But in incoming payload i did not get " Messages and Message1" Nodes.
i got incoming payload like this
<?xml version="1.0" encoding="utf-8"?>
<ns:e10738_payload_msg_input xmlns:ns="http://e10738_payload_msg_spilt_task">
<emp_det>
<emp_id>101</emp_id>
<department>PI</department>
<designation>Developer</designation>
<salary>100</salary>
<experiance>4</experiance>
</emp_det>
I am not getting messages node and messages1 nodes.
Thanks and Best Regards,
s.k.prabhakar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prabhakar!
Did you set "Recordset structure" parameter as "emp_det,*"?
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
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.