ImporterException: Path /sys:system within node user://alfre

[marco]

I tried deployed the war of alfresco 1.4 on a Debian sarge. After overcoming some issues with permissions an inadequate paths in the alfresco settings I am stuck with the following error messages:

16:30:22,534 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script: /var/lib/tomcat5.5/temp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-63583.sql
16:30:39,106 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script: classpath:alfresco/dbscripts/create/1.4/${db.script.dialect}/post-create-indexes.sql
16:30:40,883 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:448)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:670)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:54)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
   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:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.service.cmr.view.ImporterException: Path /sys:system within node user://alfrescoUserStore/30253fe9-a3e4-11db-bcbb-09bd355c45d0 does not exist - the path must resolve to a valid location
   at org.alfresco.repo.importer.ImporterComponent.getNodeRef(ImporterComponent.java:255)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:210)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:429)
   … 33 more

I removed all in the alfresco data directory and recreated the database. Still the problem persists.

Regards,
Marco

[rivetlogic]

Hi,

Did you make sure your Alfresco configuration is pointing to the correct path (dir.root)?

Regards,

–Aladdin

[marco]

What is the correct path?

I think it can be any path to which the tomcat user has write permission, isn't it?

I tried to follow the documentation about Repository Configuration which seems to be not up-to-date. There are other filenames for the custom-* files.

Anyway if it is ok if the sys.root directory is empty or not existing and the db is fresh created when the server starts then it should work as I did.

/m

[rivetlogic]

Hi,

If a path is not set then is it a relative path. In other words wherever you're starting your Tomcat from will contain an alf_data directory that has your content store and index files.

If that is the case then make sure that you're deleting that directory. Also make sure that you're deleting the Alfresco database and creating a new one. This would ensure that you're starting fresh.

After Alfresco boots up make sure that the tables were created in the database and that a new alf_data directory was created.

Hope this helps,

–Aladdin

[marco]

I had set sys.root to a path in a directory where tomcat has write permission.

I deleted the directory and recreated the database.

After a restart of tomcat the data directory is created with following subdirectories:

audit.contentstore  contentstore  contentstore.deleted  lucene-indexes

In lucene-indexes/user/alfrescoUserStore there is only a directory with a slightly different name then the one in the error message.

in that directory I find:

_3.cfs  deletable  segments

Is this the directory alfresco is looking for with the wrong name?

/m

[khurrum]

I am facing the same problem i.e. deploying alfresco on jboss 4.0.5GA. but facing same error, plz someone give solution

[delder]

Has this issue ever been resolved?

I am experiencing a similar problem, attempting to run alfresco.war on Tomcat 5.5.x and MySql 5.0.x.

I have

-Copied the war file into the [tomcat_home] webapps directory
-Copied the extensions xml file (custom-repository-context.xml) to [tomcat_home]/shared/classes/alfresco/extension
-Copied custom-repository.properties to the extenion dir, uncommented dir.root and pointed to /var/alfresco/data; uncommented general and mysql related db properties
-Copied custom-hibernate-dialect.properties to the extensions directory and uncommented mysql related properties
-Made sure the /var/alfresco/data directory was empty
-Rebuilt the database using db_remove.sql followed by db_setup.sql

The pertinent portion of the stack trace:

23:27:25,695 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed

**************
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to import package at line 8; column 23 due to error: Non-root node has no primary parent: 
   child: user://alfrescoUserStore/93d976b2-c915-11db-87f7-ebd11b9451ff
        at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:179)
‍‍‍‍‍‍‍‍

I turned on debug level logging and this is the log output just before the Exception:

23:27:25,368 DEBUG [lucene.store.FSDirectory] Alfresco FSDirectory used for /var/alfresco/data/lucene-indexes/user/alfrescoUserStore/9359bf61-c915-11db-87f7-ebd11b9451ff create = true
23:27:25,673 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.StoreImplCache: org.alfresco.repo.domain.hibernate.StoreImplMemoryStore hit for org.alfresco.repo.domain.hibernate.StoreImpl#StoreKey[ protocol=user, identifier=alfrescoUserStore]
23:27:25,673 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.NodeImpl.propertiesCache: org.alfresco.repo.domain.hibernate.NodeImpl.propertiesMemoryStore hit for org.alfresco.repo.domain.hibernate.NodeImpl.properties#1
23:27:25,674 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.NodeImpl.aspectsCache: org.alfresco.repo.domain.hibernate.NodeImpl.aspectsMemoryStore hit for org.alfresco.repo.domain.hibernate.NodeImpl.aspects#1
23:27:25,674 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocsCache: org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocsMemoryStore miss for org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocs#1
23:27:25,674 DEBUG [sf.ehcache.Cache] org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocs cache - Miss
23:27:25,674 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.NodeImpl.propertiesCache: org.alfresco.repo.domain.hibernate.NodeImpl.propertiesMemoryStore hit for org.alfresco.repo.domain.hibernate.NodeImpl.properties#2
23:27:25,674 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.NodeImpl.aspectsCache: org.alfresco.repo.domain.hibernate.NodeImpl.aspectsMemoryStore hit for org.alfresco.repo.domain.hibernate.NodeImpl.aspects#2
23:27:25,675 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocsCache: org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocsMemoryStore miss for org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocs#2
23:27:25,675 DEBUG [sf.ehcache.Cache] org.alfresco.repo.domain.hibernate.NodeImpl.parentAssocs cache - Miss‍‍‍‍‍‍‍‍‍‍

As has been noted by others the error references an alfrescoUserStore directory, in this case: 93d976b2-c915-11db-87f7-ebd11b9451ff that is almost but not quite the same as a directory that is actually created at startup: [dir.root]/lucene-indexes/user/alfrescoUserStore/9359bf61-c915-11db-87f7-ebd11b9451ff.

Anyone have any idea what is going on?

Thanks.

[derek]

Hi, Delder

Your problem is not the same as the others, but the solution is more definite.  The issues is noted on JIRA along with a workaround: http://issues.alfresco.com/browse/AR-1280

I'll see about the other errors here, if I can …

Regards

[derek]

Hi,

In bootstrap-context.xml:

    <bean id="userBootstrap" parent="userStoreImporter">
        <property name="bootstrapViews">
            <list>
                <props>
                    <prop key="path">/</prop>
                    <prop key="location">alfresco/bootstrap/alfrescoUserStore.xml</prop>
                </props>
                <props>
                    <prop key="path">/${alfresco_user_store.system_container.childname}</prop>
                    <prop key="location">alfresco/bootstrap/alfrescoAuthorityStore.xml</prop>
                </props>
            </list>
        </property>
    </bean>‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The second props section relies on the context of the first having been loaded, i.e. check that the file alfresco/bootstrap/alfrescoUserStore has not been modified.

If not, then put some debugging into the importer to find out exactly which files it is loading.

Regards

[marco]

derek,

I think you are talking about delder's problem.

But what about the original issue with the initial bootstrap of a war deployment?

The only hint I found was French message suggesting to upgrade to mysql 5. Does this really help? A deployment of alfresco with the linux installer works with mysql 4.1, too.

This problem still exists with alfresco 2.0.

/m