AnsweredAssumed Answered

indexing error

Question asked by sharifu on May 23, 2012
Latest reply on May 24, 2012 by sharifu
I am getting the following error in the log file


2012-05-23 05:47:32,783  ERROR [impl.lucene.ADMLuceneIndexerImpl] [DefaultScheduler_Worker-2] FTS index of workspace://SpacesStore/7235b464-c3c3-4486-a95d-730c68d9f89f failed. Reindexing without FTS
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
   at $Proxy6.selectList(Unknown Source)
   at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:189)
   at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectNodeProperties(NodeDAOImpl.java:531)
   at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectNodeProperties(NodeDAOImpl.java:508)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$PropertiesCallbackDAO.findByKey(AbstractNodeDAOImpl.java:2275)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$PropertiesCallbackDAO.findByKey(AbstractNodeDAOImpl.java:2265)
   at org.alfresco.repo.cache.lookup.EntityLookupCache.getByKey(EntityLookupCache.java:321)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getNodePropertiesCached(AbstractNodeDAOImpl.java:2201)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getNodeProperties(AbstractNodeDAOImpl.java:1766)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getPropertiesImpl(DbNodeServiceImpl.java:1404)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getProperties(DbNodeServiceImpl.java:1395)
   at sun.reflect.GeneratedMethodAccessor330.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:104)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy8.getProperties(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor330.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)
   at $Proxy9.getProperties(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocumentsImpl(ADMLuceneIndexerImpl.java:672)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:646)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl$4.execute(ADMLuceneIndexerImpl.java:2015)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl$4.execute(ADMLuceneIndexerImpl.java:2011)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl$1.execute(AbstractLuceneIndexerImpl.java:715)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.doInReadthroughTransaction(AbstractLuceneIndexerImpl.java:702)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.readDocuments(ADMLuceneIndexerImpl.java:2010)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1948)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl$1.execute(FullTextSearchIndexerImpl.java:232)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl$1.execute(FullTextSearchIndexerImpl.java:220)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:278)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:218)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:46)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:77)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:69)
   at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
   … 43 more
Caused by: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.alfresco.ibatis.SerializableTypeHandler.getResult(SerializableTypeHandler.java:84)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getPropertyMappingValue(FastResultSetHandler.java:238)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyPropertyMappings(FastResultSetHandler.java:221)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:196)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:145)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:121)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:98)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:40)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:75)
   … 48 more
Caused by: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1645)
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1491)
   at java.lang.Class.forName0(Native Method)
   at java.lang.Class.forName(Class.java:247)
   at java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:603)
   at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1574)
   at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1495)
   at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1731)
   at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
   at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1946)
   at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1870)
   at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
   at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
   at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1946)
   at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1870)
   at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
   at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
   at java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)
   at org.alfresco.ibatis.SerializableTypeHandler.getResult(SerializableTypeHandler.java:78)
   … 60 more
2012-05-23 05:47:33,390  ERROR [quartz.core.JobRunShell] [DefaultScheduler_Worker-2] Job DEFAULT.ftsIndexerJobDetail threw an unhandled Exception:
org.alfresco.repo.search.impl.lucene.fts.FTSIndexerException: org.alfresco.repo.search.impl.lucene.fts.FTSIndexerException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.indexCompleted(FullTextSearchIndexerImpl.java:107)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:258)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:46)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.alfresco.repo.search.impl.lucene.fts.FTSIndexerException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.indexCompleted(FullTextSearchIndexerImpl.java:107)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:240)
   … 3 more
Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
   at $Proxy6.selectList(Unknown Source)
   at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:189)
   at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectNodeProperties(NodeDAOImpl.java:531)
   at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectNodeProperties(NodeDAOImpl.java:508)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$PropertiesCallbackDAO.findByKey(AbstractNodeDAOImpl.java:2275)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$PropertiesCallbackDAO.findByKey(AbstractNodeDAOImpl.java:2265)
   at org.alfresco.repo.cache.lookup.EntityLookupCache.getByKey(EntityLookupCache.java:321)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getNodePropertiesCached(AbstractNodeDAOImpl.java:2201)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getNodeProperties(AbstractNodeDAOImpl.java:1766)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getPropertiesImpl(DbNodeServiceImpl.java:1404)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getProperties(DbNodeServiceImpl.java:1395)
   at sun.reflect.GeneratedMethodAccessor330.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:104)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy8.getProperties(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor330.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)
   at $Proxy9.getProperties(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocumentsImpl(ADMLuceneIndexerImpl.java:672)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:646)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl$4.execute(ADMLuceneIndexerImpl.java:2015)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl$4.execute(ADMLuceneIndexerImpl.java:2011)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl$1.execute(AbstractLuceneIndexerImpl.java:715)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.doInReadthroughTransaction(AbstractLuceneIndexerImpl.java:702)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.readDocuments(ADMLuceneIndexerImpl.java:2010)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1954)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl$1.execute(FullTextSearchIndexerImpl.java:232)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl$1.execute(FullTextSearchIndexerImpl.java:220)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:278)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:218)
   … 3 more
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:77)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:69)
   at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
   … 43 more
