AM WS - IIS app pool worker uses 100% CPU and RAM usage is increasing

This article is about product releases

ALVAO Asset Management 10.0 and higher

Symptoms

- IIS server with AM WS installed uses 100% CPU core
- RAM consumption is constantly increasing
- Windows TMP folder is full of temp files with name "tempXXXX.tmp"

Cause

The cause is a bug in ALVAO products.

Solution

Fixed in release 11.1.2039 - 11.1/SP1 (2023-09-14)

Workaround

- clean Windows TEMP folder and delete all "tempXXXX.tmp" files
- run the following script on the database:

declare @ids varchar(max)
select @ids=stuff((
	select distinct
		','+cast(d.intDetectId as varchar)
	from tblDetect d
		left join tblDetectOpts do on do.lintDetectId=d.intDetectId
	where do.lintDetectMethodId is null
	for xml path('')),1,1,'')

exec spRemoveDetects @ids

- restart application pool hosting AM WS on IIS server

Issue number

T146293ALVAO

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