Salesforce

Cannot purge data out of under _client-session table online.

« Go Back

Information

 
TitleCannot purge data out of under _client-session table online.
URL Name000049312
Article Number000168516
EnvironmentProduct: OpenEdge
Version: 11.1
OS: Linux
Others: N/A
Question/Problem Description
Cannot purge data out of under_client-session table, while database is online
_client-session records cannot be deleted if there is any ABL or SQL clients to the database due to exclusive schema lock
After running auditarchive with purge records under _client-session are archived but not be deleted.
Steps to Reproducedelete code:
for each _client-session.
delete _client-session.
end.
Clarifying Information
Error Message
Defect NumberPSC00292494
Enhancement Number
Cause
The schema lock is not downgraded to request when the row being deleted is a _Client-session row, which means an exclusive schema lock is requested and fails.
Resolution
Upgrade to OpenEdge 11.3.3, 11.4 or later, where special handling of _Client-Session record deletion was added before applying locking the same as is done for other auditing data tables.
Nothing should be affected if CLIENT-PRINCIPAL is used.
 
Workaround
If no schema is being changed, this exclusive schema lock can be avoided by setting SESSION:SCHEMA-CHANGES = "New Objects"
before running the program that tries to delete the _Client-Session rows.

When using this workaround, it is very important to always restore SESSION:SCHEMA-CHANGES to its previous value once returning from the program. 
Notes
Keyword Phrase
Last Modified Date6/17/2021 2:23 PM

Powered by