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.
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]]
....
Hi Alexander
You found a solution?. I experimented the same issue....
Hi Edwin
Unfortunately no. We tried to use repair tool https://support.esri.com/en/download/7544 but it didn’t help.
I think it was more than BDS issue – because later I found that relational data store was reporting that it was upgraded and federated (through ArcGIS Server rest admin) but in ArcGIS Server logs in DEBUG mode there were error that there was no federated relational data store.
So we rolled back to 10.6.1