Creating TDM Audit Triggers

Document ID : KB000045304
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

When trying to create audit triggers in the Administration Screen, I get the following error that is in a popup window:

The PL/SQL function "get_program ()" required to create the audit triggers is missing or inaccessible to this user. 
Please contact support for a copy of "f_get_program.pls" and run into the Test Data Repository using a privileged Oracle account before creating the triggers.

 

Environment:

Test Data Manager (TDM) 3.1.1 to present

Cause:

Specific permissions must be granted and inserts are made.

Resolution:

1.   Per the error message you need to accomplish these prerequisites:

  1.  Contact support for a copy of "f_get_program.pls" -  try looking in C:\Program Files (x86)\Grid-Tools\GTDatamaker (or the folder that GTDatamaker was installed into in your environment.)  If it is not on your system, please contact Support.
  2. Run into the Test Data Repository using a privileged Oracle account -  i.e. Have your DBA or Manager of the database run f_get_program.pls in a program such as SQLPlus.

                                       i.    These instructions are for sqlplus.  Before you log into sqlplus with an Administrator or DBA account, change directory to the location of the f_get_program.pls by using a command such as
cd C:\Program Files (x86)\Grid-Tools\GTDatamaker

                                     ii.    Now log into the sqlplus program.  This may vary per installation, so please use the appropriate command for your enterprise.

                                    iii.    Run the using the following command:
@f_get_program.pls
Depending on your current configuration, you will get an output such as this example output:

DROP FUNCTION system.get_program
*
ERROR at line 1:
ORA-04043: object GET_PROGRAM does not exist


DROP PUBLIC SYNONYM get_program
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist
Grant succeeded.
Function created.
Grant succeeded.
Synonym created.
SQL>

Now, back to what you started to do which is Create Audit Triggers

  1.  Launch Datamaker as administrator.
  2.  Log in using the default administrator credentials:
    User name: <<as defined by your organization>>
    Password: <<as defined by your organization>>
  3.   Access the main Datamaker window without connecting to a data source.
  4.  Click Settings, Maintain Schemas (or press Ctrl + Alt + M) to open the Maintain Schemas dialog, and enter your administrator credentials.
  5. Expand Datamaker Connection maintenance, Datamaker Test Data Repository, and choose Create Audit Triggers. 
  6.  Click Execute Script. 

Additional Information:

How to Perform Repository Maintenance

https://docops.ca.com/ca-test-data-manager/3-6/en/installing/install-ca-test-data-manager/perform-repository-maintenance