Kbase 17379: Actuate patch 9 record lock workaround
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Actuate patch 9 record lock workaround
Actuate Developer Workbench 2.010b patch 9 contains a bug which takes
out shared record locks as it accesses records in a database. This
can lead to lock table overflows and performance problems.
To work around this problem, you must add " For Read Only" to the SQL
statement. This is done by overriding the ObtainSelectStatement
method of each DataStream component. You should add a line to this
function which says:
ObtainSelectStatement = Super::ObtainSelectStatement( ) &
" For Read Only"
Notice the space between the first set of double quotes and the `For'.
This is important to have to prevent the phrase from being appended to
the end of the previous part of the statement.
You should also close the report, exit and restart Actuate and reopen
the report before adding this phrase. You must do this for each
report. This is a workaround, we are currently waiting for a
fix.
Progress Software Technical Support Note # 17379