Problem with LFSocialBPM configuration

asked on March 22, 2016

Hi,

I recently installed laserfiche socialBPM and now I'm getting this error in the log every 15 min.

Message: System.InvalidOperationException: Unable to complete operation. The supplied SqlConnection does not specify an initial catalog or AttachDBFileName.
System.Data.Entity.SqlServer.SqlProviderServices.GetOrGenerateDatabaseNameAndGetFileNames(SqlConnection sqlConnection, String& databaseName, String& dataFileName, String& logFileName)
à System.Data.Entity.SqlServer.SqlProviderServices.DbCreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
à System.Data.Entity.Core.Common.DbProviderServices.CreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
à System.Data.Entity.Core.Objects.ObjectContext.CreateDatabase()
à System.Data.Entity.Migrations.Utilities.DatabaseCreator.Create(DbConnection connection)
à System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
à System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
à System.Data.Entity.Internal.DatabaseCreator.CreateDatabase(InternalContext internalContext, Func`3 createMigrator, ObjectContext objectContext)
à System.Data.Entity.Internal.InternalContext.CreateDatabase(ObjectContext objectContext, DatabaseExistenceState existenceState)
à System.Data.Entity.Database.Create(DatabaseExistenceState existenceState)
à System.Data.Entity.CreateDatabaseIfNotExists`1.InitializeDatabase(TContext context)
à System.Data.Entity.Internal.InternalContext.<>c__DisplayClassf`1.<CreateInitializationAction>b__e()
à System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)
à System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization()
à System.Data.Entity.Internal.LazyInternalContext.<InitializeDatabase>b__4(InternalContext c)
à System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input)
à System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action)
à System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase()
à System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
à System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
à System.Data.Entity.Internal.Linq.InternalSet`1.GetEnumerator()
à System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator()
à System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
à System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
à Laserfiche.Answers.AnswersService.Repositories.GenericRepository`1.Get(Expression`1 filter, Func`2 orderBy, String includeProperties, Nullable`1 skipNumber, Nullable`1 takeNumber)
à Laserfiche.Answers.AnswersService.Services.SiteSettingService..ctor(IUnitOfWork unitOfWork, SettingsDictionary settingsDictionary)
à Laserfiche.Answers.EmailNotifications.AnswersEmailService.SendEmail()
à Laserfiche.Answers.WindowsService.EmailServiceHost.TimerCallback(Object nopara)

I checked my server name in the lasefiche Social BPM and it seems good. I use windows authentication with a user that should be db owner. The database for Social BPM was created and the name of the table is the same in my configuration.Is there something that i missed ?

0 0

SELECTED ANSWER

replied on March 22, 2016

In IIS, go to the Application Pool node. You should have two nodes for Social BPM inside there - SocialBPMAppPool and SocialBPMConfigAppPool. Right click on each one, go to Advanced Settings. Under the Process Model section, check the account used for the Identity. Please make sure that both have domain accounts and that those have rights to SQL (if using Windows Authentication to connect to the DBMS). Once you have changed those, please restart each application pool then see if the message still occurs.

0 0

View 7 previous replies

replied on March 2, 2017

Local System then.

0 0

replied on March 2, 2017

The error is still here.

[InvalidOperationException: Unable to complete operation. The supplied SqlConnection does not specify an initial catalog or AttachDBFileName.]
   System.Data.Entity.SqlServer.SqlProviderServices.GetOrGenerateDatabaseNameAndGetFileNames(SqlConnection sqlConnection, String& databaseName, String& dataFileName, String& logFileName) +362
   System.Data.Entity.SqlServer.SqlProviderServices.DbCreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection) +179
   System.Data.Entity.Migrations.Utilities.DatabaseCreator.Create(DbConnection connection) +175
   System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase) +175
   System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration) +116
   System.Data.Entity.Internal.DatabaseCreator.CreateDatabase(InternalContext internalContext, Func`3 createMigrator, ObjectContext objectContext) +121
   System.Data.Entity.Database.Create(DatabaseExistenceState existenceState) +293
   System.Data.Entity.CreateDatabaseIfNotExists`1.InitializeDatabase(TContext context) +257
   System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action) +72
   System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization() +483
   System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input) +177
   System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action) +277
   System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) +38
   System.Data.Entity.Internal.Linq.InternalSet`1.Initialize() +77
   System.Data.Entity.Internal.Linq.InternalSet`1.GetEnumerator() +21
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +432
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +70
   Laserfiche.Answers.AnswersService.Repositories.GenericRepository`1.Get(Expression`1 filter, Func`2 orderBy, String includeProperties, Nullable`1 skipNumber, Nullable`1 takeNumber) +296
   Laserfiche.Answers.AnswersService.Services.SiteSettingService..ctor(IUnitOfWork unitOfWork, SettingsDictionary settingsDictionary) +204
   DynamicInjectorf4eb52a7605b42a8a98a9cd8a9cd8ee1(Object[] ) +157
   Ninject.Activation.Context.Resolve() +250
   System.Linq.WhereSelectEnumerableIterator`2.MoveNext() +223
   System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source) +205
   System.Linq.WhereSelectArrayIterator`2.MoveNext() +80
   System.Linq.Buffer`1..ctor(IEnumerable`1 source) +250
   System.Linq.Enumerable.ToArray(IEnumerable`1 source) +106
   Ninject.Activation.Providers.StandardProvider.Create(IContext context) +734
   Ninject.Activation.Context.Resolve() +250
   System.Linq.WhereSelectEnumerableIterator`2.MoveNext() +223
   System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source) +205
   System.Linq.WhereSelectArrayIterator`2.MoveNext() +80
   System.Linq.Buffer`1..ctor(IEnumerable`1 source) +250
   System.Linq.Enumerable.ToArray(IEnumerable`1 source) +106
   Ninject.Activation.Providers.StandardProvider.Create(IContext context) +734
   Ninject.Activation.Context.Resolve() +250
   System.Linq.WhereSelectEnumerableIterator`2.MoveNext() +223
   System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source) +205
   System.Linq.WhereSelectArrayIterator`2.MoveNext() +80
   System.Linq.Buffer`1..ctor(IEnumerable`1 source) +250
   System.Linq.Enumerable.ToArray(IEnumerable`1 source) +106
   Ninject.Activation.Providers.StandardProvider.Create(IContext context) +734
   Ninject.Activation.Context.Resolve() +250
   System.Linq.WhereSelectEnumerableIterator`2.MoveNext() +223
   System.Linq.Enumerable.SingleOrDefault(IEnumerable`1 source) +205
   Ninject.ResolutionExtensions.TryGet(IEnumerable`1 iterator) +62
   Laserfiche.Answers.Infrastructure.NinjectDependencyResolver.GetService(Type serviceType) +81
   System.Web.Mvc.DefaultControllerActivator.Create(RequestContext requestContext, Type controllerType) +59

[InvalidOperationException: An error occurred when trying to create a controller of type 'Laserfiche.Answers.Controllers.HomeController'. Make sure that the controller has a parameterless public constructor.]
   System.Web.Mvc.DefaultControllerActivator.Create(RequestContext requestContext, Type controllerType) +240
   System.Web.Mvc.DefaultControllerFactory.CreateController(RequestContext requestContext, String controllerName) +103
   System.Web.Mvc.MvcHandler.ProcessRequestInit(HttpContextBase httpContext, IController& controller, IControllerFactory& factory) +268
   System.Web.Mvc.MvcHandler.BeginProcessRequest(HttpContextBase httpContext, AsyncCallback callback, Object state) +95
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +923
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +137

0 0

replied on March 2, 2017

Raymond Cruz,

The laserfiche socialBPM's version is 10.2 and my LF server is 9.2. Is it a prob?

0 0

Question

Question

Problem with LFSocialBPM configuration

Answer

Replies

Sign in to reply to this post.