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

Problem:

Getting below error message while accessing smart client, if database is locked for customizations in a thick client for the same APM version.

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()

Solution:

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

            select * from oq.connection_reg; 

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

           Use the following change the lock_db value to “0” for all rows (there should be only one rows with a value of "1");

            update oq.connection_reg set lock_db=0 where lock_db=1

       4. Launch APM and test access again.

       5. If step 4 fails, repeat steps 1 & 2. Delete the connection entries (rows) using the following query:

           delete from oq.connection_reg;

See also: