Perform Repository Maintenance

Your repository is where Datamaker stores product data. If you encounter any database-, repository-, or license-related errors, a good first troubleshooting step is to perform Repository Maintenance.
tdm38
Your repository is where Datamaker stores product data. If you encounter any database-, repository-, or license-related errors, a good first troubleshooting step is to perform Repository Maintenance.
We recommend you run Repository Maintenance after, for example, the following errors:
  • Violation of PRIMARY KEY constraint 'gtrep_project_pk'. Cannot insert duplicate key in object 'dbo.gtrep_project'
  • Database Error Message: ORA-00001: unique constraint
Access Repository Maintenance
You can perform Repository Maintenance from the Maintain Connections window in Datamaker. 
Follow these steps:
  1. Launch Datamaker as administrator.
  2. Log in using the default administrator credentials:
    User name
    : administrator
    Password:
     marmite
  3. Access the main Datamaker window without connecting to a data source.
  4. Do one of the following:
    • Press
      Ctrl + Alt + M
      and enter your credentials. 
      The 
      Maintain Connections 
      dialog opens. 
    • Enable
      Maintenance Mode
      .
      Maintenance Mode is available for as long as you are logged in. After you exit, maintenance mode is disabled. Re-enable it the next time you need it.
      To enable Maintenance Mode, follow these steps:
      1. Click
        Help, About CA Test Data Manager
        .
      2. Click the Red Toolbox icon in the bottom left. Close the About screen.
        Datamaker enables 'Maintenance Mode'. 
      3. Click
        Settings
        ,
        Maintain Schemas
        .
        The 
        Maintain Connections 
        window opens.
To access Repository Maintenance, expand 
Datamaker Connection Maintenance
,
Datamaker Test Data Repository.
Perform Maintenance
If repository maintenance is necessary, you can perform the following actions:
  • Click
    Remote Publish Authorization
    and click
    Switch Off
    , if it is switched on.
  • Click
    Reset Sequences
    and confirm by clicking
    Yes
    .
    We recommend you perform this action if you see the following error message in Datamaker or in the TDM Portal logs
    : "Violation of PRIMARY KEY constraint 'gtrep_project_pk'. Cannot insert duplicate key in object 'dbo.gtrep_project'"
After you make any changes, close and restart Datamaker. Repository maintenance is complete.