aleonovesri-cis-ru-esridist

error during Spatiotemporal data store upgrade from 10.6.1 to 10.7

Discussion created by aleonovesri-cis-ru-esridist Employee on Apr 10, 2019
Latest reply on Jun 3, 2019 by aleonovesri-cis-ru-esridist

I’m upgrading from ArcGIS Enterprise 10.6.1 to 10.7 and had got an error during Spatiotemporal data store upgrade.

 

com.esri.arcgis.datastore.common.DataStoreException: Attempt to configure data store failed.. Extended error message: Spatiotemporal data store upgrade completed. But there are some problems found while migrating metadata. Run the repair tool to fix it.

Check the required conditions

For data stores associated with this computer, the necessary prerequisites are checked.

Data store type                                    Status

Spatio-temporal                                   Ready to upgrade

 

The describedatastore tool reports that all fine, the feature services from Spatiotemporal data store are not accessible and ArcGIS GeoEvent Server didn’t see no one Spatiotemporal Big Data Sources. But it is possible to create new ones.

Please help me to repair the data. Where I can find the repair tool to fix it?RJ Sunderman Thank you!

 

 

The following errors are in the GeoEvent log:

 


com.esri.ges.datastore.agsconnection.DefaultArcGISServerConnection

Could not read content from ArcGIS Server: {0}. java.io.IOException: Server error code 500 (The table 'SpireStreamDataLife' does not exist or is a system table.). at com.esri.ges.datastore.agsconnection.DefaultArcGISServerConnection.processArcGISResponse(DefaultArcGISServerConnection.java:5532) ~[53:com.esri.ges.framework.datastore.agsconnection-datastore:10.7.0] at com.esri.ges.datastore.agsconnection.DefaultArcGISServerConnection.queryForLayerDetails(DefaultArcGISServerConnection.java:1379) [53:com.esri.ges.framework.datastore.agsconnection-datastore:10.7.0] at com.esri.ges.datastore.agsconnection.DefaultArcGISServerConnection.parseLayers(DefaultArcGISServerConnection.java:1513) [53:com.esri.ges.framework.datastore.agsconnection-datastore:10.7.0] at com.esri.ges.datastore.agsconnection.DefaultPortalConnection.updateCachedServices(DefaultPortalConnection.java:819) [53:com.esri.ges.framework.datastore.agsconnection-datastore:10.7.0] at com.esri.ges.datastore.agsconnection.DefaultPortalConnection.updateCache(DefaultPortalConnection.java:696) [53:com.esri.ges.framework.datastore.agsconnection-datastore:10.7.0] at com.esri.ges.datastore.agsconnection.DefaultArcGISServerConnection$CacheUpdater.update(DefaultArcGISServerConnection.java:186) [53:com.esri.ges.framework.datastore.agsconnection-datastore:10.7.0] at com.esri.ges.datastore.agsconnection.DefaultArcGISServerConnection$CacheUpdater.run(DefaultArcGISServerConnection.java:229) [53:com.esri.ges.framework.datastore.agsconnection-datastore:10.7.0]

Apr 10, 2019, 4:41:11 PM ERROR
....

 

Also Spatiotemporal data store logs contains warnings:

 

 

[2019-04-05T17:59:32,430][INFO ][o.e.n.Node               ] [PRESALE1.DATAPLUS.LOCAL] version[6.4.2], pid[3308], build[oss/zip/04711c2/2018-09-26T13:34:09.098244Z], OS[Windows Server 2012 R2/6.3/amd64], JVM[AdoptOpenJDK/OpenJDK 64-Bit Server VM/11/11+28-201811082134]

 

.....

[2019-04-05T17:59:42,766][WARN ][o.e.c.m.MetaDataIndexUpgradeService] [PRESALE1.DATAPLUS.LOCAL] [22997119-5b9e-4eda-a098-48b0c8274dd2_es5-5-0_20170410/inxqVcoESKeJDGUqmGzZ3g] ignoring unknown index setting: [index.recovery.initial_shards] with value [1]; archiving

[2019-04-05T17:59:42,806][WARN ][o.e.c.m.MetaDataIndexUpgradeService] [PRESALE1.DATAPLUS.LOCAL] [0b9580f9-4e31-4189-9037-b2dd94347e1c_es5-5-0/UqEEM2eCThqcb0eWJZLJxA] ignoring unknown index setting: [index.recovery.initial_shards] with value [1]; archiving

[2019-04-05T17:59:42,817][WARN ][o.e.c.m.MetaDataIndexUpgradeService] [PRESALE1.DATAPLUS.LOCAL] [d21b167e-617e-432d-91fe-0cd92c7f87c1_es5-5-0_20170830/nC2NU72fQiu7uEqY53zmTQ] ignoring unknown index setting: [index.recovery.initial_shards] with value [1]; archiving

[2019-04-05T17:59:42,848][WARN ][o.e.c.m.MetaDataIndexUpgradeService] [PRESALE1.DATAPLUS.LOCAL] [721e4e2d-bfc8-4e98-980b-c33658fffd44_es5-5-0/f4wx10wjSY2U-56JOAgVYQ] ignoring unknown index setting: [index.recovery.initial_shards] with value [1]; archiving

