by 
The OCI Marketplace PeopleSoft HCM PUM54 has an Insights issue.
Good News: It’s fixable.
The problem: The opensearch-dashboards.service file has a malformed exec statement. Insights fails when attempting to start. When you attempt to access the insights dashboards, you get a resource not found error. However, checking the Search Instance Configuration page, everything pings and validates. Added, the Integration Gateway pings too. Everything looks ok until you attempt to view an Insights dashboard, deploy a Search Index or deploy a Dashboard.
Ugly communication errors ensue.
Here is the file with the malformed exec:
[Unit]
Description=OpenSearch Dashboards
StartLimitInterval=30
StartLimitBurst=3
[Service]
Type=simple
User=esadm1
# Load env vars from /etc/default/ and /etc/sysconfig/ if they exist.
# Prefixing the path with '-' makes it try to load, but if the file doesn't
# exist, it continues onward.
EnvironmentFile=-/etc/default/opensearch-dashboards
EnvironmentFile=-/etc/sysconfig/opensearch-dashboards
ExecStart=/opt/oracle/psft/pt/ES/pt/opensearch-dashboards-2.11.0/bin/opensearch-dashboards "-c /opt/oracle/psft/pt/ES/pt/opensearch-dashboards-2.11.0/config/opensearch_dashboards.yml"
Restart=always
WorkingDirectory=/
[Install]
WantedBy=multi-user.targetNotice the bad “ExecStart” line and the call to the yml file:
ExecStart=/opt/oracle/psft/pt/ES/pt/opensearch-dashboards-2.11.0/bin/opensearch-dashboards "-c /opt/oracle/psft/pt/ES/pt/opensearch-dashboards-2.11.0/config/opensearch_dashboards.yml"Here’s what that opensearch-dashboards.service file should be:
[Unit]
Description=OpenSearch Dashboards
StartLimitInterval=30
StartLimitBurst=3
[Service]
Type=simple
User=esadm1
# Load env vars from /etc/default/ and /etc/sysconfig/ if they exist.
# Prefixing the path with '-' makes it try to load, but if the file doesn't
# exist, it continues onward.
EnvironmentFile=-/etc/default/opensearch-dashboards
EnvironmentFile=-/etc/sysconfig/opensearch-dashboards
ExecStart=/opt/oracle/psft/pt/ES/pt/opensearch-dashboards-2.11.0/bin/opensearch-dashboards --config /opt/oracle/psft/pt/ES/pt/opensearch-dashboards-2.11.0/config/opensearch_dashboards.yml
Restart=always
WorkingDirectory=/
[Install]
WantedBy=multi-user.targetThe fix is to edit the file and correct that “ExecStart” line or just replace the file with the the one above.
I’m not a Linux expert. So with some back up help from Google Gemini and my other friend Claude, was able to get the job done.
In Puddy
Find the current status of the opensearch-dashboards service:
sudo systemctl status opensearch-dashboardsThat result puked all over the terminal. But we now know that the service is broke. Where is the service broke?
sudo journalctl -u opensearch-dashboards.service -fThat told me we had an incorrect ExecStart command.
Next was to go to that directory on the server, stop the service and deleted that file
cd /etc/systemd/system
sudo systemctl stop opensearch-dashboards
sudo systemctl disable opensearch-dashboards
sudo rm opensearch-dashboards.serviceNext step was to use WinSCP to copy the corrected file up to a place on the server I can write to. I chose the /tmp directory
cd /tmp
# copy into place (overwrite any existing file)
sudo cp opensearch-dashboards.service /etc/systemd/system/opensearch-dashboards.service
# set ownership/permissions (optional but good practice)
sudo chown root:root /etc/systemd/system/opensearch-dashboards.service
sudo chmod 644 /etc/systemd/system/opensearch-dashboards.serviceCheck that and I the new file is in the right directory.
Let’s start it up
sudo systemctl daemon-reload
sudo systemctl enable opensearch-dashboards
sudo systemctl start opensearch-dashboards
sudo systemctl status opensearch-dashboardsDid it work?
Yes.
