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

book

Article ID: 85632

calendar_today

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.

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.

Environment

OS: All
OS Version: ALL OS

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.