Troubleshooting RDBMS connections

The following information can help you troubleshoot common RDBMS issues. Refer to the database vendor documentation for additional help.

If the Surround SCM Server cannot connect to the server database, errors are added to the SCMStartup.log file in the Surround SCM application directory.

The Helix ALM Server, Helix ALM License Server, and Surround SCM Server and store server configuration information in a server database. The server databases cannot be located in the same RDBMS database.

You must stop and restart the Surround SCM Server if you drop server or tables from an RDBMS and need to re-create them. You must also stop and restart the server if you reconfigure the destination database in the ODBC Data Source Administrator.

The Surround SCM Server caches data from the database. If the underlying database is modified, the cached data no longer matches the data in the database. The connection fails if the server identifies that the backend database is different and the following error is logged: 'The server failed to initialize a connection for XYZ. The destination RDBMS database was changed'.

This error occurs when the database is in use by a different Surround SCM Server. You are prompted to reconfigure the database. Do not reconfigure the database if it is used on a different computer. You must manually modify the Surround SCM Server connection information to point to a different database and restart the server. If the database is no longer in use by a different server, reconfigure the database connection information to allow the current Surround SCM Server access to the database.

Try the following if you are experiencing ODBC connection problems.

1. Test the ODBC connection in the ODBC Data Source Administrator.

If you cannot connect to the RDBMS, click the Test Connection button in the ODBC Data Source Administrator to test the connection.

2. Make sure the DSN is a system DSN.

The data source you are trying to connect to must be configured as a system DSN in the ODBC Data Source Administrator. Surround SCM only displays system DSNs.

Error Cause
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect An ODBC data source with the specified DSN was not set up in the ODBC Data Source Administrator. The DSN must be a system DSN.
Error Cause
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. QODBC3: Unable to connect Occurs on Windows. A username is not specified for the RDBMS connection and the ODBC data source was not configured to run ‘With Windows NT authentication using the network login ID’ in the ODBC Data Source Administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxxx'. QODBC3: Unable to connect The username or password entered in the RDBMS connection information is not valid.
Error Cause
Opening the database connection failed because the Surround SCM Server could not connect to the server or translate the host name The Surround SCM Server cannot connect to the PostgreSQL service. Check the following and then restart the server:
  • The PostgreSQL service is running.
  • The host name and port number are correct.
  • A firewall is not blocking the port.
  • If connecting to a remote PostgreSQL server, the server is configured to accept remote connections.