cancel
Showing results for 
Search instead for 
Did you mean: 

File Content convertion error

Former Member
0 Kudos

I am getting error (java.lang.exception)in RWB in component monitoring of sender side file NFS adapter

number of arguments in Row.fileldFixedLength does not match with no of fields in Row.fieldNames.

My file is , seperated with 5 fileds

Row.filedNames ename,eno,performrate,ratedesc,effecivedate

Row.fieldSeperator ,

i used 'nl' as newline character

Can anybody please give the reason for the error

Accepted Solutions (1)

Accepted Solutions (1)

GabrielSagaya
Active Contributor
0 Kudos

Hi

1)You should not use Both fieldFixedLengths and fieldSeparator together in FCC.

2)Since it is case-sensitive beware of spelling mistake

so

Row.fieldNames=ename,eno,performrate,ratedesc,effecivedate

Row.fieldSeperator=,

Row.endSeperator='nl'

Flat File to Flat File (FTP) Part 1

Flat File to Flat File (FTP) Part 2

Former Member
0 Kudos

I did not use fieldFixedLength.But I do not know why it is giving that error,I only used field seperator as ,

in this.

Former Member
0 Kudos

Thanks Gabriel ,it is due to spelling mistake of seperator as seperetor

Answers (3)

Answers (3)

Former Member
0 Kudos

Your structure looks like

DT_...

.......Row -

...............field1

...............field2

...............field3

...............field4

...............field5

Did you use ignoreRecordsetName = true ?

Former Member
0 Kudos

I used datatype as complex type and i did not use ignoreRecordSet,where can I use that

Former Member
Former Member
0 Kudos

Hi,

I think there is some mismatch between

Row.filedNames

Row.fileldFixedLength

Check it once..

Regards,

Soumya

Former Member
0 Kudos

I did not use Row.fieldFixedLength at all

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

hi,

i faced the same error i and i couldnt undestand why. the number of field were right. this error appears for structures like this:

i saw one thread that said PI does not suppor more than 2 child segments

<f1>

...<f2>

.........<f3>

.........<f3>

.........<f3>

.........<f3>

...<f2>

<f1>

so,

the way i solved it if put segments at same level

thnaks

Edited by: Rodrigo Pertierra on Jul 10, 2008 11:16 AM

Former Member
0 Kudos

under DT ,I kept sub element as Row and under Row Subelements are ename,eno,.....

so do you suggest to keep all

Row,ename,eno...........etc at same level.I do not think I have to do this

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

hi Raj,

try my way with the same parametes in FCC and tell me if it works.

you will see that there no error in conversion FCC.

Thanks

Rodrigo