Help
  • Explore Community Expore Community
  • Get started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Brand Logo
Help
  • Explore Community Explore Community
  • Get started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
close
  • Community Home
  • Forums
    • By Topic
    • By Topic
      EcoStruxure Building
      • Field Devices Forum
      • SmartConnector Forum
      EcoStruxure Power & Grid
      • EcoStruxure Asset Advisor
      • Gateways and Energy Servers
      • Metering & Power Quality
      • Protection & Control
      APC UPS, Critical Power, Cooling and Racks
      • APC UPS Data Center & Enterprise Solutions Forum
      • APC UPS for Home and Office Forum
      EcoStruxure IT
      • EcoStruxure IT forum
      • EcoStruxure ITโ„ข Advisor CFD
      Remote Operations
      • EcoStruxure Geo SCADA Expert Forum
      • Remote Operations Forum
      Industrial Automation
      • Alliance System Integrators Forum
      • AVEVA Plant SCADA Forum
      • CPG Expert Forum DACH
      • EcoStruxure Automation Expert / IEC 61499 Forum
      • Fabrika ve Makina Otomasyonu ร‡รถzรผmleri
      • Harmony Control Customization Forum
      • Industrial Edge Computing Forum
      • Industry Automation and Control Forum
      • Korea Industrial Automation Forum
      • Machine Automation Forum
      • Modicon PAC Forum
      • PLC Club Indonesia
      Schneider Electric Wiser
      • Schneider Electric Wiser Forum
      Power Distribution IEC
      • Eldistribution & Fastighetsautomation
      • Elektrik Tasarฤฑm DaฤŸฤฑtฤฑm ve Uygulama ร‡รถzรผmleri
      • Paneelbouw & Energie Distributie
      • Power Distribution and Digital
      • Solutions for Motor Management
      Power Distribution NEMA
      • Power Monitoring and Energy Automation NAM
      Power Distribution Software
      • EcoStruxure Power Design Forum
      • LayoutFAST User Group Forum
      Energy & Sustainability Services
      • Green Building Scoring and Certification Forum
      Light and Room Control
      • SpaceLogic C-Bus Forum
      Solutions for your Business
      • Solutions for your Business Forum
      Support
      • Ask the Community
  • Knowledge Center
    • Building Automation Knowledge Base
    • Remote Operations Devices Knowledge Base
    • Geo SCADA Knowledge Base
    • Industrial Automation How-to videos
    • Digital E-books
    • Success Stories Corner
    • EcoStruxure IT Help Center
  • Events & Webinars
    • All Events
    • Innovation Talks
    • Innovation Summit
    • Let's Exchange Series
    • Partner Success
    • Technology Partners
  • Ideas
    • EcoStruxure Building
      • EcoStruxure Building Advisor Ideas
      Remote Operations
      • EcoStruxure Geo SCADA Expert Ideas
      • Remote Operations Devices Ideas
      Industrial Automation
      • Modicon Ideas & new features
  • Blogs
    • By Topic
    • By Topic
      EcoStruxure Power & Grid
      • Backstage Access Resources
      EcoStruxure IT
      • EcoStruxure ITโ„ข Advisor CFD
      Remote Operations
      • Remote Operations Blog
      Industrial Automation
      • Industrie du Futur France
      • Industry 4.0 Blog
      Power Distribution NEMA
      • NEMA Power Foundations Blog
      Energy & Sustainability Services
      • Active Energy Management Blog
      Light and Room Control
      • KNX Blog
      Knowledge Center
      • Digital E-books
      • Geo SCADA Knowledge Base
      • Industrial Automation How-to videos
      • Remote Operations Devices Knowledge Base
      • Success Stories Corner
  • companyImpact

Trouble connecting to SmartConnect config page after fresh install

SmartConnector Forum

Schneider Electric support forum about SmartConnector applications for integration of other building management systems (BMS) into EcoStruxure Building Operation.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Showย ย onlyย  | Search instead forย 
Did you mean:ย 
  • Home
  • Schneider Electric Community
  • EcoStruxure Building
  • SmartConnector
  • SmartConnector Forum
  • Trouble connecting to SmartConnect config page after fresh install
Options
  • Subscribe to RSS Feed
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Experts
User Count
JeffBowman
JeffBowman Schneider Alumni (Retired)
164
sesa180908_brid
Commander sesa180908_brid Commander
34
ardak
ardak Schneider Alumni (Retired)
34
mike_meirovitz
Commander mike_meirovitz
21
View All

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Back to SmartConnector Forum
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 08:54 AM

0 Likes
17
730
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 08:54 AM

Trouble connecting to SmartConnect config page after fresh install

I've just installed SmartConnector v2.2.127:

I'm able to install it, and the service is running, but I can't seem to connect to 'http://localhost:8082'.

Database:

LocalDB

Installation settings:

Logs:

2017-03-09 11:47:41.0558,Info,Utility,<no principal>,InstallDatabase,

2017-03-09 11:47:41.1238,Debug,Utility,<no principal>,Installing a new database:,(localdb)\MSSQLLocalDB,SmartConnector,sa,

2017-03-09 11:47:41.1238,Debug,Utility,<no principal>,UtilityConfigFilePath,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Utility.exe.config,

2017-03-09 11:47:41.1518,Debug,Utility,<no principal>,ServiceConfigFilePath,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Service.exe.config,

2017-03-09 11:48:00.5468,Debug,Utility,<no principal>,ServiceConfigFilePath,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Service.exe.config,

2017-03-09 11:48:00.5468,Debug,Utility,<no principal>,UpdateServiceConfigurationDbConnectionString,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Service.exe.config,

2017-03-09 11:48:00.5468,Debug,Utility,<no principal>,UtilityConfigFilePath,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Utility.exe.config,

2017-03-09 11:48:00.5468,Debug,Utility,<no principal>,UpdateServiceConfigurationDbConnectionString,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Utility.exe.config,

2017-03-09 11:48:00.5658,Debug,Utility,<no principal>,Updating config file runtime section from upgrade file,

2017-03-09 11:48:08.7048,Debug,Utility,<no principal>,Adding required permissions for Windows Authentication,

2017-03-09 11:48:09.9298,Debug,Utility,<no principal>,Add Sample ProcessConfigurations,

2017-03-09 11:48:10.0688,Debug,Utility,<no principal>,Add Sample Ews Server,

2017-03-09 11:48:10.0688,Debug,Database,<no principal>,SeedEwsServer,EwsServer,

2017-03-09 11:48:10.2998,Debug,Database,<no principal>,SeedEwsServer,EwsUser,

2017-03-09 11:48:10.3978,Debug,Database,<no principal>,SeedEwsServer,Data,

2017-03-09 11:48:10.8428,Debug,Utility,<no principal>,Add Sample EndpointConfigurations,

2017-03-09 11:48:11.1498,Debug,Utility,<no principal>,Add Sample Schedule,

2017-03-09 11:48:11.3548,Debug,Utility,<no principal>,Installation complete,

2017-03-09 11:48:17.8288,Status,Service,<no principal>,SmartConnector is starting,

2017-03-09 11:48:17.8678,Info,Service,<no principal>,Cleaning up orphaned ParameterSet instances,

2017-03-09 11:48:18.1608,Status,Service,<no principal>,Spinning up WorkerManager,

2017-03-09 11:48:18.1608,Status,WorkerManager,<no principal>,Mongoose WorkerManager running with 5 Processor threads.,

2017-03-09 11:48:18.3028,Status,WorkerManager,<no principal>,Worker manager has started.,

2017-03-09 11:48:18.3618,Status,Service,<no principal>,Attaching context listeners,

2017-03-09 11:48:18.8378,Status,Service,<no principal>,PortalAddress disabled because there is no defined endpoint.,

2017-03-09 11:49:15.4398,Status,Service,<no principal>,SmartConnector is stopping,

2017-03-09 11:49:15.4398,Status,Service,<no principal>,Stopping REST Providers,

2017-03-09 11:49:15.4528,Status,Service,<no principal>,Detaching context listeners,

2017-03-09 11:49:15.4528,Status,Service,<no principal>,Stopping EWS Servers,

2017-03-09 11:49:15.4778,Status,Service,<no principal>,Stopping WorkerManager,

2017-03-09 11:49:18.6948,Status,WorkerManager,<no principal>,Worker manager has stopped.,

2017-03-09 11:49:27.2398,Status,Service,<no principal>,SmartConnector is starting,

