Need to rebuild alf_data

[dcoales]

Hi,

I had a problem with Alfresco not picking up my global properties file.  It therefore built an alf_data directory under the tomcat directory when it started.

I was helped on this forum to get over that issue by reconfiguring tomcat so that alfresco read in the correct dir.root directory.  However when I started up alfresco it complained about missing indexes.  I then found a post on this forum telling me how to ask for the repository to rebuild its indexes which got me passed that error message but simply led me to the next problem where it says that the system content was not found in the content store.  Like an idiot I have already deleted the original alf_data directory created in the tomcat directory (I know, I know). 

The log file is below:

10:34:31,873 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
10:34:31,879 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
10:34:31,880 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/usr/local/apache-tomcat-6.0.13/webapps/alfresco/WEB-INF/classes/alfresco/module/tests/alfresco-global.properties]
10:34:31,880 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/usr/local/apache-tomcat-6.0.13/webapps/alfresco/WEB-INF/classes/alfresco/module/test/alfresco-global.properties]
10:34:31,880 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/usr/local/apache-tomcat-6.0.13/shared/classes/alfresco-global.properties]
10:34:31,963 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
10:34:32,145 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
10:34:32,177 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
10:34:56,928 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
10:34:56,932 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
10:35:13,932 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
10:35:14,502 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
10:35:14,681 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
10:35:14,702 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
10:35:14,703 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
10:35:14,704 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
10:35:14,727 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
10:35:17,072 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
10:35:17,099 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
10:35:17,099 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
10:35:17,101 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
10:35:17,208 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformerWorker] ImageMagickContentTransformerWorker not available: 05030000 Failed to perform ImageMagick transformation: 
Execution result: 
   os:         Linux
   command:    [/usr/bin/convert.exe, /opt/tomcat/temp/Alfresco/ImageMagickContentTransformerWorker_init_source_43138.gif[0], /opt/tomcat/temp/Alfresco/ImageMagickContentTransformerWorker_init_target_43139.png]
   succeeded:  false
   exit code:  1
   out:        
   err:        Cannot run program "/usr/bin/convert.exe": java.io.IOException: error=2, No such file or directory
10:35:17,239 ERROR [org.alfresco.repo.content.transform.RuntimeExecutableContentTransformerWorker] Failed to start a runtime executable content transformer: 
Execution result: 
   os:         Linux
   command:    [./bin/pdf2swf, -V]
   succeeded:  false
   exit code:  1
   out:        
   err:        Cannot run program "./bin/pdf2swf": java.io.IOException: error=2, No such file or directory
10:35:17,245 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
10:35:17,245 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
10:35:17,270 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
10:35:17,271 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
10:35:17,271 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
10:35:19,242 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
10:35:19,256 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
10:35:19,967 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 66 transactions.
10:35:19,978 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    10 % complete.
10:35:19,978 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    20 % complete.
10:35:19,978 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    30 % complete.
10:35:19,978 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    40 % complete.
10:35:19,978 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    50 % complete.
10:35:19,979 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    60 % complete.
10:35:19,979 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    70 % complete.
10:35:19,979 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    80 % complete.
10:35:19,979 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    90 % complete.
10:35:19,982 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    100 % complete.
10:35:30,006 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery completed.
10:35:30,043 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding indexes for 1 AVM Stores
10:35:30,043 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]     Rebuilding index for sitestore
10:35:30,126 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]   Reindex   100% complete
10:35:30,126 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Finished rebuilding indexes for AVM Stores
10:35:30,236 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/projectoffice
10:35:30,246 ERROR [org.alfresco.repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
10:35:30,246 ERROR [org.alfresco.repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
10:35:30,252 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 05030001 Ensure that the 'dir.root' property is pointing to the correct data location.
   at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:332)
   at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:68)
   at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:180)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:272)
   at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:184)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
   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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Can anyone suggest what I should do next.

Thanks,
David

[mikeh]

…I have already deleted the original alf_data directory.

Can anyone suggest what I should do next.

Upload the content again. You've deleted it all from underneath Alfresco, so it's gone.

Thanks,
Mike

[dcoales]

Actually I have never uploaded any content.  I have never even managed to get Alfresco to start.  I'm still struggling with trying to install it.

[mrogers]

If you have removed your content for alf_data then you need to drop and recreate your database.   The database contains information for content you have removed, its not an indexing issue.

[dcoales]

Thanks, once I did this and then increased the PermGen space in tomcat that seemed to fix it.