SEO

#1 (**permalink**) 04-10-2008, 12:09 AM

Hi

I'm a VB programmer struggling to get to grips with Progress V9.

I've got a program that creates a load of Views that are used for
report in Crystal Reports.

I keep getting the following error:

"Failure to acquire exclusive schema lock for DDL operation. (7872)"

I've found enough information that tells me this error is down to
users being in the system.

If possible I'd like to query the DB to find out who's causing the
locks via my VB application.

Does anyone know if this is possible.

Thanks

Andy

#2 (**permalink**) 04-10-2008, 12:09 AM

On May 28, 4:20 pm, AndyW <AndrewMWal...@totalise.co.uk> wrote:
> Hi
>
> I'm a VB programmer struggling to get to grips with Progress V9.
>
> I've got a program that creates a load of Views that are used for
> report in Crystal Reports.
>
> I keep getting the following error:
>
> "Failure to acquire exclusive schema lock for DDL operation. (7872)"
>
> I've found enough information that tells me this error is down to
> users being in the system.
>
> If possible I'd like to query the DB to find out who's causing the
> locks via my VB application.
>
> Does anyone know if this is possible.
>
> Thanks
>
> Andy

You need to knock all other users off the DB to make a schema change.

You can find a lot more information at http://progress.atgnow.com/esprogress/Login.jsp
(no login required even though the URL reads like it).

Looks like you may need to call Progress on this one.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Schema Locking