nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Installation problems moving from labs3b to labs3stable

efestione

Hi everyone,
I'm triyng to migrate from a server (A) to another (B), but I obtain this error:

20:03:59,969 INFO [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
20:04:08,016 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
20:04:08,906 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
20:04:09,906 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 949 transactions.
20:04:10,172 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        10 % complete.
20:04:10,172 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        20 % complete.
20:04:10,172 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        30 % complete.
20:04:10,188 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        40 % complete.
20:04:10,188 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        50 % complete.
20:04:10,188 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        60 % complete.
20:04:10,203 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        70 % complete.
20:04:10,203 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        80 % complete.
20:04:10,203 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        90 % complete.
20:04:10,219 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent]        100 % complete.
20:04:18,469 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery completed.
20:04:18,500 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding indexes for 1 AVM Stores
20:04:18,500 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]     Rebuilding index for sitestore
20:04:18,563 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]   Reindex   100% complete
20:04:18,563 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Finished rebuilding indexes for AVM Stores
20:04:18,750 INFO [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: E:\Alfresco\alf_data
20:04:18,766 ERROR [org.alfresco.repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
20:04:18,766 ERROR [org.alfresco.repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
20:04:18,766 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property is pointing to the correct data location.
                at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:312)
…

Servers are:

(A)
Windows XP
dir.root: C:/Alfresco/alf_data

(B)
Windows Server 2003
dir.root: E:/Alfresco/alf_data

I followed the steps described in the wiki section "General_Process_Upgrade".
Can the different drive ('E' instead of 'C') be the source of this problem? Or what else?

Thanks for your help.
Alessandro

Find more posts tagged with

Comments

thestorm

20:04:18,766 ERROR [org.alfresco.repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.

your contentstore backup is corrupt i guess

did u make a cold or hot backup?!

efestione

Ok, DB and filesystem weren't synchronized, then I repeated the procedure and now all works fine.

Thank you for the reply!

efestione

Mmm… Now Alfresco starts without errors, but when I upload any type of document the console shows this error:

19:05:20,831 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.ftsIndexerJobDetail threw an unhandled Exception: 
java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.GeneratedMethodAccessor545.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
19:05:20,847 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.ftsIndexerJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.NullPointerException]
   at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.GeneratedMethodAccessor545.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   … 1 more
19:06:21,394 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.ftsIndexerJobDetail threw an unhandled Exception: 
java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.GeneratedMethodAccessor545.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
19:06:21,409 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.ftsIndexerJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.NullPointerException]
   at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.GeneratedMethodAccessor545.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   … 1 more
19:07:20,737 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.ftsIndexerJobDetail threw an unhandled Exception: 
java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.GeneratedMethodAccessor545.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
19:07:20,753 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.ftsIndexerJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.NullPointerException]
   at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.GeneratedMethodAccessor545.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   … 1 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

What's happening? Thanks for your help.

efestione

I'm analyzing the org.alfresco.repo.search.impl.lucene.AVMLuceneIndexerImpl source code,
I'm looking for a StringReader constructor in indexProperty(…) method where a null argument should be possible, but I can't understand where this problem should be occur.

Any Idea?

efestione

Nothing?
Alfresco seems to work fine, but I don't know why there are these NullPointer Exceptions :?:
I think I need to check the integrity of the repository… I'll try to do it.
Any help would be appreciated!

thestorm

do you use java 1.6, cause 1.5 is not working correctly anymore

efestione

I switched to java 1.6 but this doesn't solve.
I changed log levels in log4j.properties and now I can read this warning (see the log below):

