File 2 Proxy Process in PI 7.1

[Former Member]

working on File to Proxy Scenario and I gave the File content conversion as below. Incoming file contains 3 record structures Header, Record & Trailer File is getting processes only where there is only one record in the record structure

The error which I receive is

Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR converting document line no. 2 according to structure 'Record':java.lang.Exception: Consistency error: field(s) missing - specify 'lastFieldsOptional' parameter to allow this

Please suggest what needs to be done on this

Thanks

PR

_______________________________________________________________________________________________________

Document Name : MT_TW_AK

Document NameSpace : http://aiwcd.com/Claims_Management(CM)_Rel2.0

RecordSet Name : FROISROIAcknowledgement

RecordSet Structure : Header,1,Record,*,Trailer,1

Recordset Sequence : Ascending

Recordsets Per Message : *

KeyField Name :TransactionSetID

Key Field Type : String (Case Sensitive)

-

---

IgnoreRecordsetName : true

Header.fieldNames :TransactionSetID,SenderID,ReceiverID,DateTransmissionsent,TimeTransmissionsent,OriginalTransmissionDate,OriginalTransmissionTime,TestProductionCode,InterchangeVersionID

Header.fieldFixedLengths: 3,25,25,8,6,8,6,1,5

Header.keyFieldValue : HD1

Header.lastFieldsOptional : true

Record.fieldNames :TransactionSetID,RecordSequenceNumber,DateProcessed,TimeProcessed,InsurerFEIN,ClaimAdministratorPostalCode,ClaimAdministratorFein,AcknowledgementTransactionSetID,ApplicationAcknowledgmentCode,InsuredReportNumber,ClaimAdministratorClaimNumber,JuridictionClaimNumber,MaintenanceTypeCode,MaintenanceTypeCodeDate,RequestCode,FreeFormText,NumberofErrors,MaintenanceTypeCorrectionCode,MaintenanceTypeCorrectionCodeDate,JurisdictionBranchOfficeCode,ClaimAdministratorAlternatePostalCode,NumOfErrors

Record.fieldFixedLengths: 3,9,8,6,9,9,9,3,2,25,25,25,2,8,3,60,2,2,8,2,9,19

Record.keyFieldValue : AKC

Record.lastFieldsOptional: true

Trailer.fieldNames:TransactionSetID,DetailRecordCount,TransactionCount

Trailer.fieldFixedLengths: 3,9,9

Trailer.keyFieldValue : TR2

Trailer.lastFieldsOptional : true

ignoreRecordsetName: true

[Former Member]

The issue was with the data, when I deleted the 2nd record and process the file it has been sucessfully completed without any errors

Thanks a lot for all inputs

PR

[Former Member]

Hi PR,

I see few things may need a change. First .lastFieldsOptional is obselete now and must not be used. Please see this help for this:

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

> Recordsets Per Message : *

You can leave this blank

> ignoreRecordsetName: true

You have given twice. If you give once is OK.

Also the error might be saying you are missing few fields in the last. Since fixed length file if you dont have field you should have spaces in teh file. check that also. Also try to give sample file here so that somebody can help you out.

Regards,

---Satish

[Former Member]

Hi,

try:

lastFieldsOptional=YES

as per:

http://help.sap.com/saphelp_nw04s/helpdata/en/0d/00453c91f37151e10000000a11402f/content.htm

the default is NO.

Cheers'

Neetesh

[Former Member]

Hi,

Verify your input file, the content is not filling the structure you defined in the CC.

In "lastFieldsOptional" parameter you must to put "YES" and not "true".

Regards

Ivan

[Former Member]

Hi PR,

lastFieldOptional = YES

Regards,

lpbuff