installing NMS (NetSight) in Windows "404 - Not Found"

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
Hi All,

Upon installing NMS (NetSight) in Windows  I encountered "404 - Not Found" when I trying to log in it to web browser.

https://IP address:8443

https://IP address:8080

https://domain-name:8080

https://domain-name:8443

Can you help me on this?

Thanks,
Nino
Photo of Nino

Nino

  • 80 Points 75 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Nico Willamowski

Nico Willamowski

  • 886 Points 500 badge 2x thumb

Hello,


last week we have the same Problem. We have NetSight 7.3 and make a Backup. After restore the Backup in NetSight 8.0.5 on a new server, the Restore was failed. After this issue it was not possible to beame a log in window. So we upgrade the NetSight 7.3 to 8.0.5 backup the Netsight and restore it on the new Server.

Photo of Kurt Semba

Kurt Semba, Employee

  • 1,364 Points 1k badge 2x thumb
Please check your server log and if you find warnings or errors post them here. It should be under your installation folder: ...\Extreme Networks\NetSight\appdata\logs\server.log

Thanks
Photo of Volker Kull

Volker Kull

  • 1,740 Points 1k badge 2x thumb
Hi !

We did several upgrades form V7 to V8.05. At the first time we had (or we thought we had) the same issue. The second try shows us the problem: XMS needs up to 2 hours for migrating/building database ...
So try to keep calm and wait and look at the logs and netstat.

Knowing that we had never again a failed upgrade...

br
Volker
Photo of Resolut1on

Resolut1on

  • 836 Points 500 badge 2x thumb
Hi Nico,Kurt,Volker,

As I am reading your replies, he need to check first the logs right?
Is there any needed upgrade or downgrade in versions?

Thanks and best regards,
Newbie
Photo of Nico Willamowski

Nico Willamowski

  • 886 Points 500 badge 2x thumb
@Volker: We wait 36 hours and the webfront wasn ́t reachable. At our site the restore was failed. In this case he doesn ́t build any database.
Photo of Volker Kull

Volker Kull

  • 1,740 Points 1k badge 2x thumb
Did you change the OS from backup to restore point?
Which versions do you use ?
Was the previous version on a windows server ?
What does the log say ?

Volker
Photo of Volker Kull

Volker Kull

  • 1,740 Points 1k badge 2x thumb
Check release notes XMC 8.0.5:
https://documentation.extremenetworks.com/release_notes/NetSight/9035078-09_ExtremeManagementCenter_...

Upgrade Information Extreme Management Center 8.0.5 supports upgrades from Extreme Management Center version 7.1.3 only. If you are upgrading from a NetSight/Extreme Management Center version prior to 7.1.3, you must perform an intermediate upgrade. For example, if you are upgrading from Extreme Management Center 7.0, you must first upgrade to Extreme Management Center 7.1.3, and then upgrade to Extreme Management Center 8.0.5.
IMPORTANT:
When performing an upgrade, be sure to back up the database prior to performing the upgrade, and save it to a safe location. Use the Administration > Backup/Restore tab to perform the backup.
The NetSight Server service may not start after upgrading Extreme Management Center to version 8.0.5 on a system on which the Windows Server 2008 operating system is installed. Restarting Windows corrects this issue.
When upgrading the Application Analytics engines to version 8.0.5 after upgrading from version 6.1 to 7.1.3, the upgrade does not complete successfully. To successfully upgrade the engine to version 8.0.5 after upgrading from version 6.1 to 7.1.3, enter dpkg --purge postgresql* in the command line, then upgrade the Application Analytics engine to version 8.0.5.
Important Upgrade Considerations l
When upgrading the Extreme Management Center server, Application Analytics engine, or Extreme Access Control engine to version 8.0.5, ensure the DNS server IP address is correctly configured. Additionally, upgrading requires an internet connection and may take additional time due to the upgrade of the Linux Ubuntu operating system from version 12 to version 14. During this time, the engine may not be accessible via SSH. If no internet connection is available, see Migrating or Upgrading to a 64-bit Extreme Management Center Engine.

