How to Perform Repository Maintenance in Test Data Manager- Datamaker

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

There are three to four different ways to access your 'Maintain Schemas' setting in Datamaker, depending on what release version you have. From this Maintain Schemas/Connections setting, you will be able to perform repository maintenance. This document will cover why repository maintenance is necessary, each way to access the Maintain Schemas setting, and the types of errors that can be resolved from performing repository maintenance. 

After upgrading your instance of Test Data Manager (TDM), you will need to upgrade the repository tables. Your repository is where TDM, Datamaker, stores the metadata. From inside the 'Maintain Connections' setting window, you will need to 'Check Repository Tables' and 'Update Repository Transact-SQL'. Doing this will perform an analysis of the database tables in your repository and provide a report on these database tables relaying whether or not the repository tables need to be updated. In most cases, no updates will be needed, but if you do not run these tests and maintenance was needed, you can experience unexpected errors while using Datamaker. If updates are required, you will be given a script within the settings window and executing that script will perform the updates.

 

If you are encountering any database, repository, or license related errors, a good first troubleshooting step you can take is to perform repository maintenance. 
This includes errors such as:

• FATAL GTWCFHost.GTWCFHost - Exception Code: licence_error_testing_licence_contact_support. 
• Exception Message: Error 2015 while testing server licence! Please contact support. 
• Exception Message: Error 2999 while testing server licence! Please contact support.
• Database Error Message: ORA-00001: unique constraint 

 

Listed below are the four ways to access this 'Maintain Connections' setting window, when to use the option, and what is involved when using it.

Option 1. Ctrl + Alt + M 

• This option can be used with any TDM release version.
• All that is required is pressing Ctrl + Alt + M on your keyboard while logged into Datamaker. 
• This is the most common way to access the 'Maintain Connections'/Maintain Schemas window to perform repository maintenance. 

Option 2. Help -> About -> Toolbox icon (Enabling maintenance mode)

• If you are using TDM 3.2.2 and below with a remote desktop connection or virtual machine that has problems when using keyboard shortcuts, this would be the easiest option for you to use. 
• Using this option will enable 'Maintenance Mode' in Datamaker.
• Enabling maintenance mode will temporarily show the 'Maintain Schemas' option in your 'Settings' drop down menu.
• The Maintain Schemas option will only be available there for as long as you are logged into Datamaker.
• Once you exit Datamaker, maintenance mode will be disabled and you will have to re-enable it next time you login.

Option 3. Add an environment variable called SCHEMASVISIBLE

• This option is only available to users with TDM release version 3.2.3 and above.
• This option involves adding an Environment Variable on your Operating system and restarting your machine.
• The steps below for this option are for adding an environment variable on a Windows machine.

Option 4. Settings -> Maintain Schemas

• This option is only available to users with TDM release version 3.2.3 and above.
• The 'Maintain Schemas' option will be a default setting that is always available with no extra configurations required.

Environment

Test Data Manager (TDM)- Datamaker. Performing repository maintenance through Options 1 and 2 can be done in any TDM release version. Using Options 3 and 4 will only be available to users with TDM release version 3.2.3 and above.

Resolution

Note: All option instructions include how to access the Maintain Schemas/Connections Setting window, as well as how to complete your repository maintenance.

 

Option 1. Using the Ctrl + Alt + M keyboard shortcut

1. Launch Datamaker by double-clicking the icon on your desktop, or by going to your GTDatamaker directory and double-clicking on the gtdatamaker.exe. 
   - The default file path for the GTDatamaker directory is C:\Program Files (x86)\Grid-Tools\GTDatamaker
   - It is also recommended that you right-click on the icon or executable and ‘Run as administrator’ when starting the program. 
