2 Replies Latest reply on Jul 19, 2017 9:24 AM by 旭王 RSS
    旭王 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)