Problem with F4106 conversion...

As you've all probably noticed by now, we're upgrading from Xe to 9.0. In the last run of conversions, I had a problem with F4106 that I didn't have the first two times... it fails to move the F4106TCTEMP table to F4106, even though F4106 does get dropped. I've tried this three times now with the same result... here's what's in the log:

1655004/1 WRK:Starting jdeCallObject Thu Jan 13 15:02:20.531080 jdb_rq1.c7245
JDB9900267 - Failed to find requested column -- ICID in the table F4106

1655004/1 WRK:Starting jdeCallObject Thu Jan 13 15:02:20.539140 jdb_rq1.c759
JDB9900919 - Failed to find column

1655004/1 WRK:Starting jdeCallObject Thu Jan 13 15:02:20.539271 jdb_exem.c1656
JDB2100044 - Failed to set where index.

1655004/1 WRK:Starting jdeCallObject Thu Jan 13 15:02:20.540104 jdb_exem.c2058
JDB2100047 - Failed to drop index number 9 for table F4106

1655004/1 WRK:Starting jdeCallObject Thu Jan 13 15:02:20.540830 jdb_exem.c4481
JDB2100089 - Failed to drop old indexes for new table F4106

1655004/1 WRK:Starting jdeCallObject Thu Jan 13 15:02:20.540888 jdb_exem.c4046
JDB2100084 - Failed to rename table in same datasource

1655004/1 WRK:Starting jdeCallObject Thu Jan 13 15:02:20.541372 tcinit.c2352
TCE009126 - JDB_RenameTable failed for F4106.

Any ideas what's going on here? Without any Oracle errors I'm having a hard time figuring out what it might be.

Hi,

Verify no user overrides exists for P4106. This may be causing your issue.

Just a 'shot in the dark' but are you dropping the F4106TCTEMP table before rerunning? Have you checked the programmers guide to make sure there are no pre-req's? In my experience it's not unusual that the table will work one time and not the next. Doesn't happen a lot but I have seen it a few times. Did all the dependant on TC's (prior to this one) compete successfully? You might also want to restore the F4106 and indexes to the source library and try again?

Yeah, I'm dropping F4106TCTEMP, and according to the Programmer's Guide (and the sequence numbers), it depends just on R894072 and R894094, which both completed successfully. I've reloaded F4106 from the live copy each of the three times I've tried it.

[ QUOTE ]
Hi,

Verify no user overrides exists for P4106. This may be causing your issue.

[/ QUOTE ]

There are quite a few... how would this make a difference, though?

Scotti,

Can you try running the TC locally on the DS and if that’s what you did originally could you try the ES instead. When done can you check the TC log from the row exit and post same? Just for a test (if you can), clear the table and try the TC without any data.

Michael

Great idea... I tried it on the deployment server and it worked! I wish I knew why it failed on the enterprise server (especially since it worked in the previous round of conversions), but at least this way I have a workaround. Thanks!