DUAS Node appears with status "Unknown" after upgrading from v5 to v6
Article ID: 86928
Updated On:
Products
CA Automic Dollar Universe
Issue/Introduction
Error Message :
In uvserver.log file from UVMS:
======================================================================
| 2014-04-09 13:54:08 |ERROR| request-worker-12270 | org.hibernate.util.JDBCExceptionReporter | The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_NODES_INFO_NODE". The conflict occurred in database "ews_uvmsdb", table "dbo.UNI_UV_NODES", column 'ID'.
| 2014-04-09 13:54:08 |ERROR| request-worker-12270 | org.hibernate.event.def.AbstractFlushingEventListener | Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
=============================================================================
Patch level detected:Univiewer Management Server 6.2.00
After the upgrade from DUAS v5 to v6 on the UVC console the node appears with the Unknown connection status but it was reachable and objects / node settings could be displayed.
On UVC - UVMS Database Monitoring section is not possible to display the database tables
The UVMS was on version 6.2 with an external Database (MS SQL Server).
In uvserver.log file from UVMS:
======================================================================
| 2014-04-09 13:54:08 |ERROR| request-worker-12270 | org.hibernate.util.JDBCExceptionReporter | The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_NODES_INFO_NODE". The conflict occurred in database "ews_uvmsdb", table "dbo.UNI_UV_NODES", column 'ID'.
| 2014-04-09 13:54:08 |ERROR| request-worker-12270 | org.hibernate.event.def.AbstractFlushingEventListener | Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
=============================================================================
Patch level detected:Univiewer Management Server 6.2.00
After the upgrade from DUAS v5 to v6 on the UVC console the node appears with the Unknown connection status but it was reachable and objects / node settings could be displayed.
On UVC - UVMS Database Monitoring section is not possible to display the database tables
The UVMS was on version 6.2 with an external Database (MS SQL Server).
Cause
Cause type:
Other
Root Cause: A problem in the UVMS Database would not allow the modiification of the table UNI_UV_NODES
Other
Root Cause: A problem in the UVMS Database would not allow the modiification of the table UNI_UV_NODES
Environment
OS: All
Resolution
Restarting the UVMS allows to update again the impacted line of the table UNI_UV_NODES, as a result the node appeared as Connected again.
Fix Status: No Fix
Fix Status: No Fix
Feedback
Powered by
