XE to 9.1 Upgrade issue - table changes & conversions

List,

This is also posted on the developers' forum.

We are currently converting XE to 9.1

This includes base table layout changes, such as F4104 which has columns and indexes added after XE.


We tried to generate indexes on F4104, it failed,
due to IVCIRV not being found in TESTDTA/F4104.

Looking at table design, we see no errors, but the generate index wouldn't work.

I resorted to
Copying F4104 (data) to a saved file (using AS400 CPYF)
Removing the table from the database (table operations)
Generating the table (table ops)
Generating the indices (table ops)
Copying the SAVED 4104 data into the new generated table.

Looking at the KG, it seems that I should NOT have to do this, as there are Table Conversions that should address
altered tables.

The TC specific to F4104 isn't stated on the pages I've looked at.

Here's my question:
What table conversion jobs should CNC have run to create/populate the modified tables?

This issue is NOT limited to F4104.

Please AND Thanks!

--------------------
Frosty

Frosty,

I'm not a true CNC, but I do cover a lot of CNC tasks.

We are very near the sharp end of our upgrade (E811sp1 TR8.9.7.2 to E910 TR9.1.2) - go live this weekend.

With regard to altering the tables, our upgrade partner CNC consultant provided our DBA with a series of scripts (presumably run on unix or windows command line using Oracle SQL Plus - we use an Oracle database) that performs all the table structure and index changes.

Frosty,

This is an upgrade from over 4 releases ago. This is the kind of thing that full-time pro CNC people charge many man-days for. If you are trying to essentially do a copy/paste of the data, you are likely to have problems. This is not the kind of thing that can be fixed via JDELIST. And, if you have 1 bad table conversion, most likely there are many others.

There is a UBE R9698711 you can run to verify that your db structures are in line with specs. I would recommend you run that before you go much further. Your CNC guy should have run this after the database was fully converted.

[ QUOTE ]

What table conversion jobs should CNC have run to create/populate the modified tables?


[/ QUOTE ]

There are a bunch of Table Conversions. If you create an Upgrade Plan in the JDEPlan environment on your deployment server, moving from Xe to 9.1 should provide a list of ~722 table conversions for each environment to convert. I'm attaching an example list here so you can see the scope of what table conversions are needed. Each converted environment will need to have the same list - and if you notice, there is a specific conversion sequence. The F4104 is touched at sequence #555.

The issue is that some of these take INORDINATE amounts of time based on the data you have. Getting this list is easy. Ensuring your upgrade is smooth and that all the tables are perfectly converted takes a consultant many man-hours to complete. The fastest successful upgrade I ever undertook from Xe to 8.12 took 3 months. I've been involved in upgrades that took as long as 3 years with dozens of CNC specialists, data conversion specialists and hundreds of developers. It all depends on the size of implementation and the scope of the upgrade.