2017-03-09 11:49:27.2788,Info,Service,<no principal>,Cleaning up orphaned ParameterSet instances,

2017-03-09 11:49:27.5688,Status,Service,<no principal>,Spinning up WorkerManager,

2017-03-09 11:49:27.5728,Status,WorkerManager,<no principal>,Mongoose WorkerManager running with 5 Processor threads.,

2017-03-09 11:49:27.7558,Status,WorkerManager,<no principal>,Worker manager has started.,

2017-03-09 11:49:27.8328,Status,Service,<no principal>,Attaching context listeners,

2017-03-09 11:49:28.2318,Status,Service,<no principal>,PortalAddress disabled because there is no defined endpoint.,

Tags (6)
  • Tags:
  • configure
  • connect
  • installation
  • localdb
  • service
  • smartconnector
Reply
  • All forum topics
  • Previous Topic
  • Next Topic
Replies 17
sesa180908_brid
Commander sesa180908_brid Commander
Commander

Posted: โ€Ž2017-03-09 09:45 AM

0 Likes
5
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 09:45 AM

Josh,

Thanks for the input.  There was another report of this issue on the forum (SmartConnector Portal is not available. ) that is very similar (if not exact).

Try reinstalling the database as instructed in that thread.  Not sure why this is occurring (I use LocalDB myself and have never seen this) but I will certainly investigate further.

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 10:42 AM

0 Likes
4
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 10:42 AM

I attempted to reinstall the LocalDB database.

steps:

uninstall LocalDB

stop the SmartConnector service

reinstall LocalDB

I ran Mongoose.Utility.exe /CreateDatabase

restarted the service.

I'm still unable to connect to the web portal.

I also tried reinstalling both.

steps:

uninstall SmartConnector

uninstall LocalDB

reinstall LocalDB

reinstall SmartConnector

still isn't responding.

logs look the same as before.

Reply
sesa180908_brid
Commander sesa180908_brid Commander
Commander

Posted: โ€Ž2017-03-09 11:36 AM

0 Likes
3
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 11:36 AM

As I've said, we do use LocalDB for development here so this should work.

