topic Re: Migration from 5.0c to 5.1e : runtime error in Alfresco Archive

Migration from 5.0c to 5.1e : runtime error

nic0 — Wed, 15 Jun 2016 13:52:09 GMT

Hello,Needing to migrate from 5.0c to 5.1e, I have used the Upgrade documentation to migrate my current 5.0c server towards a 5.1e server on a new host.The 9.3 Postgres database has been imported into the new 9.4 database, and the directories contentstore and solr4/index copied on the new server. So

Re: Migration from 5.0c to 5.1e : runtime error

slibert — Mon, 20 Jun 2016 11:03:44 GMT

Hi,

Your log contains some warning about the migration.
Did you check them ?

/opt/alfresco-community/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Post-Upgrade-alf_-6832608428571894551.txt

Regards

Re: Migration from 5.0c to 5.1e : runtime error

nic0 — Tue, 21 Jun 2016 13:30:35 GMT

Hello,
I tool a quick look at this file, and supposed the messages were harmless, although I must admit I don't understand what they mean. It contains the following 3 lines:

Difference: missing index from database, expected at path: .alf_node_properties.idx_alf_nprop_b
Difference: missing index from database, expected at path: .alf_node_properties.idx_alf_nprop_d
Difference: missing index from database, expected at path: .alf_node_properties.idx_alf_nprop_f

Regards

Re: Migration from 5.0c to 5.1e : runtime error

gianfi — Sun, 16 Jul 2017 10:44:34 GMT

Hello,

I'm having the very same problem trying to update to 5.2.f from 5.0.0 , on postgres DB backend.

I have migrated alf_data content, then pointed new alfresco to the imported DB.

At first start, migrate applies some patches to the database, trowing out the following errors in the logfile:

Difference: missing index from database, expected at path: .alf_node_properties.idx_alf_nprop_b
Difference: missing index from database, expected at path: .alf_node_properties.idx_alf_nprop_d
Difference: missing index from database, expected at path: .alf_node_properties.idx_alf_nprop_f

I have then manually created the missing DB indexes by doing a diff from a stock alfresco 5.2.f database.

Still, after restarting alfresco, the startup fails trowing out a generic error:

...

org.alfresco.error.AlfrescoRuntimeException: 06160001 Workflow deployment failed

...

Caused by: org.alfresco.error.AlfrescoRuntimeException: 06160000 Required people system path not found: sys:system

no other error is displayed in alfresco log.

Full alfresco.log is at : 2017-07-16 12:30:12,517 INFO [org.alfresco.repo.admin] [localhost-startStop-1] - Pastebin.com

thanks for any help