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

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

  • 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

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