Error during the installation of Control Compliance Suite Vulnerability Manager (CCS VM) 12.3.x

book

Article ID: 170194

calendar_today

Updated On:

Products

Control Compliance Suite Vulnerability Manager

Issue/Introduction

During the running of the first Agent Job, while installing CCSVM 12.3.x you get a SQL error.

From the AgentJobErrorMessage.txt
Date 9/14/2017 10:06:47 AM
Log Job History (BeyondInsight - Process Daily)
 
Step ID 1
Server CCSVM
Job Name BeyondInsight - Process Daily
Step Name Execute SSIS Package
Duration 00:10:14
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
 
Message
Executed as user: CCSVM\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.4000.0 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  10:06:47 AM  Error: 2017-09-14 10:16:52.11     Code: 0x00000000     Source: Process Full Process Full     Description: Microsoft SQL Server 2008 R2 Analysis Services: MdxScript(Password Safe) (8, 8) The 'Measures' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified.  Microsoft SQL Server 2008 R2 Analysis Services: MdxScript(Password Safe) (12, 8) The 'Measures' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified.  Microsoft SQL Server 2008 R2 Analysis Services: MdxScript(Password Safe) (29, 8) The 'Measures' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified.  Microsoft SQL Server 2008 R2 Analysis Services: MdxScript(Password Safe) (47, 8) The 'Measures' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified.  End Error  Error: 2017-09-14 10:16:52.13     Code: 0x00000008     Source: Process Full      Description: The script returned a failure result.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  10:06:47 AM  Finished: 10:17:01 AM  Elapsed:  613.75 seconds.  The package execution failed.  The step failed.

Cause

The collation setting for the SQL taget instance is not set to Latin1_General_CI_AS.

Resolution

Collation for the target SQL instance must be set as Latin1_General_CI_AS