Featured post
operahouse

Relocating to Sydney, Australia

Leave a reply
This entry is part 1 of 1 in the series The Big Adventure

It’s time for The Big Adventure (again). Time to show all of the kids more of the world.

We are relocating to Australia in September 2013 and will initially settle in Sydney.

Visas, tickets etc. are all set and the only things missing at the moment is a perfect job and a perfect house.

If you are in need of a very accomplished CTO, Principal Consultant, Senior SharePoint Architect, Senior BI Architect or a Trainer/Mentor please contact me, I am available for discussions now.

If you know of the best places to work and live in Sydney (or elsewhere in Australia), please feel free to contact me or leave a comment below.

httpconfigofjetpack

Workarounds for problems using Jetpack and https on Azure Websites

1 Reply
This entry is part 5 of 5 in the series Blog Meta

This is a follow up post on: Moving the blog to azure web sites: http://www.stefanjohansson.org/2013/05/moving-the-blog-to-azure-websites/

Introduction

One key feature missing from Azure Web Sites is the possibility to run your own SSL certificate for encrypted https traffic.

This pretty much disables it for any real business use whatsoever.

Every single professional I have spoken with regarding this have chosen alternate solutions for their projects and tests. As usual a key problem here is no official words on availability and firm delivery dates to relate to. Finding a blog post or discussion thread where someone says it might be available as a feature in the future just doesn’t enable project budgets to be spent on Azure Web Sites even for tests and explorations.

Continue reading →

geoflow_demo_featured_image

SharePoint 2013 and Office 2013 launch seminar at Microsoft

Leave a reply

On May 17th (2013) we held a very successful seminar as part of the launch and roll out of the SharePoint 2013 and Office 2013 family. The event took place at Microsoft Sweden’s newly renovated office just north of Stockholm.

StefanAtMicrosoftSeminar17thMay2013

Photo by Björn Nylander

The event focused on the new capabilities for BI in SharePoint 2013, SQL Server 2012 and Office 2013 and looked at the possibilities of the platform from a strategic ROI point of view.

geoflow_demo

 

GeoFlow demo

The main part of the seminar was my presentation and demonstration of the Solver BI Framework that enables BI in SharePoint 2013 to live in a structured platform with plenty of information about report and system status, integrated news and much more. We also showcased the new GeoFlow 3D data visualization (download here) features of Excel 2013 that was very well received.

powerview_demo

 

Power View demo

More information on the Microsoft Business Intelligence start page here: http://www.microsoft.com/en-us/bi/default.aspx

If you are interested in the materials from the seminar or if you would like to see the seminar contents or demonstration, please contact me.

1-aspx_debug_error.png

Unable to create folder in SharePoint 2013 library

Leave a reply

1-aspx_debug_error

This error, “Sorry, something went wrong. The aspx_debug attribute on the page directive is not allowed in this page” occurs when trying to create a folder in some types of document libraries, such as the Report Document Library used for SQL Server Reporting Services report documents in SharePoint 2013.

The error comes from some bad /Upload.aspx files that are used by SharePoint 2013.

identifying the upload file for a Report Document Library gives us this standard file path:

C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\TEMPLATE\FEATURES\ReportsAndDataListTemplates\ReportDocumentLibrary\Upload.aspx

The standard contents:

3-upload_aspxfile

By updating the contents with something that makes more sense we can get the folder creation feature to work again:

workingfilecontents

Do note that all page directives needs to go, and we need to update the UIVersion property from 15 to 4 otherwise we just get new exciting errors.

Continue reading →

msftazurescreenshot

Moving the blog to Azure Web Sites

2 Replies

This weekend an issue with another website running in the same tenant as this blog made the whole system go down. This episode made me finally spend some time moving the blog to Azure Websites. It should be running fine and exactly as before, but if you find anything out of the ordinary or not working, please let me know.

The earlier host was LAMP-based so I had to do some changes to get everything working as before:

1, I had to upload a web.config file to support pretty links and remove the need for index.php in the url. More information here: http://stackoverflow.com/questions/9965124/how-to-rewrite-the-index-php-of-codeigniter-on-windows-azure

and here: http://codex.wordpress.org/Using_Permalinks#Permalinks_without_mod_rewrite

2, I had to trick Jetpack into working properly since there was an error message about a self signed certificate that made the whole thing go overboard: http://www.tpateman.co.uk/reboot/error-activating-jetpack-plugin/

