pulse Install

Samy_Ishak

Please advice how to solve this install problem:
Note: I had Pulse running before w/o any of these exceptions on 6.1.2

My Topology is:
   A- 4 VMWare running RHEL 6.x 64-bits 
   B- Vertica 7.0.1
   C- on a Mac Pro with I7-Quad core.
   D- Each machines has 2 GB Ram and 2 cores of my 8 cores.

Here are few command results:

   A- [dbadmin@VHost061 ~]$ cat /proc/cpuinfo | egrep "core id|physical id" | tr -d "\n" | sed s/physical/\\nphysical/g | grep -v ^$ | sort | uniq | wc -l
   Result is: 0
   
   B- [dbadmin@VHost061 ~]$ awk /MemTotal/'{printf "%f GB\n",$2/1024/1024}' /proc/meminfo
   Result is: 1.825798 GB
   [dbadmin@VHost061 ~]

When running the vsql -f /opt/vertica/packages/pulse/ddl/install.sql I got several exceptions.
Few lines are below

vsql:/opt/vertica/packages/pulse/ddl/install.sql:3: ERROR 3399:  Failure in UDx RPC call InvokeSetExecContext(): Error in User Defined Object [RemoveStorage], error code: 0com.vertica.sdk.UdfException: Couldn't instantiate class com.vertica.SentimentUDx.RemoveStorageFactory
at com.vertica.udxfence.UDxExecContext.findUDXFactoryInLibrary(UDxExecContext.java:356)
at com.vertica.udxfence.UDxExecContext.setupLanguageContext(UDxExecContext.java:391)
at com.vertica.udxfence.UDxExecContext.setupContext(UDxExecContext.java:437)
at com.vertica.udxfence.UDxExecContext.run(UDxExecContext.java:197)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.lang.ClassNotFoundException: com.vertica.SentimentUDx.RemoveStorageFactory
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:270)
at com.vertica.udxfence.UDxExecContext.findUDXFactoryInLibrary(UDxExecContext.java:341)
... 4 more

PRana

Hi Samy,

It looks like you are still using Pulse 6.1.2. Please download the latest version from http://vertica.com/marketplace

Thanks
Pratibha

Samy_Ishak

Hi Pratibha,

Please let me know how did you see I have 6.1.2 from the snippet above?

See the install below

[dbadmin@VHost061 ~]$ sudo rpm -UvH /home/dbadmin/Desktop/HPVerticaPulse_0.5.3/vertica-pulse-7.0.2.x86_64.RHEL5.rpm 

[sudo] password for dbadmin: 
Preparing packages for installation...
vertica-pulse-7.0.2-0

The HP Vertica Pulse package has been successfully installed on host VHost061

NOTE:  You cannot install or run any Innovations software on a production server.
HP Vertica does not support systems running Innovations software in a production
environment.
[dbadmin@VHost061 ~]$ 

Thanks again
Samy

PRana

Hi Samy,

I didn't see it in the snippet that you pasted but inferred it from the error that you are getting. The class com.vertica.SentimentUDx.RemoveStorageFactory is no longer available in vertica-pulse-7.0.2 and hence the install script doesn't try to load it, where as it was available in vertica-pulse-6.1.2

Thanks
Pratibha

Samy_Ishak

Hi Pratibha, What shall I do? send me all brute force method/commands to undo 6.1.2 and have successful install
Thanks
Samy

[dbadmin@VHost061 ~]$ rpm -qa | grep -i vertica
vertica-7.0.1-0.x86_64
vertica-pulse-7.0.2-0.x86_64
[dbadmin@VHost061 ~]$ 

PRana

Hi Samy,

Can you please run the uninstall.sql on you sql prompt. This file is located in the /opt/vertica/packages/pulse/ddl directory.
Then uninstall the old pulse rpm. Then install the new rpm and run the install.sql

Pratibha

Samy_Ishak

Hi Pratibha,

This is exactly what I ran and wrote in the "edit" of my past reply but all my edits was gone.

There is no need to redo- rpm.... Details are below.

I hope dev teams to consider adding the uninstall.sql automatically as a first step inn the install.sql.

Thanks
Samy

[dbadmin@VHost061 ddl]$ vsql -f /opt/vertica/packages/pulse/ddl/uninstall.sql
Password: 
DROP LIBRARY
DROP ROLE
[dbadmin@VHost061 ddl]$ vsql -f /opt/vertica/packages/pulse/ddl/install.sql
Password: 
CREATE LIBRARY
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE ROLE
[dbadmin@VHost061 ddl]$