Ah, I finally figured out the UCP Daemon error. I was seeing error when I perform fwconsole ma downloadinstall ucp, the script stopped with compilation error and it was due to the dependency module, mariasql. As in the below link, the build failed if nodejs version is 12 or greater.
https://ci.appveyor.com/project/mscdex/node-mariasql
Apparently, this module is failing the build with newer nodejs version, and Rocky Linux 9 comes with version 18 as default, (as of 4/27/2023) and I could not install legacy nodejs version from dnf/yum repository. (I guess from the security perspective installing legacy software suite is prevented which is a good security practice, I agree…)
But the error needs to be eliminated. My solution is to install nodejs through node version manager, n. (I tried nvm but it didn’t work for me)
Detailed installation step is here, basically, set the installation directory N_PREFIX followed by sudo curl -L https://bit.ly/n-install | bash installation script.
But this was not the end yet. The compilation was very picky about the nodejs version and so far I confirmed nodejs version of 10.24.1 will safely compile the ucp module for my Rocky Linux 9 environment. The nodejs version 8, 9, and 11 were not successful… (n node manager is quite convenient, just by issuing n install <version number> bring up the relevant nodejs version)
So after setting the nodejs version to 10.24.1, and perform fwconsole ma downloadinstall ucp followed by fwconsole reload, UCP Daemon error in the dashboard was eliminated. 
Just a side note, by looking at the dependency module, mariasql, the code is not updated quite long time, it maybe a frozen project. Perhaps this dependency should be eliminated going forward… (If it is already discussed and proper action is taking place, please disregard my comment…)