Broker doesn't show up in Portal

book

Article ID: 225022

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

Broker is started on the server where Registry is running and it doesn't show up in Portal which is running locally or remotely. Portal shows the below error.

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=N8cDpJpmBvU6VMUuCRVvfg==

Registry log shows the below errors for the external database Oracle:

ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ORA-00942: table or view does not exist
ERROR org.springframework.boot.SpringApplication - Application startup failed\
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateDatastoreServiceRegistry'
 

Cause

Any of the below could cause the issue.

. The database configuration property lisadb.pool.common.driverClass is missing in DevTest_Home/site.properties but it could happen with miss configuration of any of the database properties.

. DevTest_Home/searchData/solr is corrupted and could cause the issue.

Environment

Release : 10.6

Component : DevTest Broker

Resolution

Making the below configuration changes and restarting Registry, Broker and Portal should resolve the issue.
 
. Configuring the below properties for using external database in DevTest_Home/site.properties
lisadb.pool.common.driverClas
lisadb.pool.common.url
lisadb.pool.common.user
lisadb.pool.common.password
 
. Setting the below property for not using Derby
lisadb.internal.enabled=false
 
. Delete DevTest_Home/searchData/solr directory

Additional Information

Troubleshooting the issue:

. Invoke the API https://RegistryHost:1505/lisa-pathfinder-invoke/api/v1/agentGroups and see if you are getting a valid response. A valid response should look like below:

[
{
"id": -2032180703,
"name": "DEFAULT",
"agents": [
{
"id": 2024515099,
"name": "DRADIS",
"flags": 0
},
{
"id": 69429598,
"name": "IAMCL",
"flags": 0
}
]
}
]
 
Check the pfbroker.log  and see if there are any errors. You might see the below errors:
 com.itko.activemq.broker.TransportConnection serviceTransportException
Transport failed: java.io.IOException: Unknown data type: -17
 
Check the Registry log and see any errors. You might see the below errors:
ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ORA-00942: table or view does not exist
ERROR org.springframework.boot.SpringApplication - Application startup failed\
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateDatastoreServiceRegistry'