Unijob shows "Connection with warning" in UVMS, at the same time Alerts are not transmitted anymore.
Article ID: 85632
Updated On:
Products
CA Automic Dollar Universe
Issue/Introduction
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.
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
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.
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
Fix Status: No Fix
Additional Information
Workaround :
Restart UVMS and verify that the UVMS database is available.
Restart UVMS and verify that the UVMS database is available.
Feedback
Yes
No
Powered by