10:54:06,899 WARN [org.alfresco.repo.node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.

I'll try to do a full reindex…

10:46:40,462 DEBUG [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Waiting for READ lock  - http-8080-2
10:46:40,462 DEBUG [org.alfresco.repo.search.impl.lucene.index.IndexInfo] …GOT READ LOCK  - http-8080-2 -  in 3.177E-4 ms
10:46:40,462 DEBUG [org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory$ReferenceCountingReadOnlyIndexReader] http-8080-2: Reader MainReader - increment - ref count is 1        … org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory$ReferenceCountingReadOnlyIndexReader@1b335b7
10:46:40,462 DEBUG [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Main index reader references = 1
10:46:40,462 DEBUG [org.alfresco.repo.search.impl.lucene.index.IndexInfo] RELEASED READ LOCK  - http-8080-2
10:46:40,462 DEBUG [org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory$ReferenceCountingReadOnlyIndexReader] http-8080-2: Reader MainReader closing        … org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory$ReferenceCountingReadOnlyIndexReader@1b335b7
10:46:40,477 DEBUG [org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory$ReferenceCountingReadOnlyIndexReader] http-8080-2: Reader MainReader - decrement - ref count is 0        … org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory$ReferenceCountingReadOnlyIndexReader@1b335b7
10:46:40,477 DEBUG [org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory$ReferenceCountingReadOnlyIndexReader] http-8080-2: Reader MainReader still open …. ref = 0 invalidForReuse = false        … org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory$ReferenceCountingReadOnlyIndexReader@1b335b7
10:53:56,555 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
10:54:04,805 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
10:54:05,727 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
10:54:06,899 WARN  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
10:54:07,384 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: E:\Alfresco\alf_data
10:54:07,415 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
10:54:07,634 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] No patches were required.
10:54:07,649 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Found 1 module(s).
10:54:07,680 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Starting module 'org.alfresco.module.vti' version 1.0.
10:54:07,727 WARN  [org.alfresco.repo.module.ModuleServiceImpl] A previously-installed module 'org.alfresco.module.RecordsManagement' (version 1.3) is not present in your distribution.
10:54:08,462 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_12-b04; maximum heap size 986,125MB
10:54:08,462 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Labs): Current version 3.0.0 (Stable r13140) schema 2000 - Installed version 3.0.0 (c 1342) schema 1000
10:54:22,118 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
10:54:24,134 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs
10:54:24,134 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 348.81387ms)
10:55:25,102 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs
10:55:25,102 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 60940.09ms)
10:55:25,149 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
11:15:58,852 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.ftsIndexerJobDetail threw an unhandled Exception: 
java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.GeneratedMethodAccessor507.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:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
11:15:58,884 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.ftsIndexerJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.NullPointerException]
   at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.GeneratedMethodAccessor507.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:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   … 1 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

efestione

This is the log…
What's the meaning of these entries?
11:35:14,895 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     2 failed with error: null.
11:35:15,036 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     3 failed with error: null.
11:35:15,176 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     4 failed with error: null.
11:35:18,815 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     6 failed with error: null.
11:35:18,956 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     8 failed with error: null.
11:35:19,018 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     9 failed with error: null.
11:35:19,065 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer    10 failed with error: null.

I'm totally confused…

11:34:51,001 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
11:34:59,372 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
11:35:00,246 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
11:35:02,183 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 1.148 transactions.
11:35:02,433 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    10 % complete.
11:35:02,433 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    20 % complete.
11:35:02,448 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    30 % complete.
11:35:02,464 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    40 % complete.
11:35:02,464 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    50 % complete.
11:35:02,464 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    60 % complete.
11:35:02,479 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    70 % complete.
11:35:02,479 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    80 % complete.
11:35:14,895 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     2 failed with error: null.
11:35:15,036 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     3 failed with error: null.
11:35:15,176 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     4 failed with error: null.
11:35:18,815 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     6 failed with error: null.
11:35:18,956 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     8 failed with error: null.
11:35:19,018 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer     9 failed with error: null.
11:35:19,065 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer    10 failed with error: null.
11:35:20,611 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    90 % complete.
11:35:20,627 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    100 % complete.
11:35:22,938 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery completed.
11:35:22,969 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding indexes for 1 AVM Stores
11:35:22,969 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]     Rebuilding index for sitestore
11:35:23,048 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]         Rebuilding index for snapshots 0 to 11
11:35:23,329 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]   Reindex   100% complete
11:35:23,329 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Finished rebuilding indexes for AVM Stores
11:35:23,594 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: E:\Alfresco\alf_data
11:35:23,610 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
11:35:23,844 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] No patches were required.
11:35:23,860 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Found 1 module(s).
11:35:23,875 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Starting module 'org.alfresco.module.vti' version 1.0.
11:35:23,906 WARN  [org.alfresco.repo.module.ModuleServiceImpl] A previously-installed module 'org.alfresco.module.RecordsManagement' (version 1.3) is not present in your distribution.
11:35:25,171 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_12-b04; maximum heap size 986,125MB
11:35:25,171 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Labs): Current version 3.0.0 (Stable r13140) schema 2000 - Installed version 3.0.0 (c 1342) schema 1000
11:35:40,726 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
11:35:43,538 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs
11:35:43,538 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 818.11707ms)
11:36:04,465 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.ftsIndexerJobDetail threw an unhandled Exception: 
java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   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:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
11:36:15,444 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.ftsIndexerJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.NullPointerException]
   at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   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:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   … 1 more
