cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server

psycdoc
Champ in-the-making
Champ in-the-making
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)
2 REPLIES 2

mrogers
Star Contributor
Star Contributor
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
Champ in-the-making
Champ in-the-making
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..
Welcome to the new Hyland Connect. Get started or submit feedback.