> Can you show me the script that locked up, and where it locked up ?
> It sounds like a locking issue, especially if you're talking about
> backups.

The script that ran is listed below.  I never got any status messages
and I didn't think to check the stores to see if any updates got
copied. All I do know for sure is that the backup was made and copied
to the DCI_Master store.


SCRIPT
BEGIN
 DECLARE StoreCursor CURSOR FOR StoreStmt;
 DECLARE StoreName VARCHAR;
   
 USE "DCI_Master";

 -- reset DCI_Master to standard
 EXECUTE IMMEDIATE 'UNPUBLISH DATABASE "DCI_Master"';
 EXECUTE IMMEDIATE 'UPDATE Staff SET Assigned = False WHERE ID = 6';

 -- make the master backup
 EXECUTE IMMEDIATE 'BACKUP DATABASE "DCI_Master" AS "DCI_Master Backup"
                    TO STORE "setup" COMPRESSION 6 INCLUDE CATALOG';
 SET LOG MESSAGE TO 'Backed up DCI_Master';

 -- get all staff stores

 USE "Configuration";
 PREPARE StoreStmt FROM 'SELECT * FROM STORES WHERE Name LIKE
''Staff%''';

 OPEN StoreCursor;
 FETCH FIRST FROM StoreCursor (Name) INTO StoreName;
 WHILE NOT EOF(StoreCursor) DO
   -- for each "out" store, copy the backup there    
   IF RIGHT(StoreName, 3) = 'out' THEN
     EXECUTE IMMEDIATE 'COPY FILE "DCI_Master Backup.EDBBkp"
                        IN STORE "setup"
                        TO "DCI_Master Backup.EDBBkp"
                        IN STORE "' + StoreName + '"';
     SET LOG MESSAGE TO 'Copied to store ' + StoreName;
   END IF;

   FETCH NEXT FROM StoreCursor (Name) INTO StoreName;
 END WHILE;             
 CLOSE StoreCursor;
 UNPREPARE StoreStmt;
          
 -- all done, now publish the master database for replication

 EXECUTE IMMEDIATE 'PUBLISH DATABASE "DCI_Master" TABLES
   Contacts,
   Categories, ItemHeaders,
   InvoiceTypes,
   POHeaders, PODetails,
   OrderAckHeaders, OrderAckDetails, CostSheet,
   InvoiceHeaders, InvoiceDetails,
   CustPartNums, Notes, SKUs, Terms,
   CreditWarnings, Staff, system,
   InsuranceMaster, InsuranceTemp,
   HEADER';
END;



I really don't think that anything in particular that a script is doing
or that I have setup is causing the problem.  It seems to occur
sporadically, without warning during mundane tasks and with everything
else just humming along fine.  Sometimes simply restarting EDB Manager
is all that it takes.  Sometimes I have to restart the database server.

--
David Cornelius
CorneliusConcepts.com

David,

<< The script that ran is listed below.  I never got any status messages and
I didn't think to check the stores to see if any updates got copied. All I
do know for sure is that the backup was made and copied to the DCI_Master
store. >>

I don't see where any update files are copied - is that a different script ?

--
Tim Young
Elevate Software
www.elevatesoft.com

> << The script that ran is listed below.  I never got any status
> messages and I didn't think to check the stores to see if any updates
> got copied. All I do know for sure is that the backup was made and
> copied to the DCI_Master store. >>
>
> I don't see where any update files are copied - is that a different
> script ?

Uh, actually I pasted a different script and started talking about that
one, then realized I had put the wrong script and didn't cut out all of
my email.

I think I'll just watch stuff here and past up accurate details the
next time it happens.  Sorry.

--
David Cornelius
CorneliusConcepts.com

David,

<< I think I'll just watch stuff here and past up accurate details the next
time it happens.  Sorry. >>

No problem.  Please let me know if you see anything else regarding this
issue that may be of interest.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com