Rocket U2 | UniVerse & UniData

 View Only
  • 1.  35GB File Help

    PARTNER
    Posted 20 days ago
    Edited by Chris Rizza 20 days ago
    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
    ------------------------------


  • 2.  RE: 35GB File Help

    Posted 20 days ago
    Have you ran a guide on the file?  Sounds like corrupt pointers.

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



  • 3.  RE: 35GB File Help

    PARTNER
    Posted 17 days ago
    Edited by Chris Rizza 17 days ago
    The guide command is for Unidata not Universe.

    Posted: 09-09-2022 12:55

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



  • 4.  RE: 35GB File Help

    Posted 16 days ago
    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
    ------------------------------



  • 5.  RE: 35GB File Help

    PARTNER
    Posted 15 days ago
    Edited by Chris Rizza 15 days ago
    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
    ------------------------------



  • 6.  RE: 35GB File Help

    ROCKETEER
    Posted 20 days ago
    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
    ------------------------------



  • 7.  RE: 35GB File Help

    Posted 20 days ago
    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


  • 8.  RE: 35GB File Help

    PARTNER
    Posted 17 days ago
    Edited by Chris Rizza 17 days ago
    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
    ------------------------------



  • 9.  RE: 35GB File Help

    PARTNER
    Posted 17 days ago
    Edited by Chris Rizza 17 days ago
    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
    ------------------------------



  • 10.  RE: 35GB File Help

    PARTNER
    Posted 16 days ago
    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
    ------------------------------