Hi there,

I have a problem with an FEP 2010 installation that has suffered a problem with the FEPDW OLAP database. The database itself had to be deleted due to corruption, but now the SQL agent job called FEP_GetNewData_FEPDW_XXX is failing at the step where it tries to populate a non-existent database in Analysis Services.

Is there any way of re-creating this database without doing a reinstall of FEP 2010?

Thanks,

Chris.

Never mind, I've fixed it. In fact, I'm not sure if the OLAP database ever existed in the first place since I installed FEP 2010.

Anyway, the solution may come in handy for others in the same position. There's are a couple of executables in the FEP 2010 installation folder (%ProgramFiles%\Microsoft Forefront\Forefront Endpoint Protection on my system), called EnterpriseSecurityDW.exe and EnterpriseSecurityDW2008.exe (the latter presumably is for running against SQL 2008). I can't find any official documentation on these executables, but they do give you their required arguments if you run them from a command prompt.

Anyway, since we're running against SQL 2008 R2, I decided to try the EnterpriseSecurityDW2008.exe. The following set of parameters worked for me (line breaks added for readablility:

EnterpriseSecurityDW2008.exe

• /serverName:OurDBServer\SQL2008
• /sqlDatabaseName:FEPDW_ABC
• /OlapDb:FEPDW_ABC
• /reportsUser:ABC\FEP_Reporting
• /overwriteDatabase:1

ABC is the ConfigMgr site code for the existing Data Warehouse database, and also the NetBIOS AD domain name. The sqlDatabaseName is the name of the data warehouse DB on the SQL instance, not the core FEP database (FEPDB_ABC). The OlapDb is the name that will be given to the OLAP database hosted by Analysis services.

Note that the arguments are case-sensitive, so this won't work if you specify /servername instead of /serverName, for example. Remember to run this under an administrative command prompt, and if your SQL server is not local to the ConfigMgr machine, make sure that the user account you're running it under has appropriate permission on the SQL instance.

Hope this is useful for someone.

Chris.

• Marked as answer by Chris McKeown Monday, May 23, 2011 1:27 PM

Thank you!

Parameters for you environment find in log: for example C:\ProgramData\Microsoft Forefront\Support\Server\FepReport_23122010_162753.log. Find string "EnterpriseSecurityDW2008"

Hi
I tried to run the command line above (EnterpriseSecurityDW2008.exe /serverName:SERVERNAME /sqlDatabaseName:FEPDW_XXX /OlapDb:FEPDW_XXX))

But I recived a error message that the file is corrupt.

Does anybody know how I could solve this issue?

Thanks

EnterpriseSecurityDW2008 started...Version:2.0.0657.0 OLAPCubeGenerator : Error while generating/deploying OLAP Cube Error : Microsoft.AnalysisServices.OperationException: File system error: The following file is corrupted: Physical file: \\?\e:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\FEPDW_XXX.0.db\Time.0.dim\37285.120HoursIdUTC.kstore. Logical file . Errors in the metadata manager. An error occurred when loading the Time dimension, from the file, '\\?\e:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\FEPDW_XXX.0.db\Time.37285.dim.xml'. Errors in the metadata manager. An error occurred when loading the FEP cube, from the file, '\\?\e:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\FEPDW_XXX.0.db\FEP.298093.cub.xml'. at Microsoft.AnalysisServices.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion) at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion) at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId) at Microsoft.Forefront.EndpointProtection.EnterpriseSecurityDW.ConnectToOLAPServer() at Microsoft.Forefront.EndpointProtection.EnterpriseSecurityDW.Main(String[\[]] args) Error : at Microsoft.AnalysisServices.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion) at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion) at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId) at Microsoft.Forefront.EndpointProtection.EnterpriseSecurityDW.ConnectToOLAPServer() at Microsoft.Forefront.EndpointProtection.EnterpriseSecurityDW.Main(String[\[]] args)

Did you use the /overwriteDatabase:1 switch to replace the DB? If it's corrupt then you'll probably need this.

Chris.

Did you use the /overwriteDatabase:1 switch to replace the DB? If it's corrupt then you'll probably need this.

Chris.

Hi, Im experiencing the same issue, did you manage to resolve this? Im debating wether to manually drop the FEPDW_ABC database and then rerun... I do have data in the SCCM FEP console but just keep getting the SQL Schedule job issues. I definitely installed UR1 when I setup fep. is there any form of verbose logging? and also does anyone have any more info on the /reportsUser switch as im assuming this needs to be the user account of an account with admins to the SQL reports server.

Any info would be good...

Thanks