I'm wondering if its just the connection string you're using for LocalDB (the one you entered in the installer.  You can read it from the "mongoose.service.exe.config" file in the install folder.

For LocalDB, it should look something like this:

Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=SmartConnector.Service;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\SmartConnector.mdf"

NOTE:  There are two connections, one for SmartConnectorDb and one for SmartConnectorUserDb.  Both should be identical.  Also, if you make any changes, make those changes in the "mongoose.utility.exe.config" file as well.

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 12:26 PM

0 Likes
2
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 12:26 PM

my config differed a little from what you have:

connectionString = "Server=(localdb)\MSSQLLocalDB;Initial Catalog=SmartConnector;Integrated Security=SSPI"

I stopped the service, and changed this to:

connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=SmartConnector.Service;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\SmartConnector.mdf"

upon restarting the service, it is still not letting me connect to the localhost:8082

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 12:27 PM

0 Likes
0
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 12:27 PM

for reference, here is my current Mongoose.Service.exe.config:

<?xml version="1.0" encoding="utf-8"?>

<configuration>

  <configSections>

    <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"></sectionGroup>

    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

    <section name="system.identityModel" type="System.IdentityModel.Configuration.SystemIdentityModelSection, System.IdentityModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />

    <section name="system.identityModel.services" type="System.IdentityModel.Services.Configuration.SystemIdentityModelServicesSection, System.IdentityModel.Services, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />

    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->

  </configSections>

  <connectionStrings>

    <add name="SmartConnectorDb" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=SmartConnector.Service;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\SmartConnector.mdf" />

    <add name="SmartConnectorUserDb" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=SmartConnector.Service;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\SmartConnector.mdf" />

  </connectionStrings>

  <appSettings>

    <add key="EncryptionKey" value="C1D0A0C9EAB5D88D1BEE3A50243E3A032DFA82B380515504021EADEDCAF496A9" />

  </appSettings>

  <entityFramework>

    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />

    <providers>

      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />

    </providers>

  </entityFramework>

  <runtime>

    <bypassTrustedAppStrongNames enabled="false" />

    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

      <dependentAssembly>

        <assemblyIdentity name="System.Web.Http" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="System.Net.Http.Formatting" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-5.1.0.0" newVersion="5.1.0.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="System.IdentityModel.Tokens.Jwt" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-4.0.0.0" newVersion="4.0.0.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-9.0.0.0" newVersion="9.0.0.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="Microsoft.Data.Edm" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-5.7.0.0" newVersion="5.7.0.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="Microsoft.Data.OData" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-5.7.0.0" newVersion="5.7.0.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="System.Spatial" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-5.7.0.0" newVersion="5.7.0.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-1.5.2.14234" newVersion="1.5.2.14234" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="Microsoft.Owin" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="Microsoft.Owin.Security" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="Microsoft.Owin.Security.OAuth" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />

      </dependentAssembly>

      <dependentAssembly>

        <assemblyIdentity name="Microsoft.Owin.Security.Cookies" publicKeyToken="31bf3856ad364e35" culture="neutral" />

        <bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />

      </dependentAssembly>

    </assemblyBinding>

  </runtime>

</configuration>

Reply
sesa180908_brid
Commander sesa180908_brid Commander
Commander

Posted: โ€Ž2017-03-09 12:37 PM

0 Likes
0
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 12:37 PM

I think I entered that incorrectly.  Let's reset here.

Please try the following:

  1. Stop the service.
  2. Update your config files (mongoose.server.exe.config and mongoose.utility.exe.config) as below:
  3. Run mongoose.utility.exe /CreateDatabase from a command line.
  4. After step 3 completes, Run mongoose.utility.exe /ReadSettings.  This should dump out the content of the settings table (which is empty currently and why the portal doesn't start).
  5. If you see data in the console window you should be good to go.
  6. Start the service.

<connectionStrings>

<add name="SmartConnectorDb" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=SmartConnector.Service;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\SmartConnector.mdf" />

<add name="SmartConnectorUserDb" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=SmartConnector.Users;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\SmartConnectorUser.mdf" />

</connectionStrings>

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 12:53 PM

0 Likes
7
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 12:53 PM

Step 3 failed:

C:\Program Files (x86)\Schneider Electric\SmartConnector>mongoose.utility.exe /CreateDatabase

Info,Utility,<no principal>,CreateDatabase

Error,Utility,<no principal>,Cannot create file 'C:\ProgramData\SmartConnector\SmartConnector.mdf' because it already exists. Change the file path or the file name, and retry the operation.

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

  at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

  at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c)

  at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)

  at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)

  at System.Data.Entity.SqlServer.SqlProviderServices.<>c__DisplayClass1a.<CreateDatabaseFromScript>b__19(DbConnection conn)

  at System.Data.Entity.SqlServer.SqlProviderServices.<>c__DisplayClass33.<UsingConnection>b__32()

  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()

  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)

  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Action operation)

  at System.Data.Entity.SqlServer.SqlProviderServices.UsingConnection(DbConnection sqlConnection, Action`1 act)

  at System.Data.Entity.SqlServer.SqlProviderServices.UsingMasterConnection(DbConnection sqlConnection, Action`1 act)

  at System.Data.Entity.SqlServer.SqlProviderServices.CreateDatabaseFromScript(Nullable`1 commandTimeout, DbConnection sqlConnection, String createDatabaseScript)

  at System.Data.Entity.SqlServer.SqlProviderServices.DbCreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)

  at System.Data.Entity.Core.Common.DbProviderServices.CreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)

  at System.Data.Entity.Core.Objects.ObjectContext.CreateDatabase()

  at System.Data.Entity.Migrations.Utilities.DatabaseCreator.Create(DbConnection connection)

  at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)

  at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)

  at System.Data.Entity.Internal.DatabaseCreator.CreateDatabase(InternalContext internalContext, Func`3 createMigrator, ObjectContext objectContext)

  at System.Data.Entity.Internal.InternalContext.CreateDatabase(ObjectContext objectContext, DatabaseExistenceState existenceState)

  at System.Data.Entity.Database.Create(DatabaseExistenceState existenceState)

  at System.Data.Entity.CreateDatabaseIfNotExists`1.InitializeDatabase(TContext context)

  at System.Data.Entity.Internal.InternalContext.<>c__DisplayClassf`1.<CreateInitializationAction>b__e()

  at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)

  at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization()

  at System.Data.Entity.Internal.LazyInternalContext.<InitializeDatabase>b__4(InternalContext c)

  at System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input)

  at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action)

  at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase()

  at System.Data.Entity.Internal.InternalContext.ForceOSpaceLoadingForKnownEntityTypes()

  at System.Data.Entity.DbContext.System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext()

  at Mongoose.Service.Data.MongooseDbContext.WireUpEncryption()

  at Mongoose.Service.Data.MongooseDbContext..ctor(Boolean automaticDecryption)

  at Mongoose.Service.UtilityHelper.DeleteDatabase_Internal()

