Title: Importdb 2
Mil0n023 - September 26, 2006 08:00 PM (GMT)
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
Hmm? I can't figure this out.. the csv field is blank???
trezaei - September 26, 2006 09:56 PM (GMT)
| QUOTE |
ORA-01843: not a valid month
)
Error at line 2, Field 65: is too large for field
size of 25
|
That is kinda weird. It looks like two errors really. ORA-01843: not a valid month
)
and
Error at line 2, Field 65: is too large for field
size of 25
But I am sure it's not. anyway, are you sure you're looking at the right field number (65)?
Do you have a header?
Did you use the Date correction flag? That's is the one that always mucks up my game.
If all else fails paste your records in here sans the sensitive data and we'll see.
T
Milo - September 27, 2006 04:32 PM (GMT)
Trouble in importing via Impordb -- when you get an error in the first field, everything gets screwed up on the following fields. If I were you, I'd concentrate on the Month error. That other error will probably go away after you fix the problem with the first field's data.
schroncd - September 27, 2006 10:40 PM (GMT)
ALWAYS fix the first error then test again. 95% of the time you're done.
newnumber6 - October 14, 2006 05:17 PM (GMT)
If your date is formatted correctly, use the "do not reformat date" option as part of your importdb load - I've seen that happens where it tries to reformat for you, and you have to tell it to not do that.
Milo - October 16, 2006 02:26 PM (GMT)
" d - Do NOT reformat dates (Files in db format) "
That would be, >importdb -d DataArea/DataID FileName FlatFile