Oracle to AS/400 data migration file insert error

cncjunior1

Reputable Poster
Hi All,

I have an 8.12 installation running on NT and Oracle DB on NT. We are moving platforms to the AS/400. I am using R98403 to copy the databases over. Everything copies fine except for three tables: F060116, F060118 and F060119. I get an error in the log below similiar for all tables, excpet the column name might be off by one or two for each table. The column that if failes to insert on is the SDYY column. Not all the records fail to insert for these tables either. If anyone has any insight on the I would greatly appreciate it. Thanks. 8.96_F1

2548/3068 WRK:Starting jdeCallObject Mon Aug 06 11:08:27.031000 Jdbodbc.c8330
ODB0000163 - wSQLExecute failure. rc=-1

2548/3068 WRK:Starting jdeCallObject Mon Aug 06 11:08:27.031001 Jdbodbc.c8330
ODB0000164 - STMT:00 [22003][30160] [IBM][iSeries Access ODBC Driver]Column 53: Numeric value out of range.

2548/3068 WRK:Starting jdeCallObject Mon Aug 06 11:08:27.031002 Jdb_drvm.c982
JDB9900401 - Failed to execute db request

2548/3068 WRK:Starting jdeCallObject Mon Aug 06 11:08:27.031003 Jdb_exet.c5906
JDB3400009 - Failed to perform Insert for F060116

2548/3068 WRK:Starting jdeCallObject Mon Aug 06 11:08:27.031004 tcrun.c510
TCE009143 - Insert Row failed for table F060116.
 
Hi,

Have your checked before migrating by an SQL statment that there aren´t "null" values in any field of theese tables? We had a similar problems during a migration from our old version B7.3.2. to E8.11 SP1.

If your have "null" values, DB2/400 can´t make an "insert" into the table. DB2/400 is very sensitive with that.

Greetings.
 
We're running E1 on AS400 (DB2) and considering a move to Oracle platform. Can you share why you're moving to AS400 ? Especially if you have Oracle DB expertise why not goto AIX where you can have the stability (assuming the cause was Windows instability) and still use Oracled DB.
Appreciate your feedback.
Thanks,

Soyer.
 
The client initially went Oracle/NT because of cost reasons and had no in house Oracle expertise. They quickly realized that Oracle is not just an install and let it run type of database, and seeing how they already have AS/400 expertise in house, decided to migrate everything to run on the AS/400.
 
Back
Top