SQL-Server 2005 BI Studio – Class not registered

If you get this error:

Try to install Office Web Components from http://www.microsoft.com/downloads/thankyou.aspx?familyId=7287252c-402e-4f72-97a5-e0fd290d4b76&displayLang=en

On my development VM I’ve installed only O2007 getting this error.

Windows 7 – Upgrading from BETA to RC, it worked!

It’s a couple of weeks that I’m receiving a notification ad every boot of my Windows 7 RC Laptop reminding me to backup data because it will expires in july without providing me the opportunity to recover data and application.

I’ve just planned 2 day to reinstall everything but thanks to my friend AndreaR (the cyborg) I used this article to upgrade.

Recap:

• Get a Win 7 RC copy from http://www.microsoft.com/windows/windows-7/download.aspx
• Unzip it to an external disk (a USB key is fine)
• Open the file .\sources\cversion
• Change from MinClient=7x00.0 to MinClient=7000.0
• Launch .\setup.exe and the upgrade

I know, it’s the “italian way” very pragmatic. I guess that upgraded process hasn’t been fully tested so that it has blocked by MS.

In my case it worked great (it took a couple of hours to be completed)

ANIPLA 2009 – Naples

On 19th June I had the opportunity to speak at Federico II University of Naples (Italy) to the italian national conference on Intelligent Manufacturing.

My speech was again about BAM (Business Activity Monitor) on industrial plant and it has been co-authored with Enzo Maria Tieghi from ServiTecno our partner providing us with GE Fanuc SCADA solutions.

The presentation is available here:

• PowerPoint Old Format Slide-Show
• Open Office

PS: …I was forgetting to suggest  to avoid “Oste Pazzo” restaurant at Borgo Marinari in Naples. Expect from them a huge bill depending from your home town and a meal quality that is the same of a low level restaurant in Milan. Do you know the worst things about touristic restaurant? Well, you can find them there.

IBA-Day 2009 & DDG May Meeting Follow-Up

My company has been invited to present a project developed for an Hot-Rolling-Table for a new furnace at IBA Day 2009.

I was the speaker but I’ve just presented the great job of my colleagues Eros Valzasina and Chiara Susca.

The challenges of the project were:

• How to integrate the Hot-Rolling-Table logic implemented on Siemens MMC with the new S7 PLC?
• How the system can be tested running it in parallel with the previous one (we know very well this topic for level 2 application, but this was the first time we applied our “Sunsetting” to Level 1;
• Is it possible to deliver a Level 1 PCS with a low-cost Wintel hardware using IBA technologies?

Obviously if we were invited to IBA Day, the answer is yes to all of the question…

To know how, the presentation is here:

• PowerPoint Old Format Slide-Show
• Open Office

Yesterday I also attended to may meeting of London .Net User Group

There has been a great Battle of the WEB contest (great idea from Jason Chapman) where in a 35 mins for each speaker, different Content Managed platform and approach have been presented.

Obviously I’ve talked about Sharepoint but my battle has been a Waterloo…

My demo server with MOSS and WSS runs out of ADSL so that I talked about Content Management using the italian intranet running on WSS…

I’ve to be grateful to BT for this…

Anyway presentation is here:

• PowerPoint Old Format Slide-Show
• Open Office

AISTech 2009

For my company AISTech (America Iron and Steel Technology institute) is “the event” and until now we’ve 7 papers (and 7 sessions) about projects we’ve delivered on metal market.

This year we’re also exhibitor and you can find our stand on the aisle 2900.

In the past days I’ve took some sessions:

• “Computer Applications - Level 1 & 2 Control Systems and Migration” was driven by Andy Szabo from ArcelorMittal and from my friend Wlodzimierz Filipczyk (the most skilled person about level 1 and level 2 systems on steel market I’ve ever meet).
  My session was about our methodological approach and the framework in leveraging data and information available from basic automation and PCS to provide high-level business information and also how to downsize unflexible level 3 functions to level 2 systems. Presentation is here.
  About the technical stuff the involved platform are Sharepoint, Reporting Services, .Net and Analysis Services.
• “Cranes - Crane Technology I” track where I’ve spoken about a project that we’re delivering to mananage an automatic slab yard. Our system leverage an optimizer platform providing simulation, trend analysis and hot-roll mill scheduling accordingly to different policy. Presentation is here.
  We’re developing this project leveraging IBM ILog platform, using .Net for integration and WPF for the Front-End. We’ve also to deal with TMEIC-GE software to manage overhead cranes mission control.
• “Electrical Applications - Updating Electrical Applications for Continuous Improvements” track where we explained how we’re using our “Sunsetting” approach in rewriting a Level 2 PCS to manage the power distribution of an 11 milion tons steel maker plant.
  The news in this project is that we’re using Microsoft OSLO (a Domain Specific Language) to express the relationship between the component of power switches network. Presentation is here.

Reporting Services 2005, 2008 and more…

I was getting mad in configuring our internal report servers exposing them to internet on https using our CA.

Everything was ok using the reporting services web-server (I was able to navigate and invoke all the reports) but it was impossible having the report manager application working.

The problem was that the DNS names (obviously) were different from netbios name and I’ve found this article that solved my problem:

http://support.microsoft.com/kb/896861

This is gold!

What is surprising is that in any real world scenario you will find a DNS name different from the internal, why I need to hack the registry to deploy my configuration?!

PS: Remember to restart IISAdminService, an iisreset isn’t enough!

Client/Server, REST and RIA in Real-World

Scenario

In TIQ-Industrial we’re currently working on a revamping of a classic VB6 Client/Server application to WEB (for our customer’s Intranet).

This application is mission critical because it’s used to manage the production-planning and scheduling of the whole industrial site (accordingly to standard ISA-95, it’s a level 3 system). Obviously we’re talking about manufacturing sector.

Requirements

The main challenges we’ve to face are:

1. The user interaction, experience and responsiveness must be at least the same or improve the existing one;
2. We’ve to minimize the network round-trips because in some plant areas the available network bandwidth is scanty;
3. We cannot change the existing database (based on SQL-Server 2005) because the new system will run in parallel with the existing one, working at the same time with the same tables and stored-procedures but in the near future the customer would like to improve the current design (well we think so and we hope so :-D);

The technology standard for the new web application are ASP.Net 3.5 and SQL-Server 2005

The above requirements will be addressed the following ways (in vision):

Requirement 1
The application will be developed in a RIA-style (Rich Internet Application) strongly leveraging AJAX and 3rd party controls (Telerik RADControl for ASP.Net Ajax).
There will be a strong commitment by the development team on the user interface (…and not as happens sometimes on business components generalization and sexy technical stuffs creating no value for the customer)

Requirement 2
PostBack is the enemy!
Usually in ASP.Net forms development model, a PostBack is generated each time users click on a button, asking the server to perform some tasks.
We can also say that an event is generated on the browser and that event is processed by the web server generating a new page.
Today’s page are rich and large and where there is a lack on network bandwidth the user experience is bad!

Our aim is the reduction of the postbacks needed providing direct access to database data and business services to the client (browser).

This aim can be reached through a REST architecture where AJAX it the enabling technology providing richfull browser logic and functionality (…we’re emancipating the browser :-D )

Requirement 3
I’ve to admit that we don’t like the current database design but we cannot improve it!

Although this project is an opportunity to think about a new and improved database design. We’ll try doing this providing a virtual implementation of the database entities using an ORM (in this case ADO.net Entity Framework)

It this way, we take 2 advantages:

1. We can design the application working on an “ideal” and “optimized” database design abstracted through the Entity Framework and we can also evaluate if db model is working as expected…
2. In the future (if and when) the customer would decide to improve the db design, it will be feasible to reuse the existing db artifact experience (conceived in ORM) to drive the design of the new DB.
   From the application perspective, we will need to update the entities mapping to the new design (and obviously we’d like to achieve a 1:1 mapping).

Logical Architecture

The diagram below explains the main layers of the application:

Navigation Services

It’s the “classic” web-server and provides the navigational logic to the application (page generation and page navigation).
Nothing different than standard web development approach, reference technologies are based on IIS 6 and ASP.Net 3.5
When an user asks for Something to Show, a new page (for example a Report, a Master/Slave view) is generated by the WEB server and pushed to the browser (as HTML obviously with graphics and scripts mixed-up). The important thing is that the page doesn’t contain data!
Data will be bound later and page itself (hosted by the browser) will ask/pull for the data.

Data Services

It’s the service that exposes data to the browser through http in a restful way (…in this project data will be exposed in read-only)!

I don’t have time to explain REST approach here (and there are a lot of blogs about that). For more information take a look to:

Pablo Castro’s Blog

WCF: Developing RESTful Services

Here, the main idea is that page controls will directly ask the data needed (something to read) to this layer that will send them using JSON/ATOM without needing to generate a new page avoiding the PostBack.
The idea is easy to understand, but in the was tricky and challenging to be implemented. The good news is that today we’ve technology for doing effective development with this approach.

ADO.Net Data Services (built on top of Microsoft’s ORM ADO.Net Entity Framework mentioned above) is a framework to expose relational data sources and manage REST events.

We’re using this framework to expose our data model to the external clients (browsers).

Services

ADO.net Data Service is great to expose data clusters and also their basic operation (CRUD) to the browsers but it’s not effective enough to expose complex business services and transaction. It hasn’t conceived for this!

The Services layer is in charge of exposing to external client applications (hosted by browsers) high-level services (business actions) that can be invoked by users.

Technically, there is nothing new in doing this, we leverage WCF (Windows Communication Foundation) that is mediator between the clients and the stored-procedures that currently are implementing the business-logic.

Currently there is a 1:1 correspondence with a business-services to stored-procedure, but strategically we can compose more complex services aggregating stored-procedures in transactions.

What is new here is that we exposes WCF using the REST Starter Kit so that this interface is compliant to the way in which data are exposed by the Data Services layer (atom/json), providing a single pattern in accessing data and services.

Summary

With this approach we can satisfy all the customer requirements and further we‘ve a couple of more gains:

• Basic data are exposed though REST so that they can be “consumed” by other applications (for example warehouse mng, quality mng, etc.);
• Business-Services are exposed through a standard (still REST) and in a strategic perspective, they could be invoked by etherogeneous clients to perform complex and shared business actions (for example raw material allocation) avoiding the needing to create complex ETL to keep the underlying databases aligned.

That’s SOA!