File Content Conversion : Recordset Structure with * not reading file

[Former Member]

Hallo all,

we have the following problem.

we implemented a scenario as sown in this blog

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

but there is a problem.

If the file structure is declared as :

Header,1,Items,*

then the adapter does not even read the file from the directory (so I assume that for some reason the file structure is not as expected).

If on the other had the structured is declared as :

Header,1,Items,3

everything works.

Obviously though, this is not satisfying since we need variable cardinalities.

Here is an example :

I have a specific file in a standard directory, called xi_input.

The file is edited straight into that directory, so there can't be filename errors etc.

If the file is left empty :

Nothing happens . No message of any kind in sxmb_moni/monitoring xml messages .

If the file contains the following (data is random) , where 'H' is the key for the header and 'I' is the key for the items :

H 20060403 16 3 316001 kapou lalla morellala 20060403 F3 23

I 277101010 2

I 277101011 3

I 277101012 4

There are to cases :

if the file structure is declared as :

Header,1,Items,*

Then nothing happens .

If on the other had the structured is declared as :

Header,1,Items,3

everything works .

Any suggestions and help is appreciated

Thank you .

[Former Member · Accepted solution]

Actually, In the cc monitoring, i get a line

5/30/08 5:45:27 PM a6eb65b2-dbf0-428a-119a-ae71db0f5935 Processing finished successfully

which on click gives these messages

2008-05-30 18:45:27 Success Channel CC_File_adapter: Entire file content converted to XML format

2008-05-30 18:45:27 Warning Channel CC_File_adapter: Empty document found. Proceed without sending message

2008-05-30 18:45:27 Success File "E:\tmp\NetBeauty\In\xi_input.dat" archived after processing

pretty confusing, since the file is NOT empty.

[Former Member · Accepted solution]

Can you publish somewhere screenshot of the content conversion parameters of your CC?

Can you post also file content?

p

[Former Member · Accepted solution]

Markos,

just to be sure:

Do you have "H" as a keyFieldValue or you have just H there?

It must be just H... If you have "H" there, the adapter can't find this value and the document is of course empty for the CC.

P

[Former Member]

You are absolutely RIGHT.

The actual problem has to do with the quotes . I tried both with single and double quotes, but there should be none.

The problem is that the reference blogs use quotes in the key definition.

Anyway, thank you very much for your effort and time.

[Former Member]

You are right about the permissions.

I changed them and now the file is read and then archived.

Only that still, there is no message in the sxmb_moni, so no input in the XI .

[Former Member]

Hi,

a, assign some points

b, is there any message in the CC log in RWB? or does it just say - message processed. Try to put another file in the directory. The file must not be empty.

Let me know the result.

Peter

[Former Member]

Actually yes, there is an error message :

Error 5/30/08 3:12:45 PM fda9d3c5-4775-4df8-17b8-dfd14191171d

Retry interval started. Length: 5.0 seconds

Error 5/30/08 3:12:45 PM fda9d3c5-4775-4df8-17b8-dfd14191171d

Could not archive file 'E:\tmp\NetBeauty\In\xi_input.dat' after processing

5/30/08 3:12:45 PM Processing started

And the details are :

2008-05-30 16:07:00 Success Channel CC_File_adapter: Entire file content converted to XML format

2008-05-30 16:07:00 Warning Channel CC_File_adapter: Empty document found. Proceed without sending message

2008-05-30 16:07:00 Error Attempt to archive file "E:\tmp\NetBeauty\In\xi_input.dat" after processing failed. Retry

Only that they don't look very helpful. From this I only understand that the data in my input.dat file is not in the format expexced.

I Have configured key fields as :

keyfield name : keyfield

Header.fieldNames : keyfield,CreationDate,CentralCustomerCode,CustomerCode,ReferenceDocumentNumber,DeliveryPlace,Message,ReturnMessage,DeliveryDate,SalesmanCode,Rest

Items.fieldNames : keyfield,Material,Quantity

Header.keyFieldValue "H"

Items.keyFieldValue "I"

[Former Member]

Hi,

ok, so now there is no problem with your CC configuration.

Now there is a problem with permissions on your file system, when XI tries to archive the file.

Make sure, XIDADM/XIQADM/XIPADM/PIDADM/PIQADM/PIPADM user has read / write permission to required folders and has read / write permission on this file.

Peter

[Former Member]

Hi,

check your CC in RWB when you set *.

Is there any error?

have you provided keyFieldValue parameter for Header & Items?

Peter