Foundation logs are a useful tool when it comes to troubleshooting, and knowing how to read certain errors in the logs will assist in identifying what is causing issues. One such error you can find is:

"[tomcat-exec-181] ERROR spi.SqlExceptionHelper  - ORA-00001: unique constraint () violated"

This error states that there is a unique item in the application and no identical items is allowed to exists. This happens when Hub is trying to add a new item to a resource in Hub that already exists. A specific example is:

"[tomcat-exec-181] ERROR spi.SqlExceptionHelper  - ORA-00001: unique constraint (HUB.RES_LOCATION_UK) violated"

The above error is saying that Foundation is trying to add a location, but failed to do so since it already exists. The next step would be to identify the location trying to a be added into Hub and manage these locations. In certain instances it may mean the new location needs to be renamed. Or if it is a duplicate location, then find which location to keep and delete the other.