, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

Copytable and Universal Driver 3 (OpenInsight 32-Bit)

At 11 MAR 2004 03:24:55PM Enrique Murphy wrote:

We had experienced a problem when upgrading tables from the All Networks 2.1 to 3.0.0.X. We did the following:

1. Verified every table of the 2.1 volumes in the database. Everything was fine.

2. Copied every table in the database that was in 2.1 to a new (empty) folder using the copy_table subroutine programmaticaly, with the UD 3.0.0.1 driver selected in OI.

3. We verified all the tables again, but many of them (20 out of 100) were with GFE. The error was "Primary Header is corrupt" and the Fix utilities didn't work.

4. Aliased every table in the original folders (in 2.1).

5. Created (programmatically, with Create_Table) every table again in empty folders.

6. Copied all the records of the DICT and DATA portions of every table to the newly created tables.

7. Verified again. This time everything was fine. 

Is there something wrong in our method of upgrading the driver of the volumes?
Is there any issue with the COPY_TABLE subroutine when copying across drivers?
Is there any other way of upgrading from 2.x to 3 drivers?
Enrique

At 12 MAR 2004 08:05AM KevinRevelation Software wrote:

Enrique,

One of the problems we found with the UD 3.0.0.1 was just was you are experiencing. This should be fixed by going to the latest version of the UD, 3.0.0.2.

Please drop me an email ([email protected]) and I'll be sure to get the latest UD to you.

Kevin

At 12 MAR 2004 01:55PM Enrique Murphy wrote:

Kevin: 

We did the same procedure with UD 3.0.0.2, and the Copy_Table created GFE with that driver, too.
The only procedure that worked OK was using the Copy_Row to copy DICT and DATA records from the 2.1 tables to tables created using the UD 3.

View this thread on the Works forum...