topic Context initialization failed in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/284393#M237523 <HTML><HEAD></HEAD><BODY><SPAN>2016-02-11 13:47:32,805 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc<img id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://connect.hyland.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />qlserver://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</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>2016-02-11 13:47:32,935 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: 01110000</SPAN><BR /><SPAN>More than one Alfresco schema was found when querying the database metadata.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:645)</SPAN><BR /><SPAN>2016-02-11 13:47:32,941 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: 01110001 Schema auto-update failed</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1802)</SPAN><BR /><BR /><SPAN>Caused by: org.alfresco.error.AlfrescoRuntimeException: 01110000</SPAN><BR /><SPAN>More than one Alfresco schema was found when querying the database metadata.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:645)</SPAN><BR /><BR /><SPAN>We restarted the alfresco instance and see this above error. </SPAN><BR /><BR /><BR /><SPAN> find /apps/ -type f -name 'custom-hibernate-dialect.properties'</SPAN><BR /><SPAN>gave me 0 results</SPAN><BR /><SPAN>and</SPAN><BR /><SPAN>select * from dbo.alf_bootstrap_lock</SPAN><BR /><SPAN>gave me this error:</SPAN><BR /><SPAN>Msg 208, Level 16, State 1, Line 1</SPAN><BR /><SPAN>Invalid object name 'dbo.alf_bootstrap_lock'.</SPAN><BR /></BODY></HTML> Thu, 11 Feb 2016 21:03:08 GMT rajaram_mummada 2016-02-11T21:03:08Z Context initialization failed https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/284393#M237523 2016-02-11 13:47:32,805 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />qlserver://danuwlc7503:11003;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUni Thu, 11 Feb 2016 21:03:08 GMT https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/284393#M237523 rajaram_mummada 2016-02-11T21:03:08Z Re: Context initialization failed https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/284394#M237524 <HTML><HEAD></HEAD><BODY><SPAN>What version of alfresco?&nbsp;&nbsp; If it's a community one then SQL server is not supported.</SPAN></BODY></HTML> Thu, 11 Feb 2016 23:01:23 GMT https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/284394#M237524 mrogers 2016-02-11T23:01:23Z Re: Context initialization failed https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/284395#M237525 <HTML><HEAD></HEAD><BODY><SPAN>Enterprise version, definitely 4.x.</SPAN><BR /></BODY></HTML> Fri, 12 Feb 2016 00:14:21 GMT https://connect.hyland.com/t5/alfresco-archive/context-initialization-failed/m-p/284395#M237525 rajaram_mummada 2016-02-12T00:14:21Z