Skip to Content
avatar image
Former Member

File is not Picking eventhough file naming convention is there as *XXXXXX*

Hi Experts,

I would like to know the exact route cause of why PI behaves like this?

ISSUE:-

I am doing SYNC Scenario FILE -- RFC -- FILE using Integrated Configuration nothing but Advance Adapter Engine concept.

I kept file naming convention to be picking in the sender File adapter as

*ConsumerHours.xml*

Now I am keeping file with file name in FTP as given below:-

20100409_121403_000001929023_XXXXX_ConsumerHours.xml

But It is not picking the above file I tried and tried so many times finally I have taken one Old success file from Source Team and Compared both XML files using XML Comparison Tool and I found 3 Reasons:- which I wondered It Picks the below Success File

The_3 Differences are:-_

Success File Contains:-

a) <?xml version="1.0" ?>

but old one contains::

<?xml version="1.0" encoding="ISO-8859-1" ?>

MY QUESTION:-

I agree there is encoding issue but how can it validation takes place before coming into PI and that to while picking the File at FTP Location?

b) Success File Contains:-

<CUSTOM_FIELD ID="PRODUCED_QUANTITY">

Failure File Contains:

<CUSTOM_FIELD ID="PRODUCT_QUANTITY">

MY QUESTION:-

I agree there is TAG issue but how can it validation takes place before coming into PI and that to while picking the File at FTP Location?

c) File Naming conventions:-

FOR Failure File Contains:20100409_121403_000001929023_XXXXX_ConsumerHours.xml

FOR Success File Contains:091023235952188_XXXXX_ConsumerHours.xml

MY QUESTION:-

Is there any restriction in keeping FIle name length for placing into the FTP Location. Even though I kept ConsumerHours.xml I donot know why it is not picking the File ?

Kindly let me know if you have any solution on this I mean exact Route Cause:

Regards:

Amar Srinivas Eli

Edited by: Amar Srinivas Eli on Apr 10, 2010 3:27 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 10, 2010 at 10:31 AM

    Hi,

    a) <?xml version="1.0" ?>

    but old one contains::

    <?xml version="1.0" encoding="ISO-8859-1" ?>

    MY QUESTION:-

    I agree there is encoding issue but how can it validation takes place before coming into PI and that to while picking the File at FTP Location?

    S u r correct the file validation wil nt takes place before PI picks the file..

    b) Success File Contains:-

    <CUSTOM_FIELD ID="PRODUCED_QUANTITY">

    Failure File Contains:

    <CUSTOM_FIELD ID="PRODUCT_QUANTITY">

    MY QUESTION:-

    I agree there is TAG issue but how can it validation takes place before coming into PI and that to while picking the File at FTP Location?

    Its void,,

    c) File Naming conventions:-

    FOR Failure File Contains:20100409_121403_000001929023_XXXXX_ConsumerHours.xml

    FOR Success File Contains:091023235952188_XXXXX_ConsumerHours.xml

    MY QUESTION:-

    Is there any restriction in keeping FIle name length for placing into the FTP Location. Even though I kept ConsumerHours.xml I donot know why it is not picking the File ?

    Nothig as such...

    K fine u try to give the filename as

    *.xml and try with it...

    Still prblm occurs do post..

    Babu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2010 at 03:30 AM

    Hi Amar,

    Are you able to see any error message in moni, if the structure doesnt match ,as you mentioned , there will be an error entry.

    Have you checked in channel ,mode is kept as delete or test?

    If you dont see any related entry in moni,Please check the channel configuration once again, in filename have you tried

    • ConsumerHours.xml * or *ConsumerHours.xml. try with the later if not tried yet.

    If you have access to place files in server, you can use xml validation at adapter engine feature in PI 7.1,

    /people/shilpa.kchakravarthy/blog/2008/01/17/xml-validation

    please see if it applies in your case using AAE.

    Regards,

    srinivas

    Edited by: Srinivas on Apr 11, 2010 9:05 AM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      No we tried all options I mean all permutaitons without changing all the 3 above mentioned things I am not able to process the file.

      a) ANother thing I can place *.xml because ConsumerHours is the only file I need to pick

      b) Also there is no need of using XML validation here nothing as much?

      c) Message would not be comes in SXMB_MONI as I am using Integrated Configuration nothing but Advance Adapter Engine

      Hence even in Message Monitoring __RWB also not able to view since files are not picking how can I able to see error log?

      Kindly reply back with the root cause "HOW Validation Takes place before coming into PI" Is it not acccepts if u send mismaatching structure or otherwise an XML with one single wrong tag?

      Also Is there any Fix length of characters are there in maintaining the file naming Convention to be pick from sender File Adapter?

      Thanks

      Amar Srinivas

  • avatar image
    Former Member
    Apr 12, 2010 at 11:49 AM

    I suggest to switch off Advanced Adapter engine for find the reason for this problem. Make a normal file adapter configuration, and monitor the communication channel in RWB. The content in the file then should not have an implication on the picking up of the file.

    Maybe play with filesnames a bit (e.g. try your old working file with your new filename from the file which does not work)

    CSY

    Add comment
    10|10000 characters needed characters exceeded