SCSM 2012 Analysis Library – Error opening excel file. Please help!

Asked By 10 points N/A Posted on -
qa-featured

 

Hello everybody,

I started to explore Analysis Library and set up folders to store OLAP data Excel files.  As I try to open files that are saved in a library folder it gives me the error given below within the SCSM 2012 RC console.

"Error: Object reference not set to an instance of an object (see screenshot below)"

If I close this error it seems work well and the excel file will open.

 

Here is the error by text.

Date: 2/21/2012 1:48:53 PM

Application: System Center Service Manager

Application Version: 7.5.1464.0

Severity: Error

Message: Object reference not set to an instance of an object.

System.NullReferenceException: Object reference not set to an instance of an object.

   at Microsoft.EnterpriseManagement.UI.SdkDataAccess.ConsoleTaskHandler.DoTask(IList`1 navigationNodes, NavigationModelNodeTask task, List`1 parameterList)

   at Microsoft.EnterpriseManagement.UI.SdkDataAccess.ConsoleTaskHandler.DoTask(IList`1 navigationNodes, NavigationModelNodeTask task)

   at Microsoft.EnterpriseManagement.ConsoleFramework.WindowJobRecord.ExecuteBackgroundJob(Object sender, ConsoleJobEventArgs eventargs)

   at Microsoft.EnterpriseManagement.ServiceManager.UI.Console.ConsoleJobExceptionHandler.ExecuteJob(IComponent component, EventHandler`1 job, Object sender, ConsoleJobEventArgs args)

Thanks for all.

SHARE
Answered By 0 points N/A #130322

SCSM 2012 Analysis Library – Error opening excel file. Please help!

qa-featured

This is the same case when you are trying to pass such a value to the object for which it is not designed to.

Please make sure that any instance of the program that is being used for this purpose is not being used for any other purpose as it defeats the purpose of it.

Secondly, make sure that all the variables are defined at the top level of the code since then they can only be used in the program and at the rest of the places.

Make sure that you use try catch block wherever necessary as it will help you track down the problem.

Related Questions