Hi there, I have configured a spatiotemporal big data store in my test server site. However it is not showing up in Geoevent manager. Here is a screenshot if the initial command line config: Here is the description from the describedatastore command: and here is the Data store validation from the Server manager: So everything looks good, but the Data store is not showing up in Geoevent manager: I added it to server using the server primary site administrator account before I federated with portal. I also have a regular data store running on another machine that has been added to portal as the hosting server. All firewalls are turned off. Any ideas? Thanks, Marc

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Spatiotemporal big data store isn't showing up in Geoevent Manager

MarcGraham1

Hi there,

I have configured a spatiotemporal big data store in my test server site. However it is not showing up in Geoevent manager.

Here is a screenshot if the initial command line config:

spatiotemporal data store command line.PNG

Here is the description from the describedatastore command:

spatiotemporal data store description.PNG

and here is the Data store validation from the Server manager:

data store validation.PNG

So everything looks good, but the Data store is not showing up in Geoevent manager:

I added it to server using the server primary site administrator account before I federated with portal. I also have a regular data store running on another machine that has been added to portal as the hosting server. All firewalls are turned off.

Any ideas?

Thanks,

Marc

Find more posts tagged with

Accepted answers

All comments

RJSunderman

Hey Marc -

Did you try stopping the 'ArcGIS Data Store' service running on the, I'm assuming, Windows machine on which you installed and then enabled the spatiotemporal big data store (vb2stds.c2.test.local)? In an internal staff training today, a couple of folks were seeing an error logged in GeoEvent ("com.esri.ges.datastore.bds.internal.BDSClientImpl / None of the configured ArcGIS Spatiotemporal Big Data Store nodes are available") when trying to create a new output to add features to their BDS. Restarting the ArcGIS Data Store service fixed their issue.

If you try to browse to http:// vb2stds.c2.test.local:9220 does Elasicsearch respond by asking you to authenticate (provide a username and password) to log-in? You don't want to connect to Elasticsearch directly over port 9220, but trying to do so might tell you wether or not the service is responding to requests.

Were you able to register and validate a "Portal" type of server connection with GeoEvent as a Data Store? If GeoEvent does not have a registered server with a recognized BDS the 'ArcGIS Server Connection' dropdown will be empty when trying to configure a GeoEvent output to either add or update features in the spatiotemporal big data store.

Just a few ideas -

Marten

did you also register the Big Data Store in the Data Stores tab in GeoEvent Manager?

I had setup GeoEvent and Data Store with Portal and Server on my laptop and with some useful info from RJ I enabled the spatiotemporal big data store using that same command line. then registered the new datastore (as a portal store) in GeoEvent Manager. voila!

MarcGraham1

Hi,

Thanks for the responses. I have been getting quite a lot of errors in the logs relating to https/ssl issues. I think that I need to sort these out before the functionality will work correctly. Do you have a simple run down/best practice on where certificates need to be generated/signed/exported/imported? I find the documentation a bit confusing. I have an AD CA available in my test environment.

AnthonyColby1

Marc,

I had similar problems when building an all-in-one development VM.

You're right to address the SSL issues first to ensure you're not getting any requests rejected due to certificate issues. For an all-in-one I use the following approach:

1. In IIS either create a Self Signed Certificate or a Domain Certificate (see Create a Domain Server Certificate in IIS 7 on TechNet) and then use this to create SSL bindings on your default site.

2. Export this certificate from IIS to your desktop.

3. If it's a self-signed certificate then install it on the local machine into the 'Trusted Root Certificate Authorities'

4. Copy the certificate to any machine that will access the Dev system and install as per Step 3.

5. Open the ArcGIS Server Rest Admin and navigate to the machine and navigate to 'home > machines > machineName > sslcertificates > importExistingServerCertificate' to install the certificate saved to your desktop in 3.

6. Step back in the crumb trail to the machine and edit the machine properties. Update the SSL certificate to the certificate imported above. This then ensures that the AGS internal web server is using the same certificate as IIS and will be recognised by your client(s).

