topic Weird error upgrading to 4.2c in Alfresco Archive

Weird error upgrading to 4.2c

tgmweb — Sun, 30 Dec 2012 07:23:10 GMT

I'm trying to upgrade from 4.0 to 4.2c, and I'm getting a weird error on start upec 30, 2012 7:18:48 AM org.activiti.engine.impl.jobexecutor.JobExecutor startINFO: Starting up the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].Dec 30, 2012 7:18:48 AM org.activiti.engine.impl.

Re: Weird error upgrading to 4.2c

auxorro — Fri, 04 Jan 2013 14:54:52 GMT

Hi, I'm having the exact same problem. Did you get it to work?
Also, I'm wondering if the same happens when upgrading from 4.0b to 4.2b or 4.2a

Bye.

Re: Weird error upgrading to 4.2c

tgmweb — Fri, 04 Jan 2013 15:11:22 GMT

Sorry I can't be of more help, but this was just one of about 10 issues I had upgrading, and I can't remember how each were resolved exactly!

One was down to some content rule triggers in my repository - I wasn't actually using them anymore, so I basically deleted all rules/actions, and then tried again. It worked after that…(well, actually it didn't work, I had a whole host of other issues, but it is working now).

Another issue I had revolved around trying to update the version number of Alfresco in the database (which I believe it does after the upgrade). I had to turn on query logging in MySQL and then tail the logs - I then executed the version number SQL statement manually….

I'd advise you turn on MySQL query logging, tail the two logs simultaneously, and then see exactly what it's trying to do in the DB when it craps out.

Re: Weird error upgrading to 4.2c

auxorro — Mon, 07 Jan 2013 12:22:35 GMT

Hi, thanks for the info. I finally upgraded without problems to version 4.2.b.
I don't know if it's necessary to upgrade to 4.2.c, because even when upgrading from 4.2.b I get the same error.

Bye.

Re: Weird error upgrading to 4.2c

kazishariar — Tue, 15 Jan 2013 01:03:56 GMT

Not sure if this'll help. But make sure you installed alfresco solr too if youre using the .zip. If you are using the .bin this shouldn't be a problem. I'm still trying to narrow down the problem… Will have an update if I hit anything.

Re: Weird error upgrading to 4.2c

heiko_robert — Wed, 23 Jan 2013 18:46:10 GMT

We hit the same issue and finally after hours of research we found out the following (coninue reading if your repository was initially installed in version < 3.4.a):
<ul>
<li>Alfresco changed the system model (sys:versionEdition) 2010-03-12 from multiple=true to false</li>
<li>Maybe some previous migrations steps in the past failed or Alfresco didn't pick this up correctly in the migration scripts in the previous versions but in version 4.2.c this property is read during bootstrap and fails</li>
<li>easy (hot) fix: update your database and set list_index=-1 for the versionEdition property in the alf_node_properties table</li>
</ul>

see https://issues.alfresco.com/jira/browse/ALF-17483?focusedCommentId=206479#comment-206479

Re: Weird error upgrading to 4.2c

kazishariar — Mon, 11 Feb 2013 20:23:50 GMT

This is the query that was used to change the value for us, note this is running in Postgres while connected to your alfresco db, SQL queries should remain the same across multiple platforms. Please do this at your own risks, make backups, then:

update alf_node_properties set list_index = -1 where qname_id = (select id from alf_qname where local_name = 'versionEdition');

Stop, restart. For reasons please read aove comment, and check the ticket for additional information.