Automatic reporting synchronization jobs fail in Control Compliance Suite (CCS) Reporting & Analytics v.9
|Article:TECH116545|||||Created: 2009-01-09|||||Updated: 2010-09-03|||||Article URL http://www.symantec.com/docs/TECH116545|
Information in this solution applies to CCS Reporting & Analytics v.9.0 or later.
- Automatic reporting synchronization jobs fail.
- The SQL Server SSIM Proxy Execution Principle does not exist and the reporting jobs have been deleted by accident or by an attempted uninstall of Reporting & Analytics.
Follow these steps to resolve the issue:
1. Contact Symantec Support for a copy of the script to repair the SSIM proxy and restore the synchronization jobs. For more information, see "How to engage Symantec Support for help with Control Compliance Suite" at http://service1.symantec.com/support/intrusiondetectkb.nsf/docid/2007110510041753.
2. Create credential object in destination SQL server with the name “SYMC_E9B379F5-61BE-4e4f-BA1B-3AA37DC91AD2” in Security/Credentials folder with App Server credential.
3. Run CreateProxy.sql on msdb database to create the "SYMC_02C294C2-2193-4e4b-A67A-0A2D27FB871F" proxy object.
4. Run SSISPackageImporter tool to import SSIS packages. Use the following command line:
- SSISPackageImporter.exe "<Report server name>" "D:\MigrateDB\GoldSpec\install_reporting_packages_specs.xml" "D:\MigrateDB\GoldDtx"
Note: SSISPackageImporter.exe “help” - will give you the command line argument details
5. Run SQLAgentJobCreator tool to create SQL Agent jobs. Use the following command line:
- SQLAgentJobCreator.exe "server=<sql server name>
4C2-2193-4e4b-A67A-0A2D27FB871F" "<sql loginname>
Note: SQLAgentJobCreator.exe “help” - will give you the command line argument details.
6. Test the automatic reporting synchronization jobs for functionality.
Article URL http://www.symantec.com/docs/TECH116545