Schema Locking

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

On May 28, 4:20 pm, AndyW 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.