topic Tenant import fails in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/tenant-import-fails/m-p/293187#M246317 <HTML><HEAD></HEAD><BODY><SPAN>Both alfresco-community 5.1e (MySQL) and the latest alfresco-one evaluation (PostgreSQL) failed the tenant import.&nbsp; </SPAN><BR /><SPAN>Tenant export worked without errors, but import failed with the error below.</SPAN><BR /><SPAN>The test was done with aflresco consoles (Windoes 8.2):</SPAN><BR /><SPAN>&nbsp; </SPAN><A href="http://localhost:8080/alfresco/s/admin/admin-tenantconsole" rel="nofollow noopener noreferrer">http://localhost:8080/alfresco/s/admin/admin-tenantconsole</A><BR /><SPAN>&nbsp; </SPAN><A href="http://127.0.0.1:8080/share" rel="nofollow noopener noreferrer">http://127.0.0.1:8080/share</A><BR /><BR /><SPAN>Could anyone tell me why the import failed?</SPAN><BR /><BR /><SPAN>1.&nbsp; create tenant1.com admin /usr/tenantstores/tenant1.com</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;admin@</SPAN><A href="http://tenant1.com/admin" rel="nofollow noopener noreferrer">tenant1.com/admin</A><BR /><SPAN>2.&nbsp; create group1</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;create user1/ /user1@</SPAN><A href="http://google.com/user1/password/group1" rel="nofollow noopener noreferrer">google.com/user1/password/group1</A><BR /><SPAN>3.&nbsp; create Repository/group1/testdoc1.txt</SPAN><BR /><SPAN>4.&nbsp; export tenant1.com d:\\alfresco-doc\backup</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;ACP files are generated in D:\alfresco-doc\backup\tenant1.com_*.acp</SPAN><BR /><SPAN>5.&nbsp; delete tenant1.com</SPAN><BR /><SPAN>6.&nbsp; stop alfrescoTomcat service</SPAN><BR /><SPAN>7.&nbsp; delete D:\alfresco-community\alf_data\solr4\content\tenant1.com (tenant-specific index directory?)</SPAN><BR /><SPAN>8.&nbsp; delete D:\usr\tenantstores\tenant1.com (tenant-specific content directory?)</SPAN><BR /><SPAN>9.&nbsp; start alfrescoTomcat service</SPAN><BR /><SPAN>10. import tenant1.com d:\\alfresco-doc\backup /usr/tenantstores/tenant1.com</SPAN><BR /><BR /><SPAN>Web Script Status 500 - Internal Error</SPAN><BR /><SPAN>The Web Script /alfresco/s/admin/admin-tenantconsole has responded with a status of 500 - Internal Error.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>Exception:&nbsp;&nbsp;&nbsp;org.alfresco.repo.node.integrity.IntegrityException - 03081804 Found 3 integrity violations: </SPAN><BR /><SPAN><SPAN>Mandatory property not set: Node: workspace:</SPAN><A class="jive-link-email-small" href="mailto://@tenant1.com" rel="nofollow noopener noreferrer">//@tenant1.com</A><SPAN>@lightWeightVersionStore/19412204-2993-404c-89ba-9b8212bdb056 Name: testdoc1.txt Type: {</SPAN></SPAN><A href="http://www.alfresco.org/model/versionstore/2.0}version" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/versionstore/2.0}version</A><SPAN> Property: {</SPAN><A href="http://www.alfresco.org/model/versionstore/2.0}frozenNodeStoreId" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/versionstore/2.0}frozenNodeStoreId</A><SPAN> </SPAN><BR /><SPAN><SPAN>Mandatory property not set: Node: workspace:</SPAN><A class="jive-link-email-small" href="mailto://@tenant1.com" rel="nofollow noopener noreferrer">//@tenant1.com</A><SPAN>@lightWeightVersionStore/19412204-2993-404c-89ba-9b8212bdb056 Name: testdoc1.txt Type: {</SPAN></SPAN><A href="http://www.alfresco.org/model/versionstore/2.0}version" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/versionstore/2.0}version</A><SPAN> Property: {</SPAN><A href="http://www.alfresco.org/model/versionstore/2.0}frozenNodeId" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/versionstore/2.0}frozenNodeId</A><SPAN> </SPAN><BR /><SPAN><SPAN>Mandatory property not set: Node: workspace:</SPAN><A class="jive-link-email-small" href="mailto://@tenant1.com" rel="nofollow noopener noreferrer">//@tenant1.com</A><SPAN>@lightWeightVersionStore/19412204-2993-404c-89ba-9b8212bdb056 Name: testdoc1.txt Type: {</SPAN></SPAN><A href="http://www.alfresco.org/model/versionstore/2.0}version" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/versionstore/2.0}version</A><SPAN> Property: {</SPAN><A href="http://www.alfresco.org/model/versionstore/2.0}frozenNodeStoreProtocol" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/versionstore/2.0}frozenNodeStoreProtocol</A><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.repo.node.integrity.IntegrityChecker.checkIntegrity(IntegrityChecker.java:662)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.repo.node.integrity.IntegrityChecker.beforeCommit(IntegrityChecker.java:764)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.util.transaction.TransactionSupportUtil$TransactionSynchronizationImpl.beforeCommit(TransactionSupportUtil.java:498)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:95)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:925)</SPAN></BODY></HTML> Fri, 08 Apr 2016 20:54:39 GMT jeto 2016-04-08T20:54:39Z Tenant import fails https://connect.hyland.com/t5/alfresco-archive/tenant-import-fails/m-p/293187#M246317 Both alfresco-community 5.1e (MySQL) and the latest alfresco-one evaluation (PostgreSQL) failed the tenant import.&nbsp; Tenant export worked without errors, but import failed with the error below.The test was done with aflresco consoles (Windoes 8.2):&nbsp; http://localhost:8080/alfresco/s/admin/admin-tenant Fri, 08 Apr 2016 20:54:39 GMT https://connect.hyland.com/t5/alfresco-archive/tenant-import-fails/m-p/293187#M246317 jeto 2016-04-08T20:54:39Z Re: Tenant import fails https://connect.hyland.com/t5/alfresco-archive/tenant-import-fails/m-p/293188#M246318 <HTML><HEAD></HEAD><BODY><P>Hi <B>jeto _</B>​</P><P></P><P>I have similar problems when trying to import a tenant from 51g to 51g.</P><P>Were you ever able to solve this?</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Tue, 11 Oct 2016 13:14:36 GMT https://connect.hyland.com/t5/alfresco-archive/tenant-import-fails/m-p/293188#M246318 davidd2go 2016-10-11T13:14:36Z