Volker
Photo of Nino

Nino

  • 80 Points 75 badge 2x thumb
To all,

Version: Extreme Management Center Suite 8.1.0.52
OS: Windows 10


LOGS:
2018-01-22 14:52:16,516 INFO  [org.jboss.as] WFLYSRV0049: WildFly Full 10.1.0.Final (WildFly Core 2.2.0.Final) starting
2018-01-22 14:52:59,681 INFO  [org.jboss.as.server] WFLYSRV0039: Creating http management service using socket-binding (management-http)
2018-01-22 14:52:59,969 INFO  [org.jboss.as.security] WFLYSEC0002: Activating Security Subsystem
2018-01-22 14:52:59,981 INFO  [org.jboss.as.clustering.infinispan] WFLYCLINF0001: Activating Infinispan subsystem.
2018-01-22 14:53:00,036 INFO  [org.jboss.as.security] WFLYSEC0001: Current PicketBox version=4.9.6.Final
2018-01-22 14:53:00,263 INFO  [org.jboss.as.naming] WFLYNAM0001: Activating Naming Subsystem
2018-01-22 14:53:00,381 INFO  [org.jboss.remoting] JBoss Remoting version 4.0.25.1
2018-01-22 14:53:00,407 INFO  [org.jboss.as.naming] WFLYNAM0003: Starting Naming Service
2018-01-22 14:53:00,410 INFO  [org.jboss.as.mail.extension] WFLYMAIL0001: Bound mail session [java:jboss/mail/Default]
2018-01-22 14:53:18,651 INFO  [org.jboss.as.clustering.infinispan] WFLYCLINF0002: Started default-host cache from web container
2018-01-22 14:55:55,252 INFO  [org.jboss.as.jpa] WFLYJPA0002: Read persistence.xml for DefaultDS
2018-01-22 14:55:55,252 INFO  [org.jboss.as.jpa] WFLYJPA0002: Read persistence.xml for ReportDS
2018-01-22 14:56:53,761 INFO  [org.jboss.as.jpa] WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'Monitor.war#DefaultDS'
2018-01-22 14:56:53,761 INFO  [org.jboss.as.jpa] WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'Monitor.war#ReportDS'
2018-01-22 14:56:58,676 INFO  [org.jboss.weld.Version] WELD-000900: 2.3.5 (Final)
2018-01-22 14:59:29,219 INFO  [org.jboss.as.jpa] WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'Monitor.war#ReportDS'
2018-01-22 14:59:29,225 INFO  [org.jboss.as.jpa] WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'Monitor.war#DefaultDS'
2018-01-22 14:59:42,082 INFO  [com.enterasys.netsight.api.ServerInfoLogger] No antivirus software detected.
2018-01-22 14:59:42,116 INFO  [com.enterasys.netsight.api.ServerInfoLogger] ** The NetSight server is binding to override IP address: 192.168.10.162  **
2018-01-22 14:59:42,169 INFO  [com.enterasys.netsight.api.ServerInfoLogger] Server using -Xmx4g.
2018-01-22 15:05:51,591 INFO  [org.jboss.as.server] WFLYSRV0220: Server shutdown has been requested via an OS signal
2018-01-22 15:05:51,919 INFO  [org.jboss.as.clustering.infinispan] WFLYCLINF0003: Stopped default-host cache from web container
2018-01-22 15:06:03,638 ERROR [com.enterasys.netsight.database.BaseDatabaseContext] Failed- ALTER TABLE NSGROUPTOPROFILE ADD CONSTRAINT FK_NSGROUPTOPROFILE_TO_NSUSERGROUPS_13 FOREIGN KEY (GROUPID) REFERENCES NSUSERGROUPS(GROUPID) ON DELETE CASCADE;: com.enterasys.netsight.database.exception.DataAccessException: ALTER TABLE NSGROUPTOPROFILE ADD CONSTRAINT FK_NSGROUPTOPROFILE_TO_NSUSERGROUPS_13 FOREIGN KEY (GROUPID) REFERENCES NSUSERGROUPS(GROUPID) ON DELETE CASCADE;
at com.enterasys.netsight.database.exception.SQLStateSQLExceptionTranslater.translate(SQLStateSQLExceptionTranslater.java:50)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:143)
at com.enterasys.netsight.database.BaseDatabaseContext.createSchemaTables(BaseDatabaseContext.java:725)
at com.enterasys.netsight.tools.database.SchemaUtils.updateSchema(SchemaUtils.java:436)
at com.enterasys.netsight.tools.database.SchemaUtils.registerSchema(SchemaUtils.java:369)
at com.enterasys.netsight.server.ServerContext.createSchema(ServerContext.java:436)
at com.enterasys.netsight.server.ServerContext.init(ServerContext.java:284)
at com.enterasys.netsight.server.ServerContext.initialize(ServerContext.java:220)
at com.enterasys.netsight.server.jmx.NetSight.createService(NetSight.java:94)
at com.extreme.services.ServiceMain.createService(ServiceMain.java:152)
at com.extreme.services.ServiceMain.createServices(ServiceMain.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:114)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.ManagedReferenceFieldInjectionInterceptorFactory$ManagedReferenceFieldInjectionInterceptor.processInvocation(ManagedReferenceFieldInjectionInterceptorFactory.java:107)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.singleton.StartupCountDownInterceptor.processInvocation(StartupCountDownInterceptor.java:25)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134)
at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:124)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:138)
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 4,875 milliseconds ago.  The last packet sent successfully to the server was 4,875 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3556)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3456)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3897)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739)
at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:140)
... 63 more
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3008)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3466)
... 73 more

