[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1_v30

Title:*OLD* ALL-IN-1 (tm) Support Conference
Notice:Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:IOSG::PYE
Created:Thu Jan 30 1992
Last Modified:Tue Jan 23 1996
Last Successful Update:Fri Jun 06 1997
Number of topics:4343
Total number of notes:18308

2621.0. "Delete account and orphan drawers, how to recover" by TINNIE::SETHI (Ah (-: an upside down smile from Oz) Wed Apr 28 1993 07:43

    Hi All,
                                 
    A customer has ALL-IN-1 IOS version 3.0 installed and has two problems. 
    The first one being, Account Deletion:
    
    An account with shared drawers was deleted and "N" was entered in the
    shared drawer field.  The customer did a SM MSY SSP and selected an
    ALL-IN-1 user for the "Holding account for orphan drawers", so far so
    good.
    
    The account got deleted as expected BUT the drawer was not copied to
    the nominated user.  In the logfile the following messages were
    displayed:
    
    Shared drawer [ANDREW COLIN]COPORATE
    - moved to ALL-IN-1 holding account TURNER STEPHEN
    
    Shared drawer [ANDREW COLIN]MAIN
    - moved to ALL-IN-1 holding account TURNER STEPHEN
    
    The customer logged onto STEPHEN TURNER's account and the drawers were
    copied BUT no files ie WPL's an empty DOCDB and DAF were present.  The
    customer assures me that the drawers were not empty.  Also she was
    supprised that MAIN got copied and it was not a shared drawer.
    
    I have ALL-IN-1 IOS 3.0-1 installed and cannot reproduce the problem,
    can someone with 3.0 installed test this for me please, it could be a 
    bug.
    
    Problem two is the restoration of the drawer, this is what I have asked
    the customer to do:
    
    1. create temp. account
    2. restore account from backup to temp account
    3. re-seed the account using OA$LIB:OAFC$SEED_USER by setting up the
       symbols #OAFC_SEED_USER and #OAFC_PROF_KEY.  This fails because
       "GET PART$MAINT:#PARTITION.%CLOSE[#PARTITION]" symbol not found
       error message is displayed
    4. For the moment forget about the error in 3., what I wanted the
       customer to do next was to find the directory spec (FUILLDB)for the 
       drawer and backup the drawer to STEPHEN TURNER's account.
    5. Check for read and sent messages.
    6. Change the Department field in profile to something obsecure such as
       "Minister of funny walks" for STEPHEN TURNER's account. If there are
       mail messages.
    7. Run the TRU housekeeping procedure for the "Minister of funny walks"
       department.  This would report any missing RMS files in the shared
       area and update the mail usage count for other shared documents.
    
    For this problem can someone tell me what do I do to re-seed the
    drawer ?  Is there a better way of recovering the drawer ? I *WISH* that a 
    restoration could be written for a PFR, this is my way of asking this to 
    be put on the *WISH LIST* :-).  
    
    Thanks for your help,
    
    Sunil
    
T.RTitleUserPersonal
Name
DateLines
2621.1It's solved with alot of luck, give us RESTORETINNIE::SETHIAh (-: an upside down smile from OzThu Apr 29 1993 06:4534
    G'day,
    
    I have managed to solve this problem with thanks to a bit of luck.  The
    customer told me that the only one drawer apart from the MAIN.  What we
    did was:
    
    1. Remove the bad drawers (those that were transfered) from the holding
       account
    2. created new drawer (COPORATE)
    3. restored the drawer from backup to the drawer created in 2.
    4. Updated the ACL's and tested
    5. customer will run TRU tonight as the drawer had a number of mail
       messages
    
    Now what I did to recover the drawer had a lot to do with luck because
    the user only had one drawer.  What if the user had a large number of
    drawers ?  As far as I can see there was no way of knowing which
    Z*******.DIR belonged to which drawer.  For each Z*******.DIR directory
    it would have been a good idea to have an empty file containing the
    drawer name.  Riding Lady Luck does not make me feel too happy, is
    there away that I could have found what the drawer names were/are when
    restoring ?  FILECAB.DAT does not contain the drawer file
    specification.  There has to be a better way of restoring drawers than
    having to plough through all of this.  It's hard work when the customer
    is jumping up and down because it contains Coporate wide information,
    anyway it's solved.
    
    Is there any reason why the documents etc. were not tranfered to the
    drawer in the holding account ?   If there is a reason please let us
    know so that we could avoid this happening again.
    
    Regards,
    
    Sunil
2621.2A restored PARTITON file?IOSG::PYEGraham - ALL-IN-1 Sorcerer's ApprenticeThu Apr 29 1993 09:4510
    Sunil,
    
    You could have pulled an old version of PARTITION off a backup, and
    used that to identify the drawer names. But I agree (since I had a
    similar problem a few weeks ago, which I described here) I can't see
    any reason why FILECAB and PARTITION can't contain some redundant
    information enabling you to tie their records together in the event of
    a problem.
    
    Graham
2621.3Could this be put on the *WISH LIST* ?TINNIE::SETHIAh (-: an upside down smile from OzFri Apr 30 1993 00:5117
    Hi Mr. GAP :-),
    
    Yes I should have got a hold of the PARTITION.DAT and searched it for
    the drawer I could have saved time.  Well we live and learn as the
    saying goes !!!!
    
    Does this need to be SPR'd or can it be put on the *WISH LIST* ?  *WISH
    LIST* is better as someone else get's to do the paper work :0) !!!!
    
    If it goes on the *WISH LIST*, what I would like is for the FILECAB or
    some other data file to contain the name of the drawer and the file
    specification.  Main reason being it would save time restoring the
    drawer.
          
    Regards,
    
    Sunil
2621.4More problemsTINNIE::SETHIAh (-: an upside down smile from OzFri Apr 30 1993 04:2652
    Hi,
    
    Sorry I am back the problem as got worse and I have logged onto the
    system a logfile can be found on RIPPERR::USER$TSC:[SETHI]Q42029.LOG;1.
    
    Just to fill you in what has happened is that the owner of the drawer
    Stephen Turner, when he creates a ddocument get's the following error
    message:
    
    %OAFC-I-CARDIDNF, File Cabinet object does not exist
    
    When the Windy Sinclair who shares the drawer tries to create a
    document get's the error message:
    
    %OAFC-I-CARDIDNF, File Cabinet object does not exist
    %OA-I-LASTLINE, The document could not be reserved (Document not edited)
    %OA-I-LASTLINE, No document was created
    
    She is able to read and edit the documents without a problem.
    
    When I look at PARTITION.DAT I get the following:
    
    [TURNER STEPHEN]MAIN
    [TURNER STEPHEN]MAIN1
    [TURNER STEPHEN]CORPORATE
    [TURNER STEPHEN]CORPORATE1
    
    Doing a read I get the following for MAIN1 and CORPORATE:
    
     %OA-W-CAB_DWRFAIL, Error opening drawer file "DOCDB"
     -RMS-E-DNF, directory not found
     %OA-I-LASTLINE, Unable to select this drawer
    
    I have checked the ACL's they appear to be okay.  What is of concern
    are the entries in PARTITION.DAT
    
    [TURNER STEPHEN]MAIN1
    [TURNER STEPHEN]CORPORATE
    
    How did they get there and what do I do to delete them ? I could use
    the remove drawer option, however I am not sure what it's going to do. 
    Will it delete the real MAIN and CORPORATE1 drawers ?
                                          
    I would be grateful for your input and any advise to get this customers
    up and running. The customer is concerned that the delete option has
    caused this problem be they nominated another user for the orphan
    drawer.  I can't reproduce this problem it's difficult to assure the
    customer that this won't happen again.
    
    Regards,
    
    Sunil
2621.5Nearly solved still trying to narrow down what caused prob.TINNIE::SETHIAh (-: an upside down smile from OzTue May 04 1993 05:5832
    Hi All,                      
    
    Progress so far on this problem is, I asked the customer to do the
    following:
    
    1. backup/ignore=interlock partition.dat *.tmp
    2. edit/tpu and search for MAIN1 and CORPORATE drawer and check the file 
       spec.
    3. if the file spec is invalid or corrupted try removing the drawer
       from partition.dat
    4. run the TRU housekeeping routine
    
    The customer ran the TRU before doing 1-3, it turned out to be a good
    thing.  Right after the TRU the Windy who share's  the drawer could
    access it.  When we did 1-3 what we found was that the file spec was
    incorrect and we managed to remove the drawer from partition.dat.
    
    We still do not why this problem occured and the customer will do some
    more testing and get back to me.  If we can pin point the problem I
    will let you know.
    
    ONE THING TO NOTE
    
    In the base note I had said as part of my plan to solve this problem I
    mentioned that the TRU procdure should be run for the owner's account
    only.  For shared drawers in this case it appears that TRU should be
    run for the sharer's account.
         
    Regards,
    
    Sunil