by butsch
23. February 2016 15:39
I
Error you see under the VSE TIE (Threat Intelligence Exchange) Report.
ERROR: |
Error Message: The CUBE() and ROLLUP() grouping constructs are not allowed in the current compatibility mode. They are only allowed in 100 mode or higher.Error Message: The CUBE() and ROLLUP() grouping constructs are not allowed in the current compatibility mode. They are only allowed in 100 mode or higher.Error Message: The CUBE() and ROLLUP() grouping constructs are not allowed in the current compatibility mode. They are only allowed in 100 mode or higher. |
Report that this happens |
|
Our SQL Express was running 10.50.2500.0
https://kc.mcafee.com/corporate/index?page=content&id=KB76739
Under checks there is a hint.
Sadly the Upgrade Check tool they extra wrote to make sure things like this does not happen does not check that point!
Ensure the Compatibility level is set to 100 or higher for the ePO database
- Click Start, Programs, Microsoft SQL Server, SQL Server Management Studio.
- Right-click the ePO database and select Properties.
- Click Options and ensure Compatibility level is set to 100 rather than 80 or 90. If it is not, select 100 from the Compatibility level drop-down list and click OK.
Solution:
- Take an VMWARE Snapshot
- Take a Mcafee EPO Snapshot
- Export DB to FILE with SQL Management Studio Express
- Take down all Mcafee Services
Solution Change Compatibility Mode from 90 to 100
Restart EPO Server