File content conversion : empty document found

[Former Member]

Hi

I have a simple FCC scenario in which I have one recordset and only one sub structure.

Recordset>

- <Input_File>

<SortSequence>A</SortSequence>

<GRMaterialDocument>B</GRMaterialDocument>

</Input_File>

</Recordset>

And my file communication channel details are -

Recordset Name : Recordset

Recordset Structure : Input_File,*

Recordset Sequence : Ascending

Input_File.fieldNames : SortSequence,GRMaterialDocument

Input_File.fieldSeparator : ,

Input_File.lineSeparator : 'nl'

The problem I am facing is that the scenario works when there are 5 to 6 records but if I increse the number of records it gives an error even though the file is picked up from ftp server successfully

The error that I receive in the RWB MDT is -

Success : Entire file content converted to XML format

Warning : Empty document found. Proceed without sending message

Success : File "Test.txt" deleted after processing

and I have data in the file (i have increased the number of records to 20)

Can anyone suggest a solution?

[Former Member · Accepted solution]

Hi,

Firstly could you juz give a breif descrip of the entire scneario i.e bouth src & tar system.

In fcc

Input_File.lineSeparator : 'nl'

Do we have lineSeparator >? dun think so...

It should rather be

Input_File.endSeparator : 'nl'

<b>Cheers,

*RAJ*</b>

[Former Member]

I have not used the fixedFieldLengths field. Can it be an issue?

[nisarkhan_n]

your file is an field separated right? then specifiy the field separator and try.....this is totally strange problem......

if you dnt specifiy the fieldseparator it might throw error i feel....

[Former Member]

oh field separator is absolutely necessary...i was talking about the parameter 'fieldFixedLength'..but anyways that didnt work too

[Former Member]

Hi Vaibhav,

Very strange that you are facing this issue..

Try with the following parameters..This is just for testing if it works for more than 5 rows.

What we are trying to do read the input file row wise...

Recordset Name : Recordset

Recordset Structure : Input_File,*

Recordset Sequence : Ascending

Input_File.fieldNames : SortSequence

Just check if the whole file is converted into XML. If it still doesnt work ..

Why dont u try deleting the adapter and recreating it again ..

If you dont want to delete it then maybe you can raise OSS message..

Regards,

Sumit

[Former Member]

Hi guys

It was an issue with FTP...I made the channel inactive and posted a large file on the server, on refreshing it showed an empty file!! So the problem was that XI was getting an empty file and hence the warning.

I have used NFS instead of FTP for now and its working fine. BTW can anyone tell me the reason for the abovementioned wierd behaviour?

[Former Member]

Hi Vaibhav,

Correct me if i am wrong..

The problem you are facing is something like this..

When the file transfer mode is FTP, then in adapter monitoring you get the erorr that empty document found ? Or in message monitoring you see a empty payload ?

and when the file transfer mode is NFS. The adapter reads the file.

Regards,

Sumit

[Former Member]

Hi Sumit

When I use FTP, the file (if it is in excess of 10KB) reaches the XI EMPTY. so in communication channel monitoring I see the warning 'Empty Document Found'.

When I use NFS, the problem doesnt occur and file is transferred smoothly.

[Former Member]

Hi Vaibhav,

>>>When I use FTP, the file (if it is in excess of 10KB) reaches the XI EMPTY. so in communication channel monitoring I see the warning 'Empty Document Found'.

1) Does it work in FTP mode when the file size is less than 10KB?

2) in communication channel monitoring I see the warning 'Empty Document Found'.? Does the file gets deleted from FTP folder in this case ? Do you also see in message monitoring empty document? When you open the same file in notepad do you see contents inside ?

Do let us know answers to the above questions.

Regards,

Sumit

[Former Member]

> 1) Does it work in FTP mode when the file size is

> less than 10KB?

>

Yes sumit, it does.

I talked to the network guys, they said they have not made any settings for this.

> 2) in communication channel monitoring I see the

> warning 'Empty Document Found'.?

The message does not go into message monitoring since XI does not process empty files. Henceforth it will not be shown in Moni either.

> Does the file gets

> deleted from FTP folder in this case ? Do you also

> see in message monitoring empty document? When you

> open the same file in notepad do you see contents

> inside ?

>

> Yes it does get deleted from FTP and the file has data before i put it into FTP but when its picked up, empty file goes to XI

[Former Member]

Hi Vaibhav,

You didnt not say .. Does it work in FTP mode if the file size is less than 10KB?

Or you get the same problem.. Empty Document Found?

Regards,

Sumit

[Former Member]

yes it works in FTP mode with a file which has 5-6 records

[Former Member]

>>>Entire file content converted to XML format

Warning : Empty document found. Proceed without sending message

You get this msg if your FCC fails. So check this.

I dont think line separator is the cause of the issue. Just remove the parameter. By default 'nl' is the endSeparator. Since u said it is working fine with 5 records, copy the 5 records and paste it again. I know you already said this. But my gut is tere are some empty space or some missing char which causes the FCC to fail and hence the error.

Regards,

Jai Shankar

[Former Member]

have you tried writing this ?

ignoreRecordset = true.

[Former Member]

try this out

In content conversion parameter specify Recordsets per message = 20

[Former Member]

Mugdha

Same problem

[Former Member]

Hello,

If the file is successfull picked up for 5 record it should be processed for 20 records also. Might be an issue with your file. Remove the successful 5 records try on a trail error methods with rest of the records.

There must be a bad rec in the file.

Regards,

[Former Member]

Hi SriHari

I have copy pasted the same record 20 times

[Former Member]

Hey

either there is something wrong in the sender file or there is something wrong with sender CC parameters.

i know ur getting error in AE so u might not copy the XML from sxmb_moni but just in case u have the XML for it,can u please test the message mapping once.

i think the sender file has some error

Thanx

Aamir

[Former Member]

Hi aamir

I checked the message mapping again in the test tab...works fine even if i duplicate node 20 times

I posted my FCC parameters...can u detect an error from that?

[Former Member]

Hey Vaibhav

well first of all you wont have Input_File.lineSeparator : 'nl'

it will be as suggested by Raj.

secondly ur other FCC parameters looks ok to me.

if possible can u please remove FCC for a min and test ur scenario with the XML.

if that works fine then fault is with FCC.

Thanx

Aamir

[Former Member]

Hi

Changing from 'line separator' to 'end separator' didnt work!

My test data is A,B and ive copied it and pasted it 20 times making it 20 records. Works well with 4-5 records but i get 'empty document found' when I increase that number. So neither there shud be a prob with FCC nor the data for that matter.

Any other suggestion?

[nisarkhan_n]

it is an strange behaviour..........reactivate the file adapters

(change the filename and location from where you are picking up)........

[Former Member]

Hi Vaibhav,

Open the file in command prompt (cmd) and see if the file is as per your requirement.

Also try creating a new file instead of copying from the old file.

As earlier mentioned if it works for 5 it will work for any number of record.

Also leave the RecordSet per message field to blank.

Regards,

Sumit

[Former Member]

Hi Vaibhav,

Kindly upload the txt file in some website and share the link with us.

Regards,

Sumit

[Former Member]

Hi everyone

1. i removed 'line separator' and replaced it with 'end separator'

2. i reactivated file adapter

3 i tried ignoreRecordset = true

4. deleted that old file and created a new one.

5. checked contents in command prompt

6. tried leaving 'recordset per message' field blank

None of that worked

I am using sample data

A,B,C

and copy pasted it 20 times.

When i use 4-5 lines, works fine but when i increase the number i encounter 'empty document found'