SQL Server

[psycdoc]

Hello, I am a bit new to installing Alfresco and have encountered an issue I cannot seem to get past. I have installed Alfresco 4.2.3.1 on windows 2012 and during the install I did not install the database as I was planning on connecting it to SQL Server 2012. I followed the instructions and when I change the "dir.root=C:/Alfresco/alf_data" entry to "dir.root=E:/efs" in the properties file I am unable to log into the system. If I leave the "dir.root=C:/Alfresco/alf_data", everything works fine and I can access the system. I have reinstalled at least 7 times with the same results. For the record I have copied all of the content from :dir.root=C:/Alfresco/alf_data" to the new directory and it does not seem to resolve the issue. When I try to log onto the system I get the following error "Your authentication details have not been recognized or Alfresco may not be available at this time"

Any help would be appreciated

Here is the stdot log:

2014-10-11 12:19:10 Commons Daemon procrun stdout initialized
2014-10-11 12:19:18,111  WARN  [handler.component.SpellCheckComponent] [localhost-startStop-1] No queryConverter defined, using default converter
2014-10-11 12:19:19,359  WARN  [handler.component.SpellCheckComponent] [localhost-startStop-1] No queryConverter defined, using default converter
2014-10-11 12:19:41,433  INFO  [alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbc:sqlserver://69.175.90.52:1433;databaseName=alfrescoprod' with user 'alfrescoprod'.
2014-10-11 12:19:41,698  INFO  [alfresco.repo.admin] [localhost-startStop-1] Connected to database Microsoft SQL Server version 11.00.3128
2014-10-11 12:19:48,328  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
2014-10-11 12:19:48,359  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
2014-10-11 12:19:48,406  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes
2014-10-11 12:20:00,762  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl
2014-10-11 12:20:00,777  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js
2014-10-11 12:20:08,250  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:sqlserver://69.175.90.52:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=alfrescoprod;applicationName=Microsoft SQL Server JDBC Driver;, UserName=alfrescoprod, Microsoft SQL Server JDBC Driver 3.0
2014-10-11 12:20:08,250  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect.
2014-10-11 12:20:10,293  ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
org.springframework.dao.DuplicateKeyException:
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).
### The error may involve alfresco.appliedpatch.insert_AppliedPatch-Inline
### The error occurred while setting parameters
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).
; SQL []; Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
   at com.sun.proxy.$Proxy9.insert(Unknown Source)
   at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:231)
   at org.alfresco.repo.domain.patch.ibatis.AppliedPatchDAOImpl.createAppliedPatchEntity(AppliedPatchDAOImpl.java:52)
   at org.alfresco.repo.domain.patch.AbstractAppliedPatchDAOImpl.createAppliedPatch(AbstractAppliedPatchDAOImpl.java:39)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:1003)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1689)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
   at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
   at java.util.concurrent.FutureTask.run(FutureTask.java:166)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
   at java.lang.Thread.run(Thread.java:724)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)
   at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)
   at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:87)
   at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:46)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:107)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
   … 30 more
2014-10-11 12:20:10,293  ERROR [web.context.ContextLoader] [localhost-startStop-1] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 09110000 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1788)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
   at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
   at java.util.concurrent.FutureTask.run(FutureTask.java:166)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
   at java.lang.Thread.run(Thread.java:724)
Caused by: org.springframework.dao.DuplicateKeyException:
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).
### The error may involve alfresco.appliedpatch.insert_AppliedPatch-Inline
### The error occurred while setting parameters
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).
; SQL []; Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
   at com.sun.proxy.$Proxy9.insert(Unknown Source)
   at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:231)
   at org.alfresco.repo.domain.patch.ibatis.AppliedPatchDAOImpl.createAppliedPatchEntity(AppliedPatchDAOImpl.java:52)
   at org.alfresco.repo.domain.patch.AbstractAppliedPatchDAOImpl.createAppliedPatch(AbstractAppliedPatchDAOImpl.java:39)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:1003)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1689)
   … 24 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__alf_appl__3213E83F010F028F'. Cannot insert duplicate key in object 'dbo.alf_applied_patch'. The duplicate key value is (patch.db-V4.0-Activiti-task-id-indexes).
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)
   at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)
   at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:87)
   at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:46)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:107)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
   … 30 more
2014-10-11 12:20:24,115  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2014-10-11 12:20:24,193  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
2014-10-11 12:20:24,193  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2014-10-11 12:20:24,193  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
2014-10-11 12:20:26,876  INFO  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 359 Web Scripts (+0 failed), 373 URLs
2014-10-11 12:20:26,876  INFO  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 8 Package Description Documents (+0 failed)
2014-10-11 12:20:26,876  INFO  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 0 Schema Description Documents (+0 failed)
2014-10-11 12:20:27,095  INFO  [extensions.webscripts.AbstractRuntimeContainer] [localhost-startStop-1] Initialised Spring Surf Container Web Script Container (in 2894.6714ms)
2014-10-11 12:20:27,110  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2014-10-11 12:20:27,110  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
2014-10-11 12:20:28,015  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-3] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110000 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:20:28,015  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-2] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110001 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:20:28,140  INFO  [web.site.EditionInterceptor] [http-apr-8080-exec-2] Unable to retrieve License information from Alfresco: 404
2014-10-11 12:20:30,059  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-1] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110002 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:20:30,121  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-3] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110003 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:20:45,051  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-3] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110004 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:20:45,051  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-1] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110005 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:21:00,042  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-3] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110006 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:21:00,058  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-2] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110007 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:21:15,034  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-3] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110008 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:21:15,034  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-1] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110009 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:21:30,041  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-1] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110010 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2014-10-11 12:21:30,057  ERROR [solr.tracker.CoreTracker] [SolrTrackerScheduler_Worker-3] Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 09110011 GetModelsDiff return status is 404
   at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1059)
   at org.alfresco.solr.tracker.CoreTracker.trackModelsImpl(CoreTracker.java:1950)
   at org.alfresco.solr.tracker.CoreTracker.trackModels(CoreTracker.java:4745)
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1275)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:561)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)

[mrogers]

you have some sort of upgrade issue.   What you are doing to your dir.root is irrelevant.

What have you done with the database?

[psycdoc]

This is a new install and not an upgrade. I followed the instructions to connect to a MS SQL server and it does successfully connect, however when I change the "dir.root=" this is where it breaks.. If I leave it to its default value it works fine..