7. Switch to the Portal for ArcGIS admin page (https://<server>/<webadaptername>/portaladmin) login using a Portal Administrator's credentials and select Security > SSL Certificates. Repeat the import Existing Server Certificate as performed in step 5.

8. Once imported, use the 'update' operation to update the Portal web server to use the certificate you've just imported.

9. Perhaps a bit of overkill, but I prefer to now restart the VM to ensure that the services come back up with the right certificates.

With a domain certificate you may need to check to ensure that the CA's root certificate has been installed into your Trusted Root CA store to ensure that your domain certificate can be validated.

I'd done all this and had the error you originally highlighted. I found that Martin's pointer to add the Portal instance as a data store then solved my problems. (Thanks Martin!)

Tony

VitruvioPlugin.png

AnthonyColby1

Worked for me - thanks!

Tony

MarcGraham1

RJ Sunderman Marten Hogeweg Anthony Colby

Thanks heaps for your advice. Following Anthony's advice on setting up the SSL certificates and then RJ and Marten's adive on setting the portal in data store worked great. Everything worked much better. Am I correct in guessing that if I was to split the install across several machines that the root certificate and server certificates would need to be installed into each machine? So if there was a web server with the two web adapters, a portal machine, a server machine with GEE and two data store servers, one configured as BDS then the same steps should be taken to import the certificates into each one. Do you need to create any extra certificates for the other machines?

Thanks again.

RJSunderman

I'm not an SSL certificates guru, but I believe that you will want to export a domain certificate from your CA (I do this from within IIS) and then import that certificate into both Portal and Server. Do this on the machine that is providing your "WebGIS" ... the machine on which you're running Portal, the hosting Server, and the hosting Server's managed geodatabase (presumably the PostGRE RDBMS provided by ArcGIS Data Store).

Then, on the machine that is providing your "WebGIS", from a browser (I do this from witin Internet Explorer) you'll want to export a *.cer certificate. You'll then want to import that certificate into Server on machine you have set-up for "RealTime" event processing. Typically this second server has only ArcGIS Server and GeoEvent installed. You could choose to federate this second server with Portal - but you do not have to.

The reason, I've been told, that you want to export a *.cer from a browser and not from IIS is that a certificate generated by IIS will have the "WebGIS" server's private key ... which you do not want to share with other server mahcines. The browser generated certificate does not include the "WebGIS" server's private key, but will still allow GeoEvent (which will trust, by default, anything that the Server installation it is running under trusts) trust with Portal running on the other server machine.

This will probably be more clearly presented in a tutorial introducing the spatiotemporal big data store we are working to put up on the GeoEvent Gallery ASAP. The tutorial will not cover product installation and set-up of your WebGIS but will include some discussion on SSL certificates and the trust required between machines when configuring a server for your "WebGIS", a separate server for "RealTime", and a third server for hosting the BDS.

- RJ

Sabri_Ghaith

After "Restarting the ArcGIS Data Store service fixed their issue.", restarting GeoEvent service will do the job as well.

StephanKünster

Hi RJ,

is the tutorial regarding SSL configuration you mentioned in your previous post already available?

Cheers,

Stephan

ThomasPaschke

Hi Stephan,

The tutorial can be found on the GeoEvent Gallery:
http://www.arcgis.com/home/item.html?id=870b1bf0ad17472497b84b528cb9af00

Best,

Thomas

MarcGraham1

Hi,

Thanks for creating the BDS tutorial, it is extremely helpful.

Regards,

Marc

WilliamCraft

I was seeing the same behavior as described above by the original poster, whereby the list of Spatiotemporal Big Data Stores was empty no matter what steps I tried. In my case, the issue was caused by having the Spatiotemporal data store registered with the ArcGIS Server containing GeoEvent Server. If you are federating your servers with Portal, then the Spatiotemporal data store must instead be registered with the Hosted ArcGIS Server. After I made this change and refreshed the data store connections from GeoEvent Manager, they began appearing in the drop-down list as expected.

SaraAbasi

William, it seems we have the same issue. Could you please explain more?

we have two servers federated with portal.How to register Spatiotemporal data store with the Hosted ArcGIS Server? Do you mean to replace "geoevent server" with "hosted ArcGIS server" when configuring spatootemporal ds?

configuredatastore <ArcGIS Server admin URL> <ArcGIS Server administrator> <ArcGIS Server administrator password>  <data directory> --stores spatiotemporal

In addition, there is no child item for /nosqldatabases

GangWang

GeoEvent server Manager -> Site -> Data Store -> Register ArcGIS Server

HyrumErnstrom

I'm seeing the same issue 10.8.1:

Interesting is the hosted ArcGIS Server has a big data store registered, but the supportsBDS is still set to false. I've checked all the SSL certificates and have all the Data Stores setup in GeoEvents Data Stores. I'm not sure how to proceed to get ArcGIS Server to change that value to true. I've also restarted all services to see if that would change.

{
 ...,
"supportsBDS":false,
"managedDatabase":[..., {"name":"/nosqlDatabase/ArcGISDataStore_bigdata_bds_fhdkye8r"}]
}

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.