jdbcwso2governance-registrywso2-governance-registry

WSO2 Governance Not Finding All Assets in JDBC Database


I'm new to WSO2 and working on an existing application that uses WSO2. We load our database of assets into wso2 but not all of the assets show up in the store or publisher when queried. It seems there is some disconnect between what is in the database/carbon and what can be seen in store/publisher.

the missing assets can be found by:

the assets are missing in:

All the ones missing have invalid asset names according to our rxt definitions. I removed these validations in carbon but still was not able to find them.

We have validations in the rxt files for asset names, would this affect what is seen in store/publisher?

Is there a way to sync up the governance registry with the database so that it would show all the assets in the store and publisher?

Any help is much appreciated!!


Solution

  • After some long investigating, I found that some entries weren't in the REG_LOG table and some dates in the REG_LOG table made entries not be indexed. The solution for this was adding to the REG_LOG table with current timestamps which forced a reindex and then the missing assets were able to be searched for in the web ui.