on 11-14-2007 1:49 PM
Hi all,
I am working in a file to file scenario. My source & target structure are
source /target
FIRSTNAME -
NAME(first & last name)
LASTNAME -
^
EMPID----
DEPT , YR OF JOIN,
DOB -
DOB
i have tested the data mapping & interface mapping with a sample data. its working fine. But i dont get the output target file with all conversions applied. In XI runtime environment when the receiver channel is started i get an error msg "Java.Lang.exception conversion cannot be applied in xml ", "field separator or field fixed lenght is missing row.filed" . (But i have specified the field separator as comma in conversion parameters in receiver channel) . Kindly help me with the configurations of sender and receiver channels.
sample data that i've used.
-
saravanakumar,pk,ESAL200401,1984.
arun,cb,EPRD200211,1982.
KARTHIK,JANARTHANAN,ECSC200107,1978.
FCC PARAMETERS of sender
-
Message protocol : FILE CONTENT CONVERSION
Recordset structure : ROW,*
document name : MAIN_TAG
ROW.fieldNames FIRSTNAME,LASTNAME,EMPID,DOB.
ROW.fieldSeparator ,
ROW.endSeparator '.'
FCC PARAMETERS of receiver
-
Message protocol : FILE
ADVANCE MODE
-
ROW.fieldNames NAME,DEPT,YEAROFJOIN,DOB.
ROW.fieldSeparator ,
ROW.endSeparator '.'
EXPECTED OUTPUT
-
"i have made the necessary mapping and i tested data mapping and interface mapping
its working fine."
saravanakumarpk,SAL,2004,1984.
aruncb,PRD,2002,1982.
KARTHIKJANARTHANAN,CSC,2001,1978.
Thanks in advance
Hi Navajeevan,
Remove the full stop & use this in your Receiver FCC
ROW.fieldNames NAME,DEPT,YEAROFJOIN,DOB
ROW.fieldSeparator ,
ROW.endSeparator '0x0D''0x0A'
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Check whether there is any blank space after the parameter(ROW.fieldSeparator)
and check the recordsetname also
Yuga
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.