File Content Conversion: Sender Problem

[Former Member]

Hi,

I'm getting a very typical error in my Sender Communciation channel.

Channel CC_FILE_SENDER_2: Empty document found. Proceed without sending message

I've gone through a few threads and I know that the problem is with the Key Field and using * in the Recordset Structure but I cannot solve it. If I use * in the Recordset structure it fails,when I use a specific number it works. Any ideas

Here is my Communication Channel details

 
Document Name: MT_SENDER
Document namespace: http:\\sender
Recordset Structure: FileHeaderRecord1,1,FileHeaderRecord2,1,FileHeaderRecord3,1,FileDetailRecord,*,FileTrailerRecord1,1
Recordset Sequence: Ascending
Key Field Name: RType

And the configuration:

 
FileHeaderRecord1.fieldNames:             RType,Filler,Code,Filler2
FileHeaderRecord1.fieldFixedLengths:  10,31,6,69
FileHeaderRecord1.keyFieldValue:         V  
FileHeaderRecord2.fieldNames:            RType,Filler
FileHeaderRecord2.fieldFixedLengths:  3,113
FileHeaderRecord2.keyFieldValue:        HDR1
FileHeaderRecord2.fieldNames:            RType,Filler,Date,File,Filler2,Num,Filler3
FileHeaderRecord3.fieldFixedLengths: 3,2,5,6,21,3,76
FileHeaderRecord3.keyFieldValue:        UH1
FileDetailRecord.fieldNames:                 RType,Filler,TCode,Filler1,Amount,Filler2,ZGC,Filler3,Date,Filler4
FileDetailRecord.fieldFixedLengths:       14,1,2,18,11,18,9,28,5,10
FileDetailRecord.keyFieldValue:             9
FileTrailerRecord1.fieldNames:              RType,Filler,TCode,Filler1,Date
FileTrailerRecord1.fieldFixedLengths:   14,1,2,12,5
FileTrailerRecord1.keyFieldValue:          UT1
ignoreRecordsetName:                           true

This is a copy of my file....

VPR456SCL1                               852086                                                                                
HDR1 SED456RD  345344500428            F     04 094520428     BS   09452                                                        
UHL1 09452ESBCL1    00000000         004                                                                                
85208681123787085              000000000000500FREW RTYU POSWS123704375                            09452                      
85208681123787085              000000000000600FREW RTYU POSWS123705307                            09452                      
85208681123787085              000000000000600FREW RTYU POSWS123705671                            09452 

[Former Member · Accepted solution]

Hi,

problem is in your keyfield value,

FileHeaderRecord1.fieldNames: RType,Filler,Code,Filler2

FileHeaderRecord1.fieldFixedLengths: 10,31,6,69

FileHeaderRecord1.keyFieldValue: V

keyfield name is RType and it is given a fixedlength of 10 characters, but your keyfieldvalue is "V

" which is not 10 char long that is the reason your adapter is failing to pick it.

same for all the other recordsets, the fieldvalue shd match the fixed length given.

Eg:- give keyfieldvalue like this "V ". it will work.

[Former Member]

Thanks very much for the quick responses. I would never have figured out that the lengths were the problem.

[Former Member]

1st length in fieldFixedLengths patameter should be exact length of keyField...check if it is maintained correctly

Modify fieldFixedLengths parameter accordingly

Also check if you have specified endSeparaor = 'nl'

[Former Member]

Hi Damien

Problem is .. Your key field value and length is not matching. If value is V length cannot be 10.

If you want to test key fields then just remove Fixedlengh and test it and again you can implement it.

Thanks

Gaurav

[VijayKonam]

Looking at the configuration, I can see that, you are not specifying the KeyField name for each record. Also, it is not included in the fieldList of each record. See to that these conditions are provided and length of the key fields and length of the key field value same.

VJ