11:36:44,648 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs
11:36:44,648 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 61121.418ms)
11:36:44,711 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
11:36:53,347 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.ftsIndexerJobDetail threw an unhandled Exception: 
java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   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:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
11:36:53,347 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.ftsIndexerJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.NullPointerException]
   at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.NullPointerException
   at java.io.StringReader.<init>(StringReader.java:33)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   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:296)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy30.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   … 1 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

efestione

Anyway, I think an uncatched NullPointerException may be considered a bug…

derek

Hi,

                        for (Locale locale : mlText.getLocales())
                        {
                            String localeString = mlText.getValue(locale);
                            …
                                duplicator = new MLTokenDuplicator(vba.tokenStream(attributeName, new StringReader(localeString)), locale, null, analysisMode);
                            …
‍‍‍‍‍‍‍

It appears that the locale-specific string returned from the mltext object is null. This is unexpected i.e. I would not expect null string values to be applied to any locale. The good news is that the FTS indexer is a background job (which is why only text searching would be broken) so we should be able to find the data that is causing the problem. Run the following SQL and post the results (or a subset if there are many):

select * from alf_node_properties np join alf_locale l on (l.id = np.locale_id) where l.locale_str != '.default' and np.string_value is null;‍

Also, please give details of what your language settings are for the user that uploads the documents.

efestione

Run the following SQL and post the results (or a subset if there are many):
select * from alf_node_properties np join alf_locale l on (l.id = np.locale_id) where l.locale_str != '.default' and np.string_value is null;‍
Also, please give details of what your language settings are for the user that uploads the documents.

Hi,

The result is a single record:

node_id    2662
actual_type_n    0
persisted_type_n    0
boolean_value    
long_value    0
float_value    0
double_value    0
string_value    NULL
serializable_value    [BLOB - 0B]
qname_id    111
list_index    -1
locale_id    5
id    5
version    0
locale_str    it_IT_‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I installed the italian language pack but the exception is thrown even if I select english. The problem doesn't seem linked to a particular user.
A doubt: the node id = 2662 is an image I uploaded this morning, but the problem is more days old.

Thank you very much

derek

Hi,
Delete that record; it contains no useful information and is incorrect (null string_value with non-default locale). Then repeat some document uploads and let me know if new, incorrect data appears.

delete from alf_node_properties where node_id = 2662 and qname_id = 111 and list_index = -1 and locale_id = 5‍

Regards

efestione

Hi,
I deleted the record.

After, logged as admin, I uploaded a .ppt file but I obtained the same exception.

Then I relaunched this query

select * from alf_node_properties np join alf_locale l on (l.id = np.locale_id) where l.locale_str != '.default' and np.string_value is null;
‍‍‍

Now the result is 0 records.

derek

Hi,
Let's widen the search to get cm:title and cm:description properties without any value:

select * from alf_node_properties np join alf_qname qn on (np.qname_id = qn.id) where qn.local_name in ('title', 'description') and np.string_value is null;
‍‍‍

Regards

efestione

I obtained 83 records. I report below the first four:

node_id     2021    2399    1858    1879
actual_type_n    0    0    0    0
persisted_type_n    0    0    0    0
boolean_value             
long_value    0    0    0    0
float_value    0    0    0    0
double_value    0    0    0    0
string_value    NULL    NULL    NULL    NULL
serializable_value    [BLOB - 0B]    [BLOB - 0B]    [BLOB - 0B]    [BLOB - 0B]
qname_id    110    110    111    111
list_index    -1    -1    -1    -1
locale_id    1    1    1    1
id    110    110    111    111
version    0    0    0    0
ns_id    3    3    3    3
local_name    title    title    description    description
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

derek

Hi,
Does this list grow as you add documents? You can delete those as well, but you'll need the mysql delete-join syntax.

efestione

Hi,
no, the list doesn't grow when I add document.
Then to solve the problem Do I need to delete all those records?

Does the query sound like this?

DELETE alf_node_properties.*, alf_qname.*
FROM alf_node_properties np, alf_qname qn
WHERE np.qname_id = qn.id
AND
qn.local_name
IN (
'title', 'description'
)
AND np.string_value IS NULL

derek

Not quite!

DELETE alf_node_properties
&nbsp;&nbsp; FROM alf_node_properties
&nbsp;&nbsp; JOIN alf_qname ON (alf_node_properties.qname_id = alf_qname.id)
&nbsp;&nbsp; WHERE
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alf_qname.local_name IN ('title', 'description') AND
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alf_node_properties.string_value is null
;
‍‍‍‍‍‍‍‍‍

efestione

Great Derek! thank you very much! The exception disappears.
Have you any idea about the presence of these dirty records?

derek

Hi,
My guess is that it occured during the upgrade process, assuming it didn't occur on 3b. As you know we attempt to provide an incremental upgrade process along all versions for the Community releases, but don't spend much QA time on it - the focus, for Community, rather being on upgrades between major releases.
Regards

efestione

Hi,
I verified these dirty records were also on 3b.
Thanks again
Regards

derek

Was 3b the first version you installed or did you upgrade to it from an earlier release?
Anyway, as long as the issue doesn't arise again, at least we know that the issue isn't in the code as it stands.

efestione

Yes, it was the first version I installed.

luca

Hi,
I have quite the same problem, except I'm using Alfresco 3.0 Labs from the beginning.

I started to have the same errors in ftsIndexerJobDetail job:

09:53:24,686  ERROR [quartz.core.ErrorLogger] Job (DEFAULT.ftsIndexerJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.NullPointerException]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.NullPointerException
        at java.io.StringReader.<init>(StringReader.java:33)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:1037)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:602)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1502)
        at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
…
‍‍‍‍‍‍‍‍‍‍‍‍‍

I tryed to do a full index rebuild, but the problem isn't solved.

If I search in the database with this query:

select * from alf_node_properties np join alf_locale l on (l.id = np.locale_id) where l.locale_str != '.default' and np.string_value is null;‍

I get more than 40000 records like these:

node_id     actual_type_n     persisted_type_n     boolean_value     long_value     float_value     double_value     string_value     serializable_value     qname_id     list_index     locale_id     id     version     locale_str
857191    0    0    f    0    0    0          106    -1    69730    69730    0    it_IT_
857227    0    0    f    0    0    0          106    -1    69730    69730    0    it_IT_
857071    0    0    f    0    0    0          106    -1    69730    69730    0    it_IT_
‍‍‍‍‍‍

Do I have to delete all these records? Won't it cause problems on the documents related to them?

If I search to get cm:title and cm:description properties without any value I also get more than 40000 records, am I doing anything wrong?

Can I delete them without any problem?

derek

Hi, Luca

In 3.0, the MLText (multilingual text) values were stored in the alf_attribute tables. Upon upgrade, these values were pulled back into alf_node_properties. It appears that null values in the originally-persisted MLText object - which was just a map - had been persisted and are causing your problems.

Your analysis of the alf_node_properties table is quite correct. Notice the 'actual_type_n' values that are zero … that indicates a null value. In other words, you can delete all alf_node_properties where the locale is not '.default' (ID 69730?) and the persisted_type_n is zero. Perhaps just double-check that all string_value values are null where persisted_type_n is 0.

Regards