Here are some common resolutions to this error:
The issue could be caused by the wrong database name inside the application.properties file. Go to C:\Program Files\CA\CA Test Data Manager Portal\conf to review this file for correct connection details.
If you do not have the Datamaker or Repository installed and configured, you will encounter this error (and others). After installing the repository using these directions, and trying to access the Portal again, the issue should be resolved. https://docops.ca.com/ca-test-data-manager/4-0/en/installing/install-ca-test-data-manager/install-the-repository
There may be missing scripts for your database. If this is a brand new install, it may be worth re-installing the Portal and trying to connect again.
1. Open a sqlplus window, and connect to your repository DB using a system account as sysdba.
- The default password that TDM uses for the system account is "manager", but you set the actual password when you install Oracle.
- If you do not have access to the system account, request that a DBA execute the statements.
- For example, for a local XE installation, you connect as follows: SQL> CONNECT system@XE/manager as sysdba
2. Run the following commands to verify the parameters values:
show parameter processes
show parameter session
show parameter transactions
3. The following are the recommended values.
- If the values are less than the recommended values, use the following commands:
alter system set processes=300 scope=spfile;
alter system set sessions=300 scope=spfile;
alter system set transactions=330 scope=spfile;
4. Save the file. (Commit the changes)
5. Restart Oracle and the TDM Portal.
If you were previously using https:8443, change the Portal properties file to use http:8080:
1. Stop the CA Test Data Manager Portal service.
2. Stop the OrientDB service. (if running)
3. Go to C:\Program Files\CA\CA Test Data Manager Portal\conf
4. Make a copy of the application.properties file.
5. Open the application.properties file in a program like Notepad.
6. Using the find and replace option enter:
- Find what: 8443
- Replace with: 8080
7. Click the OK button.
8. Verify you only see 8080 listed in file.
9. Save file.
10. Start the CA Test Data Manager Portal service.
11. Start the OrientDB service. (if you had to stop it before)
12. Launch the TDM Portal in your web browser.
13. Go to C:\Program Files\CA\CA Test Data Manager Portal\logs
14. Open the startup.log file in a program like Notepad.
15. Watch and verify that all the micro services have started.
16. Check the web browser (Portal) to see if you are able to access it.