This can cause the Export to seem to hang in the Application Administrator . This causes a large SQL CPU load and can have the effect or causing performance issues across the system.
When trying to override the settings for a relational or multi-relational field in the Application Administrator , it hangs due to trying to load all of the records if there are many records (over 200,000 records in our test example) in the table that the relational field points to.
A JBoss instance that runs the orchestration engine throws errors each time Jboss is started. : ERROR 2010-05-21 12:30:51,932 STDERR -- LoggerWrapper.loadLogger: Loaded Common Logger class: com.serena.eventlog.internal.logger.LoggerImpl : INFO 2010-05-21 12:30:51,963 mashupmgr.EventLog.Server -- Initializing event log...
Cannot logon to Work Center as the User Interface hangs with loading symbol and in the Application Administrator >Work Center >Settings you also get an error similar to below error on the UI as well as in workcenter.log: 00000 ERROR 03-02-2015 10:52:38 [MenuItemController] -- could not execute query; SQL [select TS_LOCALE from TS_APPLICATIONS
The underlying issue is a user can have the correct privilege to open the main Application but not have permission to also view the Orchestration which causes the error. What happens next is the defect in that when this same user then checks in the application, because they don't have access to the Orchestration the Orchestration is then missing from the Privileges section in the Application Administrator .
You either need to wait for the page to finish loading and the query to finish executing or you may use the search field on the application administrator's home page to search for users, groups, or projects without having to go into the sub-section where the entire list is loaded .
