Unijob shows "Connection with warning" in UVMS, at the same time Alerts are not transmitted anymore.

Document ID : KB000085632
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): 1

Error Message :
Unijob log:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| 2013-08-19 05:59:20 |ERROR|IO |pid=14400.-160212080| k_handshakeAuthent | authentication to [AUT]/[y001f0o] failed, status [5]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

uvms log:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
on feature not supported for: [ env= [HSUIZA/h397000r/X] ; product= DOLLAR_UNIVERSE ]
| 2013-08-19 05:59:23 |INFO | consolidation-1-worker-558 | com.orsyp.central.consolidation.ConsolidationExtractCallable | com.orsyp.UnsupportedFeatureException:Consolidation feature not supported for: [ env= [UNISCH/hprdPOSIB2/X] ; product= DOLLAR_UNIVERSE ]
| 2013-08-19 05:59:23 |INFO | consolidation-1-worker-559 | com.orsyp.central.consolidation.ConsolidationExtractCallable | com.orsyp.UnsupportedFeatureException:Consolidation feature not supported for: [ env= [HSUIZA/h397000r/X] ; product= DOLLAR_UNIVERSE ]
| 2013-08-19 06:00:40 |ERROR| request-worker-596 | org.hibernate.util.JDBCExceptionReporter | Échec de la connexion TCP/IP à l'hôte . java.net.ConnectException: Connection refused
| 2013-08-19 06:00:40 |ERROR| request-worker-596 | org.hibernate.util.JDBCExceptionReporter | Échec de la connexion TCP/IP à l'hôte . java.net.ConnectException: Connection refused
| 2013-08-19 06:00:40 |ERROR| request-worker-596 | org.hibernate.util.JDBCExceptionReporter | Échec de la connexion TCP/IP à l'hôte . java.net.ConnectException: Connection refused
| 2013-08-19 06:00:42 |ERROR| request-worker-596 | org.hibernate.util.JDBCExceptionReporter | Échec de la connexion TCP/IP à l'hôte . java.net.ConnectException: Connection refused
| 2013-08-19 06:00:42 |ERROR| request-worker-596 | org.hibernate.util.JDBCExceptionReporter | Échec de la connexion TCP/IP à l'hôte . java.net.ConnectException: Connection refused
| 2013-08-19 06:00:44 |ERROR| request-worker-596 | org.hibernate.util.JDBCExceptionReporter | Échec de la connexion TCP/IP à l'hôte . java.net.ConnectException: Connection refused
| 2013-08-19 06:00:44 |ERROR| request-worker-596 | org.hibernate.util.JDBCExceptionReporter | Échec de la connexion TCP/IP à l'hôte . java.net.ConnectException: Connection refused
| 2013-08-19 06:01:31 |ERROR| request-worker-596 | org.hibernate.util.JDBCExceptionReporter | Cannot open database "UNIDU" requested by the login. The login failed.
| 2013-08-19 06:01:31 |ERROR| Check node status pool-1-Check OWLS/UJ node status-6 | org.hibernate.util.JDBCExceptionReporter | Cannot open database "UNIDU" requested by the login. The login failed.
| 2013-08-19 06:01:31 |ERROR| ConsolidationServiceExecutor | org.hibernate.util.JDBCExceptionReporter | Cannot open database "UNIDU" requested by the login. The login failed.
| 2013-08-19 06:01:31 |ERROR| ConsolidationServiceExecutor | com.orsyp.central.consolidation.ConsolidationServiceManager | Error reading the node status for unijob nodes:Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Cannot open connection
| 2013-08-19 06:01:31 |ERROR| ConsolidationServiceExecutor | org.hibernate.util.JDBCExceptionReporter | Cannot open database "UNIDU" requested by the login. The login failed.
| 2013-08-19 06:01:31 |ERROR| ConsolidationServiceExecutor | com.orsyp.central.consolidation.ConsolidationServiceManager$1 | Consolidation process encountered an error: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Cannot open connection
at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:427)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at com.orsyp.central.service.NetworkNodeService$$EnhancerByCGLIB$$9d21570d.getALLNodesWithNodeInfoForService()
at com.orsyp.central.consolidation.ConsolidationDUNodeProvider.getALLNodeList(ConsolidationDUNodeProvider.java:23)
at com.orsyp.central.consolidation.AbstractConsolidationNodeProvider.getNodeList(AbstractConsolidationNodeProvider.java:65)
at com.orsyp.central.consolidation.ConsolidationServiceManager.populateDuasDatasources(ConsolidationServiceManager.java:613)
at com.orsyp.central.consolidation.ConsolidationServiceManager.runService(ConsolidationServiceManager.java:489)
at com.orsyp.central.consolidation.ConsolidationServiceManager$1.run(ConsolidationServiceManager.java:401)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
.
.
.
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "UNIDU" requested by the login. The login failed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)

... 23 more

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Patch level detected:Unijob 1.4.0
Unijob shows connection with warning in Univiewer Console, at the same time Alerts are not transmitted anymore.
Environment:
OS: All
OS Version: ALL OS
Cause:
Cause type:
Configuration
Root Cause: The status "Connected with Warning" on the Unijob node means that the Unijob node cannot authenticate to the UVMS node.
In this case, the issue was due to a problem in the Database, not being reachable by the UVMS.
Resolution:
If using an external DB for UVMS and if it is MSSQL Server database, please make sure that the UVMS is installed on supported Windows operating system.

Fix Status: No Fix

Additional Information:
Workaround :
Restart UVMS and verify that the UVMS database is available.