This discussion is archived
6 Replies Latest reply: Dec 19, 2012 7:24 AM by JeffJon RSS

FDQM import error

SBR Newbie
Currently Being Moderated
Hi,
i'm using FDQM 11.1.1.3, here i'm not able to import trial balance file,its throwing error like "an error occured importing this file invalid procedure call or argument"

please help me out



Satyajeet
  • 1. Re: FDQM import error
    JeffJon Guru
    Currently Being Moderated
    Please attach a copy of the user error log:

    a) Choose Tools > Clear Error Log
    b) Re-run the import to reproduce the error
    c) Choose Tools > View Error Log

    Attach the log.
  • 2. Re: FDQM import error
    user10757003 Journeyer
    Currently Being Moderated
    Is the delimiter in the file the same as defined against the import group?
  • 3. Re: FDQM import error
    SBR Newbie
    Currently Being Moderated
    hi,
    thanks for your reply
    i found following log entries

    2012-12-18-10:46:18

    User ID...........     admin
    Location..........     TEXAS
    Source File.......     C:\Hyperion\products\FinancialDataQuality\FDQMAPP\TrainFDM\Inbox\TEXAS\Texas_GL.glo

    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: [2012-12-18-10:46:18]

    [File Parse Error Begin]
         Message:      (5) - Invalid procedure call or argument
    [File Parse Error End]




    Satyajeet
  • 4. Re: FDQM import error
    SBR Newbie
    Currently Being Moderated
    yeah its correctly defined



    satyajeet
  • 5. Re: FDQM import error
    user10757003 Journeyer
    Currently Being Moderated
    As it seems to fail on the first record does the number of fields in the record match the number of fields in the import format? (assuming it is delimited file.) As requested earlier, a the full detail of the error might be helpful.
  • 6. Re: FDQM import error
    JeffJon Guru
    Currently Being Moderated
    We need to see the user error log as well, all that was attached was the import log.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points