Our relational data store is no longer validating, and I'm not exactly sure what might have caused it to stop validating. We have previously been able to create hosted feature layers, use them in web maps, etc... without issue. The Tile Cache data store is validating in Server Manager, which is on the same machine as the relational data store.
The Data Store does not validate in either Server Manager nor in Portal when validating the Hosting Server.
The error in the Portal logs is simply: Validation failed for hosting server.
The error in Server Manager when validating is a couple messages:
- Exception in get user privileges Server Machine ".../arcgis/sharing/rest/community/self" returned an error: 'Invalid token.'
- The connection property set was missing a required property or the property value was unrecognized. Bad login user.
I'm really not sure where to look and diagnose what went wrong. I have tried running the "updatelicense" batch file that comes with the Data Store install, with no avail.
The only thing I can think of that may have changed in our Portal is that we demoted the initial admin account from an Admin to User, otherwise, I can't think of any configuration that would have changed.
I dug into the data store logs and this is the entry that seems to repeat when validating through Portal:
System Info:
- Version: Enterprise 10.9
- Multiple Machine Deployment --- all components on a dedicated server