none
getting streaminsight debugger to work

    質問

  • 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.

    2012年4月30日 18:57

回答

すべての返信

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

    2012年4月30日 19:35
  • 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.
    • 編集済み sma12341 2012年4月30日 20:56
    2012年4月30日 20:44
  • 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...

    2012年4月30日 23:58
  • 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.


    • 回答としてマーク sma12341 2012年5月1日 2:48
    2012年5月1日 2:40
  • 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)


    Ruminations of J.net


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

    2012年5月2日 0:57
    モデレータ