If you have used an Admin module to connect to a PE database , you will not be able to delete the database until you restart IIS. The database connections are cached on the PE server, and are not released until IIS is reset."
If you have customized any of the SBM templates you have to open System Administrator and use the "Put Files to to Database " option. Those changes don't take affect until you restart IIS. However, you can use the url below to force the cache to refresh without restarting IIS.
Teamtrack connected to an Oracle database server is taking up to 15 minutes to load the login page first time around after restart of the application engine. The DB has got about 2 million records and 12400 users organized into 2000 user groups. This scenario has been encountered on the following configuration but it may recur on similar ones :
Therefore, edit the odbc.ini file and make the necessary changes. You will need to stop and restart the oplrqb process after making your changes to this file.
You will need to go into SQL Server Enterprise Manager and create the Repository database. Restart Serena Common JBoss service. The repository is created when Mashup Manager is started
Resolution: When a new database is added, configure the MSMQ on the settings page of the admin module (if you want to enable notifications) then restart the Notification Process. Workaround:
Release Automation sends polling pings from the server to the database . If SRA detects that it has not been able to poll for a few cycles, this message is returned. This can signify that there was a temporary loss of network or database connectivity.
Serena always recommends to stop dimensions first , and then stop Oracle. The reason for this is to avoid possible inconsistency in the database and/or item library and also to prevent orphaned processes be left over in the environment, which might later affect the performance of dimensions.
When you first install a new solution various files get placed into the payload folder. When you restart IIS after that install the files in the payload folder get pulled into the SBM database and the files are then deleted. You may have to investigate further why they aren't getting deleted but that can cause IIS to take a long time to start.