2018-01-22 15:06:03,669 ERROR [com.enterasys.netsight.database.BaseDatabaseContext] Failed- ALTER TABLE NSGROUPTOPROFILE ADD CONSTRAINT FK_NSGROUPTOPROFILE_TO_NSPROFILES_14 FOREIGN KEY (PROFILEID) REFERENCES NSPROFILES(PROFILEID) ON DELETE CASCADE;: com.enterasys.netsight.database.exception.DataAccessException: ALTER TABLE NSGROUPTOPROFILE ADD CONSTRAINT FK_NSGROUPTOPROFILE_TO_NSPROFILES_14 FOREIGN KEY (PROFILEID) REFERENCES NSPROFILES(PROFILEID) ON DELETE CASCADE;
at com.enterasys.netsight.database.exception.SQLStateSQLExceptionTranslater.translate(SQLStateSQLExceptionTranslater.java:50)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:143)
at com.enterasys.netsight.database.BaseDatabaseContext.createSchemaTables(BaseDatabaseContext.java:725)
at com.enterasys.netsight.tools.database.SchemaUtils.updateSchema(SchemaUtils.java:436)
at com.enterasys.netsight.tools.database.SchemaUtils.registerSchema(SchemaUtils.java:369)
at com.enterasys.netsight.server.ServerContext.createSchema(ServerContext.java:436)
at com.enterasys.netsight.server.ServerContext.init(ServerContext.java:284)
at com.enterasys.netsight.server.ServerContext.initialize(ServerContext.java:220)
at com.enterasys.netsight.server.jmx.NetSight.createService(NetSight.java:94)
at com.extreme.services.ServiceMain.createService(ServiceMain.java:152)
at com.extreme.services.ServiceMain.createServices(ServiceMain.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:114)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.ManagedReferenceFieldInjectionInterceptorFactory$ManagedReferenceFieldInjectionInterceptor.processInvocation(ManagedReferenceFieldInjectionInterceptorFactory.java:107)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.singleton.StartupCountDownInterceptor.processInvocation(StartupCountDownInterceptor.java:25)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134)
at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:124)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:138)
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@22842a9c
at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)
at org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:337)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:139)
... 63 more

