Merging two dbs: add-in

Showing posts with label add-in. Show all posts

Wednesday, March 21, 2012

Microsoft Excel Add-In for Analysis Services

Our customer is using the latest version of the Microsoft Excel Add-In for Analysis Services in a Microsoft Excel ver 10.6823.6735. When using a filter on a report that queries a SSAS 2005 (SP1) cube Excel stops responding. Does anyone have an idea what to do or what to look for? Any help is welcome.

Thanks

Hi,

By 'Stop responding',

Do you mean that excel does not display any data?

or applying the filter does not filter the necessary data?

Regards

sql

Friday, March 9, 2012

Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName'

my goal is to show reports in sharepoint services 3.0 and use this update Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

i have this problem:

After update my sql server 2005 to sp2 ctp with SQLServer2005SP2-KB921896-x86-ENU.exe and upate reporting services, try to::1010/reportserver" href="http://links.10026.com/?link=http://_3A1010/reportserver">http://<localserver>:1010/reportserver show the message.

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName()'.

i this problem is in the Microsoft.ReportingServices.Diagnostics.dll i see the method and in version (9.0.3027.0) dont have, and have in 9.0.1399, what i can do to this work rigth

Just try Microsoft.ReportingServices.Diagnostics.dll 9.0.3033.0 still dont working...........

More Details.........

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3033.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__12_26_2006_12_16_30.log</Path>
<SystemName>CRM</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!26-12-2006-12:16:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.MissingMethodException: Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.set_CacheUserName(Boolean)'.
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!26-12-2006-12:16:31:: i INFO: Initializing EnableRemoteErrors to default value of 'False' because it was not specified in Server system properties.
w3wp!library!1!26-12-2006-12:16:31:: Unhandled exception was caught: System.MissingMethodException: Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName()'.
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!library!1!26-12-2006-12:16:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.MissingMethodException: Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserName()'.
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
End of inner exception stack trace

Dont understand what happend but i was forcing to work, modifing the web.config and them assum the 9.0.3033.00 and works fine ? now can make reports?

But what happen? i think the problem he was assuming 9.00.1399.00 not 9.0.3033.00..... but if anyone have a better explination, please report i lose more then a week to solve this problem.

Method not found: 'Void Microsoft.ReportingServices.Diagnostics.UserUtil.CleanCurrentUserNa