DPA: Request are showing Queued for Processing, and the Datastore log shows: ERROR: null value in column "f_agent_name" violates not-null constraint

Data collection is not being processed, and reports are not showing data.

Checking Inventory>Object Library>Applications and opening the server that is not showing data. Click the Data Collection tab and then select the jobmonitor collection and click the History button.
In the Request History popup box the data collections show Queued for Processing.

Checking the Datastore logs you see the following errors:

2018-03-10 21:45:56.588 GMT 1916 5acvxxxxx.77c 1 apollo:ERROR: null value in column "f_agent_name" violates not-null constraint

This error shows that the data collection message that the agent sent in does not have a value for the f_agent_name filed. 

This is a server hostname issue on the agent server.

Form the dpa/agent/bin directory, run the following:
 

./dpaagent -i

You should get the following:
 

[root@rhel-dpa-app bin]# ./dpaagent -i
Hostname is:
labserver.dell.com
Interfaces are:
192.xxx.x.x
labserver.dell.com

If you get a response like below, there is an issue with the hostname on this server.

[root@ bin]# ./dpaagent -i
Hostname is:
.
Interfaces are:
.
192.xxx.x.x
labserver.dell.com

The resolution to this issue requires investigation by the Administrators of the affected server.


In one case it was found that the hosts file did not have the IP of the server as an entry. We added the IP of the server with the FQDN and the short name to the hosts file and restarted the agent. This resolved this and the agent could determine it's server name and populate the f_agent_name.

Contact Dell Support for further details or information.