Microsoft Message Queues – Private Queue Gotchas

I have just developed an application hosted on Windows 2003 Server that employs MSMQ 3.0 technology to manage transactions from a web service.

I created a function to create a private queue and used the samples in MSDN.

When I tried to view the queue from within MMC, I found that I did not have access, even though I was an Administrator. I got messages to do with opening a “Security Descriptor”. Googling for this problem revealed similar problems but no solution.

So I checked out the MessageQueue Class in MSDN and found the culprit. I needed to grant explicit access rights at creation. Thus the code is as follows:

Private Sub Init()
Dim QueueFromWeb As String = “.\private$\OnlineSalesInbound”
Dim QueueToWeb As String = “.\private$\OnlineSalesOutbound”
Dim QueueInbound As MessageQueue = New MessageQueue(QueueFromWeb)
Dim QueueOutbound As MessageQueue = New MessageQueue(QueueToWeb)
If Not MessageQueue.Exists(QueueFromWeb) Then
MessageQueue.Create(QueueFromWeb)
QueueInbound.Label = QueueFromWeb
QueueInbound.Authenticate = False
QueueInbound.SetPermissions(“MyDomain\Domain Admins”, MessageQueueAccessRights.FullControl)
QueueInbound.MessageReadPropertyFilter.CorrelationId = True
QueueInbound.UseJournalQueue = True
End If
If Not MessageQueue.Exists(QueueToWeb) Then
MessageQueue.Create(QueueToWeb)
QueueOutbound.Label = QueueToWeb
QueueOutbound.Authenticate = False
QueueOutbound.SetPermissions(“MyDomain\Domain Admins”, MessageQueueAccessRights.FullControl)
QueueOutbound.UseJournalQueue = True
End If
End Sub

The addition of the bolded code fixed the problem.

Technorati tags:

Oracle to Acquire Hyperion

This is an interesting development from a number of perspectives.

I recall when Oracle acquired the PC Express / Express MDB products from Information resources in the early 90s. Oracle did not really do a lot with the products.

With Oracle acquiring Hyperion, that leaves Cognos and Business Objects. I am betting that SAP will step in an acquire one of those two. Which one? I am guessing that it will be Business Objects because of their French (European) origins.

For the one left out, life will be difficult at the Oracle / PeopleSoft /SAP sites around the world.

But then that assumes that the acquirer actually does a decent job of integrating and developing the technology. Sad to say, if Express is anything to go by, Hyperion technology may well be destined for a similar fate.

Gripe about SSIS – SQL Server Integration Services

I have been using this tool for a while now and it contains a lot of good things that, in general, augurs well for future releases.

I have griped before in the News Group about some things that are way too complicated compared to other ETL Tools such as Informatica and Cognos DecisionStream.

One of things that really annoys me is that the property: ValidateExternalMetaData is always set to True. Basically, it assumes that all tables will pre-exist. As we all know, tables are apt to be changed and hence our code contains bits that create tables and indexes. Hence one has to set the property to False if a source or destination is dynamically generated.

I just want to set it’s default to False. Where does one do this?

Was there ever so good a cube browser as the Holos Worksheet?

I spent a bit of time working with the now defunct Holos product. (Crystal Decisions did a Computer Associates on it but that’s a story for another day).

For those who do not know about Holos, it was the bees knees of OLAP products and based on my exposure to competitor products since, I would say it is still up there. It’s problem was that it did not have a sexy front end but I digress. (I’ll leave that story for another day too)

It had a Native Windows and Macintosh GUI front end that would allow a user to browse the contents of a cube. You could change views by dragging and dropping the dimension names.

A lot of products rely on Excel as a client. This has it’s place but you cannot get in and quickly slice and dice. The Excel clients are very easy to stuff up. The Holos Worksheet was impossible to stuff up – well, if you tried to read a 25 dimension cube and embed 20 of them you could. The nice thing was that you could drag and drop but you couldn’t have non-sensical combinations like you could in, say Cognos Powerplay.

Please could someone tell me if there is such a tool out there that can browse Essbase cubes or Analysis Services cubes in a similarly elegant fashion.

Which vendors are Blog Challenged?

I had cause recently to look for blogs from a vendor who shall remain nameless (But whose name begins with H) and found three. One was somewhat technical by a well known technologist there. It was somewhat sanitised though – the PR types had vetted it, no doubt. The other blogs were more conceptual – stuff you could find on their web site.

As far as the big vendors go, Microsoft really sets the benchmark in terms of the numbers of blogs. They don’t seem to have been through PR.

 I am interested to hear what people think. Perhaps even rate a vendor on a scale of 10. 1 being Blog Challenged and 10 being Blog Gifted.

My rankings are:

Microsoft – 6, Hyperion – 1, Cognos – 1, Business Objects – 1