Problems moving from Labs 3c to 3d/stable

[bjohanns7p]

Hello,

we are currently moving (our testsystem 🙂 ) from alfresco labs 3c to 3d/stable.
Unfortunately alfresco 3d refuses to start up. Has anyone experienced the same?

Our procedure is:
- backup production mysql:alfresco
- backup production alf_data
—– on testsystem (a clone from production)
- take alfresco 3d/stable tomcat distribution
- replace alfresco 3c tomcat distribution with new distri
- install vti amp
- install studio.war
- customize 3d (property and xml-files) according to 3c
- restore alf_data and mysql:alfresco on test
- switch schema upgrade on
- start alfresco

we see in the logs a short patch sequence and that anything seems to be fine (apart from known noncritical errors) until
———- snip ———
java.lang.RuntimeException: No root found for :
   root path: /app:company_home/st:sites
        at org.alfresco.module.vti.handler.alfresco.VtiPathHelper$2.doWork(VtiPathHelper.java:502)
————————–
this causes alfresco to go down completely.

If we zap the mysql:alfresco db forcing alfresco to do the db setup again everything works fine (indeed very very fine 🙂 ) - but we cannot dismiss all our documents and document histories.
A difference between our alfresco 3c (production) and the (newly initialized) 3d is the space "company_home/sites" which is missing in our 3c alfresco or was never there as our production db has a history comming from alfresco labs 3 and we never had this "sites" space seen there.

The error hints toward this fact - would it be sufficient to create a space "sites" on production before migrating to alfresco 3d? Shouldn't this be handled by the db patch procedure?

anno: As we were new to alfresco 3 I cannot guarantee that the "sites" space was really NEVER there. Perhaps it got deleted in the early days. But at least our alfresco 3/3b/3c worked well enough for us without this "sites"-space - until now.

Many thanks for any advice.
Greetings
Bernd

[mikeh]

If you have deleted it, have you tried restoring it from "Manage Deleted Items"..?

The problem with just recreating it is that it won't be of the correct type - i.e. st:sites. You might be able to reapply the patch.sitesFolder patch by messing around in the alf_applied_patch - but obviously this would be best avoided!

Thanks,
Mike

[bjohanns7p]

Thanks for the suggestions.

Unfortunately there is no sites-space inside our deleted items archive. And none of our admins is aware that he might ever have deleted such a space.
So I suppose that we somehow missed the relevant patch you mentioned.

Which release should have activated the patch? Our current database was set up with labs 3B and migrated to 3C.

Is there a documentation on how to "reactivate" a patch procedure and can this be done savely?

Thank you for your help.
Greetings
Bernd

[mikeh]

It should have been in 3B - not sure why you don't have it.

Your best option is to run a script that does:

companyhome.createNode("Sites", "{http://www.alfresco.org/model/site/1.0}sites")‍

(NOTE: untested!)

Then make sure the EVERYONE group has "Contributor" permissions using Manage Space Users.

Thanks,
Mike

[bjohanns7p]

hu - seems we are out of luck.

