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.
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.