2018-01-22 15:06:03,732 ERROR [com.enterasys.netsight.database.BaseDatabaseContext] Failed- ALTER TABLE NSALARMCATEGORYELEMS ADD CONSTRAINT FK_NSALARMCATEGORYELEMS_TO_NSALARMDEFS_15 FOREIGN KEY (ALARMID) REFERENCES NSALARMDEFS(ID) ON DELETE CASCADE;: com.enterasys.netsight.database.exception.DataAccessException: ALTER TABLE NSALARMCATEGORYELEMS ADD CONSTRAINT FK_NSALARMCATEGORYELEMS_TO_NSALARMDEFS_15 FOREIGN KEY (ALARMID) REFERENCES NSALARMDEFS(ID) ON DELETE CASCADE;
at com.enterasys.netsight.database.exception.SQLStateSQLExceptionTranslater.translate(SQLStateSQLExceptionTranslater.java:50)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:143)
at com.enterasys.netsight.database.BaseDatabaseContext.createSchemaTables(BaseDatabaseContext.java:725)
at com.enterasys.netsight.tools.database.SchemaUtils.updateSchema(SchemaUtils.java:436)
at com.enterasys.netsight.tools.database.SchemaUtils.registerSchema(SchemaUtils.java:369)
at com.enterasys.netsight.server.ServerContext.createSchema(ServerContext.java:436)
at com.enterasys.netsight.server.ServerContext.init(ServerContext.java:284)
at com.enterasys.netsight.server.ServerContext.initialize(ServerContext.java:220)
at com.enterasys.netsight.server.jmx.NetSight.createService(NetSight.java:94)
at com.extreme.services.ServiceMain.createService(ServiceMain.java:152)
at com.extreme.services.ServiceMain.createServices(ServiceMain.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:114)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.ManagedReferenceFieldInjectionInterceptorFactory$ManagedReferenceFieldInjectionInterceptor.processInvocation(ManagedReferenceFieldInjectionInterceptorFactory.java:107)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.singleton.StartupCountDownInterceptor.processInvocation(StartupCountDownInterceptor.java:25)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134)
at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:124)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:138)
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@22842a9c
at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)
at org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:337)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:139)
... 63 more

2018-01-22 15:06:03,794 ERROR [com.enterasys.netsight.database.BaseDatabaseContext] Failed- ALTER TABLE NSNETWORKRESOURCEGROUPMEMBERS ADD CONSTRAINT FK_NSNETWORKRESOURCEGROUPMEMBERS_TO_NSNETWORKRESOURCEGROUPS_16 FOREIGN KEY (RESOURCEGROUPID) REFERENCES NSNETWORKRESOURCEGROUPS(RESOURCEGROUPID) ON DELETE CASCADE;: com.enterasys.netsight.database.exception.DataAccessException: ALTER TABLE NSNETWORKRESOURCEGROUPMEMBERS ADD CONSTRAINT FK_NSNETWORKRESOURCEGROUPMEMBERS_TO_NSNETWORKRESOURCEGROUPS_16 FOREIGN KEY (RESOURCEGROUPID) REFERENCES NSNETWORKRESOURCEGROUPS(RESOURCEGROUPID) ON DELETE CASCADE;
at com.enterasys.netsight.database.exception.SQLStateSQLExceptionTranslater.translate(SQLStateSQLExceptionTranslater.java:50)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:143)
at com.enterasys.netsight.database.BaseDatabaseContext.createSchemaTables(BaseDatabaseContext.java:725)
at com.enterasys.netsight.tools.database.SchemaUtils.updateSchema(SchemaUtils.java:436)
at com.enterasys.netsight.tools.database.SchemaUtils.registerSchema(SchemaUtils.java:369)
at com.enterasys.netsight.server.ServerContext.createSchema(ServerContext.java:436)
at com.enterasys.netsight.server.ServerContext.init(ServerContext.java:284)
at com.enterasys.netsight.server.ServerContext.initialize(ServerContext.java:220)
at com.enterasys.netsight.server.jmx.NetSight.createService(NetSight.java:94)
at com.extreme.services.ServiceMain.createService(ServiceMain.java:152)
at com.extreme.services.ServiceMain.createServices(ServiceMain.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:114)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.ManagedReferenceFieldInjectionInterceptorFactory$ManagedReferenceFieldInjectionInterceptor.processInvocation(ManagedReferenceFieldInjectionInterceptorFactory.java:107)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.singleton.StartupCountDownInterceptor.processInvocation(StartupCountDownInterceptor.java:25)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134)
at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:124)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:138)
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@22842a9c
at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)
at org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:337)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:139)
... 63 more

