PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/26/2006 3:19 PM by  Greg Moeller
apcinvoice
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
mil0n023
Veteran Member
(137 points)
Veteran Member
Posts:63


Send Message:

--
09/26/2006 3:00 PM
    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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    09/26/2006 3:19 PM
    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" ??
    You are not authorized to post a reply.