About a week ago, I lost the use of GETLIST and SAVELIST. My client has Arev 3.0 on a Novell 3.12. For five years everything has worked fine, but now whenever a GETLIST or SAVELIST command is issued, nothing happens.

First, this only occurs on one account. In fact, I have another account and I can issue a GET or SAVELIST command on a file in the current account with no problems. I have also restored all known files associated with the GETLIST and SAVELIST commands, both on the REVBOOT, i.e. SYSOBJ, and the current ACCOUNT, i.e. LISTS. but to no avail.

I have temporarily converted my subroutines to write a list of key words to a LIST file and to retrieve (GET) the list by using FORMLIST. This is tedious, since I have several routines using the GET and SAVELIST commands. BTW, I have attempted to use the GETLIST_SUB and SAVELIST_SUB routines and they do not work – again only on one account.

There seems to be no reason for this to happen and I've ran out of ideas of what to look for in rectifying the problem. It is double difficult to understand since it is an issue only on one account.

Any suggestions would be deeply appreciated.

Regards,

Frank S. Adamo

[email protected]

What do you mean nothing happens at all? Does ARev just return to the TCL colon prompt without any sort of message?

Edit the VOC entries for GETLIST and SAVELIST and compare them with those in the account that works.

]What do you mean nothing happens at all? Does ARev just return to ]the TCL colon prompt without any sort of message?

Yep. No error messages, no nothing. Certainly not a message saying the number of records saved for SAVELIST.

]Edit the VOC entries for GETLIST and SAVELIST and compare them with ]those in the account that works.

I did that. I also restored the VOC file from a backup prior to the time that I had this problem.

As I think I mentioned, nothing makes sense. I've restored the VOC file, actually created a new LISTS file and of course the SYSOBJ file under REVBOOT, except this should not be the problem since other accounts work.

An added problem seems to have occurred. It seems that I can not sort. I can select a range of records but when I do a sort, I get no report. Everything is left blank, just as if I did a get or savelist.

Again, if I go to another account, I can process the search without any problems.

Regards,

Frank S. Adamo

[email protected]

Just some things to look at – probably unrelated.

* Check the sort path in your environment. Does it exist?

* Is there available disk space on the drive pointed to by your sort path?

* Have all users log off and then clear the SYSTEMP file.

* Clean up the LISTS file.

* What is your setting for number of saved queries. If it is not zero, can you restore an old list using CTRL-F10?

* Do you have shells around GETLIST and SAVELIST?

* Are the VOC entries set up correctly?

* Do the items pointed to by the VOC entries exist?

* Is your SYSMESSAGES file intact, e.g., S144?

* Do you have an MFS on your LISTS file?

Other than Victor's suggestions I would move all the application/data files to a separate directory or directories, back those up, delete the account and recreate it in SYSPROG. Just stabbing in the dark…

I'm getting confused. What can and can't you do? Sorry to make you post it all again, but you have to admit, this is a bit strange.

[email protected]

Sprezzatura Group

]]Other than Victor's suggestions I would move all the application/data files to a separate directory or directories, back those up, delete the account and recreate it in SYSPROG. Just stabbing in the dark…«

I plan to do this, but as a last resort. So far, I have been able to set up a routine to read all the keys during the listing and saving the keys to the LISTS file. I then use FORMLIST to get the list. This is quite tedious and only a bandage, but it does appear to work at this time.

]]I'm getting confused. What can and can't you do? Sorry to make you post it all again, but you have to admit, this is a bit strange.«

Plain and simple, GETLIST and SAVELIST is not functional, no response when I do either during TCL or within a program. Only on one account. Other accounts, the GET and SAVELISTs work fine, therefore, the problem is within this one account.

If you

EDIT SYSTABLES SYSOBJ

do you get this on the first four lines:

REVBOOT

SYSOBJ

GLOBAL

RTP57

If not, then maybe you are looking at a different SYSOBJ file for this account. I assume you have already checked the integrity of $V1, $V2, $SAVELIST_SUB, and $GETLIST_SUB by comparing to the records in other accounts (unless you have created duplicate/additional SYSOBJ files, you should be looking at the same actual objects in each account).

]]* Check the sort path in your environment. Does it exist?

* Is there available disk space on the drive pointed to by your sort path?

* Have all users log off and then clear the SYSTEMP file.

* Clean up the LISTS file.

* What is your setting for number of saved queries. If it is not zero, can you restore an old list using CTRL-F10?

* Do you have shells around GETLIST and SAVELIST?

* Are the VOC entries set up correctly?

* Do the items pointed to by the VOC entries exist?

* Is your SYSMESSAGES file intact, e.g., S144?

* Do you have an MFS on your LISTS file?«

Well, I had done all but two of your suggestions, however, when I tried to clear the SYSTEMP file, I could not. In fact, I could not list the SYSTEMP file nor could I even edit a record in that file.

So, I decided to restore the SYSTEMP file from a backup I had before I had this problem. That did it. Everything was back to normal. I simply forgot to check the SYSTEMP. I'm still not sure how or why the SYSTEMP file got corrupted (or whatever), but thanks for the suggestions.

Regards,

Frank

If the REVMEDIA reference to SYSTEMP and the REV#####.* files associated with them were extant, perhaps you had a file ownership issue. It would probably be a good idea as PM to check all your files at this point to make sure they have a valid owner. The only other thing I can think of besides a corrupted file that would cause your symptoms would be index-related. I will assume there was no indexing on this file.

Arev 3.12 seems to embed directory mapping in odd places. I'm not familiar with the internals of 3.x but one time I copied a network system on to a local drive to do some file conversion tests. I changed every setting I could find for attaches, programs, environment settings etc, and it would still attach network volumes. Deleting the account and recreating it solved it. I'm sure there is some setting I missed but again my unfamiliarity with 3.x made me miss it.

So, as you said, leave it for a last resort.

View this thread on the forum...