Archive

Archive for January, 2012

Recreating FEP 2010 Olap database

January 5, 2012 9 comments

So recently I ran into an issue where a customer was experiencing issues with the FEP 2010 Olap database. No data was being shown in the FEP SQL Analysis database, and errors were showing in the Application event log as follow:

MSSQLServerOLAPService
Errors in the metadata manager. An error occurred when loading the Collection dimension, from the file, ‘\\?\D:\MSAS10_50.MSSQLSERVER\OLAP\Data\FEPDW_ABC.0.db\Collection.4141.dim.xml’.

MSSQLServerOLAPService
Errors in the metadata manager. An error occurred when loading the FEP cube, from the file, ‘\\?\D:\MSAS10_50.MSSQLSERVER\OLAP\Data\FEPDW_ABC.0.db\FEP.33097.cub.xml’.

SQLISPackage100
Package “ssisFEP_OlapProcessing” failed.

Doing a little research it looked like the old Olap database needed to be dropped and the creation of a new FEP Analysis database need to be done. There are a couple of executables in the folder where FEP has been installed to. In this example we will say that FEP lives in the “D:\Program Files\Microsoft Forefront\Forefront Endpoint Protection” folder. There are 2 executables in the folder called EnterpriseSecurityDW.exe used for SQL 2005 and EnterpriseSecurityDW2008.exe used for SQL 2008 and 2008 R2.

For this example we will use the following names for SQL server name, SQL database name, Olap database name, FEP reporting user:

SQL Servername – SQL
SQL Database Name – FEPDW_ABC
OlapDb: FEPDW_ABC
FEP reporting user: domain\fepreporting

On the SCCM/FEP server, open up an Administrator command prompt and browse to the “D:\Program Files\Microsoft Forefront\Forefront Endpoint Protection” folder.

Type the following command for a SQL 2008 or 2008 R2 server:

EnterpriseSecurityDW2008.exe /serverName:SQL /sqlDatabaseName:FEPDW_ABC /OlapDb:FEPDW_ABC /reportsUser:domain\fepreporting /overwriteDatabase:1

Type the following command for a SQL 2005 server:

EnterpriseSecurityDW.exe /serverName:SQL /sqlDatabaseName:FEPDW_ABC /OlapDb:FEPDW_ABC /reportsUser:domain\fepreporting /overwriteDatabase:1

* Note that theĀ argumentsĀ are case sensitive

The command should execute and give you a successfully completed at the end.

Advertisements
Categories: FEP 2010