apcinvoice

 1 Replies
 0 Subscribed to this topic
 11 Subscribed to this forum
Sort:
Author
Messages
mil0n023
Veteran Member
Posts: 63
Veteran Member
    I get this error when doing 'importdb' with the csv file. The field it is referencing as "too large" is blank??? Error:


    tsStoreDBRec error is Database error (94).
    Additional information is 1843.
    Additional Text is:
    StoreSqlRec(LAWSON.APCINVOICE)
    OCIStmtExecute() returned OCI_ERROR code 1843 parse offset 88997888 (
    ORA-01843: not a valid month
    )
    Error at line 2, Field 65: is too large for field
    size of 25

    2 Record(s) Processed

    0 Record(s) Added
    0 Record(s) Modified
    2 Record(s) Skipped
    0 Record(s) the Same
    M. C. Miller
    Analyst
    Salem, Oregon
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
      Is the error really "Field too large"? or could it possibly be that somewhere else in the file you are missing (or have misconfigured) the first error that Oracle mentions of "Not a valid month" ??