our site-pages were stored within the data_dictionary (don't know why and how this happened). So I created the node "sites" via this script as you suggested (trying "Sites" and "sites" - both did not work).

companyhome.createNode("sites", "{http://www.alfresco.org/model/site/1.0}sites");
var sitesNode = companyhome.childByNamePath("sites");
if (sitesNode != null) {
  if (sitesNode.addAspect("{http://www.alfresco.org/model/application/1.0}uifacets"))
  {
     … some logging
  }
}
‍‍‍‍‍‍‍‍‍

to get a result that resembles as closely as possible that node which was created in a de-novo setup (I used the node browser to inspect both). Then I adjusted the accessrights as you suggested.
Then I moved the site-pages from the data_dictionary to the sites-space.
After this I checked (still 3C) if the sites where still accessible and created a testsite with wiki and blog - both worked correctly and the site-page popped up in the "sites" space.

then I moved to 3D and the whole thing blew up.

Now I got a partial solution to the problem - I deinstalled the vti-amp et voila - alfresco explorer starts up and seems to be fully functional.
However collaboration is broken - it does not find any existing site and if I try to create a new one I see

Failed to execute script '/org/alfresco/repository/site/sites.post.json.js (in classpath store file:/data/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts)': No root sites folder exists

here the created "sites" node as displayed in the node browser:

Node Identifier
Primary Path:   /{http://www.alfresco.org/model/application/1.0}company_home/{http://www.alfresco.org/model/content/1....
Reference:   workspace://SpacesStore/d28a857e-632f-4732-865b-f3101c3be353
Type:   {http://www.alfresco.org/model/site/1.0}sites
Parent:    workspace://SpacesStore/a6174087-f439-42af-b6d3-d8e5b61c4000

Properties
Name   Value   Property Type   Value Type   Residual
{http://www.alfresco.org/model/application/1.0}icon space-icon-default {http://www.alfresco.org/model/dictionary/1.0}text false
{http://www.alfresco.org/model/content/1.0}name sites {http://www.alfresco.org/model/dictionary/1.0}text false
{http://www.alfresco.org/model/system/1.0}node-dbid 3741 {http://www.alfresco.org/model/dictionary/1.0}long false
{http://www.alfresco.org/model/system/1.0}store-identifier SpacesStore {http://www.alfresco.org/model/dictionary/1.0}text false
{http://www.alfresco.org/model/content/1.0}title Sites {http://www.alfresco.org/model/dictionary/1.0}mltext false
{http://www.alfresco.org/model/system/1.0}node-uuid d28a857e-632f-4732-865b-f3101c3be353 {http://www.alfresco.org/model/dictionary/1.0}text false
{http://www.alfresco.org/model/content/1.0}modified Thu Feb 12 13:50:05 CET 2009 {http://www.alfresco.org/model/dictionary/1.0}datetime   false
{http://www.alfresco.org/model/content/1.0}created    Thu Feb 12 13:14:15 CET 2009 {http://www.alfresco.org/model/dictionary/1.0}datetime false
{http://www.alfresco.org/model/system/1.0}store-protocol workspace {http://www.alfresco.org/model/dictionary/1.0}text    false
{http://www.alfresco.org/model/content/1.0}description Site Collaboration Spaces {http://www.alfresco.org/model/dictionary/1.0}mltext false
{http://www.alfresco.org/model/content/1.0}creator   admin {http://www.alfresco.org/model/dictionary/1.0}text false
{http://www.alfresco.org/model/content/1.0}modifier admin {http://www.alfresco.org/model/dictionary/1.0}text false

Aspects
{http://www.alfresco.org/model/application/1.0}uifacets
{http://www.alfresco.org/model/content/1.0}auditable
{http://www.alfresco.org/model/system/1.0}referenceable

Permissions
Inherit:   true
Assigned Permission   To Authority   Access
Consumer   GROUP_EVERYONE   ALLOWED
Contributor   GROUP_EVERYONE   ALLOWED
Store Permission   To Authority   Access
All <No Mask>   All   Allowed
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Please note: the newly created site has the path:
/{http://www.alfresco.org/model/application/1.0}company_home/{http://www.alfresco.org/model/content/1.0}sites
with type
{http://www.alfresco.org/model/site/1.0}sites

whereas the node from the de-novo setup has the path:
/{http://www.alfresco.org/model/application/1.0}company_home/{http://www.alfresco.org/model/site/1.0}sites
with type
{http://www.alfresco.org/model/site/1.0}sites
and I don't know how to create a node which resembles the given path exactly.

Something within 3D seems to work profundly different as in 3C as 3C is able to cope with the synthetic "sites"-node whereas 3D is not.
If you still have any suggestion how we could get around that special problem I would appreciate this very much.

Greetings - and still with hope
Bernd

[mikeh]

What you might be able to do is export the Sites space from your clean 3D install and import it into your 3C (having moved the faked Sites space you created manually).

Mike