Problem logging in after reinstalling IMC and restoring database backup.

[ahnet]

I reinstalled MS SQL server 2012 Standard on Windows 2012 Server then reinstall IMC and restored IMC backup.

When I try to login I got:

Remediation Suggestion

1)   Go back to  Home  to try again. 2)   Collect logs and contact technical support for help. To obtain compressed logs, log in to the system server, execute file deploy\logfiles.bat (for Windows) or deploy/logfiles.sh (for Linux) in the installation path, and go to the tmp folder in the installation path.

Error Details

org.apache.myfaces.view.facelets.el.ContextAwareELException: javax.el.ELException: java.lang.NullPointerException
at org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:108)
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
at javax.faces.component.UICommand.broadcast(UICommand.java:120)
at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1041)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:289)
at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1415)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:765)
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.h3c.imc.servlet.filters.FileUploadEncodingFilter.doFilter(FileUploadEncodingFilter.java:29)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.h3c.imc.filter.ImcBrowserCacheInvalidFilter.doFilter(ImcBrowserCacheInvalidFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.h3c.imc.filter.ImcNoEtagFilter.doFilter(ImcNoEtagFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.h3c.imc.filter.ImcExpiresFilter.doFilter(ImcExpiresFilter.java:830)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.h3c.imc.servlet.filters.UrlAccessController.doFilter(UrlAccessController.java:494)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1775)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1734)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: javax.el.ELException: java.lang.NullPointerException
at org.apache.el.parser.AstValue.invoke(AstValue.java:292)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:273)
at org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
... 51 more
Caused by: java.lang.NullPointerException
at java.base/java.lang.String.<init>(String.java:537)
at com.h3c.imc.common.CommonUtils.decryptData(CommonUtils.java:1949)
at com.h3c.imc.plat.entity.Operator.getPassword(Operator.java:761)
at com.h3c.imc.plat.operator.func.OperatorMgrImpl.localAuthentic(OperatorMgrImpl.java:2599)
at com.h3c.imc.plat.operator.func.OperatorMgrImpl.login(OperatorMgrImpl.java:2052)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy55.login(Unknown Source)
at com.h3c.imc.plat.operator.view.OperatorBean.onLogin(OperatorBean.java:1719)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.el.parser.AstValue.invoke(AstValue.java:279)
... 53 more

I found on forum that the log containing more info about it is in file imcforeground.log

IMC version iMC_PLAT_7.3_E0605P06.

Does anyone know how to solve it?

[jguse]

Hello,

How exactly was IMC restored from the backup? Did you use MSSQL backup/restore tools (these are not supported and will not work properly to restore the filesystem of IMC), or did you restore a DBMAN Backup instead via Restore button on DMA Environment Tab?

[ahnet]

I used Backup and Restore options on DMA Environment Tab.

I'm looking for an option at this forum to attach a file with full imcforeground.log but can't find it..

[jguse]

Hello,

Thanks for confirming and sharing the error details. You won't be able to attach logs here unfortunately, just excerpts.

- Can you please check the DMA Process and Environment tabs, and make sure all processes have started correctly and DB connectivity works?

- Check the jserver process memory usage compared to Java Heap memory limit. It is shown on the Environment tab. Does your 'jserver' process consume all the memory available for Java Heap?

We've seen issues with the same javax.el.ELException: java.lang.NullPointerException in the past, but the root cause is not always the same. On older versions of IMC (7.3 E0506) there was an issue with NULL entries in the database that triggered it, but that was fixed by 7.3 E0605.

[ahnet]

All processes are up. I can connect to db using SQL Server Management Studio (SSMS).

How to check if IMC is able to connect to DB - MS SQL?

jserver process memory usage meet limits for Java Heap memory:

jar:file:/C:/Program%20Files/iMC/deploy/deploy.jar!/com/h3c/imc/deploy/resource/state_running.gif jserver Started Local Host 1.44 2848384.0 2019-08-27 12:14:54 Manageable Process Auto

Max. heap/non-heap mem: 4096m/1024m

