Article - CS419213

ServerManager failed to startup with error "seconds java.lang.IllegalStateException: Invalid JDBC connection" in Windchill PDMLink

Modified: 31-May-2024   


Applies To

  • Windchill PDMLink 12.0

Description

  • Unable to connect SQL Database with Windchill PDMLink
  • Failed to connect Windchill PDMLink with Database 
  • Unable to start the MethodServer in Windchill PDMLink
  • ServerManager is getting the below error:
ERROR [RMI TCP Connection(2)<ip_address>] wt.manager.CacheMasterNegotiator - isValid() returned false for ConnectionID:2 ClientConnectionId: java.lang.IllegalStateException: Invalid JDBC connection
	at wt.manager.CacheMasterNegotiator.isConnectionValid(CacheMasterNegotiator.java:1350)
	at wt.manager.CacheMasterNegotiator.isConnectionValid(CacheMasterNegotiator.java:1317)
	at wt.manager.CacheMasterNegotiator.refreshConnection(CacheMasterNegotiator.java:850)
	at wt.manager.CacheMasterNegotiator.forceRMIStubUpdate(CacheMasterNegotiator.java:823)
	at wt.manager.CacheMasterNegotiator.getMasterStub(CacheMasterNegotiator.java:761)
	at wt.manager.ServerManagerImpl.getMaster(ServerManagerImpl.java:728)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.
 
 ERROR [RMI Unreferenced-0] wt.cache.server.com.ptc.core.meta.server.impl.LogicalIdentifiedCacheMgr - Ignoring...
 ERROR [RMI TCP Connection(2)- wt.manager.CacheMasterNegotiator - fetchRMIStubUpdate() failed com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1090)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:3461)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:3112)
	at wt.manager.CacheMasterNegotiator$ConnectionInvocationHandler.prepareStatement(CacheMasterNegotiator.java:2584)
	at wt.manager.CacheMasterNegotiator$ConnectionInvocationHandler.invoke(CacheMasterNegotiator.java:2551)
	at wt.manager.$Proxy22.prepareStatement(Unknown Source)
	at wt.manager.CacheMasterNegotiator.getRMIStub(CacheMasterNegotiator.java:1161)
	at wt.manager.CacheMasterNegotiator.fetchRMIStubUpdate(CacheMasterNegotiator.java:1135)
	at wt.manager.CacheMasterNegotiator.forceRMIStubUpdate(CacheMasterNegotiator.java:811)

 
This is a printer-friendly version of Article 419213 and may be out of date. For the latest version click CS419213