Article - CS163464

“wt.pom.ConnectionException” error reported in MethodServer.log in Windchill PDMLink

Modified: 04-Sep-2024   


Applies To

  • Windchill PDMLink 10.0 to 13.0

Description

  • Multiple wt.pom.ConnectionException error printed in the MethodServer logs
WARN [wt.log4j.jmx.AsyncJDBCAppender.flushScheduler] wt.log4j.jmx.AsyncJDBCAppender - MiscLogEvents: Already shutdown, log record discarded
WARN [wt.log4j.jmx.AsyncJDBCAppender.flushScheduler] wt.log4j.jmx.AsyncJDBCAppender - ServletRequests: Already shutdown, log record discarded
WARN [wt.log4j.jmx.AsyncJDBCAppender.flushScheduler] wt.log4j.jmx.AsyncJDBCAppender - MethodContexts: Already shutdown, log record discarded
WARN [wt.log4j.jmx.AsyncJDBCAppender.flushScheduler] wt.log4j.jmx.AsyncJDBCAppender - TopSQLStats: Already shutdown, log record discarded
yyyy-mm-dd 02:05:11,209 ERROR [wt.fv.FileServersImpl.notifyVaultStatusTimer] wt.fv.FileServersImpl Administrator - A SQL error has occurred. Database system message follows:
Nested exception is: wt.pom.ConnectionException(Ok if installation)
wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
Nested exception is: wt.pom.ConnectionException
at wt.pom.POMHandler.getConnection(POMHandler.java:87)
at wt.method.MethodContext.getConnection(MethodContext.java:2122)
at wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:322)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1099)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1015)
at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1829)
at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:1858)
at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:675)
at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:427)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy9.find(Unknown Source)
at wt.fv.FvSurrogate.doGetVaultsOfType(FvSurrogate.java:274)
at wt.fv.StandardFvService.getLocalVaults(StandardFvService.java:3875)
at sun.reflect.GeneratedMethodAccessor243.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy43.getLocalVaults(Unknown Source)
at wt.fv.FileServersImpl.notifyVaultStatus(FileServersImpl.java:347)
at wt.fv.FileServersImpl$NotifyVaultStatusTask.run(FileServersImpl.java:227)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Or
wt.queue.PoolQueue.WfPropagationQueue ### - Exception in doWait() wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
Nested exception is: wt.pom.ConnectionException
	at wt.pom.POMHandler.getConnection(POMHandler.java:88)
	at wt.method.MethodContext.getConnection(MethodContext.java:2436)
	at wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:304)
	at wt.pom.Transaction._start(Transaction.java:693)
	at wt.pom.Transaction.start(Transaction.java:654)
	at wt.queue.WtQueueThread.doWait(WtQueueThread.java:311)
	at wt.queue.RandomAccessQueueThread.run(RandomAccessQueueThread.java:380)
Or
ERROR [ajp-nio-127.0.0.1-8010-exec-207] com.ptc.core.components.jsp.JspUtils ### - A persistence error occurred.
wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
Nested exception is: wt.pom.ConnectionException
	at wt.pom.POMHandler.getConnection(POMHandler.java:88)
	at wt.method.MethodContext.getConnection(MethodContext.java:2442)
	at wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:303)
	at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1069)
	at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:985)
	at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972)
	at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2008)
	at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:655)
	at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:407)
	at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
This is a printer-friendly version of Article 163464 and may be out of date. For the latest version click CS163464