2 Replies Latest reply on Jul 12, 2013 4:04 PM by JeffJon

    FDM import error

    7b23d2fa-fd14-4bd8-8c8b-5247b98546d8

      am loading a bulk insert in fdm and getting this error:

      Processing Codes:

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

      1. BLANK............. Line is blank or empty.
      2. ESD............... Excluded String Detected, SKIP Field value was found.
      3. NN................ Non-Numeric, Amount field contains non numeric characters.
      4. RFM............... Required Field Missing.
      5. TC................ Type Conversion, Amount field could be converted to a number.
      6. ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.

       

      Create Output File Start: [2013-07-11-13:53:49]

       

      [TC] - [Amount=NN]        HH          CONCUR STANDARD EXPORT WITH HDR           EXPORTID:02013061620130617USCAAV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           

      [TC] - [Amount=NN]        TT          RECORD COUNT: 000000618          TOTAL AMT: 0000000000083772.2400          TOTAL ABS AMT: 0000000000087672.2400          SUM OF CREDITS:0000000000001950.0000          SUM OF DEBITS:0000000000085722.2400                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           

      [Blank] -       

       

      Excluded Record Count..............2

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

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

      Total Records Bypassed.............3

      Valid Records......................618

      Total Records Processed............621

       

      Begin Oracle (SQL-Loader) Process (618): [2013-07-11-13:53:49]

       

      Oracle (SQL-Loader) Log File Contents:

       

       

      SQL*Loader: Release 11.2.0.1.0 - Production on Thu Jul 11 13:53:50 2013

       

      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

       

      Control File:   C:\DOCUME~1\fdmadmin\LOCALS~1\Temp\tW502216176079404941.ctl

      Data File:      C:\DOCUME~1\fdmadmin\LOCALS~1\Temp\tW502216176079404941.tmp

        Bad File:     C:\DOCUME~1\fdmadmin\LOCALS~1\Temp\tW502216176079404941.bad

        Discard File:  none specified

       

      (Allow all discards)

       

      Number to load: ALL

      Number to skip: 0

      Errors allowed: 50

      Continuation:    none specified

      Path used:      Direct

       

      Load is UNRECOVERABLE; invalidation redo is produced.

       

      Table TW502216176079404941, loaded from every logical record.

      Insert option in effect for this table: APPEND

      TRAILING NULLCOLS option in effect

       

         Column Name                  Position   Len  Term Encl Datatype

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

      DATAKEY                                                   SEQUENCE (1, 1)

      PARTITIONKEY                        FIRST     *           CHARACTER           

          Terminator string : '~|'

      CATKEY                               NEXT     *           CHARACTER           

          Terminator string : '~|'

      PERIODKEY                            NEXT     *           DATE YYYYMMDD       

          Terminator string : '~|'

      DATAVIEW                             NEXT     *           CHARACTER           

          Terminator string : '~|'

      ACCOUNT                              NEXT     *           CHARACTER           

          Terminator string : '~|'

      ENTITY                               NEXT     *           CHARACTER           

          Terminator string : '~|'

      ICP                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD1                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD2                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD3                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD4                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD5                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD6                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD7                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD8                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD9                                  NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD10                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD11                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD12                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD13                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD14                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD15                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD16                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD17                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD18                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD19                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      UD20                                 NEXT     *           CHARACTER           

          Terminator string : '~|'

      DESC1                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      DESC2                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR1                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR2                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR3                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR4                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR5                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR6                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR7                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR8                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR9                                NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR10                               NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR11                               NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR12                               NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR13                               NEXT     *           CHARACTER           

          Terminator string : '~|'

      ATTR14                               NEXT     *           CHARACTER           

          Terminator string : '~|'

      MEMOKEY                              NEXT     *           CHARACTER           

          Terminator string : '~|'

      AMOUNT                               NEXT     *           CHARACTER           

          Terminator string : '~|'

      CALCACCTTYPE                                              CONSTANT

          Value is '9'

      CHANGESIGN                                                CONSTANT

          Value is '0'

      AMOUNTX                                                   CONSTANT

          Value is '0'

      ACCOUNTR                                                  CONSTANT

          Value is '0'

      ACCOUNTF                                                  CONSTANT

          Value is '0'

      ENTITYR                                                   CONSTANT

          Value is '0'

      ENTITYF                                                   CONSTANT

          Value is '0'

      ICPR                                                      CONSTANT

          Value is '0'

      ICPF                                                      CONSTANT

          Value is '0'

      UD1R                                                      CONSTANT

          Value is '0'

      UD1F                                                      CONSTANT

          Value is '0'

      UD2R                                                      CONSTANT

          Value is '0'

      UD2F                                                      CONSTANT

          Value is '0'

      UD3R                                                      CONSTANT

          Value is '0'

      UD3F                                                      CONSTANT

          Value is '0'

      UD4R                                                      CONSTANT

          Value is '0'

      UD4F                                                      CONSTANT

          Value is '0'

      UD5R                                                      CONSTANT

          Value is '0'

      UD5F                                                      CONSTANT

          Value is '0'

      UD6R                                                      CONSTANT

          Value is '0'

      UD6F                                                      CONSTANT

          Value is '0'

      UD7R                                                      CONSTANT

          Value is '0'

      UD7F                                                      CONSTANT

          Value is '0'

      UD8R                                                      CONSTANT

          Value is '0'

      UD8F                                                      CONSTANT

          Value is '0'

      UD9R                                                      CONSTANT

          Value is '0'

      UD9F                                                      CONSTANT

          Value is '0'

      UD10R                                                     CONSTANT

          Value is '0'

      UD10F                                                     CONSTANT

          Value is '0'

      UD11R                                                     CONSTANT

          Value is '0'

      UD11F                                                     CONSTANT

          Value is '0'

      UD12R                                                     CONSTANT

          Value is '0'

      UD12F                                                     CONSTANT

          Value is '0'

      UD13R                                                     CONSTANT

          Value is '0'

      UD13F                                                     CONSTANT

          Value is '0'

      UD14R                                                     CONSTANT

          Value is '0'

      UD14F                                                     CONSTANT

          Value is '0'

      UD15R                                                     CONSTANT

          Value is '0'

      UD15F                                                     CONSTANT

          Value is '0'

      UD16R                                                     CONSTANT

          Value is '0'

      UD16F                                                     CONSTANT

          Value is '0'

      UD17R                                                     CONSTANT

          Value is '0'

      UD17F                                                     CONSTANT

          Value is '0'

      UD18R                                                     CONSTANT

          Value is '0'

      UD18F                                                     CONSTANT

          Value is '0'

      UD19R                                                     CONSTANT

          Value is '0'

      UD19F                                                     CONSTANT

          Value is '0'

      UD20R                                                     CONSTANT

          Value is '0'

      UD20F                                                     CONSTANT

          Value is '0'

      ARCHIVEID                                                 CONSTANT

          Value is '9574'

      HASMEMOITEM                                               CONSTANT

          Value is '0'

      STATICDATAKEY                                             CONSTANT

          Value is '0'

       

       

      Referential Integrity Constraint/Trigger Information:

      NULL, UNIQUE, and PRIMARY KEY constraints are unaffected.

       

      Trigger FDM_USER."TW502216176079404941_AK" was disabled before the load.

      FDM_USER."TW502216176079404941_AK" was re-enabled.

       

      Table TW502216176079404941:

        618 Rows successfully loaded.

        0 Rows not loaded due to data errors.

        0 Rows not loaded because all WHEN clauses were failed.

        0 Rows not loaded because all fields were null.

       

        Date cache:

         Max Size:      1000

         Entries :         1

         Hits    :       617

         Misses  :         0

       

      Bind array size not used in direct path.

      Column array  rows :    3000

      Stream buffer bytes:  256000

      Read   buffer bytes:18576000

       

      Total logical records skipped:          0

      Total logical records read:           618

      Total logical records rejected:         0

      Total logical records discarded:        0

      Total stream buffers loaded by SQL*Loader main thread:        1

      Total stream buffers loaded by SQL*Loader load thread:        1

       

      Run began on Thu Jul 11 13:53:50 2013

      Run ended on Thu Jul 11 13:53:51 2013

       

      Elapsed time was:     00:00:01.47

      CPU time was:         00:00:00.87

       

       

      Processing Complete... [2013-07-11-13:53:51]