Thread: Upgrading SC 6.2 to SM 7.01

Attention SC users:

Has anyone out there upgraded from SC 6.2 to SM 7.01? We are pushed to Oracle and getting lots of errors when we run the upgrade. This upgrade utility is changing the LONG RAW fields to VARRAW(0) fields.

Help!

Here is the solution to our issue - we moved from Oracle 9i to Oracle 10 as part of the upgrade. Oracle 10 no longer supports LONG RAW datatypes. All LONG RAW datatypes have to be changed to BLOB's or CLOB's. We made these db changes against our SC 6.2 database before running the SM 7 upgrade utility and we no longer have this issue.

Another strange issue that we have run into with Oracle and the SM 7 upgrade utility is that when the upgrade utility adds new fields to the existing db tables, the new fields are added as upper case. All the old fields are lower case. When we try to query the data using sql*plus, we get the "invalid identifier" error message. We have to surround the lower case fields with double quotes to have a successful query.

Hi Debbie,

thanks very much for this very valuable posting!

Greetings,

Lars