35GB File Help

I have this audit file that cannot be selected, counted, or cleared. I am running Universe 12.1 in Windows 2016. Generally, this audit file gets purged daily using date criteria of 90 days back, however, I just noticed the select never comes back. I was able to kill the indexes and was hoping that was the problem, but that was not the case. I should point out that I can add more data to the file with writes but not much else.

Besides creating a new file and renaming this one, has anyone seen something like this?

Posted 08-27-2022 11:43

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

Have you ran a guide on the file?  Sounds like corrupt pointers.

------------------------------
David Green
Computer Programmer
Rocket Forum Shared Account
------------------------------

Have you ran a guide on the file?  Sounds like corrupt pointers.

------------------------------
David Green
Computer Programmer
Rocket Forum Shared Account
------------------------------

The guide command is for Unidata not Universe.

Posted: 09-09-2022 12:55

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

I have this audit file that cannot be selected, counted, or cleared. I am running Universe 12.1 in Windows 2016. Generally, this audit file gets purged daily using date criteria of 90 days back, however, I just noticed the select never comes back. I was able to kill the indexes and was hoping that was the problem, but that was not the case. I should point out that I can add more data to the file with writes but not much else.

Besides creating a new file and renaming this one, has anyone seen something like this?

Posted 08-27-2022 11:43

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

Is the SELECT doing any sorting or just the selection criteria based on the date?
Just wondering if the UVTEMP space might be having a problem.
So the SELECT just never finishes but there are no obvious error messages?

------------------------------
Neil Morris
Universe Advanced Technical Support
Rocket Software
------------------------------

Is the SELECT doing any sorting or just the selection criteria based on the date?
Just wondering if the UVTEMP space might be having a problem.
So the SELECT just never finishes but there are no obvious error messages?

------------------------------
Neil Morris
Universe Advanced Technical Support
Rocket Software
------------------------------

Sounds like you are getting some good advice. I am on UniData, but I would do is a quick ISTAT filename and see what that looks like and then run guide against the file. It could be on extreme Overflow, also when attempting Selects and such monitor the temp space file it creates and see how large that gets and if it fails.
Good luck.

Sent from my iPhone

On Sep 9, 2022, at 3:32 PM, Neil Morris via Rocket Forum wrote:


CAUTION: External Sender
________________________________
Is the SELECT doing any sorting or just the selection criteria based on the date? Just wondering if the UVTEMP space might be having a problem. So... -posted to the "Rocket U2 | UniVerse & UniData" forum
Invite your colleagues to join the Rocket Forum and grow our expert network.
________________________________
[Rocket Software]
Rocket U2 | UniVerse & UniData
Post New Message Online
Invite your colleagues to join the Rocket Forum and grow our expert network. Share this link.
Re: 35GB File Help
Reply to Group Online Reply to Group
[Neil Morris]
Sep 9, 2022 3:33 PM
Neil Morris
Is the SELECT doing any sorting or just the selection criteria based on the date?
Just wondering if the UVTEMP space might be having a problem.
So the SELECT just never finishes but there are no obvious error messages?

------------------------------
Neil Morris
Universe Advanced Technical Support
Rocket Software
------------------------------

Is the SELECT doing any sorting or just the selection criteria based on the date?
Just wondering if the UVTEMP space might be having a problem.
So the SELECT just never finishes but there are no obvious error messages?

------------------------------
Neil Morris
Universe Advanced Technical Support
Rocket Software
------------------------------

1. SELECT XLr8Audit was the statement
2. UVTEMP is empty
3. The selection never finished after 24 hours with no messages

Posted: 09/10/2022 7:59

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

Sounds like you are getting some good advice. I am on UniData, but I would do is a quick ISTAT filename and see what that looks like and then run guide against the file. It could be on extreme Overflow, also when attempting Selects and such monitor the temp space file it creates and see how large that gets and if it fails.
Good luck.

Sent from my iPhone

On Sep 9, 2022, at 3:32 PM, Neil Morris via Rocket Forum wrote:


