Forum Stats

  • 3,759,068 Users
  • 2,251,495 Discussions
  • 7,870,480 Comments

Discussions

"File not found" error while importing file in FDM Classic

Mikkis
Mikkis Member Posts: 221 Blue Ribbon
edited May 29, 2018 2:42PM in Financial Data Management

Hi,

I am facing an issue while importing in FDM. The error I am getting is below. Any idea what this could be?

ERROR:

Code............................................. 53

Description...................................... File not found

Procedure........................................ clsUtilities.fShellAndWait

Component........................................ upsWDataWindowDM

Version.......................................... 1112

Thread........................................... 20284

ERROR:

Code............................................. 53

Description...................................... File not found

Procedure........................................ clsImpDataPump.fImportTextFile

Component........................................ upsWObjectsDM

Version.......................................... 1112

Thread........................................... 20284

ERROR:

Code............................................. 53

Description...................................... File not found

Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile

Component........................................ upsWObjectsDM

Version.......................................... 1112

Thread........................................... 20284

Tagged:

Best Answer

  • 3134325
    3134325 Member Posts: 6
    edited Jan 8, 2016 5:33AM Accepted Answer

    Can you verify if the delimiter and column order specified in the Import Format matches with the one present in the data file (.txt).

    Looks like you are getting the [Blank] - error, and FDM is not able to read the data from the data file.


    Thanks

    Hem

Answers

  • Ankit13
    Ankit13 Member Posts: 25
    edited Jan 6, 2016 4:59PM

    Do you have an import or event script?


    Thanks

    Ankit

  • Mikkis
    Mikkis Member Posts: 221 Blue Ribbon
    edited Jan 6, 2016 8:58PM

    Hi

    Yes, we do have the import script. Those just do some simple parsing. I actually tried after removing the the import script. Still got the same error.

    We used to have event script but I removed them and not used anymore.

  • Ankit13
    Ankit13 Member Posts: 25
    edited Jan 7, 2016 12:20PM

    What's the target application that you are loading data to ? Also, can you check if the proper import format has been assigned to this location ?

  • Mikkis
    Mikkis Member Posts: 221 Blue Ribbon
    edited Jan 7, 2016 1:51PM

    Hi,

    Yes, I verified import format. Doesn't look like the issue. I tried without any script with just 1 line of sample file. Still the same issue.

    I was looking at the logs I see this error. Something on SQL side.

    egin Oracle (SQL-Loader) Process (13996): [2016-01-06 20:59:43]

    2016-01-06 20:59:34

    User ID........... admin

    Location.......... XXXXXX

    Source File....... D:\FDMData\FDM_DATA\Inbox\XXXXXX\2016-01-05_165144PM~XXXXXX~Actual~NOV-2015~RM.txt

    Processing Codes:

    ------------------------------------------------------------------------------------------------

    BLANK............. Line is blank or empty.

    ESD............... Excluded String Detected, SKIP Field value was found.

    NN................ Non-Numeric, Amount field contains non numeric characters.

    RFM............... Required Field Missing.

    TC................ Type Conversion, Amount field could be converted to a number.

    ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.

    Create Output File Start: [2016-01-06 20:59:35]

    [Blank] -

    Excluded Record Count..............0

    Blank Record Count.................1

    ------------------------------------------------------------------------------------------------

    Total Records Bypassed.............1

    Valid Records......................13996

    Total Records Processed............13997

    Begin Oracle (SQL-Loader) Process (13996): [2016-01-06 20:59:43]

    [RDMS Bulk Load Error Begin]

      Message:   (53) - File not found

      See Bulk Load File: C:\Users\hypsrvc\AppData\Local\Temp\tWadmin25248225927264.tmp

    [RDMS Bulk Load Error End]

  • 3134325
    3134325 Member Posts: 6
    edited Jan 8, 2016 5:33AM Accepted Answer

    Can you verify if the delimiter and column order specified in the Import Format matches with the one present in the data file (.txt).

    Looks like you are getting the [Blank] - error, and FDM is not able to read the data from the data file.


    Thanks

    Hem

  • Mikkis
    Mikkis Member Posts: 221 Blue Ribbon
    edited Jan 11, 2016 11:56AM

    Hi,

    Doesn't look like it is the issue. I created new .txt file with just one record. Still the issue.

    After that I did some other change, and the error is different now. Raised another thread now

This discussion has been closed.