Running the Pulse Install Script

As the dbadmin user, run the install.sql script with vsql:

vsql -f /opt/vertica/packages/pulse/ddl/install.sql

Where should i type in this command to? 

Comments

  • Navin_CNavin_C Vertica Customer
    Hi,

    vsql is commanline tool for vertica.

    vsql -f /opt/vertica/packages/pulse/ddl/install.sql

    This command will run the install.sql file inside vertica

    vsql -f : stands for running a .sql file
  • You should run that command in the bash shell of the dbadmin user. 
  • Hi, it shows me this error message.. How can i resolve it?


    vsql:/opt/vertica/packages/pulse/ddl/install.sql:3: WARNING 4973:  The UDx zygote process is down, restarting it...vsql:/opt/vertica/packages/pulse/ddl/install.sql:3: WARNING 4973:  The UDx zygote process is down, restarting it...
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:3: ROLLBACK 2175:  An error occurred when loading library file on node v_testdb_node0002, message:
    Couldn't create new UDx side process, failed to get UDx side process info from zygote: UDx side process has exited abnormally
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:4: ROLLBACK 3861:  Library not found: sentimentlib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:5: ROLLBACK 3861:  Library not found: sentimentlib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:6: ROLLBACK 3861:  Library not found: sentimentlib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:7: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:8: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:9: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:10: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:11: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:12: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:13: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:14: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:15: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:17: ROLLBACK 3861:  Library not found: SentimentLib
    vsql:/opt/vertica/packages/pulse/ddl/install.sql:19: ROLLBACK 5403:  User/role "pulse_users" already exists


  • PRanaPRana Employee
    The error suggests that the configuration parameter 'JavaBinaryforUDX' has not been set properly. Please run the following command from the vsql prompt to set 'JavaBinaryforUDX' to '<path to your java>'

    select set_config_parameter('JavabinaryForUDx', '<path to your java>' );


    Pratibha

Leave a Comment

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