1-Visitor

Question

Error importing entities:from Thingworx 7.2.4 to 8.0.1

Forum|Forum|8 years ago
August 3, 2017
1 reply
2671 views

Hi everyone,

To migrate data to 8.0.1 I first imported all extensions from our old server.When I try importing Entities.twx ,I get error -Error importing-Not Acceptable .When I tried importing data.twx of data tables,it is successfully imported.When I try importing SourceControl.zip I get error - Unable to invoke service ImportSourceControlEntities on SourceControlFunctions:null.

Please help me on this .

Install-Upgrade

V

VladimirRosu_116627

19-Tanzanite

Hi Kirti,

Can you check the Application Log, does it says anything on the error, meaning more specific?

K

kchouhan

Author

1-Visitor

Hi Vladimir,

These are the logs-

2017-08-03 17:39:43.206+0530 [L: INFO] [O: c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-10] Starting entity import of F:\ThingworxStorage\repository\SystemRepository\SourceControlEntities

2017-08-03 17:39:43.207+0530 [L: WARN] [O: c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-10] Skipping import file F:\ThingworxStorage\repository\SystemRepository\SourceControlEntities\SourceControl.zip

2017-08-03 17:39:43.208+0530 [L: ERROR] [O: c.t.c.p.ReflectionProcessor] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-10] ErrorCode(e27ddc7c-61e3-43f1-8795-295b6a5fcf4d), Cause(null), Reason(Access was attempted on a null reference variable.), Possible Resolutions(Remove the reference to the null variable within your extension code.)

2017-08-03 17:39:43.210+0530 [L: ERROR] [O: c.t.w.BaseService] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-10] [context: com.thingworx.webservices.context.HttpExecutionContext@76ee33ae][message: Unable to Invoke Service GetSourceControlledEntitiesDiff on SourceControlFunctions : null]

2017-08-03 17:39:51.981+0530 [L: INFO] [O: c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-3] Starting entity import of F:\ThingworxStorage\repository\SystemRepository\SourceControlEntities

2017-08-03 17:39:51.981+0530 [L: WARN] [O: c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-3] Skipping import file F:\ThingworxStorage\repository\SystemRepository\SourceControlEntities\SourceControl.zip

2017-08-03 17:39:51.982+0530 [L: ERROR] [O: c.t.c.p.ReflectionProcessor] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-3] ErrorCode(24e0e4c7-6434-4537-9b45-6cb1dbe8ba73), Cause(null), Reason(Access was attempted on a null reference variable.), Possible Resolutions(Remove the reference to the null variable within your extension code.)

2017-08-03 17:39:52.038+0530 [L: ERROR] [O: c.t.w.BaseService] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-3] [context: com.thingworx.webservices.context.HttpExecutionContext@4468a41e][message: Unable to Invoke Service ImportSourceControlledEntities on SourceControlFunctions : null]

2017-08-03 17:40:04.657+0530 [L: INFO] [O: c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-6] Starting entity import of F:\ThingworxStorage\repository\SystemRepository\SourceControlEntities

2017-08-03 17:40:04.657+0530 [L: WARN] [O: c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-6] Skipping import file F:\ThingworxStorage\repository\SystemRepository\SourceControlEntities\SourceControl.zip

2017-08-03 17:40:04.658+0530 [L: ERROR] [O: c.t.c.p.ReflectionProcessor] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-6] ErrorCode(f7559418-ac3a-41e9-94ae-9edf3a586b0e), Cause(null), Reason(Access was attempted on a null reference variable.), Possible Resolutions(Remove the reference to the null variable within your extension code.)

2017-08-03 17:40:04.705+0530 [L: ERROR] [O: c.t.w.BaseService] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-6] [context: com.thingworx.webservices.context.HttpExecutionContext@3fa0ac4d][message: Unable to Invoke Service ImportSourceControlledEntities on SourceControlFunctions : null]

