Hi All

I thank my favourite higher power, I don't get these too often.

We got FS493 Group Format Error in ] Group 852 the group contains an invalid frame type.

The unfortunate thing about this is that the client is on the run time engine and I can't figure out how to get at the stuff for verify and fix gfe without booting all the users off for a while so I can change the oengine.exe to development. This is annoying for all concerned. They don't even have an official dev licence although they do have an unlimited run time licence. They do have a current all paid up NLM for Novell.

How are you supposed to fix these things on a client site if they are not "officially" licenced for development? What is the point of selling runtime alone if you have to use dev oengine to fix gfe's.

Or am I missing something in my self taught skill set.

Scott.

Hi all

I should know better than to try to fix a GFE, I should go directly to the restore from backup procedure. It is not acceptable for it to eat a record and not even tell me which one.

In my "advanced developers guide" there is a syntax for REMAKETABLE in the bit about redefining linear hash tables. It contradicts itself about the order of the path name and the table name in the example it gives over the page, and it doesn't actually work in either variation when I type it into system editor. I get an error something like "invalid parameter". The remake.txt example on the works site doesn't give me a clue about the parameter order either, it is different again.

Is this something that does work from SYSTEM Editor, if so, could someone please respond with the correct syntax for the following paramters.

Table name MYTABLE

path where MYTABLE lives T:\TEAM\DATA

number of rows 60000

avg row size 400

number of cols 60

Frame size 4096 (should I pick something bigger the LV file is about 12MB and the OV file is about 15MB)

Resize threshold 80%

What happens when a file that big goes into "automatic" resizing?

I only need to rebuild the data bit not the dict bit.

I can use AREV instead, but it seems a bit slow.

I am sure I will be bald before the week is out.

Scott

I wan't aware that remaketable was available in OI !!

In the given situation, I would create a MYTABLE_TEMP table to the required size - I would probably go to 8192 to allow a bit more flexibility for new data - copy the dictionary and data items to the new table, delete the original and rename MYTABLE_TEMP to MYTABLE.

Simon

Rebus Software

Scott ..

That's why I wouldn't dream of putting any kind of serious app into production on a Run Time only environment. Under the terms of the license, the only choice is to restore from a good backup. I always demand at least 1 development license in OI or a single-user Run Time AREV 3.12. Otherwise, SOL. You might be able to get around it by getting to System Editor as part of an RDK process but I don't think that you can get to the tools necessary to repair a GFE under a Run-Time license.

Don Miller

C3 Inc.

Revelation have indicated that they consider the act of installing a single user AREV runtime for this purpose a breach of license unless the AREV license existed on the site previously. However during RDK upgrades the installation becomes a dev copy so you could issue an upgrade which could be reapplied whenever the system GFEs and that fixes the GFEs.

The Sprezzatura Group

World Leaders in all things RevSoft

Sprezz ..

I'm sure you're right. But, where is it written that an OI Run-Time user can't purchase a license for a single-user AREV 3.1 run-time after the fact? I think that if that's true, there would be a serious possibility of litigation, but I'm not a lawyer.

Don Miller

C3 Inc.

This discussion normally takes place on the licensing forum and goes nowhere quickly.

And I apologise for trashing the thread links by posting mal-formed HTML earlier.

The Sprezzatura Group

World Leaders in all things RevSoft

Sprezz folks ..

Your right .. it goes nowhere fast. I'm a little befuddled since there's so much contradictory stuff anyway (including RTI).

As for the link .. WTFGAS .. figger that out.

Don Miller

C3 Inc.

Who the….

The Sprezzatura Group

World Leaders in all things RevSoft

Scott,

Shouldn't that be Remake_Table and not RemakeTable? Here is a Remake_Table utility for OpenInsight. With parameters docced. Might be different from the Arev command.

- Oystein -

Hi All

Ok Sprez, that made no sense. If I upgrade (which I can't do because it stops me from using stuff like copy table) then the runtime gets overwritten with a development copy? Bad. The Rev upgrades that I get can only be applied once and then I have to get a new disk. I can't even set up a test system to evaluate the impact of upgrading to 3.7 because I can only install the upgrade once. Were you talking about some other kind of upgrade? I don't use the standard (how it says in the manuals) system for application upgrades.

The site is licenced for AREV as well as OI.

So if we had a development licence and a run time licence would we still have to do

copy oengine.dev oengine.run

I'd like to avoid that step because I get sharing violations ie people who have crashed out of our applicaiton and not rebooted their pc's or shut them down leave a link to the oengine.exe even when they have logged out and gone home. I had to get a network tech to kick the novell system to make them let go.

Is there some way of finding out who has the file locked? Like a list users command?

Scott

Hi Oystein and Simon

The book says on page 17, REMAKETABLE not remake_table. and to run it from system editor and then gives two different (conflicting) parameter layouts. I have already looked at the utility. I have decided I like Simon's method better.

So usually its a command/feature that is not in the book but everyone uses, this looks like one that is in the book but is not in the OPENINSIGHT product, unless you set up the utility. The utility incidentally has a different set of parameters again from the two sets described in the OpenInsight Advanced Users Guide.

Scott

Sorry the RDK upgrade sets the development flag on.

If they're AREV licensed then by all means fix it in AREV, the AREV fix is more stable in any case.

The Sprezzatura Group

World Leaders in all things RevSoft

Scott,

Dug out my OI 2.0 ADG. Found the REMAKETABLE you're talking about. But the syntax is pure TCL. So it must be a chapter or paragraph taken from Arev docs and not translated into the OI realm.

But since you have got Arev too perhaps you can do it from Arev?

- Oystein -

PS. Bald yet? Or still some hair left? =

Hi Oystein

I don't know why I can be so simple sometimes but I figured out how to do things like verifys without overwriting the oengine stuff.

I set up a dev copy in a separate folder/dir. I start up dev oi but not the app. I attach the tables (using syseditor) in the actual live app folder (or wherever I choose to put them), and then I can run the verify. I can even create a table with the right size parameters (I'm in dev, I can set up a form and a button…), then I copy all the data from table1 to table2, then I make backup copies of everything then I rename table1's dos files in the app then I copy the dos files for table2 into the app folder and rename table2 DOS files to the original table1 dos file names.

Then I start the live app and rebuild the indexes - we built a tool for that. Hey presto - working file. Unfortunately the network drongo (loser idiot) has restored a file from a month ago instead of last weekend. I don't know why I bother sometimes. And I should be a chrome dome (bald) by now but I'm not. There is enough hair around my desk and on my chair and on the floor to thatch a lounge suite.

Scott.

Great, Scott! Good to hear it's working out.

- Oystein -

PS. Sorry for that awful pun and thanks for updating me on the latest terminology.

View this thread on the forum...