All users have been locked out of the system by <user name>

Problem:

Getting below error message while accessing application, if system is locked for customizations.

Detailed error:

Exception Type: Ivara.PL.Exceptions.InvalidConfigurationException

Message: A message was posted when there is no MessageBoxCallback registered and the message was not an assert.

The posted message does not allow itself to be queued so an exception will be thrown.

The message posted was:

All users have been locked out of the system by <user name>

Stack Trace:

Server stack trace:

at Ivara.Common.Communication.WcfClientMessageInspector.AfterReceiveReply(Message& reply, Object correlationState)

at System.ServiceModel.Dispatcher.ImmutableClientRuntime.AfterReceiveReply(ProxyRpc& rpc)

at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)

at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

at Ivara.PL.Interfaces.IServerInfo.InitializeSession(Guid sessionKey, ClientEnvironment clientEnv, Credentials credentials, String& userTimeZoneID, Byte[]& timeZoneMd5Hash, Boolean& bNeedsInitialTimeZoneSet)

at Ivara.PL.Client.ServerInfo.InitializeSession(Guid sessionKey, ClientEnvironment clientEnv, Credentials credentials, String& userTimeZoneId, Byte[]& timeZoneMd5Hash, Boolean& bNeedsInitialTimeZoneSet)

at Ivara.PL.Client.ActivityManager.CreateSession(ClientEnvironment clientEnv, Credentials credentials, String Address, Int32 Port, String& timeZoneID, Byte[]& timeZoneMd5Hash, Boolean& bNeedsInitialTimeZoneSet)

at Ivara.Client.UI.WindowManager.AsyncCreateSession()

Solutiion:

Open the APM database in SQL Server Management Studio
Locate and Select the Table "oq.connection_reg" " table

select * from oq.connection_reg;

3. Check column lock_db, if you found value “1” that means respected user has locked the database for customization.

You can unlock the system by updating the “lock_db” column value “1” to ‘”0”. Below query will update the all lock_db value to “0”.

update oq.connection_reg set lock_db=0 where lock_db=1; --Query to update lock_db status to "0"

Delete all the user records in this table. There only user in this table at this time should be the administrator who locked the system for customization but delete all the records in the table if there are more than one. To delete all the session use below query.

delete from oq.connection_reg; --Query to delete all sessions.