CAUTION: External Sender
________________________________
Is the SELECT doing any sorting or just the selection criteria based on the date? Just wondering if the UVTEMP space might be having a problem. So... -posted to the "Rocket U2 | UniVerse & UniData" forum
Invite your colleagues to join the Rocket Forum and grow our expert network.
________________________________
[Rocket Software]
Rocket U2 | UniVerse & UniData
Post New Message Online
Invite your colleagues to join the Rocket Forum and grow our expert network. Share this link.
Re: 35GB File Help
Reply to Group Online Reply to Group
[Neil Morris]
Sep 9, 2022 3:33 PM
Neil Morris
Is the SELECT doing any sorting or just the selection criteria based on the date?
Just wondering if the UVTEMP space might be having a problem.
So the SELECT just never finishes but there are no obvious error messages?

------------------------------
Neil Morris
Universe Advanced Technical Support
Rocket Software
------------------------------

Again this is not Unidata. GROUP.STAT never returns any values. The overflow is about 25GB.

Posted: 09/10/2022 8:01

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

The guide command is for Unidata not Universe.

Posted: 09-09-2022 12:55

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

For Universe the command should be fixtool

You could also try just using a BASIC select and stepping through the items counting them and displaying item ids until it breaks
That might take a week though....

------------------------------
Will Johnson
Systems Analyst
Rocket Forum Shared Account
------------------------------

For Universe the command should be fixtool

You could also try just using a BASIC select and stepping through the items counting them and displaying item ids until it breaks
That might take a week though....

------------------------------
Will Johnson
Systems Analyst
Rocket Forum Shared Account
------------------------------

I forgot about fixtool.  I ran it and after 4 hours it fixed the file.
Thanks Will:

C:\\U2\\Accounts\\U2logic>c:\\u2\\uv\\bin\\fixtool -file DOUG99 -fix
Filename: DOUG99

Start Diagnostics.
0 Errors found in physical structure.
1 Errors found in file header.
U_am_access_get_fd() : information : calling MFopen() on mf_data, afid=2957.
0 Errors found in diag_file_header.
Second scan group 29642 out of 29642.
0 Errors found in groups.
0 Errors found in miscellaneous chains.

845815 records processed.

1 Errors on file.

Posted: 09-13-2022 16:52

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

I have this audit file that cannot be selected, counted, or cleared. I am running Universe 12.1 in Windows 2016. Generally, this audit file gets purged daily using date criteria of 90 days back, however, I just noticed the select never comes back. I was able to kill the indexes and was hoping that was the problem, but that was not the case. I should point out that I can add more data to the file with writes but not much else.

Besides creating a new file and renaming this one, has anyone seen something like this?

Posted 08-27-2022 11:43

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

hi,

seems file is corrupted , I suggest 
1/ create a new file  

CREATE.FILE NEW DYNAMIC ​

then swap NEW to OLD  

CNAME OLD TO OLD.BAD 
CNAME NEW TO OLD 
​

copy old 'good' items via basic without 'UNIQUERY SELECT' 

OPEN "OLD.BAD" TO OLD ELSE STOP 201,'OLD' 
OPEN "OLD" TO NEW ELSE STOP 201,"NEW" 
SELECT OLD  ;* set the select ptr to first group/record but do not load select list in mem
X = 0 
LOOP WHILE READNEXT K DO 
    X+=1 ; IF MOD(X,10000) ELSE CRT X 
    READ R FROM OLD,K ELSE CONTINUE 
    IF R<date> > dateref THEN WRITE R ON NEW,K
REPEAT    ​

I hope this help 

manu

------------------------------
manu fernandes
------------------------------

I have this audit file that cannot be selected, counted, or cleared. I am running Universe 12.1 in Windows 2016. Generally, this audit file gets purged daily using date criteria of 90 days back, however, I just noticed the select never comes back. I was able to kill the indexes and was hoping that was the problem, but that was not the case. I should point out that I can add more data to the file with writes but not much else.

Besides creating a new file and renaming this one, has anyone seen something like this?

Posted 08-27-2022 11:43

------------------------------
Doug Averch
Owner
U2 Logic
------------------------------

Doug:
Please consider _ reversing the orientation of your photo.   When I write code _ the letters and numbers go from left to right.   This group is not a historical society.   I like to think that we are looking forward.  Of course _ [1] the Rocket logo points from left to right.  [2] I hope that the photo flip will result in increased sales there.
--Bill

PS. As a high-school kid I had a TI calculator _ not the HP ones having reverse polish notation.

------------------------------
Bill Brutzman
IT Manager
Hk Metalcraft Manufacturing Corporation
Lodi NJ US
------------------------------