Apart from that there was just the usual parts, update the dns configuration to support the new dns name in Azure (http://www.stefanjohansson.org/2012/12/how-to-configure-custom-dns-names-for-multiple-subdomain-based-azure-web-sites/), update the dns to point to the new host, migrate the content from the old host to the new and make sure everything was still configured as before.

While doing all of that I also managed to learn about the Core Control plugin (http://wordpress.org/extend/plugins/core-control/),

I also updated a few posts with manual Excerpts so that the posts displayed on the front page are truncated and a sticky post about migrating to Australia…

Update 2013-05-20: I have explored the JetPack issues some more and describe it here:  http://www.stefanjohansson.org/2013/05/workarounds-for-problems-using-jetpack-and-https-on-azure-websites/

BI Seminar Image

Lönar sig en investering i Business Intelligence?

Leave a reply

Den 17de maj pratar jag om och demonstrerar verksamhetsnyttan i en investering i Microsofts BI plattform under ett seminarie på Microsoft.

In English: On May 17th I will present and demonstrate the business value of an investment in the Microsoft BI platform.

Mer information på Solvers hemsida: http://sj.la/12JLaiH

Mer information på Microsofts CloudFacts-sida: http://sj.la/YTDYfG

Mer information:

Solver demonstrerar verksamhetsnyttig BI med Microsoft Office 2013 och Sharepoint 2013

Fråga: Hur får min personal tillgång till och möjlighet att förstå och analysera både företagets och sina personliga nyckeltal (KPI)
Svar: – Vi visar effektiva sätt att få tillgång till och analysera de viktigaste nyckeltalen genom intranätets BI-portal

Fråga: Som ansvarig för IT har jag tillstyrkt stora investeringar i avtal med Microsoft, hur drar jag nytta av dessa?
Svar: – Vi visar upp olika exempel hur dessa investeringar kan utvecklas till en verksamhetsanpassad informations- och BI-lösning med standardprodukter från Microsoft

Agenda:
- Kort om Solver
- Microsoft BI, en översikt
- Demonstrationer

Seminarieinformation
När? – Fredagen den 17 maj 8.00 – 10.00 (registrering och kaffe 08.00 – 08.30)
Var? - Microsoft, Finlandsgatan 36, Kista
Anmälan? – Maila din anmälan till bjorn.nylander@solver.se eller ring Björn Nylander på 08-24 88 00 för att boka ditt deltagande. O.S.A senast 10 maj. Seminariet är kostnadsfritt men begränsat till 40 deltagare.
Välkommen!

 

Migrating to TFS, Team Foundation Service

Leave a reply

As part of the Easter holiday time abundance I am migrating some projects to the TFS service at http://tfs.visualstudio.com/. This is part of the evaluation to see if it works for some of the more complex scenarios we face when developing BI solutions.

Once a project is created the following message greets the creator:

“Your project is created and your team is going to absolutely love this.”

BIFrameworkprojectcreated

So at least we are off to a good start.

Excel Services: Unable to process the request. Wait a few minutes and try performing this operation again.

1 Reply

Error

This error message appeared in a SharePoint 2010 farm/environment when trying to use Excel Services to display a Excel spreadsheet in SharePoint 2010.

image

Screenshot in English: Excel. Unable to process the request. Wait a few minutes and try performing this operation again.

image

Screenshot in Swedish: Excel. Det går inte att behandla begäran. Vänta några minuter innan du försöker utföra den här åtgärden igen.

After reviewing the Events and log files and finding error messages such as theese:

image

Event Viewer: Event 5239, Excel Services Application. There was an error in communicating with Excel Calculation Service (server address on port 32843, standard port for web services address ending with /ExcelService*.asmx)  exception: The underlying connection was closed: An unexpected error occurred on a receive.

Issue

The issue was that the web site used for the SharePoint Web Services had the ASP.NET Impersonation Authentication method enabled.

Solution

The solution is to disable the ASP.NET Impersonation again.

Go to IIS Manager (Start, Administrative Tools, Internet Information Services (IIS) Manager). Expand the Sites node on the server running the Excel Services Service Application. Choose the Authentication icon in the IIS area. Choose ASP.NET Impersonation in the list and disable it using the action link on the right hand side.

image

Screenshot: IIS Manager, Authentication settings for the SharePoint Web Services.

Continue reading →