Hi,

I am trying to create a job to backup 2 ElevateDB databases, using ElevateDB Manager (everything on 2.03b19). However the Job did not appear to work so I started to break the SQL up into bits.

I started with this query, which works fine -

BACKUP DATABASE npchSGPT
     AS "npchSGPTDataBaseDailyBackup"
     TO STORE "Database Backup"
     INCLUDE CATALOG

However, when I try to run the same sql using a script as below -

SCRIPT
BEGIN
EXECUTE IMMEDIATE 'BACKUP DATABASE npchSGPT
     AS "npchSGPTDataBaseDailyBackup"
     TO STORE "Database Backup"
     INCLUDE CATALOG;';
END

The Backup Database SQL is executed  and a message is displayed to say it has completed in n.nn secs but then the script does not complete and hangs for a while before coming up with the error -

ElevateDB Error #506 Cannot lock the session manager (ID: 1)

This then seems to screw the server up and I have to reset both the ElevateDB server and ElevateDB Manager.

Can anyone explain what I am doing wrong to cause such a catastrophic failure in the ElevateDB Server?

Many thanks,
Ian Turner

Ian,

<< The Backup Database SQL is executed  and a message is displayed to say it
has completed in n.nn secs but then the script does not complete and hangs
for a while before coming up with the error -

ElevateDB Error #506 Cannot lock the session manager (ID: 1)

This then seems to screw the server up and I have to reset both the
ElevateDB server and ElevateDB Manager. >>

The issue is on the client side, specifically the EDB Manager script
debugger.  There's an issue with the variable display when the debugger is
in the middle of updating the progress for the script.

Workaround: using a normal Delphi application with ExecScript will work
fine.

A fix will be in build 20.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<< A fix will be in build 20.>>

Thanks Tim. I thought I was going a little loopy so I'm just glad it wasn't old age creeping in (yet).

Thanks,
Ian