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

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