2. On the login page, enter your User Name and Password. Then, click the green checkmark in the bottom, right-hand corner of the window or hit ‘Enter’ on your keyboard.
3. Once inside Datamaker, on your keyboard, press Ctrl + Alt + M. 
4. A 'Datamaker Administrator Logon' window will pop up. Enter in your User Name of 'Administrator' and your corresponding Password. A 'Maintain Connections' window should now appear.
5. Under 'CA Test Data Manager- Datamaker Connection Maintenance', click on the + sign next to 'CA Test Data Manager- Datamaker Test Data Repository' to expand the tree underneath it. 
6. Click on the 'Check Repository Tables' option with a green checkmark next to it. 
7. You will be prompted with the message 'Check all CA Test Data Manager- Datamaker tables are present in the repository connection. This facility will check if any tables are missing and create a script to create any missing tables. Click the Process button to check the tables.' Click on the 'Process' button.
8. You should see a 'Checking repository tables' message' while it is running the check. 
   - If everything is correct in your repository, you will get a message saying 'Repository Schema OK - No updates required.'
   - If updates are required, the script to correct the repository will be listed in the right-hand panel. You will click 'Execute Script' to perform the updates.
9. Under this same tree, on the left-hand side, click on 'Update Repository Transact-SQL' with the blue gear icon next to it. 
10. You will get a pop-up message asking 'Do you want to update all the repository Transact-SQL?'. Click the 'Yes' button.
11. You should get a message returned saying something similar to '9 attempted, 0 failed or not attempted'. Click the 'OK' button. 
    - This verifies that your repository database is up-to-date and synced properly. Your repository maintenance is complete. 
    
    

 

 

 

Option 2. Help -> About -> Toolbox icon (Enabling maintenance mode)

1. Launch Datamaker. 
2. Login by entering your User Name and Password. Click the green checkmark to continue.
3. Once inside Datamaker, click on the 'Help' tab in the toolbar at the top of the screen.
4. From the drop-down, choose the 'About CA Test Data Manager-Datamaker' option.
5. In the window that appears, click on the red toolbox icon in the bottom, left-hand corner of the screen.
6. A pop-up labeled 'Maintenance mode Enabled' will appear. You will get a message saying 'Please use the "Maintain Schemas" option on the "Settings" menu to access maintenance mode'. Click the 'OK' button.
7. Exit out of the 'About' window by clicking the red X button in the corner of the screen.
8. Click on the 'Settings' tab in the toolbar at the top of the screen.
9. From the drop-down, choose the 'Maintain Schemas' option. 
10. A 'Datamaker Administrator Logon' window will pop up. Enter in your User Name of 'Administrator' and your corresponding Password. A 'Maintain Connections' window should now appear.
11. Under 'CA Test Data Manager- Datamaker Connection Maintenance', click on the + sign next to 'CA Test Data Manager- Datamaker Test Data Repository' to expand the tree underneath it. 
12. Click on the 'Check Repository Tables' option with a green checkmark next to it. 
13. You will be prompted with the message 'Check all CA Test Data Manager- Datamaker tables are present in the repository connection. This facility will check if any tables are missing and create a script to create any missing tables. Click the Process button to check the tables.' Click the 'Process' button.
14. You should see a 'Checking repository tables' message while it is running the check. 
    - If everything is correct in your repository, you will get a message saying 'Repository Schema OK - No updates required.'
    - If updates are required, the script to correct the repository will be listed in the right-hand panel. You will click 'Execute Script' to perform the updates.
15. Under this same tree, on the left-hand side, click on 'Update Repository Transact-SQL' with the blue gear icon next to it. 
16. You will get a pop-up message asking 'Do you want to update all the repository Transact-SQL?'. Click the 'Yes' button.
17. You should get a message returned saying something similar to '9 attempted, 0 failed or not attempted'. Click the 'OK' button. 
    - This verifies that your repository database is up-to-date and synced properly. Your repository maintenance is complete. 
    
    

 

 

Option 3: Add an environment variable called SCHEMASVISIBLE

1. From your Windows desktop, open the Start Menu.
2. Right click on 'Computer' and select 'Properties' from the drop-down menu.
3. In the left-hand side panel, click on 'Advanced system settings'.
4. A 'System Properties' window will appear. Click on the 'Advanced' tab, if you are not already in it.
5. Click on the 'Environment Variables' button.
6. Click on the 'New...' button.
7. In the 'New User Variable' window, enter the following information:
   - Variable name: SCHEMASVISIBLE
   - Variable value: Y
   - Click the 'OK' button once finished.
