Unable to import a ThingShape file right after it ...

htran-21 · ‎Sep 08, 2019

Hi,

The error is 406 Not Acceptable.

2019-09-08 18:28:17.766-0500 [L: ERROR] [O: E.c.t.w.Importer] [I: ] [U: thingworxRead] [S: ] [T: http-nio-192.168.230.139-443-exec-44] [message: Import Failed: java.lang.NullPointerException] com.thingworx.contentmanagement.ImportProcessor.processImport(ImportProcessor.java:1764)

...

Wrapped by: com.thingworx.common.exceptions.ModelAccessException: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.

The detail error in Error log is

2019-09-08 18:28:17.766-0500 [L: ERROR] [O: E.c.t.w.Importer] [I: ] [U: thingworxRead] [S: ] [T: http-nio-192.168.230.139-443-exec-44] [message: Import Failed: java.lang.NullPointerException] java.lang.NullPointerException: null
Wrapped by: java.lang.Exception: Import Failed: java.lang.NullPointerException
	at com.thingworx.contentmanagement.ImportProcessor.processImport(ImportProcessor.java:1764)
	at com.thingworx.webservices.Importer.processImport(Importer.java:342)
	at com.thingworx.webservices.Importer.importFromAttachment(Importer.java:195)
	at com.thingworx.webservices.Importer.service(Importer.java:153)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.thingworx.security.contenttype.ContentTypeFilter.doFilter(ContentTypeFilter.java:109)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.thingworx.security.filter.ValidationFilter.doFilter(ValidationFilter.java:22)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.thingworx.security.authentication.AuthenticationFilter.propagateRequest(AuthenticationFilter.java:479)
	at com.thingworx.security.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:172)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.thingworx.security.filter.ClickjackFilter.doFilter(ClickjackFilter.java:188)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.thingworx.security.filter.ProhibitIfNotLeaderFilter.doFilter(ProhibitIfNotLeaderFilter.java:120)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.thingworx.security.filter.HttpResponseHeadersFilter.doFilter(HttpResponseHeadersFilter.java:173)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1533)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1489)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
2019-09-08 18:29:42.085-0500 [L: ERROR] [O: E.c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: ] [S: ] [T: pool-22-thread-1] [message: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.] com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:710)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:2953)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:2592)
	at sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask.run(GooGooStatementCache.java:547)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Wrapped by: java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread.
	at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:571)
	at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkoutStatement(GooGooStatementCache.java:204)
	at com.mchange.v2.c3p0.impl.NewPooledConnection.checkoutStatement(NewPooledConnection.java:321)
	at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:1086)
	at com.thingworx.persistence.mssql.MssqlDocumentModelDriver.getAllReservations(MssqlDocumentModelDriver.java:880)
	... 10 common frames omitted
Wrapped by: com.thingworx.common.exceptions.ModelAccessException: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.
	at com.thingworx.persistence.mssql.MssqlModelExceptionTranslator.rethrowTranslated(MssqlModelExceptionTranslator.java:28)
	at com.thingworx.persistence.mssql.MssqlDocumentModelDriver.getAllReservations(MssqlDocumentModelDriver.java:898)
	at com.thingworx.persistence.documentmodel.FileTransferDocumentModelProvider.getFileTransferReservations(FileTransferDocumentModelProvider.java:112)
	at com.thingworx.system.subsystems.filetransfer.engine.TransferReservationService.getAllReservations(TransferReservationService.java:300)
	at com.thingworx.system.subsystems.filetransfer.engine.ReservationReclaimer.run(ReservationReclaimer.java:56)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.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)

Any help would be greatly appreciated.

My Bests,

Hung Tran

raluca_edu · ‎Sep 09, 2019

Hi,

I have tried to import the attached ThingShape and it is importing without error (Important: enable Use Default Persistence Provider) in Thingworx 8.3.4 and 8.4.4 (H2).

But if Use Default Persistence Provider is not enabled, I get also "Not acceptable" error.

Also, check if you have connectivity to your database by connecting with twadmin.

Thank you,

Raluca Edu

htran-21 · ‎Sep 09, 2019

Hi @raluca_edu

Yes, i also tried to enable "Use Default Persistence Provider", unfortunately it did not work either.

Of course, the connection is good cause that's a working system and i am using an Administrator account, I could import others well, except the one here. The TW version here is 7.4.19-b262.

Other entities, also other ThingShapes are working fine. CachingFeature is also a ThingShape XML and it works fine.

The different point is the one here is being used by thousands of entities. I assume that the system requires a long time to recompile all dependents and a timeout occurred internally. It seems to be a bug.

My Bests,

Hung Tran

Unable to import a ThingShape file right after it is exported

Unable to import a ThingShape file right after it is exported