,["Deleting MongooseDbContext"]

Debug,Utility,<no principal>,ServiceConfigFilePath,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Service.exe.config

Debug,Utility,<no principal>,UpdateServiceConfigurationDbConnectionString,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Service.exe.config

Debug,Utility,<no principal>,UtilityConfigFilePath,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Utility.exe.config

Debug,Utility,<no principal>,UpdateServiceConfigurationDbConnectionString,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Utility.exe.config

Debug,Utility,<no principal>,Cannot upgrade config file runtime section because runtime.xml file not found at: C:\Program Files (x86)\Schneider Electric\SmartConnector\runtime.xml

Error,Utility,<no principal>,Cannot create file 'C:\ProgramData\SmartConnector\SmartConnector.mdf' because it already exists. Change the file path or the file name, and retry the operation.

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

  at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

  at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c)

  at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)

  at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)

  at System.Data.Entity.SqlServer.SqlProviderServices.<>c__DisplayClass1a.<CreateDatabaseFromScript>b__19(DbConnection conn)

  at System.Data.Entity.SqlServer.SqlProviderServices.<>c__DisplayClass33.<UsingConnection>b__32()

  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()

  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)

  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Action operation)

  at System.Data.Entity.SqlServer.SqlProviderServices.UsingConnection(DbConnection sqlConnection, Action`1 act)

  at System.Data.Entity.SqlServer.SqlProviderServices.UsingMasterConnection(DbConnection sqlConnection, Action`1 act)

  at System.Data.Entity.SqlServer.SqlProviderServices.CreateDatabaseFromScript(Nullable`1 commandTimeout, DbConnection sqlConnection, String createDatabaseScript)

  at System.Data.Entity.SqlServer.SqlProviderServices.DbCreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)

  at System.Data.Entity.Core.Common.DbProviderServices.CreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)

  at System.Data.Entity.Core.Objects.ObjectContext.CreateDatabase()

  at System.Data.Entity.Migrations.Utilities.DatabaseCreator.Create(DbConnection connection)

  at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)

  at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)

  at Mongoose.Service.UtilityHelper.UpdateDatabase_Internal(Boolean windowsLogIn, Boolean domainUser)

  at Mongoose.Service.UtilityHelper.CreateDatabase(Boolean addSampleData, Boolean windowsLogIn, Boolean domainUser)

,[]

Error,Utility,<no principal>,Cannot create file 'C:\ProgramData\SmartConnector\SmartConnector.mdf' because it already exists. Change the file path or the file name, and retry the operation.

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

  at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

  at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c)

  at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)

  at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)

  at System.Data.Entity.SqlServer.SqlProviderServices.<>c__DisplayClass1a.<CreateDatabaseFromScript>b__19(DbConnection conn)

  at System.Data.Entity.SqlServer.SqlProviderServices.<>c__DisplayClass33.<UsingConnection>b__32()

  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()

  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)

  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Action operation)

  at System.Data.Entity.SqlServer.SqlProviderServices.UsingConnection(DbConnection sqlConnection, Action`1 act)

  at System.Data.Entity.SqlServer.SqlProviderServices.UsingMasterConnection(DbConnection sqlConnection, Action`1 act)

  at System.Data.Entity.SqlServer.SqlProviderServices.CreateDatabaseFromScript(Nullable`1 commandTimeout, DbConnection sqlConnection, String createDatabaseScript)

  at System.Data.Entity.SqlServer.SqlProviderServices.DbCreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)

  at System.Data.Entity.Core.Common.DbProviderServices.CreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)

  at System.Data.Entity.Core.Objects.ObjectContext.CreateDatabase()

  at System.Data.Entity.Migrations.Utilities.DatabaseCreator.Create(DbConnection connection)

  at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)

  at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)

  at Mongoose.Service.UtilityHelper.UpdateDatabase_Internal(Boolean windowsLogIn, Boolean domainUser)

  at Mongoose.Service.UtilityHelper.CreateDatabase(Boolean addSampleData, Boolean windowsLogIn, Boolean domainUser)

  at Mongoose.Utility.Program.TestableMain(String[] args)

  at Mongoose.Utility.Program.Main(String[] args)

,[]

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 12:56 PM

0 Likes
0
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 12:56 PM

to work around this, i have renamed the files SmartConnector.mdf and SmartConnector_log.ldf

Reply
sesa180908_brid
Commander sesa180908_brid Commander
Commander

Posted: โ€Ž2017-03-09 12:59 PM

0 Likes
5
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 12:59 PM

Well CreateDatabase runs DeleteDatabase first so clearly that step failed.  Could be something has it locked.  You can manually delete the database files yourself.  They are in the C:\ProgramData\SmartConnector folder.  If you can't, something has the DB locked.  Might need to reboot to clear that.  But make sure that the service doesn't auto-start.

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 01:02 PM

0 Likes
0
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 01:02 PM

I was able to complete all the steps.

unfortunately, now the service seems to crash shortly after being started.

logs are now showing:

2017-03-09 15:58:44.3813,Status,Service,<no principal>,SmartConnector is starting,

2017-03-09 15:58:44.4203,Info,Service,<no principal>,Cleaning up orphaned ParameterSet instances,

2017-03-09 15:58:44.7343,Status,Service,<no principal>,Spinning up WorkerManager,

2017-03-09 15:58:44.7343,Status,WorkerManager,<no principal>,Mongoose WorkerManager running with 5 Processor threads.,

2017-03-09 15:58:44.9773,Status,WorkerManager,<no principal>,Worker manager has started.,

2017-03-09 15:58:45.0503,Status,Service,<no principal>,Attaching context listeners,

2017-03-09 15:58:45.3653,Error,Service,<no principal>,The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.  Please enable the Service Broker for this database if you wish to use notifications.

   at SqlDependencyProcessDispatcher.SqlConnectionContainer..ctor(SqlConnectionContainerHashHelper hashHelper, String appDomainKey, Boolean useDefaults)

   at SqlDependencyProcessDispatcher.Start(String connectionString, String& server, DbConnectionPoolIdentity& identity, String& user, String& database, String& queueService, String appDomainKey, SqlDependencyPerAppDomainDispatcher dispatcher, Boolean& errorOccurred, Boolean& appDomainStart, Boolean useDefaults)

   at SqlDependencyProcessDispatcher.StartWithDefault(String connectionString, String& server, DbConnectionPoolIdentity& identity, String& user, String& database, String& service, String appDomainKey, SqlDependencyPerAppDomainDispatcher dispatcher, Boolean& errorOccurred, Boolean& appDomainStart)

   at System.Data.SqlClient.SqlDependency.Start(String connectionString, String queue, Boolean useDefaults)

   at Mongoose.Service.Notifications.EntityChangeNotifier.AddConnectionString(String cs)

   at Mongoose.Service.Notifications.EntityChangeNotifier`2..ctor(Expression`1 query)

   at Mongoose.Service.Mongoose.StartDbContextNotificationListeners()

   at Mongoose.Service.Mongoose.OnStart(String[] args)

,[],

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 01:03 PM

0 Likes
0
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 01:03 PM

I will try rebooting the pc, and see if that sorts something out

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 01:25 PM

0 Likes
2
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 01:25 PM

rebooting did not fix the issue

Reply
sesa180908_brid
Commander sesa180908_brid Commander
Commander

Posted: โ€Ž2017-03-09 01:54 PM

0 Likes
1
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 01:54 PM

To be honest, while we use LocalDB for dev work, it's not meant for production so installer testing around that was probably minimal.  The installer only interacts with the Utility and the configs anyway.

The error you are seeing is because the LocalDB instance you're referencing in the config files doesn't exist on your machine.

  1. Open up Visual Studio
  2. Select View-SQL Server Object Explorer
  3. Right click the SQL Server node in the window.
  4. Select Add Server
  5. Expand Local

