AM - Objects - Recycle bin - emptying the bin takes a long time

This article is about product releases

ALVAO Asset Management 11.0 and higher

Symptoms

Emptying the bin takes a long time:

AM Console deletes ten objects at a time in batches. One batch can take several seconds.
The WebApp deletes all objects at once. This can take tens of minutes to hours.

Cause

The cause is missing indexes in the database.

Solution

Fixed in release 11.1.1096 - 11.1 (2023-04-13)

Workaround

Run the following SQL script on the database:

create nonclustered index IX_tblHistory_lintOpNodeId on tblHistory (lintOpNodeId)
create nonclustered index IX_tblDocument_lintSrcNodeId on tblDocument (lintSrcNodeId)
create nonclustered index IX_tblHistory_lintOp2NodeId on tblHistory (lintOp2NodeId)
create nonclustered index IX_tblLicHist_OrganizationNodeId on tblLicHist (OrganizationNodeId)

Issue number

T138217ALVAO

Did not find what you were looking for? Ask our technical support team.