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.
OpenLink][ODBC][Progress Server]Failure getting record lock
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Re: OpenLink][ODBC][Progress Server]Failure getting record l
G SHIVARANJANI wrote: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.
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Re: OpenLink][ODBC][Progress Server]Failure getting record l
Any suggestions..
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Hi,
Could you please throw light on ' 'uncommitted' read over ODBC. '
Could you please throw light on ' 'uncommitted' read over ODBC. '
chulett wrote: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.
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Thanks Craig
chulett wrote: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.