2 Replies Latest reply on Aug 3, 2017 9:47 AM by kchouhan RSS
    kchouhan Newbie

    Error importing entities:from Thingworx 7.2.4 to 8.0.1

    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 .

      • Re: Error importing entities:from Thingworx 7.2.4 to 8.0.1
        vladimirros Creator

        Hi Kirti,

         

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

          • Re: Error importing entities:from Thingworx 7.2.4 to 8.0.1
            kchouhan Newbie

            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