OpenLink][ODBC][Progress Server]Failure getting record lock

[G SHIVARANJANI]

Hi,

I am getting the following error

OpenLink][ODBC][Progress Server]Failure getting record lock on a record from table PUB.Client.

when another online application has locked the table 'client' for update or delete.

And this happens even when i read i.e even when i do select records from the table

Is it possible that both the ETL and the other online applications run simultaniously whithout abort.

Please suggest.

[G SHIVARANJANI]

Hi,

I am getting the following error

OpenLink][ODBC][Progress Server]Failure getting record lock on a record from table PUB.Client.

when another online application has locked the table 'client' for update or delete.

And this happens even when i read i.e even when i do select records from the table

Is it possible that both the ETL and the other online applications run simultaniously whithout abort.

Please suggest.

[G SHIVARANJANI]

Any suggestions..

[chulett]

If anyone did, they would post them.

Have you talked to your Progress DBA about this? My Progress days are way behind me so can't really offer any concrete advice except to see if there's any way to do a 'dirty' or 'uncommitted' read over ODBC. That's a 'standard' way to get around record locks but not sure it will help with table locks, you may be out of luck there.

Talk to your DBA.

[G SHIVARANJANI]

Hi,

Could you please throw light on ' 'uncommitted' read over ODBC. '

If anyone did, they would post them.

Have you talked to your Progress DBA about this? My Progress days are way behind me so can't really offer any concrete advice except to see if there's any way to do a 'dirty' or 'uncommitted' read over ODBC. That's a 'standard' way to get around record locks but not sure it will help with table locks, you may be out of luck there.

Talk to your DBA.

[chulett]

Google should turn up a ton of links on the subject, for example this one. The concepts are similar across all databases.

Again, questions like this really need to either go to your DBA for Progress specific answers or through your official support provider back to the vendor for guidance, unless (of course) someone here as done this and posts a solution for you.

[G SHIVARANJANI]

Thanks Craig

Google should turn up a ton of links on the subject, for example this one. The concepts are similar across all databases.

Again, questions like this really need to either go to your DBA for Progress specific answers or through your official support provider back to the vendor for guidance, unless (of course) someone here as done this and posts a solution for you.