[jguse]

Hello,

If the Environment Tab on DMA is showing all the databases, then that usually means it is able to connect. Most likely the issue is actually triggered by entries in the DB, as NullPointerException usually indicates an unexpected NULL record in some database table.

I think this will require a proper log investigation and possibly remote session to resolve. Can you please open a support case for this issue?

[jguse]

One more thing you could test in the meantime as you mentioned that this error happens upon login.

Do you see the same issue with any IMC operator (user) that you login with? Does it affect the default 'admin' operator, and any other operators as well (if you have any to test)?

[ahnet]

The issue exist for any user, no matter if I will provide correct user/password or wrong one.

Unfortunatelly I cannot open support case - that is why I'm looking for kind of support at this forum.

[jguse · Accepted solution]

Hello,

I understand and will see if we can figure it out, but you may need to revert to an older backup (if you have one) prior to the issue, or risk losing some configurations if you re-deploy a component to 'repair' it. However there are a few things you can check first...

Do you see any message about a database table error or similar in the imcforeground.log right before or during the Java exception error? Or anything about missing files?

In the past we had a similar issue with this exception, where we found that the DB table imc_config.tbl_bs_view had some NULL entries that triggered the issue. Can you check that database table with MSSQL Management Studio (right-click and select top 1000 rows on it, for example), and share the table output screenshot?

[ahnet]

23:35 [ERROR] [imchost-startStop-4] [com.imc.common.StringManager::initResourceBundle] Can't find resource for bundle  com.imc.rs.netasset.LocalStrings
ClassLoader: WebappClassLoader
  context: /imcrs
  delegate: false
  repositories:
----------> Parent Classloader:
com.imc.bootstrap.StandardClassLoader@166e0c3
URLs: 
[]
URLs: 
[file:C:\Program Files\iMC\client\repository\activemq\jars\activeio-core.jar, file:C:\Program Files\iMC\client\repository\activemq\jars\activemq-core.jar, file:C:\Program Files\iMC\client\repository\activemq\jars\backport-util-concurrent.jar, file:C:\Program Files\iMC\client\repository\activemq\jars\xbean-spring.jar, file:C:\Program Files\iMC\client\repository\antlr\jars\antlr.jar, file:C:\Program Files\iMC\client\repository\asm\jars\asm.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\annogen.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\axiom-api.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\axiom-impl.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\axis2-adb.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\axis2-kernel.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\neethi.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\woden-api.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\wstx-asl.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\XmlSchema.jar, file:C:\Program Files\iMC\client\repository\bouncycastle\jars\bcpkix-jdk15on-148.jar, file:C:\Program Files\iMC\client\repository\bouncycastle\jars\bcprov-jdk15on-148.jar, file:C:\Program Files\iMC\client\repository\cglib\jars\cglib.jar, file:C:\Program Files\iMC\client\repository\chardet\jars\chardet.jar, file:C:\Program Files\iMC\client\repository\commons-beanutils\jars\commons-beanutils.jar, file:C:\Program Files\iMC\client\repository\commons-cli\jars\commons-cli.jar, file:C:\Program Files\iMC\client\repository\commons-codec\jars\commons-codec.jar, file:C:\Program Files\iMC\client\repository\commons-collections\jars\commons-collections.jar, file:C:\Program Files\iMC\client\repository\commons-collections\jars\commons-collections4.jar, file:C:\Program Files\iMC\client\repository\commons-compress\jars\commons-compress.jar, file:C:\Program Files\iMC\client\repository\commons-configuration\jars\commons-configuration.jar, file:C:\Program Files\iMC\client\repository\commons-dbcp\jars\commons-dbcp.jar, file:C:\Program Files\iMC\client\repository\commons-digester\jars\commons-digester.jar, file:C:\Program Files\iMC\client\repository\commons-discovery\jars\commons-discovery.jar, file:C:\Program Files\iMC\client\repository\commons-el\jars\commons-el.jar, file:C:\Program Files\iMC\client\repository\commons-email\jars\commons-email.jar, file:C:\Program Files\iMC\client\repository\commons-fileupload\jars\commons-fileupload.jar, file:C:\Program Files\iMC\client\repository\commons-httpclient\jars\commons-httpclient-contrib.jar, file:C:\Program Files\iMC\client\repository\commons-httpclient\jars\commons-httpclient.jar, file:C:\Program Files\iMC\client\repository\commons-httpclient\jars\httpclient.jar, file:C:\Program Files\iMC\client\repository\commons-httpclient\jars\httpcore.jar, file:C:\Program Files\iMC\client\repository\commons-io\jars\commons-io.jar, file:C:\Program Files\iMC\client\repository\commons-lang\jars\commons-lang.jar, file:C:\Program Files\iMC\client\repository\commons-lang3\jars\commons-lang3.jar, file:C:\Program Files\iMC\client\repository\commons-logging\jars\commons-logging.jar, file:C:\Program Files\iMC\client\repository\commons-math\jars\commons-math.jar, file:C:\Program Files\iMC\client\repository\commons-modeler\jars\commons-modeler.jar, file:C:\Program Files\iMC\client\repository\commons-net\jars\commons-net.jar, file:C:\Program Files\iMC\client\repository\commons-pool\jars\commons-pool.jar, file:C:\Program Files\iMC\client\repository\commons-pool\jars\commons-pool2.jar, file:C:\Program Files\iMC\client\repository\commons-serializer\jars\serializer.jar, file:C:\Program Files\iMC\client\repository\commons-validator\jars\commons-validator.jar, file:C:\Program Files\iMC\client\repository\concurrent\jars\concurrent.jar, file:C:\Program Files\iMC\client\repository\dns\jars\dnsjava.jar, file:C:\Program Files\iMC\client\repository\docx4j\jars\docx4j.jar, file:C:\URLs: 
[file:/C:/Program Files/iMC/client/bin/bootstrap.jar]
URLs: 
[file:/C:/Program Files/iMC/common/jre/lib/ext/access-bridge-64.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/dnsns.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/jaccess.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/localedata.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/ssl-provider-jvm16-0.2.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/sunec.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/sunjce_provider.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/sunmscapi.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/zipfs.jar]
ClassLoader: com.imc.bootstrap.StandardClassLoader@166e0c3URLs: 
[file:C:\Program Files\iMC\client\repository\activemq\jars\activeio-core.jar, file:C:\Program Files\iMC\client\repository\activemq\jars\activemq-core.jar, file:C:\Program Files\iMC\client\repository\activemq\jars\backport-util-concurrent.jar, file:C:\Program Files\iMC\client\repository\activemq\jars\xbean-spring.jar, file:C:\Program Files\iMC\client\repository\antlr\jars\antlr.jar, file:C:\Program Files\iMC\client\repository\asm\jars\asm.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\annogen.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\axiom-api.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\axiom-impl.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\axis2-adb.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\axis2-kernel.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\neethi.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\woden-api.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\wstx-asl.jar, file:C:\Program Files\iMC\client\repository\axis2\jars\XmlSchema.jar, file:C:\Program Files\iMC\client\repository\bouncycastle\jars\bcpkix-jdk15on-148.jar, file:C:\Program Files\iMC\client\repository\bouncycastle\jars\bcprov-jdk15on-148.jar, file:C:\Program Files\iMC\client\repository\cglib\jars\cglib.jar, file:C:\Program Files\iMC\client\repository\chardet\jars\chardet.jar, file:C:\Program Files\iMC\client\repository\commons-beanutils\jars\commons-beanutils.jar, file:C:\Program Files\iMC\client\repository\commons-cli\jars\commons-cli.jar, file:C:\Program Files\iMC\client\repository\commons-codec\jars\commons-codec.jar, file:C:\Program Files\iMC\client\repository\commons-collections\jars\commons-collections.jar, file:C:\Program Files\iMC\client\repository\commons-collections\jars\commons-collections4.jar, file:C:\Program Files\iMC\client\repository\commons-compress\jars\commons-compress.jar, file:C:\Program Files\iMC\client\repository\commons-configuration\jars\commons-configuration.jar, file:C:\Program Files\iMC\client\repository\commons-dbcp\jars\commons-dbcp.jar, file:C:\Program Files\iMC\client\repository\commons-digester\jars\commons-digester.jar, file:C:\Program Files\iMC\client\repository\commons-discovery\jars\commons-discovery.jar, file:C:\Program Files\iMC\client\repository\commons-el\jars\commons-el.jar, file:C:\Program Files\iMC\client\repository\commons-email\jars\commons-email.jar, file:C:\Program Files\iMC\client\repository\commons-fileupload\jars\commons-fileupload.jar, file:C:\Program Files\iMC\client\repository\commons-httpclient\jars\commons-httpclient-contrib.jar, file:C:\Program Files\iMC\client\repository\commons-httpclient\jars\commons-httpclient.jar, file:C:\Program Files\iMC\client\repository\commons-httpclient\jars\httpclient.jar, file:C:\Program Files\iMC\client\repository\commons-httpclient\jars\httpcore.jar, file:C:\Program Files\iMC\client\repository\commons-io\jars\commons-io.jar, file:C:\Program Files\iMC\client\repository\commons-lang\jars\commons-lang.jar, file:C:\Program Files\iMC\client\repository\commons-lang3\jars\commons-lang3.jar, file:C:\Program Files\iMC\client\repository\commons-logging\jars\commons-logging.jar, file:C:\Program Files\iMC\client\repository\commons-math\jars\commons-math.jar, file:C:\Program Files\iMC\client\repository\commons-modeler\jars\commons-modeler.jar, file:C:\Program Files\iMC\client\repository\commons-net\jars\commons-net.jar, file:C:\Program Files\iMC\client\repository\commons-pool\jars\commons-pool.jar, file:C:\Program Files\iMC\client\repository\commons-pool\jars\commons-pool2.jar, file:C:\Program Files\iMC\client\repository\commons-serializer\jars\serializer.jar, file:C:\Program Files\iMC\client\repository\commons-validator\jars\commons-validator.jar, file:C:\Program Files\iMC\client\repository\concurrent\jars\concurrent.jar, file:C:\Program Files\iMC\client\repository\dns\jars\dnsjava.jar, file:C:\Program Files\iMC\client\repository\docx4j\jars\docx4j.jar, file:C:\URLs: 
[file:/C:/Program Files/iMC/client/bin/bootstrap.jar]
URLs: 
[file:/C:/Program Files/iMC/common/jre/lib/ext/access-bridge-64.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/dnsns.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/jaccess.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/localedata.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/ssl-provider-jvm16-0.2.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/sunec.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/sunjce_provider.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/sunmscapi.jar, file:/C:/Program Files/iMC/common/jre/lib/ext/zipfs.jar]
StackTrace: 
23:41 [ERROR] [imchost-startStop-3] [com.imc.bigscreen.plat.BsUtils::checkLicenseExitOrNot] 3D license is not exit,so you cannot use 3D datacentertopo
[...]
23:42 [ERROR] [imchost-startStop-3] [com.imc.bigscreen.plat.BsUtils::checkLicenseExitOrNot] 3D license is not exit,so you cannot use 3D datacentertopo
23:42 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
23:42 [ERROR] [imchost-startStop-3] [com.imc.bigscreen.plat.BsUtils::checkLicenseExitOrNot] 3D license is not exit,so you cannot use 3D datacentertopo
[...]
23:42 [ERROR] [imchost-startStop-3] [com.imc.bigscreen.plat.BsUtils::checkLicenseExitOrNot] 3D license is not exit,so you cannot use 3D datacentertopo
23:42 [WARN ] [imchost-startStop-3] [com.imc.traceLog.IMCTraceBeanPostProcessor::postProcessAfterInitialization] ****iMC Startup tarce log: Bean after 'bsWidgetMgr' created : com.imc.bigscreen.plat.lib.func.WidgetMgrImpl@289c5d53 spend ms is 1656
23:43 [WARN ] [imchost-startStop-3] [com.imc.traceLog.IMCTraceBeanPostProcessor::postProcessAfterInitialization] ****iMC Startup tarce log: Bean after 'platFlexTopoConfigMgr' created : com.imc.flex.plat.lib.func.FlexTopoConfigMgrImpl@6270341e spend ms is 13
23:45 [WARN ] [imchost-startStop-3] [com.imc.common.faces.SortableList::initMaxItemNumberForPage] 
java.lang.NullPointerException
23:45 [WARN ] [imchost-startStop-3] [com.imc.common.faces.SortableList::initMaxItems] 
java.lang.NullPointerException
23:45 [WARN ] [imchost-startStop-3] [com.imc.common.faces.SortableList::initMaxItemNumberForPage] 
java.lang.NullPointerException
23:45 [WARN ] [imchost-startStop-3] [com.imc.common.faces.SortableList::initMaxItems] 
java.lang.NullPointerException
23:52 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
24:02 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
24:12 [WARN ] [imchost-startStop-3] [com.imc.ext.ExtensionConfig::translate] Resource not found
java.util.MissingResourceException: Can't find resource for bundle java.util.PropertyResourceBundle, key mgrNav.navItem.ipmgr.dhcpConfig.desc
24:12 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
24:13 [WARN ] [imchost-startStop-3] [com.imc.ext.ExtensionConfig::translate] Resource not found
java.util.MissingResourceException: Can't find resource for bundle java.util.PropertyResourceBundle, key qsp.wsm.fatstDeploy.desc

[ahnet]

24:19 [INFO ] [main] [org.apache.catalina.startup.Catalina::start] Server startup in 61182 ms
24:19 [ERROR] [main] [com.imc.bootstrap.ServerContext::afterStarted] afterStarted() invoke com.imc.ext.NavigationSearchImplementMgrImpl@7d6e6201, class: class com.imc.ext.NavigationSearchImplementMgrImpl get Exception: 
24:19 [ERROR] [main] [com.imc.bootstrap.ServerContext::afterStarted] 
net.sf.json.JSONException: A JSONObject text must begin with '{' at character 1 of <html><head><title>Apache Tomcat/7.0.85 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 500 - </h1><HR size="1" noshade="noshade"><p><b>type</b> Exception report</p><p><b>message</b> <u></u></p><p><b>description</b> <u>The server encountered an internal error that prevented it from fulfilling this request.</u></p><p><b>exception</b> <pre>java.lang.NullPointerException
	java.lang.String.&lt;init&gt;(String.java:481)
	com.imc.common.CommonUtils.decryptData(CommonUtils.java:1950)
	com.imc.seplat.operator.entity.Operator.getPassword(Operator.java:76)
	com.imc.seplat.operator.func.OperatorMgrImpl.queryPwdByName(OperatorMgrImpl.java:63)
	com.imc.rs.seplat.ext.OperatorUserDetailsService.loadUserByUsername(OperatorUserDetailsService.java:97)
	com.imc.rs.seplat.ext.DigestAuthenticationFilter.handleAuth(DigestAuthenticationFilter.java:414)
	com.imc.rs.seplat.ext.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:185)
	com.imc.rs.seplat.ext.PasswordProtectDigestAuthenticationFilter.doFilter(PasswordProtectDigestAuthenticationFilter.java:66)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
	org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
	com.imc.rs.seplat.ext.api.ApiOriginFilter.doFilter(ApiOriginFilter.java:66)
</pre></p><p><b>note</b> <u>The full stack trace of the root cause is available in the Apache Tomcat/7.0.85 logs.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.85</h3></body></html>
24:22 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
arg0 : LicenseRegister
arg1 : C:\Program Files\iMC\client
iMF connection listener added
Aug 23, 2019 7:24:19 PM com.imf.IMFConnection open
INFO: open() - imgAddress=/127.0.0.1:8801
monitorThread is alive...
Aug 23, 2019 7:24:20 PM com.imf.KeepAlive call
SEVERE: Try to connect to img/img.exe, I/O return "Connection refused: connect"
monitorThread is alive...
thread wait finish, number : 1
monitorThread is alive...
monitorThread is alive...
thread wait finish, number : 2
monitorThread is alive...
monitorThread is alive...
thread wait finish, number : 3
monitorThread is alive...
Aug 23, 2019 7:24:26 PM com.imf.IMFConnection freeConnection
SEVERE: freeConnection()
iMF Disconnected
exit process.

24:32 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
24:42 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
24:51 [WARN ] [http-nio-8080-exec-7] [com.imc.servlet.filters.UrlAccessController::doFilter] Access URL With No OperatorInfo: /imc/login.jsf?null from 192.168.100.200
24:52 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
24:53 [WARN ] [http-nio-8080-exec-7] [com.imc.traceLog.IMCTraceBeanPostProcessor::postProcessAfterInitialization] ****iMC Startup tarce log: Bean after 'platAclMgr' created : com.imc.plat.acl.func.AclMgrImpl@9f0542f spend ms is 12
24:54 [WARN ] [http-nio-8080-exec-7] [com.imc.ext.beans.CommonExtensionManagedBean::filterExtensionConfigsForAppVersion] current version is not app version.current perspectiveId is empty.
24:54 [WARN ] [http-nio-8080-exec-7] [com.imc.ext.beans.CommonExtensionManagedBean::filterExtensionConfigsForAppVersion] current version is not app version.current perspectiveId is empty.
[...]
24:54 [WARN ] [http-nio-8080-exec-7] [com.imc.ext.beans.CommonExtensionManagedBean::filterExtensionConfigsForAppVersion] current version is not app version.current perspectiveId is empty.
24:54 [WARN ] [http-nio-8080-exec-11] [com.imc.servlet.filters.UrlAccessController::doFilter] Access URL With No OperatorInfo: /imc/javax.faces.resource/aes.js.jsf?ln=jscript from 192.168.100.200
24:54 [WARN ] [http-nio-8080-exec-15] [com.imc.servlet.filters.UrlAccessController::doFilter] Access URL With No OperatorInfo: /imc/javax.faces.resource/login_hpe.css.jsf?ln=css from 192.168.100.200
24:55 [WARN ] [http-nio-8080-exec-19] [com.imc.servlet.filters.UrlAccessController::doFilter] Access URL With No OperatorInfo: /imc/resources/fonts/HPSimplifiedW04-Regular.ttf?null from 192.168.100.200
24:55 [WARN ] [http-nio-8080-exec-19] [com.imc.servlet.filters.UrlAccessController::doFilter] Access URL With No OperatorInfo: /imc/resources/fonts/HPSimplifiedW04-Regular.ttf?null from 192.168.100.200
24:55 [WARN ] [http-nio-8080-exec-23] [com.imc.servlet.filters.UrlAccessController::doFilter] Access URL With No OperatorInfo: /imc/navigationToLogin.xhtml?reloginFlag=true from 192.168.100.200
25:02 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
25:12 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
25:21 [WARN ] [http-nio-8080-exec-25] [com.imc.servlet.filters.UrlAccessController::doFilter] Access URL With No OperatorInfo: /imc/login.jsf?null from 192.168.100.200
25:21 [WARN ] [http-nio-8080-exec-25] [com.imc.ext.beans.CommonExtensionManagedBean::filterExtensionConfigsForAppVersion] current version is not app version.current perspectiveId is empty.
[...]
25:21 [WARN ] [http-nio-8080-exec-25] [com.imc.ext.beans.CommonExtensionManagedBean::filterExtensionConfigsForAppVersion] current version is not app version.current perspectiveId is empty.
25:21 [ERROR] [http-nio-8080-exec-25] [com.imc.common.CommonUtils::decryptData] 
25:21 [ERROR] [http-nio-8080-exec-25] [org.apache.catalina.core.StandardWrapperValve::invoke] Servlet.service() for servlet [Faces Servlet] in context with path [/imc] threw exception [javax.el.ELException: java.lang.NullPointerException] with root cause
java.lang.NullPointerException
25:21 [ERROR] [http-nio-8080-exec-25] [com.imc.common.ex.ErrorPageBean::checkLoginErrorException] ErrorPageBean find error : org.apache.myfaces.view.facelets.el.ContextAwareELException: javax.el.ELException: java.lang.NullPointerException
Caused by: javax.el.ELException: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
org.apache.myfaces.view.facelets.el.ContextAwareELException: javax.el.ELException: java.lang.NullPointerException
Caused by: javax.el.ELException: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
25:22 [WARN ] [http-nio-8080-exec-25] [com.imc.common.ImcPerspectiveBean::getCurrentOperator] plat error code:50324
25:22 [WARN ] [http-nio-8080-exec-25] [com.imc.common.ImcPerspectiveBean::getPerspective] Operator is null.
25:22 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
[...]
29:52 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
30:01 [WARN ] [ImcTaskQuartzScheduler_Worker-9] [com.imc.plat.task.entity.ImcRfTaskEntity::execute] execute() ImcTask: periodic.[ImcTaskIdentifier_CallerClass(class com.imc.plat.search.task.ImcSearchTaskMgrImpl)_TaskName(execute periodicCustomizeSearchableEntityList of resDeviceSearchImplementMgr)]_1566580995644_2, beanObject: class com.imc.res.device.func.DeviceSearchImplementMgrImpl, methodName: periodicCustomizeSearchableEntityList, parameters: [Ljava.lang.Object;@3bded382, parameterTypes: [Ljava.lang.Class;@22101a83 get exception: 
java.lang.reflect.InvocationTargetException
Caused by: net.sf.json.JSONException: A JSONObject text must begin with '{' at character 1 of <html><head><title>Apache Tomcat/7.0.85 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 500 - </h1><HR size="1" noshade="noshade"><p><b>type</b> Exception report</p><p><b>message</b> <u></u></p><p><b>description</b> <u>The server encountered an internal error that prevented it from fulfilling this request.</u></p><p><b>exception</b> <pre>java.lang.NullPointerException
	java.lang.String.&lt;init&gt;(String.java:481)
	com.imc.common.CommonUtils.decryptData(CommonUtils.java:1950)
	com.imc.seplat.operator.entity.Operator.getPassword(Operator.java:76)
	com.imc.seplat.operator.func.OperatorMgrImpl.queryPwdByName(OperatorMgrImpl.java:63)
	com.imc.rs.seplat.ext.OperatorUserDetailsService.loadUserByUsername(OperatorUserDetailsService.java:97)
	com.imc.rs.seplat.ext.DigestAuthenticationFilter.handleAuth(DigestAuthenticationFilter.java:414)
	com.imc.rs.seplat.ext.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:185)
	com.imc.rs.seplat.ext.PasswordProtectDigestAuthenticationFilter.doFilter(PasswordProtectDigestAuthenticationFilter.java:66)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144)
	org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
	org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
	com.imc.rs.seplat.ext.api.ApiOriginFilter.doFilter(ApiOriginFilter.java:66)
</pre></p><p><b>note</b> <u>The full stack trace of the root cause is available in the Apache Tomcat/7.0.85 logs.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.85</h3></body></html>
30:02 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out
[...]
39:52 [WARN ] [Thread-66] [com.imc.ntam.config.ntatask.func.NoneConfigInfoReceiver$ReceiverMsgMonitor::run] java.net.SocketTimeoutException: Receive timed out

[ahnet]

Regarding the SQL query:

SELECT * FROM [config_db].[imc_config].[tbl_bs_view]

it returns 0 rows. (This table is empty.)

I also checked that this table is empty after fresh install of IMC to which I can login without issues (before I restore backup)

[ahnet]

I recovered IMC database from different backup and now it's working.