Skip to main content

pulse Install

  • May 22, 2014
  • 6 replies
  • 20 views
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

    6 replies

    PRana
    Forum|alt.badge.img
    • PRana
    • Participating Frequently
    • May 22, 2014
    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
    • Samy_Ishak
    • Author
    • New Participant
    • May 23, 2014
    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
    Forum|alt.badge.img
    • PRana
    • Participating Frequently
    • May 23, 2014
    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
    • Samy_Ishak
    • Author
    • New Participant
    • May 23, 2014
    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
    Forum|alt.badge.img
    • PRana
    • Participating Frequently
    • May 23, 2014
    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
    • Samy_Ishak
    • Author
    • New Participant
    • May 23, 2014
    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]$ 


    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement