Hi Forum, When I create the below DSN , without ConnectionLoadBalance=1 , it works fine, however when I add that parameter, it throws the error "[Vertica][VerticaDSII]Connnection attempt failed: could not send SSL negotiation packet: Connection timed out. [DW_DB] Description=Vertica driver Driver=/o...

Can someone please help me on this?

Hi Forum, I installed Vertica 7.0 on Linux redhat (3 nodes) and the installation was successful. However when I tried to log in using dbadmin user, I got an invalid password error. Since I had to first log in using dbadmin even to reset it's password , I followed the below article to reset the passw...

Thanks for your responses. It is still not working. I removed the WHERE clause 'WHERE a12.emp_id is not null' and made the FK as NOT NULL as well , however I still get error when I try to create the projection "failed: projection is unsafe". I understood from another post that we need to mention "ks...

Forum, I have the following two tables (ORDER_DETAIL and LU_EMPLOYEE) Schemas of the two tables are mentioned below dbadmin=> \d superapp.order_detail List of Fields by Tables Schema | Table | Column | Type | Size | Default | Not Null | Primary Key | Foreign Key ----------+--------------+-----------...

Forcefully starting the database resolved the issue

admintools -t start_db -d c000_temp_wh -F

Now the node is in the "RECOVERING STATE". Can you please tell me , how can I find the % of recovery. Is there anything that I can do to speed up the RECOVERY process?

Thanks

Hi Forum, Our Vertica DB is on a 3 node cluster. One of the nodes went down and I am unable to bring the database up. I think , I didn't shut it down properly before starting the database and something got messed up. Here are the errors in the log file. Can someone tell me what I need to do. It does...