Troubleshooting
Problem
This technote explains how to resolve an issue where one client user can login or connect to a project at a time, whether through IBM® Rational® Robot, IBM Rational TestManager or IBM Rational Administrator.
Symptom
When a project's test datastore uses Sybase SQL Anywhere 8.0 for its back-end database, and only one client user can login or connect to a project at a time. When trying to connect to a tds.db file of the project on the server through Sybase Central, you receive the error:
Database server connection limit exceeded
Item Value
SQLCODE -102
Constant SQLE_TOO_MANY_CONNECTIONS
SQLSTATE 08W03
Sybase error code 1601
ODBC 2 State 08004
ODBC 3 State 08004Cause
The probable cause is that the number of computers allowed to the connect to the server has been exceeded. If running the network database server, the limit is spelled out in the license agreement. The server may be running low on cache such that it cannot accept any more database connections. The personal database server is restricted to 10 connections.
Resolving The Problem
To resolve this issue, check the following:
- Is the server running low on cache?
- Check the number of concurrent open sessions on the server
- Go to the Control Panel and click on Administrative Tools
- Click Computer Management
- Expand Shared Folders and select Sessions
Was this topic helpful?
Document Information
More support for:
Rational TestManager
Software version:
2003.06.00, 2003.06.10, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15
Operating system(s):
Windows
Document number:
78735
Modified date:
16 June 2018
UID
swg21179658