GFE in Group 0 of SYSPROCS table (OpenInsight 32-bit Specific)
At 31 MAR 2004 07:58:43PM Andrew M Matthews wrote:
Hi All,
Has anyone experienced a GFE in Group 0 of the SYSPROCS table? This error is stopping Stored Procedures from going across to a client in updates, and so is a big problem.
Being the SYSPROCS table, there is no actual table definition, and so we cannot even find out what the filename is for the table. If anyone knows what REV file the SYSPROCS table is in, we could at least try to delete the file and replace it with a working copy from the development system.
Any help on this matter would be greatly appreciated.
Thanks,
Andrew Matthews
iTMS Software Pty Ltd
At 01 APR 2004 01:56AM The Sprezzatura Group wrote:
REV30012 according to database manager on our system. It might be worth looking at the Frame 0 to determine the nature of the GFE but for fixing purposes as you say copying in the correct file should work. You can also establish the filename using run list_volume "REVBOOT" in the exec line of the system editor.
The Sprezzatura Group
World Leaders in all things RevSoft
At 05 MAY 2004 01:14AM Prashant Mittal wrote:
Is there any way we can fix the error on the sysprocs table i.e. Rev30012. Didn't fix it thru Arev or database manager.
It just doesn't want to do it!!!!!!!!!!!!!!
In the end had to copy it back frm a backup.
Thanks
Prashant
CSOFT Information Systems
At 05 MAY 2004 02:17AM The Sprezzatura Group wrote:
Well you could write a program or use dump in AREV to take the frame apart by hand and reassemble but it is not straightforward.
The Sprezzatura Group
World Leaders in all things RevSoft