Broker doesn't show up in Portal

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.

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'

 

Environment

All supported DevTest releases.

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.

Resolution

Making the below configuration changes and restarting Registry, Broker and Portal resolved 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

 

. Deleted the 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 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 like below:

 com.itko.activemq.broker.TransportConnection serviceTransportException

Transport failed: java.io.IOException: Unknown data type: -17

 

Check the Registry log and see any errors like below:

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'