[2019-04-05T17:59:42,873][WARN ][o.e.c.m.MetaDataIndexUpgradeService] [PRESALE1.DATAPLUS.LOCAL] [7bd09d88-f756-4a5d-8cef-11dabba50bb8_es5-5-0_20170410/85avdv6HSCeexYRju-eQfQ] ignoring unknown index setting: [index.recovery.initial_shards] with value [1]; archiving

[2019-04-05T17:59:42,881][WARN ][o.e.c.m.MetaDataIndexUpgradeService] [PRESALE1.DATAPLUS.LOCAL] [b4f93cb1-8df2-43dd-b9dd-aeefeaa42cee_es5-5-0/5LKSpDCgQqSvEtYIfacAZQ] ignoring unknown index setting: [index.recovery.initial_shards] with value [1]; archiving

[2019-04-05T17:59:42,899][WARN ][o.e.c.m.MetaDataIndexUpgradeService] [PRESALE1.DATAPLUS.LOCAL] [3d901c77-c8e9-49ee-a1fd-37dd8d326dd3_es5-5-0/YEIj3d1YTKCJYkHTW46f7w] ignoring unknown index setting: [index.recovery.initial_shards] with value [1]; archiving

[2019-04-05T17:59:42,930][WARN ][o.e.c.m.MetaDataIndexUpgradeService] [PRESALE1.DATAPLUS.LOCAL] [4715fd6c-b2df-4f80-9704-18d873dbb6a8_es5-5-0_20170427/pnRLxFfDSDKsCphgZ6bhKA] ignoring unknown index setting: [index.recovery.initial_shards] with value [1]; archiving

[2019-04-05T17:59:42,965][WARN ][o.e.c.m.MetaDataIndexUpgradeService] [PRESALE1.DATAPLUS.LOCAL] [5c9342dd-8f73-41d8-961d-ed6f5ac49bcd_es5-5-0/83ChM5i7RteLEOpDdmtSOw] ignoring unknown index setting: [index.recovery.initial_shards] with value [1]; archiving

…..

[2019-04-05T18:00:15,350][INFO ][o.e.n.Node ] [PRESALE1.DATAPLUS.LOCAL] started
[2019-04-05T18:00:31,815][INFO ][o.e.g.GatewayService ] [PRESALE1.DATAPLUS.LOCAL] recovered [254] indices into cluster_state
[2019-04-05T18:00:32,607][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [.dsconfig_es5-5-0] re-syncing mappings with cluster state because of types [[dsconfigOpts]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [020bf2b8-bc9e-407a-abc6-c93e5dc33763_es5-5-0_20170804] re-syncing mappings with cluster state because of types [[gax6afe1180b9224f16933426210661e154]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [0f2f84dd-f5fd-4dc1-b81b-3bad27263703_es5-5-0_20171023] re-syncing mappings with cluster state because of types [[gax27dc5602f3094335bd3e5733398a2293]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [4f56a4ac-df1b-4065-bb64-235666d92854_es5-5-0_20171018] re-syncing mappings with cluster state because of types [[gaxebdbc8c2233c478284bb69f5c6d99c69]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [4855a227-09e0-4404-a08e-0c7a9add5168_es5-5-0_20170804] re-syncing mappings with cluster state because of types [[Tele2_KPI3G_BDS]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [1b621c40-2909-421e-95a7-4389782719b8_es5-5-0_20170330] re-syncing mappings with cluster state because of types [[esparBDS_GEP]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [6cdacf4c-a774-4a64-9811-4cb553c26765_es5-5-0_20170728] re-syncing mappings with cluster state because of types [[Tele2_customer_claimsBDS]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [30ab05f6-50dd-4591-9f8c-3300529926f9_es5-5-0_2017021318] re-syncing mappings with cluster state because of types [[GPNItime_7day_Bashkartastan_GEP]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [4715fd6c-b2df-4f80-9704-18d873dbb6a8_es5-5-0_20170427] re-syncing mappings with cluster state because of types [[gax966f452ddf2b417c8a59312b82f4c8ec]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [4118298b-e490-48b8-a14d-24b23f92c22c_es5-5-0_20170410] re-syncing mappings with cluster state because of types [[gaxf6142aa354f64b059462bd11bfe40264]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [30ab05f6-50dd-4591-9f8c-3300529926f9_es5-5-0_2017021317] re-syncing mappings with cluster state because of types [[GPNItime_7day_Bashkartastan_GEP]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [12f30e3c-2c24-4772-a9a6-343d4bdb1ad5_es5-5-0_20170728] re-syncing mappings with cluster state because of types [[gaxa0ce9f3ca3de42789e12335d89771605]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [0b9580f9-4e31-4189-9037-b2dd94347e1c_es5-5-0_20170721] re-syncing mappings with cluster state because of types [[Tele2coverageBDS]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [ecca09c8-9b2d-489e-974c-64e39cbaf56d_es5-5-0_20170915] re-syncing mappings with cluster state because of types [[gax8183638384d0465f83b5f80f20710c4e]]
[2019-04-05T18:03:04,390][WARN ][o.e.c.m.MetaDataMappingService] [PRESALE1.DATAPLUS.LOCAL] [7bd09d88-f756-4a5d-8cef-11dabba50bb8_es5-5-0_20170410] re-syncing mappings with cluster state because of types [[gax555eb4d869374a27a0a97696aa5ace3b]]

....

Outcomes