SQL Server
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2014 01:02 PM
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)
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)
Labels:
- Labels:
-
Archive
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2014 02:14 AM
you have some sort of upgrade issue. What you are doing to your dir.root is irrelevant.
What have you done with the database?
What have you done with the database?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2014 11:31 AM
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..