Whilst trying to open mappings for a given location, FDM has crashed. We have restarted the FDM service, however despite the service running cannot log into FDM any more. Internet Explorer now displays the following error:
Internet Explorer:
"Application Error
Description: An exception occurred during the execution of the current web request. Please contact the administrator to review the stack trace in the event log for more information about the error.
Source:
http://ibm-pr-mihdca-01.yodel.net/HyperionFDM/AuthorizedPages/LogonPage.aspx?ReturnUrl=/HyperionFDM/default.aspx"
Event Viewer Application Logs:
Exception Details:
Retrieving the COM class factory for component with CLSID {00000535-0000-0010-8000-00AA006D2EA4} failed due to the following error: 800703fa.
Stack Trace:
at Hyperion.FDM.Classes.LanguageTranslator.LookupPreferredLanguageId(ArrayList listLanguages)
at Hyperion.FDM.Pages.BasePage.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at Hyperion.FDM.Classes.LanguageTranslator.LookupPreferredLanguageId(ArrayList listLanguages)
at Hyperion.FDM.Pages.BasePage.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
I have seen potential solutions at the following links, suggesting potential invalid reserved characters (such as &) in the mappings previous uploaded. We will look at trying to remove these rows via a SQL script, however we do not have any visibility at this stage and will require assistance from the DBA's.
2355931
1055734
Can anyone please suggest which tables we need to be looking at/guiding the DBA's too? Or even better, can anyone please provide a script? Or could this be a red herring, since the FDM login page is not even loading?