Should look something like this:

2017-03-09_16-48-52.png

What ever is listed (and it depends on what VS version you're using and/or what updates you've installed) is what needs to go in the config files. If MSSQLLocalDB isn't there (as I suspect) then update the config setting to what is there and then run the "CreateDatabase" step again.

It this doesn't work, we're going to need to do a WebEx or something.

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 02:36 PM

0 Likes
0
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 02:36 PM

Alright, I have followed your steps, and here are my results:

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-09 02:49 PM

0 Likes
2
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 02:49 PM

It may be useful to know that I went to the trouble to completely uninstall all SQL components, as well as Visual Studio before installing LocalDB (I had to reinstall Visual Studio to follow the above instructions).

We're exploring LocalDB with the goal of producing as minimal a deployment of SmartConnector as possible, so as to simplify installation.

In a perfect world, SmartConnector would have an option to deploy its own local database, further simplifying deployment, while still leaving the option of hosting on an existing SQL server

Reply
sesa180908_brid
Commander sesa180908_brid Commander
Commander

Posted: โ€Ž2017-03-09 05:16 PM

0 Likes
1
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-09 05:16 PM

I was able to reproduce what you are experiencing on a test machine.  There are definitely issues with the installer when attempting to use LocalDB.  We'll have to look at that for future releases but you can certainly get this configured and operational manually after the installer runs.  Here are the steps I used to get this operational.

Let's assume that you have run the installer and the service is NOT running.  Then follow these steps.

  1. Open Visual Studio
  2. View-Sql Server Object Explorer
  3. Delete any "SmartConnector" DB there for earlier attempts.  Make sure you choose "Close Connections".
  4. In the deploy folder, edit the "mongoose.service.config" and "mongoose.utility.config" files so that the connection strings section are EXACTLY as shown below.
  5. Open a command prompt as an Administrator
  6. Run mongoose.utility.exe /createdatabase
  7. You can verify that the database was created from Visual Studio Object Explorer by refreshing.  You should see the "SmartConnector.Service" database.
  8. Start the service.
  9. The portal should be visible.  You can change the default password and install your runtime licese now as described in the Installation and Configuration guide.

Thanks for your patience on this.

 

  <connectionStrings>

  <add name="SmartConnectorDb" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=SmartConnector.Service;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\SmartConnector.mdf" />

  <add name="SmartConnectorUserDb" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=SmartConnector.Users;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\SmartConnectorUser.mdf" />

  </connectionStrings>

Reply
jritchey_jaxcon
Lieutenant JG jritchey_jaxcon
Lieutenant JG

Posted: โ€Ž2017-03-10 06:58 AM

0 Likes
0
597
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

โ€Ž2017-03-10 06:58 AM

sorry for the delay.

I have attempted the above steps.

I'm observing a problem creating the database 'SmartConnector.Users',

and the SmartConnectorService crashes upon startup, complaining about ServiceBroker not being enabled

relevant logs:

2017-03-10 09:46:07.4614,Status,Service,<no principal>,SmartConnector is stopping,

2017-03-10 09:46:07.4614,Status,Service,<no principal>,Stopping REST Providers,

2017-03-10 09:46:07.4731,Status,Service,<no principal>,Detaching context listeners,

2017-03-10 09:46:07.4731,Status,Service,<no principal>,Stopping EWS Servers,

2017-03-10 09:46:07.5013,Status,Service,<no principal>,Stopping WorkerManager,

2017-03-10 09:46:08.2684,Status,WorkerManager,<no principal>,Worker manager has stopped.,

2017-03-10 09:48:16.9602,Info,Utility,<no principal>,CreateDatabase,

2017-03-10 09:48:27.2743,Debug,Utility,<no principal>,ServiceConfigFilePath,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Service.exe.config,

2017-03-10 09:48:27.2743,Debug,Utility,<no principal>,UpdateServiceConfigurationDbConnectionString,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Service.exe.config,

2017-03-10 09:48:27.2842,Debug,Utility,<no principal>,UtilityConfigFilePath,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Utility.exe.config,

2017-03-10 09:48:27.2842,Debug,Utility,<no principal>,UpdateServiceConfigurationDbConnectionString,C:\Program Files (x86)\Schneider Electric\SmartConnector\Mongoose.Utility.exe.config,

