error during Spatiotemporal data store upgrade from 10.6.1 to 10.7

2304
2
04-10-2019 07:07 AM
AlexanderLeonov
Esri Contributor

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]]

....

0 Kudos
2 Replies
EdwinRoa
Esri Contributor

Hi Alexander

You found a solution?.  I experimented the same issue....

0 Kudos
AlexanderLeonov
Esri Contributor

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

0 Kudos