2017-08-03 17:40:19.170+0530 [L: WARN] [O: c.t.s.s.p.PlatformSubsystem] [I: ] [U: SuperUser] [S: ] [T: pool-10-thread-1] Thingworx System Metrics_----------------------------------------------------------------------------_AlertProcessingSubsystem#, maximumQueueSize= 50000.0, queueSize= 0.0, totalAlertsQueued= 0.0, _EventProcessingSubsystem#, corePoolSize= 16.0, maxPoolSize= 500.0, curentPoolSize= 16.0, activeThreads= 0.0, queueSize= 0.0, largestPoolSize= 16.0, submitedTaskCount= 887.0, completedTaskCount= 887.0, _FederationSubsystem#, clientCount= 0.0, publishedCount= 0.0, updateInterval= 100.0, _FileTransferSubsystem#, corePoolSize= 10.0, maxPoolSize= 10.0, curentPoolSize= 0.0, activeThreads= 0.0, queueSize= 0.0, largestPoolSize= 0.0, submitedTaskCount= 0.0, completedTaskCount= 0.0, _IntegrationSubsystem#, numberOfConnectors= 0.0, requestCount= 0.0, _LicensingSubsystem#, ptc_navigate_view_named= 0.0, ptc_navigate_view= 0.0, twx_composer= 1.0, twx_mashup_builder= 167.0, twx_named_user= 1.0, twx_things= 47.0, twx_utilities= 0.0, twx_utilities_scm_packages= 0.0, twx_utilities_workflows= 0.0, DaysRemaining= 90.0, _MessageStoreSubsystem#, corePoolSize= 10.0, maxPoolSize= 100.0, curentPoolSize= 0.0, activeThreads= 0.0, queueSize= 0.0, largestPoolSize= 0.0, submitedTaskCount= 0.0, completedTaskCount= 0.0, _PlatformSubsystem#, eventQueueSize= 0.0, streamQueueSize-ThingworxPersistenceProvider= 0.0, valueStreamQueueSize-ThingworxPersistenceProvider= 0.0, memoryInUse= 9.21461504E8, totalMemoryAllocated= 1.476395008E9, thingCount= 83.0, _StreamProcessingSubsystem#, maximumWaitTime= 10000.0, sizeThreshold= 1000.0, maximumBlockSize= 2500.0, scanRate= 5.0, maximumQueueSize= 250000.0, queueSize= 0.0, totalWritesQueued= 0.0, totalWritesPerformed= 0.0, numberOfProcessingThreads= 5.0, _TunnelSubsystem#, activeTunnelCount= 0.0, totalTunnelCount= 0.0, _UserManagementSubsystem#, userCount= 2.0, _ValueStreamProcessingSubsystem#, maximumWaitTime= 10000.0, sizeThreshold= 1000.0, maximumBlockSize= 2500.0, scanRate= 5.0, maximumQueueSize= 500000.0, queueSize= 0.0, totalWritesQueued= 0.0, totalWritesPerformed= 0.0, numberOfProcessingThreads= 5.0, _WSCommunicationsSubsystem#, activeWebsockets= 0.0, _WSExecutionProcessingSubsystem#, corePoolSize= 1000.0, maxPoolSize= 10000.0, curentPoolSize= 0.0, activeThreads= 0.0, queueSize= 0.0, largestPoolSize= 0.0, submitedTaskCount= 0.0, completedTaskCount= 0.0, _ThingworxServer#, systemRuntime= 143 hours, memoryInUse = 0.922 GB, totalMemoryAllocated= 1.476 GB, activeUsers= 1, BoundConnectedThings= 0, UnBoundConnectedThings= 0_----------------------------------------------------------------------------_

2017-08-03 18:03:37.908+0530 [L: INFO] [O: c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-10] Starting entity import of F:\ThingworxStorage\repository\SystemRepository\SourceControlEntities

2017-08-03 18:03:37.909+0530 [L: WARN] [O: c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-10] Skipping import file F:\ThingworxStorage\repository\SystemRepository\SourceControlEntities\SourceControl.zip

2017-08-03 18:03:37.910+0530 [L: ERROR] [O: c.t.c.p.ReflectionProcessor] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-10] ErrorCode(ab901cf1-97fe-4894-80d3-d46352fddceb), Cause(null), Reason(Access was attempted on a null reference variable.), Possible Resolutions(Remove the reference to the null variable within your extension code.)

2017-08-03 18:03:37.951+0530 [L: ERROR] [O: c.t.w.BaseService] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-10] [context: com.thingworx.webservices.context.HttpExecutionContext@653b6124][message: Unable to Invoke Service ImportSourceControlledEntities on SourceControlFunctions : null]

2017-08-03 18:09:14.969+0530 [L: ERROR] [O: c.t.w.BaseService] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-1] [context: com.thingworx.webservices.context.HttpExecutionContext@4aba0db2][message: Invalid path. No valid import file found in the given path directory]

2017-08-03 18:09:37.160+0530 [L: ERROR] [O: c.t.w.BaseService] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-5] [context: com.thingworx.webservices.context.HttpExecutionContext@762f0011][message: Invalid file type. Given path points to a file with unsupported content type]