2017-03-10 09:48:27.2842,Debug,Utility,<no principal>,Cannot upgrade config file runtime section because runtime.xml file not found at: C:\Program Files (x86)\Schneider Electric\SmartConnector\runtime.xml,

2017-03-10 09:48:35.7054,Debug,Utility,<no principal>,Add Sample ProcessConfigurations,

2017-03-10 09:48:35.8471,Debug,Utility,<no principal>,Add Sample Ews Server,

2017-03-10 09:48:35.8471,Debug,Database,<no principal>,SeedEwsServer,EwsServer,

2017-03-10 09:48:36.0967,Debug,Database,<no principal>,SeedEwsServer,EwsUser,

2017-03-10 09:48:36.2017,Debug,Database,<no principal>,SeedEwsServer,Data,

2017-03-10 09:48:36.5979,Debug,Utility,<no principal>,Add Sample EndpointConfigurations,

2017-03-10 09:48:37.0139,Debug,Utility,<no principal>,Add Sample Schedule,

2017-03-10 09:48:37.1942,Debug,Utility,<no principal>,Database Created,

2017-03-10 09:49:09.8470,Error,Service,<no principal>,Cannot attach the file 'C:\ProgramData\SmartConnector\SmartConnectorUser.mdf' as database 'SmartConnector.Users'.

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)

  at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)

  at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)

  at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)

  at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)

  at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)

  at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)

  at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

  at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

  at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

  at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)

  at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)

  at System.Data.SqlClient.SqlConnection.Open()

  at Microsoft.AspNet.Identity.EntityFramework.IdentityDbContext`1.IsIdentityV1Schema(DbContext db)

  at Mongoose.Service.Portal.Authentication.MongooseUserDbContext.Initialize()

  at Mongoose.Service.Mongoose.InitializeUserDbContext()

,["InitializeUserDbContext.Initialize() failed.  If this occurs in the runtime the user DB may not be present or is corrupted."],

2017-03-10 09:49:10.2600,Status,Service,<no principal>,SmartConnector is starting,

2017-03-10 09:49:10.2600,Info,Service,<no principal>,Cleaning up orphaned ParameterSet instances,

2017-03-10 09:49:10.6087,Status,Service,<no principal>,Spinning up WorkerManager,

2017-03-10 09:49:10.6087,Status,WorkerManager,<no principal>,Mongoose WorkerManager running with 5 Processor threads.,

2017-03-10 09:49:10.8286,Status,WorkerManager,<no principal>,Worker manager has started.,

2017-03-10 09:49:10.9098,Status,Service,<no principal>,Attaching context listeners,

2017-03-10 09:49:11.0346,Error,Service,<no principal>,The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.  Please enable the Service Broker for this database if you wish to use notifications.

  at SqlDependencyProcessDispatcher.SqlConnectionContainer..ctor(SqlConnectionContainerHashHelper hashHelper, String appDomainKey, Boolean useDefaults)

  at SqlDependencyProcessDispatcher.Start(String connectionString, String& server, DbConnectionPoolIdentity& identity, String& user, String& database, String& queueService, String appDomainKey, SqlDependencyPerAppDomainDispatcher dispatcher, Boolean& errorOccurred, Boolean& appDomainStart, Boolean useDefaults)

  at SqlDependencyProcessDispatcher.StartWithDefault(String connectionString, String& server, DbConnectionPoolIdentity& identity, String& user, String& database, String& service, String appDomainKey, SqlDependencyPerAppDomainDispatcher dispatcher, Boolean& errorOccurred, Boolean& appDomainStart)

  at System.Data.SqlClient.SqlDependency.Start(String connectionString, String queue, Boolean useDefaults)

  at Mongoose.Service.Notifications.EntityChangeNotifier.AddConnectionString(String cs)

  at Mongoose.Service.Notifications.EntityChangeNotifier`2..ctor(Expression`1 query)

  at Mongoose.Service.Mongoose.StartDbContextNotificationListeners()

  at Mongoose.Service.Mongoose.OnStart(String[] args)

,[],

Reply
Preview Exit Preview

never-displayed

You must be signed in to add attachments

never-displayed

Additional options
You do not have permission to remove this product association.
ย 
To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings ยฉ 2023 Schneider Electric, Inc