Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

pulse Install

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- [[email protected] ~]$ 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- [[email protected] ~]$ awk /MemTotal/'{printf "%f GB\n",$2/1024/1024}' /proc/meminfo
   Result is: 1.825798 GB
   [[email protected] ~]

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

  • Hi Pratibha,

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

    See the install below

    [[email protected] ~]$ 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.
    [[email protected] ~]$ 

    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
  • Hi Pratibha, What shall I do? send me all brute force method/commands to undo 6.1.2 and have successful install
    Thanks
    Samy

    [[email protected] ~]$ rpm -qa | grep -i vertica
    vertica-7.0.1-0.x86_64
    vertica-pulse-7.0.2-0.x86_64
    [[email protected] ~]$ 


  • 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
  • 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

    [[email protected] ddl]$ vsql -f /opt/vertica/packages/pulse/ddl/uninstall.sql
    Password: 
    DROP LIBRARY
    DROP ROLE
    [[email protected] 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
    [[email protected] ddl]$ 


Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.