cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

When I upgraded the thingworx version, an error occurred

旭王1
1-Newbie

When I upgraded the thingworx version, an error occurred

2017-07-16 21:37:32 Commons Daemon procrun stderr initialized

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Server version:        Apache Tomcat/8.0.38

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Server built:          Oct 6 2016 20:51:55 UTC

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Server number:         8.0.38.0

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: OS Name:               Windows 7

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: OS Version:            6.1

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Architecture:          amd64

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Java Home:             C:\Program Files\Java\jre1.8.0_131

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: JVM Version:           1.8.0_131-b11

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: JVM Vendor:            Oracle Corporation

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 8.0

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 8.0

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Command line argument: -Dserver -Dd64

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Command line argument: -XX:+UseG1GC

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Command line argument: -Dfile.encoding=UTF-8

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Command line argument: -Djava.library.path=C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\Thingworx\WEB-INF\extensions

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.VersionLoggerListener log

信息: Command line argument: exit

七月 16, 2017 9:37:34 下午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent

信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\Thingworx\WEB-INF\extensions

七月 16, 2017 9:37:34 下午 org.apache.coyote.AbstractProtocol init

信息: Initializing ProtocolHandler ["http-nio-80"]

七月 16, 2017 9:37:34 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector

信息: Using a shared selector for servlet write/read

七月 16, 2017 9:37:34 下午 org.apache.coyote.AbstractProtocol init

信息: Initializing ProtocolHandler ["ajp-nio-8009"]

七月 16, 2017 9:37:34 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector

信息: Using a shared selector for servlet write/read

七月 16, 2017 9:37:34 下午 org.apache.catalina.startup.Catalina load

信息: Initialization processed in 2280 ms

七月 16, 2017 9:37:34 下午 org.apache.catalina.core.StandardService startInternal

信息: Starting service Catalina

七月 16, 2017 9:37:34 下午 org.apache.catalina.core.StandardEngine startInternal

信息: Starting Servlet Engine: Apache Tomcat/8.0.38

七月 16, 2017 9:37:35 下午 org.apache.catalina.startup.HostConfig deployWAR

信息: Deploying web application archive C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\Thingworx.war

七月 16, 2017 9:37:55 下午 org.apache.jasper.servlet.TldScanner scanJars

信息: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

七月 16, 2017 9:37:55 下午 org.apache.catalina.core.ApplicationContext log

信息: No Spring WebApplicationInitializer types detected on classpath

七月 16, 2017 9:38:09 下午 org.apache.catalina.startup.HostConfig deployWAR

信息: Deployment of web application archive C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\Thingworx.war has finished in 34,659 ms

七月 16, 2017 9:38:09 下午 org.apache.catalina.startup.HostConfig deployDirectory

信息: Deploying web application directory C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\docs

七月 16, 2017 9:38:09 下午 org.apache.catalina.startup.HostConfig deployDirectory

信息: Deployment of web application directory C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\docs has finished in 20 ms

七月 16, 2017 9:38:09 下午 org.apache.catalina.startup.HostConfig deployDirectory

信息: Deploying web application directory C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\manager

七月 16, 2017 9:38:09 下午 org.apache.catalina.startup.HostConfig deployDirectory

信息: Deployment of web application directory C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\manager has finished in 137 ms

七月 16, 2017 9:38:09 下午 org.apache.catalina.startup.HostConfig deployDirectory

信息: Deploying web application directory C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\ROOT

七月 16, 2017 9:38:09 下午 org.apache.catalina.startup.HostConfig deployDirectory

信息: Deployment of web application directory C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\ROOT has finished in 115 ms

七月 16, 2017 9:38:09 下午 org.apache.coyote.AbstractProtocol start

信息: Starting ProtocolHandler ["http-nio-80"]

七月 16, 2017 9:38:09 下午 org.apache.coyote.AbstractProtocol start

信息: Starting ProtocolHandler ["ajp-nio-8009"]

七月 16, 2017 9:38:09 下午 org.apache.catalina.startup.Catalina start

信息: Server startup in 35088 ms

七月 16, 2017 9:38:49 下午 org.apache.catalina.core.ApplicationContext log

信息: HTMLManager: init: Associated with Deployer 'Catalina:type=Deployer,host=localhost'

七月 16, 2017 9:38:49 下午 org.apache.catalina.core.ApplicationContext log

信息: HTMLManager: init: Global resources are available

七月 16, 2017 9:38:49 下午 org.apache.catalina.core.ApplicationContext log

信息: HTMLManager: list: Listing contexts for virtual host 'localhost'

talina.startup.HostConfig.deployWAR(HostConfig.java:940)

at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1816)

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)

Caused by: org.postgresql.util.PSQLException: ERROR: relation "notificationcontent_model" does not exist

  位置:355

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)

at com.thingworx.persistence.postgres.dao.PostgresModelDao.getAllEntities(PostgresModelDao.java:76)

... 25 more

com.thingworx.common.exceptions.ModelAccessException: ERROR: current transaction is aborted, commands ignored until end of transaction block

at com.thingworx.persistence.postgres.PostgresModelExceptionTranslator.rethrowTranslated(PostgresModelExceptionTranslator.java:27)

at com.thingworx.persistence.postgres.PostgresDocumentModelDriver.getRootEntityCollectionId(PostgresDocumentModelDriver.java:619)

at com.thingworx.persistence.documentmodel.RootEntityCollectionDocumentModelProvider.fromStorage(RootEntityCollectionDocumentModelProvider.java:31)

at com.thingworx.system.managers.BaseManager.initializeCollection(BaseManager.java:125)

at com.thingworx.system.entities.ThingWorxEntityManager.initializeCollections(ThingWorxEntityManager.java:212)

at com.thingworx.system.ThingWorxServer.createSystemEntities(ThingWorxServer.java:997)

at com.thingworx.system.ThingWorxServer.loadModel(ThingWorxServer.java:499)

at com.thingworx.system.ThingWorxServer.doHA(ThingWorxServer.java:193)

at com.thingworx.system.ThingWorxBootstrapper.contextInitialized(ThingWorxBootstrapper.java:152)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4853)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:940)

at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1816)

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)

Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)

at com.thingworx.persistence.postgres.PostgresDocumentModelDriver.getRootEntityCollectionId(PostgresDocumentModelDriver.java:612)

... 20 more

java.lang.Exception: Unable to initialize and start system: Import Failed: Unable to create data shape: ERROR: current transaction is aborted, commands ignored until end of transaction block

at com.thingworx.system.ThingWorxServer.loadModel(ThingWorxServer.java:534)

at com.thingworx.system.ThingWorxServer.doHA(ThingWorxServer.java:193)

at com.thingworx.system.ThingWorxBootstrapper.contextInitialized(ThingWorxBootstrapper.java:152)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4853)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:940)

at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1816)

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)

3 REPLIES 3
supandey
19-Tanzanite
(To:旭王1)

Are you still having this issue (i see that the question is marked as assumed answered). There seems be an issue with the DB table/relation  notificationcontent_model

If you still having this issue, could share which Persistence provider you are using? From which version of the ThingWorx and Persistence Provider are you upgrading?

I think you did not execute the bat script that I was ignoring before. You can tell me how you are upgrading I can see where the problem lies

rvecchiato
13-Aquamarine
(To:旭王1)

Even if the question maybe has been already solved months ago, I am writing here a reference that could be useful.

 

The same error could happen creating a second persistence provider, please follow this guide:

https://www.ptc.com/en/support/article?n=CS262935

Top Tags