ArcGIS Data Store has detected an issue with 'db'

[Sehafiz]

I am using ArcGIS Enterprise 11.3 with ArcGIS Portal, Web Adaptors, Hosting Server, Data Store and another federated ArcGIS Server - each installed on separate virtual machines with Windows Server 2019 OS.

From ArcGIS Hosting Server Manager log, I can see there is a warning that says ArcGIS Data Store has detected an issue with 'db'. This message actually comes from the Data store log that I confirmed when I checked the Data Store log file from within the Data Store machine. Usually it appears after a certain interval. Not the same interval every day. It may appear every 5 minutes or every 9 minutes and sometimes there is a big 3-4 hours gap and then starts appearing.

I raised this issue with local Esri and they could not replicate the issue and could not find the cause of the issue. During the investigation the machine resources were checked like CPU, RAM, Disk Space etc. Nothing found insufficient. I had unique SSL certificates for each machine with the required Subject Alternative Names (SANs) and the machines were trusting each other. Someone else advised to use the same single SSL certificate across all the machines with one common name and the required SANs. I implemented that. Still I get the same warning message.

Is there anything I can do to find the root cause of the message thereby find a solution to fix it?

Following is a screenshot of the error message. 

Thank you.

[CodyPatterson]

Hey @Sehafiz 

In the ArcGIS Server Manager, under Site, Server Configuration, Data Stores, do you see the 'db' database there? If so, does it validate, and if it does/doesn't, do any issues regarding this specific database come up during a webgisdr backup?

The main reasons I say this is because I have a similar issue of a corrupted database, where I found it coming up in the logs, it validated correctly, but it threw errors during the webgisdr backup. I had to delete the database out, and recreate it. Before deleting anything though, please let me know if this fits your issue!

Cody

[Sehafiz]

Hi @CodyPatterson,

Thank you for your reply.

No, 'db' does not exist there. Instead, it is there in the ArcGIS Portal machine.

Hafiz

[Sehafiz]

During the investigation the following was taken into consideration. But this did not help.

https://support.esri.com/en-us/knowledge-base/error-arcgis-data-store-has-detected-an-issue-with-db-...

[OzanCanT]

Hi @Sehafiz ,

While these logs are being logged, did you test if you can publish a feature layer hosted from the Portal?

Also, for further checks, you can check Event Viewer on the machine where Data Store is installed and look at the Windows Logs > System and Application logs for the time intervals when the "Issue with db" logs were logged to see if there are any indications of problems with the ArcGIS Data Store service or installation.

[Sehafiz]

Hi @OzanCanT ,

Thank you for your reply.

Yes, I can publish a feature layer hosted from the Portal.

I checked the Event Viewer. There is no indication in Windows Logs > Application. But there are error events in Windows Logs > System.

Following are some of the messages from the latest ArcGIS Server log and the messages from the Event Viewer. Times of the errors in the event viewer and ArcGIS logs are not the same though.

 

 

 

 

 

From https://learn.microsoft.com/en-us/answers/questions/2628317/event-viewer-error-there-was-an-error-wh... I learnt about the location of the hosts file.

I noticed that the "hosts" file is named as "hosts2" in C:\Windows\System32\drivers\etc and it looks like it was modified on 9 May 2025. I have no idea about this file and how it was created and renamed. I never look at this. Our IT may have knowledge about this.

Do you have any advice?

[OzanCanT]

Hi @Sehafiz ,

The hosts file is the first place your machine looks for DNS resolution. In other words, it is where IP-URL mapping takes place. You mentioned that the file name has changed. This is not good, as your machine should first search here and then go to the DNS server. You can see which IP address you are currently using as your DNS server by using the nslookup command in cmd.

You may need to consult your IT team to find out why this file was changed.

You may also want to review the additional logs located at "<Disk>:\ arcgisdatastore\logs\MachineName>\database" on the Data Store machine for more detailed logs. If you can check and share your findings in the logs, we can look at it together.

[Sehafiz]

Hi @OzanCanT ,

Thank you for the advice.

I got the original version of the hosts file. I copied it into the location and since then the event viewer stopped reporting about the file. However, the file is a default one and does not include any of our machine IPs etc. following is a screenshot of the contents of the file.

From the log located in "<Disk>:\ arcgisdatastore\logs\MachineName>\database" I see the following message

Screenshot from postgresql log of Data Store

For this "could not accept SSL connection: An established connection was aborted by the software in your host machine" message the esri consultant recommended to use a single certificate across all the participating machines with all the SANs and a common name in ArcGIS Enterprise and I did so. But the message still appears.

I am keen to resolve the issue and I appreciate your effort and time to assist me.