getting streaminsight debugger to work

Question

I've installed streaminsight 1.2.  I'm on XP.  I've gone through all the steps of reserving the http address using httpcfg, added my user to the StreamInsightUsers group.  But I still can't connect to the service when starting up the StreamInsight debugger.

The service doesn't startup in the Services control panel.  When I look at Event Viewer, I have the following error (I have both sql compact 3.5 sp2 and sql compact 4.0 installed):

What am I doing wrong?  I've uninstalled and installed sql compact a dozen times.

Service cannot be started. Microsoft.ComplexEventProcessing.Metadata.MetadataException: Incorrect version of SQL Compact Edition 3.5 installed. Cumulative Update 4 for SQL Compact Edition 3.5 SP2 or higher must be installed. Install SQL Compact Edition through the included .msi, which can be found in the redist subfolder of the StreamInsight installation folder.

at Microsoft.ComplexEventProcessing.Diagnostics.Exceptions.Throw(Exception exception)

at Microsoft.ComplexEventProcessing.Metadata.SqlCeMetadataProvider.Init(String fileName, Boolean createIfMissing)

at Microsoft.ComplexEventProcessing.Metadata.SqlCeMetadataProvider..ctor(String fileName, Boolean createIfMissing)

at Microsoft.ComplexEventProcessing.EmbeddedServerProxy..ctor(String instanceName, String sqlCeDatasource, Boolean createIfMissing, CheckpointConfiguration checkpointConfig)

at Microsoft.ComplexEventProcessing.Server.Create(String instanceName, SqlCeMetadataProviderConfiguration config, CheckpointConfiguration checkpointConfig)

at Microsoft.C...

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Answer 1

Are you sure you have the cumulative updates installed? What are your SQL CE v3.5 and v4 build numbers?

Answer 2

positive.  I've gone to the MS download site numerous times and reinstalled.

Microsoft SQL Server Compact 3.5 SP2 ENU

Version. 3.5.8080.0

Microsoft SQL Server Compact 4.0 ENU

Version 4.0.8482.1

Plus, I am able to goto SQL Server Management Studio and create a SQL Server Compact Database.

Answer 3

Still having the same issue.  Tried it on windows 7 64bit.    I have the http address reserved, verified by netsh.  User is added to the streaminsight group, verified by whoami.  I have both x86 and x64 compact server sp2 installed version 3.5.8080.0.  Whenever I start the service using Services, I get 2 errors in the event log:

I have sql server 2012 installed as well.  What does it mean by saying use the "included" .msi in the StreamInsight folder?  I downloaded StreamInsight and SQL Compact .msi separately from the downloads and only see a standalone .msi. 

First error:

Exception: Incorrect version of SQL Compact Edition 3.5 installed. SQL Compact Edition 3.5 SP2 (cumulative Update 4 or higher) must be installed. Install SQL Compact Edition through the included .msi, which can be found in the redist subfolder of the StreamInsight installation folder.

second error:

Service cannot be started. Microsoft.ComplexEventProcessing.Metadata.MetadataException: Incorrect version of SQL Compact Edition 3.5 installed. SQL Compact Edition 3.5 SP2 (cumulative Update 4 or higher) must be installed. Install SQL Compact Edition through the included .msi, which can be found in the redist subfolder of the StreamInsight installation folder.
   at Microsoft.ComplexEventProcessing.Diagnostics.Exceptions.Throw(Exception exception)
   at Microsoft.ComplexEventProcessing.Metadata.SqlCeMetadataProvider.Init(String fileName, Boolean createIfMissing)
   at Microsoft.ComplexEventProcessing.EmbeddedServerProxy..ctor(String instanceName, String sqlCeDatasource, Boolean createIfMissing, CheckpointConfiguration checkpointConfig)
   at Microsoft.ComplexEventProcessing.Server.Create(String instanceName, SqlCeMetadataProviderConfiguration config, CheckpointConfiguration checkpointConfig)
   at Microsoft.ComplexEventProcessing.StreamInsightHost.StreamInsightHost.CreateServer(StreamInsightHostConfig streamHostConfig)
   at M...

Answer 4

Ok I figured out the issue.  The link the sql server compact 3.5 sp2 edition (http://www.microsoft.com/en-us/download/details.aspx?id=9290) is broken.  It gives you a version of 3.5.8080.0.

The install requires version 3.5.8085.0.  I had to go through and request a hotfix email to be sent to me which gives you the right version of sql server compact 3.5 sp2.  See http://support.microsoft.com/kb/2516828

It would be nice if they had the proper links.

Answer 5

Why didn't you just install the version of Sql CE 3.5 that is in the redist folder of the StreamInsight installation?

---

DevBiker (aka J Sawyer)
Microsoft MVP - Sql Server (StreamInsight)

---

---

If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.