2018-01-22 15:06:03,857 ERROR [com.enterasys.netsight.database.BaseDatabaseContext] Failed- ALTER TABLE NSGROUPTOCAPABILITY ADD CONSTRAINT FK_NSGROUPTOCAPABILITY_TO_NSUSERGROUPS_17 FOREIGN KEY (GROUPID) REFERENCES NSUSERGROUPS(GROUPID) ON DELETE CASCADE;: com.enterasys.netsight.database.exception.DataAccessException: ALTER TABLE NSGROUPTOCAPABILITY ADD CONSTRAINT FK_NSGROUPTOCAPABILITY_TO_NSUSERGROUPS_17 FOREIGN KEY (GROUPID) REFERENCES NSUSERGROUPS(GROUPID) ON DELETE CASCADE;
at com.enterasys.netsight.database.exception.SQLStateSQLExceptionTranslater.translate(SQLStateSQLExceptionTranslater.java:50)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:143)
at com.enterasys.netsight.database.BaseDatabaseContext.createSchemaTables(BaseDatabaseContext.java:725)
at com.enterasys.netsight.tools.database.SchemaUtils.updateSchema(SchemaUtils.java:436)
at com.enterasys.netsight.tools.database.SchemaUtils.registerSchema(SchemaUtils.java:369)
at com.enterasys.netsight.server.ServerContext.createSchema(ServerContext.java:436)
at com.enterasys.netsight.server.ServerContext.init(ServerContext.java:284)
at com.enterasys.netsight.server.ServerContext.initialize(ServerContext.java:220)
at com.enterasys.netsight.server.jmx.NetSight.createService(NetSight.java:94)
at com.extreme.services.ServiceMain.createService(ServiceMain.java:152)
at com.extreme.services.ServiceMain.createServices(ServiceMain.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:114)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.ManagedReferenceFieldInjectionInterceptorFactory$ManagedReferenceFieldInjectionInterceptor.processInvocation(ManagedReferenceFieldInjectionInterceptorFactory.java:107)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.singleton.StartupCountDownInterceptor.processInvocation(StartupCountDownInterceptor.java:25)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134)
at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:124)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:138)
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@22842a9c
at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)
at org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:337)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:139)
... 63 more

2018-01-22 15:06:03,904 ERROR [com.enterasys.netsight.database.BaseDatabaseContext] Failed- ALTER TABLE NSPORTDATA ADD CONSTRAINT FK_NSPORTDATA_TO_NSDEVICEENTITYDATA_18 FOREIGN KEY (DEVICEENTITYDATAID) REFERENCES NSDEVICEENTITYDATA(DEVICEENTITYDATAID) ON DELETE CASCADE;: com.enterasys.netsight.database.exception.DataAccessException: ALTER TABLE NSPORTDATA ADD CONSTRAINT FK_NSPORTDATA_TO_NSDEVICEENTITYDATA_18 FOREIGN KEY (DEVICEENTITYDATAID) REFERENCES NSDEVICEENTITYDATA(DEVICEENTITYDATAID) ON DELETE CASCADE;
at com.enterasys.netsight.database.exception.SQLStateSQLExceptionTranslater.translate(SQLStateSQLExceptionTranslater.java:50)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:143)
at com.enterasys.netsight.database.BaseDatabaseContext.createSchemaTables(BaseDatabaseContext.java:725)
at com.enterasys.netsight.tools.database.SchemaUtils.updateSchema(SchemaUtils.java:436)
at com.enterasys.netsight.tools.database.SchemaUtils.registerSchema(SchemaUtils.java:369)
at com.enterasys.netsight.server.ServerContext.createSchema(ServerContext.java:436)
at com.enterasys.netsight.server.ServerContext.init(ServerContext.java:284)
at com.enterasys.netsight.server.ServerContext.initialize(ServerContext.java:220)
at com.enterasys.netsight.server.jmx.NetSight.createService(NetSight.java:94)
at com.extreme.services.ServiceMain.createService(ServiceMain.java:152)
at com.extreme.services.ServiceMain.createServices(ServiceMain.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:114)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.ManagedReferenceFieldInjectionInterceptorFactory$ManagedReferenceFieldInjectionInterceptor.processInvocation(ManagedReferenceFieldInjectionInterceptorFactory.java:107)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.singleton.StartupCountDownInterceptor.processInvocation(StartupCountDownInterceptor.java:25)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134)
at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:124)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:138)
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@22842a9c
at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)
at org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:337)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:139)
... 63 more

