Release 3 of Create Time Dimension App now available

This entry is part 3 of 3 in the series Create Time Dimension

Release 3 of the Create Time Dimension App is now live. This version brings Czech language support and ISO-8601 week numbers.

The update is made on the server so it is available for everyone right away, no update needed on the Excel/Client side.

Big thanks to Petr Havlik (Twitter: https://twitter.com/petrhavlik) for helping with the Czech translation.

Please note that the ISO-8601 week numbers are just one way of expressing week numbers and might not be what you want. The week numbers start on Mondays per definition and does not change when changing the week start day. If you would like to use another week numbering format you can still add a column using the =WEEKNUM(date, week number system) formula in Excel.

How to: run a 32 bit web application on a SharePoint 2013 Server

When installing a separate 32 bit web application in a SharePoint 2013 Farm the new application might fail to load and give a general 503 Service Unavailable error message. When looking in IIS manager, the Application Pool for the new app would be in the stopped state.

The following error messages might be visible in the Event log…

For the new 32 bit web application

event_error_message

Event ID 5002 – Error <date and time> WAS 5002 None

Application pool ‘<App Pool Name>’ is being automatically disabled due to a series of failures in the process(es) serving that application pool.

And

Event ID 5139 – Warning <date and time> WAS 5139 None

A listener channel for protocol ‘http’ in worker process ‘<process number>’ serving application pool ‘<App Pool Name>’ reported a listener channel failure. The data field contains the error number.

 For SharePoint 2013

Event ID 2282 – Error <date and time> IIS-W3SVC-WP 2282 None

The Module DLL ‘C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\isapi\spnativerequestmodule.dll’ could not be loaded due to a configuration problem. The current configuration only supports loading images built for a x86 processor architecture. The data field contains the error number. To learn more about this issue, including how to troubleshooting this kind of processor architecture mismatch error, see http://go.microsoft.com/fwlink/?LinkId=29349.

The Microsoft link for the issue will only redirect you to the www.iis.net web site.

Solution / work around

The solution to this issue is to enable 32 bit applications to be loaded together with SharePoint and ask the SharePoint Module to only load in 64 bit mode. This can be done by running the following command, located in the %WINDIR%\System32\inetsrv\ folder:

appcmd.exe set config -section:system.webServer/globalModules /[name=’SPNativeRequestModule’].preCondition:integratedMode,bitness64

More information on configuring IIS can be found here: http://technet.microsoft.com/en-us/library/cc627313.aspx

Hat Tip to my colleague Markus Lind for pointing this out.

Cube Status – a new open source project for BI in SharePoint

I have released my Cube Status project (http://cubestatus.codeplex.com) to http://www.codeplex.com.

cubestatusscreenshot

This web part for SharePoint provides the possibility to visualize both the current status of a SQL Server Analysis Services (SSAS) cube or tabular model (BISM) and some of its metadata.

This web part can be used in BI portal type pages in SharePoint to show the current status of a cube used for reports and analysis. This means that there is no need to guess the update status or last process time etc. of a cube.

Both the source code and a .wsp solution file for deployment are available for download from the project page: http://cubestatus.codeplex.com

This project is described in more detail here

This project also works quite well together with the SQL Server Agent Job Status project found at http://jobstatus.codeplex.com and with more details here

Please, feel free to suggest updates and new features etc. either here on the blog or on CodePlex.

Update to Create Time Dimension App

This entry is part 2 of 3 in the series Create Time Dimension

I have published an update to the Create Time Dimension Application for Excel that includes a new Date Integer Id column (in the format 20130616 for June 16, 2013) and Dutch language support.

The update is made on the server so it is available for everyone right away, no update needed on the Excel/Client side.

Big thanks to Frederik Vandeputte (Web: http://www.vandeputte.org/ Twitter: https://twitter.com/frederikvdp) for suggesting the id column and helping with the Dutch translations.

ctd-dutch-ui

 

Screenshot: Updated app UI with the Dutch language choice