Excel Services errors when AS cube changes
When using Excel Services to display data from an Analysis Services cube, the following error might occur when the cube structure changes. Web part page error If the Excel spreadsheet is displayed as a web part, the following error will appear in the web part page: Text: Error. Web Part Error: An error occurred while setting the value of this …
Read MoreNumbers in perspective
While it is very nice to read about Microsoft’s free cloud service for research: http://blogs.technet.com/b/microsoft_blog/archive/2010/11/18/democratizing-research-with-the-cloud.aspx I couldn’t help noticing that their perspective on numbers are a bit peculiar. The comparison image they use even fail to link to their sources, you need to type them yourself: http://www.census.gov/ipc/www/idb/worldpop.php http://www.ncbi.nlm.nih.gov/genbank/genbankstats.html Link to original image in larger format: http://blogs.technet.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-80-54/8132.NCBI_2D00_lg.bmp While I …
Read MoreWhat is the cost of cloudspamming?
Being of curious nature, I wanted to test if spam traffic would affect cloud services in a typical “pay as you go” scenario. I ordered an introductory SQL Azure package from Microsoft with a pay as you go pricing plan. By creating a plain, empty, SQL server instance with a random public access name I managed to get a monthly …
Read MoreSetting debug to true in web.config breaks Reporting Services in SharePoint
When using Reporting Services reports in SharePoint and at the same time changing the debug attribute to true in web.config the following error message might appear in a web browser alongside the Reporting Services reports not behaving properly: Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET4.0C; .NET4.0E; .NET CLR …
Read MoreHow to: Enable larger reports in Reporting Services
When deploying large reports to SharePoint or Reporting Services from BIDS (Visual Studio) something like the following message might appear: Error 1 System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. —> System.Web.HttpException: Maximum request length exceeded. at System.Web.HttpRequest.GetEntireRawContent() at System.Web.HttpRequest.get_InputStream() at System.Web.Services.Protocols.SoapServerProtocol.Initialize() — End of inner exception stack trace — at System.Web.Services.Protocols.SoapServerProtocol.Initialize() at System.Web.Services.Protocols.ServerProtocol.SetContext(Type type, …
Read MoreSQL Server Agent job status web part for SharePoint
I have released a small web part for SharePoint that displays the current status of a SQL Server Agent job as a colored icon and displays status messages as text. The solution and the source code is available at: http://jobstatus.codeplex.com Here is a screenshot of how it might look in a standard SharePoint 2007 team site. Why would anyone want …
Read MoreSharePoint and BI seminar in Stockholm
I’m presenting at the Itera Consulting Groups breakfast seminar on SharePoint and BI on September 24th (in Swedish). My presentation will focus on hands on examples of efficient, easy to use, interactive ways to access and analyze information in SharePoint and SQL Server. By combining the power of data processing from SQL Server with the possibilities to personalize and focus …
Read MoreA Microsoft Update killed printing in Reporting Services
One client recently had a novel experience with their SQL Server 2005 Reporting Services installation. One day the printing feature stopped to work with this error: Turns out Microsoft decided to kill the print control because of a security issue… Upgrading SQL Server 2005 with Service Pack 3 installed a new version of the control and solved the problem…
Read MoreSharePoint eats PerformancePoint
Microsoft has announced that PerformancePoint will be eaten by SharePoint and SQL Server. PerformancePoint will be discontinued as a stand-alone product and features like the scorecard’ing, KPI and graphing will be integrated into SharePoint. Microsofts BI strategy appears to focus on SharePoint, Excel and SQL Server. More info will probably be available within a few days…
Read More