2017-08-03 18:10:19.175+0530 [L: WARN] [O: c.t.s.s.p.PlatformSubsystem] [I: ] [U: SuperUser] [S: ] [T: pool-10-thread-1] Thingworx System Metrics_----------------------------------------------------------------------------_AlertProcessingSubsystem#, maximumQueueSize= 50000.0, queueSize= 0.0, totalAlertsQueued= 0.0, _EventProcessingSubsystem#, corePoolSize= 16.0, maxPoolSize= 500.0, curentPoolSize= 16.0, activeThreads= 0.0, queueSize= 0.0, largestPoolSize= 16.0, submitedTaskCount= 1128.0, completedTaskCount= 1128.0, _FederationSubsystem#, clientCount= 0.0, publishedCount= 0.0, updateInterval= 100.0, _FileTransferSubsystem#, corePoolSize= 10.0, maxPoolSize= 10.0, curentPoolSize= 0.0, activeThreads= 0.0, queueSize= 0.0, largestPoolSize= 0.0, submitedTaskCount= 0.0, completedTaskCount= 0.0, _IntegrationSubsystem#, numberOfConnectors= 0.0, requestCount= 0.0, _LicensingSubsystem#, ptc_navigate_view_named= 0.0, ptc_navigate_view= 0.0, twx_composer= 1.0, twx_mashup_builder= 167.0, twx_named_user= 1.0, twx_things= 46.0, twx_utilities= 0.0, twx_utilities_scm_packages= 0.0, twx_utilities_workflows= 0.0, DaysRemaining= 90.0, _MessageStoreSubsystem#, corePoolSize= 10.0, maxPoolSize= 100.0, curentPoolSize= 0.0, activeThreads= 0.0, queueSize= 0.0, largestPoolSize= 0.0, submitedTaskCount= 0.0, completedTaskCount= 0.0, _PlatformSubsystem#, eventQueueSize= 0.0, streamQueueSize-ThingworxPersistenceProvider= 0.0, valueStreamQueueSize-ThingworxPersistenceProvider= 0.0, memoryInUse= 6.01769176E8, totalMemoryAllocated= 1.476395008E9, thingCount= 83.0, _StreamProcessingSubsystem#, maximumWaitTime= 10000.0, sizeThreshold= 1000.0, maximumBlockSize= 2500.0, scanRate= 5.0, maximumQueueSize= 250000.0, queueSize= 0.0, totalWritesQueued= 0.0, totalWritesPerformed= 0.0, numberOfProcessingThreads= 5.0, _TunnelSubsystem#, activeTunnelCount= 0.0, totalTunnelCount= 0.0, _UserManagementSubsystem#, userCount= 2.0, _ValueStreamProcessingSubsystem#, maximumWaitTime= 10000.0, sizeThreshold= 1000.0, maximumBlockSize= 2500.0, scanRate= 5.0, maximumQueueSize= 500000.0, queueSize= 0.0, totalWritesQueued= 0.0, totalWritesPerformed= 0.0, numberOfProcessingThreads= 5.0, _WSCommunicationsSubsystem#, activeWebsockets= 0.0, _WSExecutionProcessingSubsystem#, corePoolSize= 1000.0, maxPoolSize= 10000.0, curentPoolSize= 0.0, activeThreads= 0.0, queueSize= 0.0, largestPoolSize= 0.0, submitedTaskCount= 0.0, completedTaskCount= 0.0, _ThingworxServer#, systemRuntime= 144 hours, memoryInUse = 0.602 GB, totalMemoryAllocated= 1.476 GB, activeUsers= 1, BoundConnectedThings= 0, UnBoundConnectedThings= 0_----------------------------------------------------------------------------_

2017-08-03 18:24:13.424+0530 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] WebApp stopping:

2017-08-03 18:24:13.424+0530 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] ========================================

2017-08-03 18:24:14.440+0530 [L: ERROR] [O: c.t.p.p.PostgresModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] [message: [2,002] No connection. Contact the administrator.]

2017-08-03 18:24:14.440+0530 [L: ERROR] [O: E.c.t.p.d.FileTransferDocumentModelProvider] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] [context: [2,002] No connection. Contact the administrator.][message: [2,002] No connection. Contact the administrator.]

2017-08-03 18:24:14.456+0530 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] Thingworx Server Application...OFF

2017-08-03 18:24:14.456+0530 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] Thingworx Server Application...Cleaned up

2017-08-03 18:24:14.456+0530 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] WebApp OFF [server = Apache Tomcat/8.5.16]

2017-08-03 18:24:14.456+0530 [L: WARN] [O: c.m.v.c.i.NewPooledConnection] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] [c3p0] A PooledConnection that has already signalled a Connection error is still in use!

2017-08-03 18:24:14.456+0530 [L: WARN] [O: c.m.v.c.i.NewPooledConnection] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] [c3p0] Another error has occurred [ java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. ] which will not be reported to listeners!

2017-08-03 18:24:14.456+0530 [L: ERROR] [O: c.t.p.p.PostgresModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] [message: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.]

2017-08-03 18:24:14.456+0530 [L: ERROR] [O: c.t.p.ThingworxDefaultTransaction] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] Could not commit the transaction.

2017-08-03 18:24:14.456+0530 [L: WARN] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] Driver org.postgresql.Driver@16b226b8 deregistered

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded