Skip Navigation LinksALVAO 11.1Known issues Skip Navigation Links.


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)

Steps to reproduce this behavior

Attachments

Issue number

T138217ALVAO

 

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