8. You should now see the variable listed in the 'Environment Variables' table. Click the 'OK' button.
9. You will be taken back to the 'System Properties' window. Click the 'OK' button.
10. Now you will need to restart your computer.
11. Once your computer is restarted, launch Datamaker.  
12. Login by entering your User Name and Password. Click the green checkmark to continue.
13. Once inside Datamaker, click on the 'Settings' tab in the toolbar at the top of the screen.
14. From the drop-down, choose the 'Maintain Schemas' option. 
15. A 'Datamaker Administrator Logon' window will pop up. Enter in your User Name of 'Administrator' and your corresponding Password. A 'Maintain Connections' window should now appear.
16. Under 'CA Test Data Manager- Datamaker Connection Maintenance', click on the + sign next to 'CA Test Data Manager- Datamaker Test Data Repository' to expand the tree underneath it. 
17. Click on the 'Check Repository Tables' option with a green checkmark next to it. 
18. You will be prompted with the message 'Check all CA Test Data Manager- Datamaker tables are present in the repository connection. This facility will check if any tables are missing and create a script to create any missing tables. Click the Process button to check the tables.' Click the 'Process' button.
19. You should see a 'Checking repository tables' message' while it is running the check. 
    - If everything is correct in your repository, you will get a message saying 'Repository Schema OK - No updates required.'
    - If updates are required, the script to correct the repository will be listed in the right-hand panel. You will click 'Execute Script' to perform the updates.
20. Under this same tree, on the left-hand side, click on 'Update Repository Transact-SQL' with the blue gear icon next to it. 
21. You will get a pop-up message asking 'Do you want to update all the repository Transact-SQL?'. Click the 'Yes' button.
22. You should get a message returned saying something similar to '9 attempted, 0 failed or not attempted'. Click the 'OK' button. 
    - This verifies that your repository database is up-to-date and synced properly. Your repository maintenance is complete. 
    
    

 

Option 4. Settings -> Maintain Schemas

1. Launch Datamaker. 
2. Login by entering your User Name and Password. Click the green checkmark to continue.
3. Once inside Datamaker, click on the 'Settings' tab in the toolbar at the top of the screen.
4. From the drop-down, choose the 'Maintain Schemas' option. 
5. A 'Datamaker Administrator Logon' window will pop up. Enter in your User Name of 'Administrator' and your corresponding Password. A 'Maintain Connections' window should now appear.
6. Under 'CA Test Data Manager- Datamaker Connection Maintenance', click on the + sign next to 'CA Test Data Manager- Datamaker Test Data Repository' to expand the tree underneath it. 
7. Click on the 'Check Repository Tables' option with a green checkmark next to it. 
8. You will be prompted with the message 'Check all CA Test Data Manager- Datamaker tables are present in the repository connection. This facility will check if any tables are missing and create a script to create any missing tables. Click the Process button to check the tables.' Click the 'Process' button.
9. You should see a 'Checking repository tables' message' while it is running the check. 
   - If everything is correct in your repository, you will get a message saying 'Repository Schema OK - No updates required.'
   - If updates are required, the script to correct the repository will be listed in the right-hand panel. You will click 'Execute Script' to perform the updates.
10. Under this same tree, on the left-hand side, click on 'Update Repository Transact-SQL' with the blue gear icon next to it. 
11. You will get a pop-up message asking 'Do you want to update all the repository Transact-SQL?'. Click the 'Yes' button.
12. You should get a message returned saying something similar to '9 attempted, 0 failed or not attempted'. Click the 'OK' button. 
    - This verifies that your repository database is up-to-date and synced properly. Your repository maintenance is complete. 
    
    

 

Additional Information

• If you experience any other issues, or if performing repository maintenance does not resolve the errors you are seeing, please open a support case by going to Broadcom Support Portal or calling support at one of these numbers Contact Broadcom Enterprise Software Support. 
  
  
• Documentation on installing TDM: Installing TDM   
  
  
• Documentation on upgrading TDM: Upgrading TDM Components
  
  
• More information on Repository Maintenance: Preforming Repository maintenance