When promoting snapshots containing Workcenter Objects like Dashboards or Kanban Boards the information shown in the workcenter.log is often not sufficient to troubleshoot the cause of why certain objects did not come across. It is possible to create more detailed output in the workcenter.log as follows: 1. Stop the SBM Tomcat service
Work Center dashboard does not promote - error in the workcenter.log - [WorkCenterDeploymentController] -- org.hibernate.exception.DataException: could not update
Warnings in workCenter.log : WARN 13-06-2016 18:00:35 [SubmitDestinationServiceImpl] -- Error while creating a SubmitDestination instance: can't read project with id = 31 This error is happening because deleted projects are not deleted from users' favorites in work center
CJSONReader threw an exception on the following JSON data. The workcenter.log has the following error also but timings not quite the same so unrelated? "WARN 24-10-2017 10:04:31 [DTOConverterEntityToJSON] -- Menu Item with id = 6298 was skipped because it has type='REFERENCE' but unable to resolve the reference item"
If you use Oracle as your database and you login to workcenter and you don't see any applications or any SBM items at all take a look in the following log. C:\Program Files\Serena\SBM\Common\jboss405\server\default\log\ workCenter.log You may see errors like the following:
Cannot logon to Work Center as the User Interface hangs with loading symbol - error in workcenter.log ...[MenuItemController] -- could not execute query ...select TS_LOCALE from TS_APPLICATIONS where TS_ID = ...
If you login to work center and the main body of the page doesn't ever load one thing to look at is the Collation of the SBM database. If you look in the following file you may see errors like the following. C:\Program Files\Serena\SBM\Common\jboss405\server\default\log\ workCenter.log
in the workcenter.log file when creating a snapshot, then there is a problem with the WorkCenter defintions on the source AE database. You will also find that the workcenter.xml
When user tries to access Folders > My Folders in workcenter, this error appears on the browser: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet From workcenter.log , we see this error:
