Ticket #1074: Errors_indexing-documents.txt

File Errors_indexing-documents.txt, 25.7 KB (added by Blucecio, 2 months ago)

Errors while indexing documents

Line 
1
208.02.2021 18:44:21,212 WARN   (com.logicaldoc.core.document.dao.HibernateDocumentDAO:1214) -- StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
3com.logicaldoc.core.PersistenceException: StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
4        at com.logicaldoc.core.HibernatePersistentObjectDAO.jdbcUpdate(HibernatePersistentObjectDAO.java:550)
5        at com.logicaldoc.core.document.dao.HibernateDocumentDAO.cleanUnexistingUniqueTags(HibernateDocumentDAO.java:1212)
6        at jdk.internal.reflect.GeneratedMethodAccessor802.invoke(Unknown Source)
7        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
8        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
9        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
10        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
11        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
12        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
13        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
14        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
15        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
16        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
17        at com.sun.proxy.$Proxy62.cleanUnexistingUniqueTags(Unknown Source)
18        at com.logicaldoc.core.document.TagsProcessor.runTask(TagsProcessor.java:47)
19        at com.logicaldoc.core.task.Task.run(Task.java:204)
20        at jdk.internal.reflect.GeneratedMethodAccessor651.invoke(Unknown Source)
21        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
22        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
23        at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:265)
24        at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:257)
25        at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)
26        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
27        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
28Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
29        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:230)
30        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
31        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
32        at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:544)
33        at com.logicaldoc.core.HibernatePersistentObjectDAO.jdbcUpdate(HibernatePersistentObjectDAO.java:548)
34        ... 23 more
35Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
36        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
37        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
38        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
39        at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1335)
40        at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2108)
41        at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1245)
42        at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
43        at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
44        at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:532)
45        at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:529)
46        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
47        ... 25 more
4808.02.2021 18:50:20,648 WARN   (com.logicaldoc.core.document.dao.HibernateDocumentDAO:1214) -- StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
49com.logicaldoc.core.PersistenceException: StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
50        at com.logicaldoc.core.HibernatePersistentObjectDAO.jdbcUpdate(HibernatePersistentObjectDAO.java:550)
51        at com.logicaldoc.core.document.dao.HibernateDocumentDAO.cleanUnexistingUniqueTags(HibernateDocumentDAO.java:1212)
52        at jdk.internal.reflect.GeneratedMethodAccessor802.invoke(Unknown Source)
53        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
54        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
55        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
56        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
57        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
58        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
59        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
60        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
61        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
62        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
63        at com.sun.proxy.$Proxy62.cleanUnexistingUniqueTags(Unknown Source)
64        at com.logicaldoc.core.document.TagsProcessor.runTask(TagsProcessor.java:47)
65        at com.logicaldoc.core.task.Task.run(Task.java:204)
66        at jdk.internal.reflect.GeneratedMethodAccessor651.invoke(Unknown Source)
67        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
68        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
69        at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:265)
70        at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:257)
71        at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)
72        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
73        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
74Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
75        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:230)
76        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
77        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
78        at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:544)
79        at com.logicaldoc.core.HibernatePersistentObjectDAO.jdbcUpdate(HibernatePersistentObjectDAO.java:548)
80        ... 23 more
81Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
82        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
83        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
84        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
85        at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1335)
86        at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2108)
87        at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1245)
88        at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
89        at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
90        at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:532)
91        at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:529)
92        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
93        ... 25 more
9408.02.2021 18:52:22,795 ERROR  (com.logicaldoc.core.document.DocumentManagerImpl: 506) -- Error reindexing document 3606055 - RR Form 01 - User Access Request Form.docx
9508.02.2021 18:52:22,864 ERROR  (com.logicaldoc.core.document.DocumentManagerImpl: 506) -- Error reindexing document 3606056 - User Access Request.html
9608.02.2021 18:56:20,075 WARN   (com.logicaldoc.core.document.dao.HibernateDocumentDAO:1214) -- StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
97com.logicaldoc.core.PersistenceException: StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
98        at com.logicaldoc.core.HibernatePersistentObjectDAO.jdbcUpdate(HibernatePersistentObjectDAO.java:550)
99        at com.logicaldoc.core.document.dao.HibernateDocumentDAO.cleanUnexistingUniqueTags(HibernateDocumentDAO.java:1212)
100        at jdk.internal.reflect.GeneratedMethodAccessor802.invoke(Unknown Source)
101        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
102        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
103        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
104        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
105        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
106        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
107        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
108        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
109        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
110        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
111        at com.sun.proxy.$Proxy62.cleanUnexistingUniqueTags(Unknown Source)
112        at com.logicaldoc.core.document.TagsProcessor.runTask(TagsProcessor.java:47)
113        at com.logicaldoc.core.task.Task.run(Task.java:204)
114        at jdk.internal.reflect.GeneratedMethodAccessor651.invoke(Unknown Source)
115        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
116        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
117        at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:265)
118        at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:257)
119        at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)
120        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
121        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
122Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
123        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:230)
124        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
125        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
126        at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:544)
127        at com.logicaldoc.core.HibernatePersistentObjectDAO.jdbcUpdate(HibernatePersistentObjectDAO.java:548)
128        ... 23 more
129Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
130        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
131        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
132        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
133        at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1335)
134        at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2108)
135        at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1245)
136        at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
137        at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
138        at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:532)
139        at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:529)
140        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
141        ... 25 more
14208.02.2021 19:02:24,601 WARN   (com.logicaldoc.core.document.dao.HibernateDocumentDAO:1214) -- StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
143com.logicaldoc.core.PersistenceException: StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
144        at com.logicaldoc.core.HibernatePersistentObjectDAO.jdbcUpdate(HibernatePersistentObjectDAO.java:550)
145        at com.logicaldoc.core.document.dao.HibernateDocumentDAO.cleanUnexistingUniqueTags(HibernateDocumentDAO.java:1212)
146        at jdk.internal.reflect.GeneratedMethodAccessor802.invoke(Unknown Source)
147        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
148        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
149        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
150        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
151        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
152        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
153        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
154        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
155        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
156        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
157        at com.sun.proxy.$Proxy62.cleanUnexistingUniqueTags(Unknown Source)
158        at com.logicaldoc.core.document.TagsProcessor.runTask(TagsProcessor.java:47)
159        at com.logicaldoc.core.task.Task.run(Task.java:204)
160        at jdk.internal.reflect.GeneratedMethodAccessor651.invoke(Unknown Source)
161        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
162        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
163        at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:265)
164        at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:257)
165        at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)
166        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
167        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
168Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [delete from ld_uniquetag as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_document as C where UT.ld_tenantid=B.ld_tenantid and UT.ld_tag=B.ld_tag and C.ld_id=B.ld_docid and C.ld_deleted=0)  and not UT.ld_tag in (select distinct(D.ld_tag) from ld_foldertag as D, ld_folder as E where UT.ld_tenantid=D.ld_tenantid and UT.ld_tag=D.ld_tag and E.ld_id=D.ld_folderid and E.ld_deleted=0) ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
169        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:230)
170        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
171        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
172        at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:544)
173        at com.logicaldoc.core.HibernatePersistentObjectDAO.jdbcUpdate(HibernatePersistentObjectDAO.java:548)
174        ... 23 more
175Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as UT where  not UT.ld_tag in (select distinct(B.ld_tag) from ld_tag as B, ld_do' at line 1
176        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
177        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
178        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
179        at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1335)
180        at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2108)
181        at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1245)
182        at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
183        at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:341)
184        at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:532)
185        at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:529)
186        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
187        ... 25 more