'No ContentData value exists for ID' errors

[jjungalwala]

I can not get our Enterprise 3.2.1.2 to start up correctly. I have some corrupt contentData and I am unsure how to get rid of it. The description of the problem is identical to https://issues.alfresco.com/jira/browse/ALF-2719
But that ticket does not describe all the ways to fix the problem.

We are no longer under a support contract because the business is winding down, so I could really use the help of the community.

Here is my sql output showing the error:

mysql> select * from alf_node_properties np left join alf_content_data cd on (cd.id = np.long_value) where np.actual_type_n = 21 and cd.id is null;
+———+———-+———–+————+—————+——————+—————+————+————-+————–+————–+——————–+——+———+—————-+———————+———————+——————-+
| node_id | qname_id | locale_id | list_index | actual_type_n | persisted_type_n | boolean_value | long_value | float_value | double_value | string_value | serializable_value | id | version | content_url_id | content_mimetype_id | content_encoding_id | content_locale_id |
+———+———-+———–+————+—————+——————+—————+————+————-+————–+————–+——————–+——+———+—————-+———————+———————+——————-+
| 1022197 | 79 | 1 | -1 | 21 | 3 | | 436329 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 1022209 | 79 | 1 | -1 | 21 | 3 | | 436314 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
+———+———-+———–+————+—————+——————+—————+————+————-+————–+————–+——————–+——+———+—————-+———————+———————+——————-+
2 rows in set (5.55 sec)

I would like to repair this data.  I have a cold backup, but it is a month old.

Also I am not sure it is related, but I can no longer login to admin/admin.

I would attach my alfresco.log but I can't seem to see where to do it in the forum interface.

Please help!

Jay

[jjungalwala]

Will the upgrade "fix" the problem – this seems like a data corruption issue.  Don't I need to fix the database before I can upgrade?

[sebek72]

I have the same error. Using Alfresco 3.4 CE

Is there a way to repair data? FULL reindex doesn't help.

Thank you