How do you correct group format errors in the SYSREPOS table?

Thanks

Rick

Rick,

How do you correct group format errors in the SYSREPOS table?

Very carefully.

Actually, it is not recommended that GPF's be fixed in system tables, especially SYSREPOS. In fact, SYSREPOS can't be directly fixed anyway because (I believe) of the BFS upon it. If restoring the table is not an option then you can do this:

1. Backup the SYSREPOS files (REVREPOS.*) first.

2. Install a new copy of OpenInsight so you can get clean versions of the SYSREPOS files to use.

3. Copy the clean SYSREPOS files into your original OI folder.

4. Create a temporary folder with a temp table in it.

5. Copy your REVREPOS.* files into this folder and rename them to the name of the temp files.

6. Attach this temporary folder and temp table. You should now be able to see your original REVREPOS table under the temp table's name.

7. Copy as many records from the temp table into your clean SYSREPOS. You can do this via the COPY_ROW command or using code.

8. If you are unable to copy rows because of the GFE then you can attempt to fix the GFEs in this temp table.

9. Once the GFEs have been fixed then copy the remaining records to SYSREPOS.

10. If you know what REVREPOS records were corrupted by the GFEs then add those back in manually. Otherwise, you will know when a REVREPOS record is missing when you are unable to bring up an entity (e.g. the Form Designer won't load a window.)

Hope that helps,

[email protected]

SRP Computer Solutions, Inc.

Great job Don. I hope I won't ever need this, but I will file it away somewhere.

Ray

Ray,

No problem. BTW, to all, we highly recommend using the REVIMAGE.EXE program so that the repository is continually backed-up.

[email protected]

SRP Computer Solutions, Inc.

View this thread on the Works forum...