Support Questions
Find answers, ask questions, and share your expertise

smarsense not working

smarsense not working

Smarsense not getting up , hst-server and hst-agents are all stopped

I checked log /var/log/hst/hst-server.out :

user.dir=/var/lib/ambari-agent derby.system.home=null Database Class Loader started - derby.database.classpath='' [EL Warning]: metadata: 2018-03-29 12:10:55.09--ServerSession(1241480588)--Reverting the lazy setting on the OneToOne or ManyToOne attribute [agent] for the entity class [class com.hortonworks.support.tools.server.entity.RequestEntity] since weaving was not enabled or did not occur. [EL Info]: connection: 2018-03-29 12:10:55.164--ServerSession(1241480588)--file:/usr/hdp/share/hst/hst-common/lib/smartsense-hst-1.3.0.0-22.jar_hst login successful

Internal Exception: java.sql.SQLException: Table/View 'HST_AGENT' already exists in Schema 'APP'.

Internal Exception: java.sql.SQLException: Table/View 'HST_REQUEST' already exists in Schema 'APP'. Error Code: 30000

Internal Exception: java.sql.SQLException: Table/View 'HST_BUNDLE_SERVICE' already exists in Schema 'APP'.

Internal Exception: java.sql.SQLException: Table/View 'HST_USER' already exists in Schema 'APP'.

Internal Exception: java.sql.SQLException: Table/View 'HST_JOB' already exists in Schema 'APP'. Error Code: 30000

Internal Exception: java.sql.SQLException: Table/View 'SERVICEAGENTS' already exists in Schema 'APP'. Error Code: 30000

Internal Exception: java.sql.SQLException: Constraint 'HSTREQUESTAGENT_ID' already exists in Schema 'APP'. Error Code: 30000

Internal Exception: java.sql.SQLException: Constraint 'HSTBNDLSRVICEBNDLD' already exists in Schema 'APP'. Error Code: 30000

Thanks in advance