Problem: When starting the Sybase Unified Agent service, it takes a long time before failing, and the service manager displays a message that the service startup has timed out.
The <UnwiredPlatform_InstallDir>\SCC_3-0\log\agent.log shows the following message:
2009-11-10 13:35:50,752 [INFO ] [main] com.sybase.ua.util.process.ProcessHandler.startProcess(395) -
Starting process SQLAnywhere-scc_repository: C:\Sybase\SCC-3_0\services\SccSADataserver\sa\bin_windows32\dbsrv11.exe
-n scc_repository -o C:\Sybase\SCC-3_0\services\Repository\scc_repository.slg -m -qi -qw -sb 0 -gn 100 -gm 500 -zl
-zp -x TCPIP{port=3638} C:\Sybase\SCC-3_0\services\Repository\scc_repository.db
2009-11-10 13:36:57,037 [ERROR] [main] com.sybase.ua.services.asa.ASAEngine.startEngine(135) - Failed to connect to
dataserver engine. ASAEngine: Unable to open a new connection to the engine.
Explanation: This problem usually occurs when the Sybase Control Center repository database log file is out of sync with the repository database. A related symptom is the message SQL Login Failure in the Sybase Control Center repository log file.
Solution 1: Review
<UnwiredPlatform_InstallDir>\SCC-3_0\services\Repository\scc_repository.log log for any issues with the database transaction log file during startup. If the transaction log could not be processed, the database cannot start, and consequently nor can the Unified Agent service. Resolve this error by:
- Creating a backup of <UnwiredPlatform_InstallDir>\SCC-3_0\services\Repository\scc_repository.log.
- Deleting the <UnwiredPlatform_InstallDir>\SCC-3_0\services\Repository\scc_repository.log file and restarting the Unified Agent service.
Solution 2: Review
<UnwiredPlatform_InstallDir>\SCC-3_0\services\Repository\scc_repository.log log for any failures in database recovery. Resolve this error by temporarily configuring the consolidated database to start without a transaction log:
- Log out of Sybase Control Center.
- Open <UnwiredPlatform_InstallDir>\SCC-3_0\services\SccSADataserver\service-config.xml.
- Locate this line: com.sybase.asa.server.options.
- Append "-f" to the value of this property.
- Save the changes.
- Restart the Unified Agent service.
- Once the database server has processed the incomplete transaction, it will shutdown the database.
- Confirm the successful transaction in the log file.
- Revert the configuration of <UnwiredPlatform_InstallDir>\SCC-3_0\services\SccSADataserver\service-config.xml.
- Restart the Unified Agent service.