2018-01-22 15:06:03,950 ERROR [com.enterasys.netsight.database.BaseDatabaseContext] Failed- ALTER TABLE NSDEVICEPORTVLANDATA ADD CONSTRAINT FK_NSDEVICEPORTVLANDATA_TO_NSDEVICEVLANDATA_19 FOREIGN KEY (DEVICEVLANID) REFERENCES NSDEVICEVLANDATA(DEVICEVLANID) ON DELETE CASCADE;: com.enterasys.netsight.database.exception.DataAccessException: ALTER TABLE NSDEVICEPORTVLANDATA ADD CONSTRAINT FK_NSDEVICEPORTVLANDATA_TO_NSDEVICEVLANDATA_19 FOREIGN KEY (DEVICEVLANID) REFERENCES NSDEVICEVLANDATA(DEVICEVLANID) ON DELETE CASCADE;
at com.enterasys.netsight.database.exception.SQLStateSQLExceptionTranslater.translate(SQLStateSQLExceptionTranslater.java:50)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:143)
at com.enterasys.netsight.database.BaseDatabaseContext.createSchemaTables(BaseDatabaseContext.java:725)
at com.enterasys.netsight.tools.database.SchemaUtils.updateSchema(SchemaUtils.java:436)
at com.enterasys.netsight.tools.database.SchemaUtils.registerSchema(SchemaUtils.java:369)
at com.enterasys.netsight.server.ServerContext.createSchema(ServerContext.java:436)
at com.enterasys.netsight.server.ServerContext.init(ServerContext.java:284)
at com.enterasys.netsight.server.ServerContext.initialize(ServerContext.java:220)
at com.enterasys.netsight.server.jmx.NetSight.createService(NetSight.java:94)
at com.extreme.services.ServiceMain.createService(ServiceMain.java:152)
at com.extreme.services.ServiceMain.createServices(ServiceMain.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:114)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.ManagedReferenceFieldInjectionInterceptorFactory$ManagedReferenceFieldInjectionInterceptor.processInvocation(ManagedReferenceFieldInjectionInterceptorFactory.java:107)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.singleton.StartupCountDownInterceptor.processInvocation(StartupCountDownInterceptor.java:25)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134)
at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:124)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:138)
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@22842a9c
at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)
at org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:337)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:139)
... 63 more