Caused by: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.alfresco.ibatis.SerializableTypeHandler.getResult(SerializableTypeHandler.java:84)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getPropertyMappingValue(FastResultSetHandler.java:238)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyPropertyMappings(FastResultSetHandler.java:221)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:196)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:145)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:121)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:98)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:40)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:75)
   … 48 more
Caused by: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1645)
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1491)
   at java.lang.Class.forName0(Native Method)
   at java.lang.Class.forName(Class.java:247)
   at java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:603)
   at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1574)
   at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1495)
   at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1731)
   at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
   at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1946)
   at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1870)
   at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
   at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
   at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1946)
   at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1870)
   at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
   at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
   at java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)
   at org.alfresco.ibatis.SerializableTypeHandler.getResult(SerializableTypeHandler.java:78)
   … 60 more
2012-05-23 05:47:33,392  ERROR [quartz.core.ErrorLogger] [DefaultScheduler_Worker-2] Job (DEFAULT.ftsIndexerJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.alfresco.repo.search.impl.lucene.fts.FTSIndexerException: org.alfresco.repo.search.impl.lucene.fts.FTSIndexerException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException]
   at org.quartz.core.JobRunShell.run(JobRunShell.java:227)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.alfresco.repo.search.impl.lucene.fts.FTSIndexerException: org.alfresco.repo.search.impl.lucene.fts.FTSIndexerException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.indexCompleted(FullTextSearchIndexerImpl.java:107)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:258)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:46)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   … 1 more
Caused by: org.alfresco.repo.search.impl.lucene.fts.FTSIndexerException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.indexCompleted(FullTextSearchIndexerImpl.java:107)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:240)
   … 3 more
Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
   at $Proxy6.selectList(Unknown Source)
   at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:189)
   at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectNodeProperties(NodeDAOImpl.java:531)
   at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectNodeProperties(NodeDAOImpl.java:508)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$PropertiesCallbackDAO.findByKey(AbstractNodeDAOImpl.java:2275)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$PropertiesCallbackDAO.findByKey(AbstractNodeDAOImpl.java:2265)
   at org.alfresco.repo.cache.lookup.EntityLookupCache.getByKey(EntityLookupCache.java:321)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getNodePropertiesCached(AbstractNodeDAOImpl.java:2201)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getNodeProperties(AbstractNodeDAOImpl.java:1766)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getPropertiesImpl(DbNodeServiceImpl.java:1404)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getProperties(DbNodeServiceImpl.java:1395)
   at sun.reflect.GeneratedMethodAccessor330.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:104)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy8.getProperties(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor330.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)
   at $Proxy9.getProperties(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocumentsImpl(ADMLuceneIndexerImpl.java:672)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:646)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl$4.execute(ADMLuceneIndexerImpl.java:2015)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl$4.execute(ADMLuceneIndexerImpl.java:2011)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl$1.execute(AbstractLuceneIndexerImpl.java:715)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.doInReadthroughTransaction(AbstractLuceneIndexerImpl.java:702)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.readDocuments(ADMLuceneIndexerImpl.java:2010)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1954)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl$1.execute(FullTextSearchIndexerImpl.java:232)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl$1.execute(FullTextSearchIndexerImpl.java:220)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:278)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:218)
   … 3 more
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:77)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:69)
   at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
   … 43 more
Caused by: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.alfresco.ibatis.SerializableTypeHandler.getResult(SerializableTypeHandler.java:84)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getPropertyMappingValue(FastResultSetHandler.java:238)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyPropertyMappings(FastResultSetHandler.java:221)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:196)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:145)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:121)
   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:98)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:40)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:75)
   … 48 more
Caused by: java.lang.ClassNotFoundException: com.ibatis.common.jdbc.exception.NestedSQLException
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1645)
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1491)
   at java.lang.Class.forName0(Native Method)
   at java.lang.Class.forName(Class.java:247)
   at java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:603)
   at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1574)
   at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1495)
   at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1731)
   at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
   at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1946)
   at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1870)
   at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
   at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
   at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1946)
   at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1870)
   at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
   at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
   at java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)
   at org.alfresco.ibatis.SerializableTypeHandler.getResult(SerializableTypeHandler.java:78)
   … 60 more


any suggestions?

Outcomes