Product(s):	APM Implementation and Performance Management
	Version(s):	7
	Environment:	N/A
	Area:	N/A
	Subarea:	N/A

Problem Description

An APM user recently applied a patch on the database server resulting in connection errors with some or all smart-client services to that server, 

2023-11-11 12:00:54.6015 Fatal username-adm Ivara.OTAssert [9] File: database.cpp(1391) :  oDatabase::lockObject(..) - GetAppLock(..) returned -1!  This means the session was not found in oq.connection_reg cid=xxxxx oid=3 locktype=1 userIDOut=<> clientAddrOut=<>

Solution

Users should always test database patches in the QA environment first and test that all APM services can connect with the database in advance. If a patch fails, it is generally up to the user's database administrators to investigate if the appropriate patch is compatible with the applicable versions of Bentley APM and Bentley Connect and that the patch is installed properly and drivers updated on target servers, etc. In this case the patch was reinstalled and all connecting servers updated with new drivers.