2018-01-22 15:06:04,013 ERROR [com.enterasys.netsight.database.BaseDatabaseContext] Failed- ALTER TABLE NSDEVICEPORTVLANDATA ADD CONSTRAINT FK_NSDEVICEPORTVLANDATA_TO_NSPORTDATA_20 FOREIGN KEY (DEVICEPORTDATAID) REFERENCES NSPORTDATA(DEVICEPORTDATAID) ON DELETE CASCADE;: com.enterasys.netsight.database.exception.DataAccessException: ALTER TABLE NSDEVICEPORTVLANDATA ADD CONSTRAINT FK_NSDEVICEPORTVLANDATA_TO_NSPORTDATA_20 FOREIGN KEY (DEVICEPORTDATAID) REFERENCES NSPORTDATA(DEVICEPORTDATAID) ON DELETE CASCADE;
at com.enterasys.netsight.database.exception.SQLStateSQLExceptionTranslater.translate(SQLStateSQLExceptionTranslater.java:50)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:143)
at com.enterasys.netsight.database.BaseDatabaseContext.createSchemaTables(BaseDatabaseContext.java:725)
at com.enterasys.netsight.tools.database.SchemaUtils.updateSchema(SchemaUtils.java:436)
at com.enterasys.netsight.tools.database.SchemaUtils.registerSchema(SchemaUtils.java:369)
at com.enterasys.netsight.server.ServerContext.createSchema(ServerContext.java:436)
at com.enterasys.netsight.server.ServerContext.init(ServerContext.java:284)
at com.enterasys.netsight.server.ServerContext.initialize(ServerContext.java:220)
at com.enterasys.netsight.server.jmx.NetSight.createService(NetSight.java:94)
at com.extreme.services.ServiceMain.createService(ServiceMain.java:152)
at com.extreme.services.ServiceMain.createServices(ServiceMain.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:114)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.ManagedReferenceFieldInjectionInterceptorFactory$ManagedReferenceFieldInjectionInterceptor.processInvocation(ManagedReferenceFieldInjectionInterceptorFactory.java:107)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103)
at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.ejb3.component.singleton.StartupCountDownInterceptor.processInvocation(StartupCountDownInterceptor.java:25)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134)
at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:124)
at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:138)
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@22842a9c
at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)
at org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:337)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:139)
... 63 more

2018-01-22 15:06:04,075 ERROR [com.enterasys.netsight.database.BaseDatabaseContext] Failed- ALTER TABLE NSPHYSICALENTITYDATA ADD CONSTRAINT FK_NSPHYSICALENTITYDATA_TO_NSDEVICEENTITYDATA_21 FOREIGN KEY (DEVICEENTITYDATAID) REFERENCES NSDEVICEENTITYDATA(DEVICEENTITYDATAID) ON DELETE CASCADE;: com.enterasys.netsight.database.exception.DataAccessException: ALTER TABLE NSPHYSICALENTITYDATA ADD CONSTRAINT FK_NSPHYSICALENTITYDATA_TO_NSDEVICEENTITYDATA_21 FOREIGN KEY (DEVICEENTITYDATAID) REFERENCES NSDEVICEENTITYDATA(DEVICEENTITYDATAID) ON DELETE CASCADE;
at com.enterasys.netsight.database.exception.SQLStateSQLExceptionTranslater.translate(SQLStateSQLExceptionTranslater.java:50)
at com.enterasys.netsight.database.BasePersistenceManager.execute(BasePersistenceManager.java:143)
at com.enterasys.netsight.database.BaseDatabaseContext.createSchemaTables(BaseDatabaseContext.java:725)
at com.enterasys.netsight.tools.database.SchemaUtils.updateSchema(SchemaUtils.java:436)
at com.enterasys.netsight.tools.database.SchemaUtils.registerSchema(SchemaUtils.java:369)
at com.enterasys.netsight.server.ServerContext.createSchema(ServerContext.java:436)
at com.enterasys.netsight.server.ServerContext.init(ServerContext.java:284)
at com.enterasys.netsight.server.ServerContext.initialize(ServerContext.java:220)
at com.enterasys.netsight.server.jmx.NetSight.createService(NetSight.java:94)
at com.extreme.services.ServiceMain.createService(ServiceMain.java:152)
at com.extreme.services.ServiceMain.createServices(ServiceMain.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:114)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor
Photo of James A

James A, Embassador

  • 6,586 Points 5k badge 2x thumb
Looks like the MySQL database isn't running?
Photo of FURKAN SABANCI

FURKAN SABANCI

  • 114 Points 100 badge 2x thumb
Hi Nino ,

I had the same error 1 month ago in 8.1 version. Just re- installed same version of netsight.exe and it worked . I didn't get backup, all of my database same and runnig now.

Thanks
Furkan