AnsweredAssumed Answered

Context initialization failed

Question asked by rajaram.mummadavarapu on Feb 11, 2016
Latest reply on Feb 12, 2016 by rajaram.mummadavarapu
2016-02-11 13:47:32,805 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:Sqlserver://danuwlc7503:11003;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=docs_alfresco;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;, UserName=docs_alfresco, Microsoft JDBC Driver 4.0 for SQL Server
2016-02-11 13:47:32,806 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect.
2016-02-11 13:47:32,935 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 01110000
More than one Alfresco schema was found when querying the database metadata.
   Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.
        at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:645)
2016-02-11 13:47:32,941 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 01110001 Schema auto-update failed
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1802)

Caused by: org.alfresco.error.AlfrescoRuntimeException: 01110000
More than one Alfresco schema was found when querying the database metadata.
   Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.
        at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:645)

We restarted the alfresco instance and see this above error.


find /apps/ -type f -name 'custom-hibernate-dialect.properties'
gave me 0 results
and
select * from dbo.alf_bootstrap_lock
gave me this error:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.alf_bootstrap_lock'.

Outcomes