By default, the CA Client Automation database is not configured to perform tenancy collection. Enable a number of database triggers in CA Client Automation for the MDB to maintain the tenancy columns in the database.
Execute the following statement to enable the triggers:
Oracle
Execute this statement as the mdbadmin on Oracle so the tables and procedures for the mdbadmin are available. You cannot execute this statement as the ca_itrm user because that user does not have access to the required tables and procedures.
execute sp_enableTenantTriggers(1);
commit;
Microsoft SQL Server
Execute this statement in the MDB namespace. Issue the command use mdb; if your session is not already in the MDB namespace.
exec sp_enableTenantTriggers 1
|
Copyright © 2013 CA.
All rights reserved.
|
|