pulse Install

Samy_IshakSamy_Ishak Community Edition User
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

Comments

  • PRanaPRana Employee
    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_IshakSamy_Ishak Community Edition User
    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
  • PRanaPRana Employee
    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_IshakSamy_Ishak Community Edition User
    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 ~]$ 


  • PRanaPRana Employee
    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_IshakSamy_Ishak Community Edition User
    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]$ 


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file