Data Repository nodes not populating correctly in the Portal
Article ID: 414466
Updated On:
Products
Issue/Introduction
Under the system status tab we can only see the primary node showing up and not the other 2 nodes.
Environment
24.3.x
Cause
All the nodes are not listed in dbconnection.cfg under apache-karaf/etc folder
dbconnection.cfg:
dbDriverClassName=com.vertica.jdbc.Driver
dbUrl=jdbc:vertica://{dbHost}:5433/drdata
dbUser=dauser
dbEncryptedPassword=<ENCRYPTED PASSWORD>
dbAdminUser=dradmin
dbEncryptedAdminPassword=<ENCRYPTED PASSWORD>
dataLoaderConnProps=&directBatchInsert=true&Label="Data Loader"
dbHostNames=DR1.intranet.com
Resolution
dbconnection.cfg under apache-karaf/etc folder only one node is listed
dbconnection.cfg:
dbDriverClassName=com.vertica.jdbc.Driver
dbUrl=jdbc:vertica://{dbHost}:5433/drdata
dbUser=dauser
dbEncryptedPassword=<ENCRYPTED PASSWORD>
dbAdminUser=dradmin
dbEncryptedAdminPassword=<ENCRYPTED PASSWORD>
dataLoaderConnProps=&directBatchInsert=true&Label="Data Loader"
dbHostNames=DR1.intranet.com
Add dbhostnames with comma seperated values at the end
dbHostNames=DR1.intranet.com,DR2.intranet.com,DR3.intranet.com
dbconnection.cfg:
dbDriverClassName=com.vertica.jdbc.Driver
dbUrl=jdbc:vertica://{dbHost}:5433/drdata
dbUser=dauser
dbEncryptedPassword=<ENCRYPTED PASSWORD>
dbAdminUser=dradmin
dbEncryptedAdminPassword=<ENCRYPTED PASSWORD>
dataLoaderConnProps=&directBatchInsert=true&Label="Data Loader"
dbHostNames=DR1.intranet.com,DR2.intranet.com,DR3.intranet.com
Recycle the services of dadaemon and activemq
Feedback
