Required R functions do not exist in Vertica database

Hi

Do you face any error during the vertica installing .?

nope, and already have bunch of collectors OMI, BPM, OMagents and SiteScope pushing data into Vertica.  Just no logger instance and we are using splunk not arcsight

Hi,

    Can you share vertica.log?? It is present in catalog directory

Sruthi

on the vertical server there is /opt/vertica/log/install.log 

HiTo validate that you have dx R install

Run the below command in the Linux account hosting you vertica and send the output

ps -ef|grep vertica-udx-R

and share the output

tnx

$ ps -ef|grep vertica-udx
dbadmin 18080 18076 0 2015 ? 00:13:25 /opt/vertica/bin/vertica-udx-zygote 12 11 18076 debug-log-off /opt/vertica/opsa_data/opsadb/v_opsadb_node0001_catalog/UDxLogs

 ps -ef|grep vertica-udx-R
root     31839 25188  0 18:02 pts/0    00:00:00 grep vertica-udx-R

Hi , In addition please send the output of rpm -qa|grep -i vertica Thanks

rpm -qa|grep -i vertica
opsa_vertica-2.31.104-1.x86_64
vertica-7.1.1-0.x86_64
vertica-R-lang-7.1.1-5.x86_64

Hello!! Faced same problem. Here is the solution which helped us:

---

Operations Analytics Installation Guide - Chapter 3: Installing Operations Analytics - Page 24

Install Vertica and use the R Language Pack from Vertica

---

12. Run the following command to set the correct permissions:

chmod 777 /home/create_R_GammaDist.sh

13. Run the following command to switch to the dbadmin user: su - dbadmin

14. From the /home directory, run the following command: ./create_R_GammaDist.sh

Hi ,

I am also facing the same issue.

[ bin]# rpm -qa|grep vertica*
vertica-7.1.1-0.x86_64
opsa_vertica-2.31.104-1.x86_64
vertica-R-lang-7.1.1-5.x86_64

--

[bin]# ps -ef|grep vertica*
dbadmin   5167     1  0 Mar17 ?        00:00:12 /opt/vertica/spread/sbin/spread -c /tmp/home/dbadmin/opsadb/v_opsadb_node0001_catalog/spread.conf
dbadmin   5169     1  4 Mar17 ?        00:50:25 /opt/vertica/bin/vertica -D /tmp/home/dbadmin/opsadb/v_opsadb_node0001_catalog -C opsadb -n v_opsadb_node0001 -h 127.0.0.1 -p 5433 -P 4803 -Y ipv4
dbadmin   5173  5169  0 Mar17 ?        00:00:07 /opt/vertica/bin/vertica-udx-zygote 13 10 5169 debug-log-off /tmp/home/dbadmin/opsadb/v_opsadb_node0001_catalog/UDxLogs
root      7034 28125  0 10:56 pts/0    00:00:00 grep vertica*
dbadmin  22727     1  0 Mar16 ?        00:00:00 /bin/bash /opt/vertica/agent/agent.sh /opt/vertica/config/users/dbadmin/agent.conf
dbadmin  22734 22727  0 Mar16 ?        00:09:26 /opt/vertica/oss/python/bin/python ./simply_fast.py