topic 'No ContentData value exists for ID' errors in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/no-contentdata-value-exists-for-id-errors/m-p/254611#M207741 <HTML><HEAD></HEAD><BODY><SPAN>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 </SPAN><A href="https://issues.alfresco.com/jira/browse/ALF-2719" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/ALF-2719</A><BR /><SPAN>But that ticket does not describe all the ways to fix the problem. </SPAN><BR /><BR /><SPAN>We are no longer under a support contract because the business is winding down, so I could really use the help of the community.</SPAN><BR /><BR /><SPAN>Here is my sql output showing the error:</SPAN><BR /><BR /><SPAN>mysql&gt; 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;</SPAN><BR /><SPAN>+———+———-+———–+————+—————+——————+—————+————+————-+————–+————–+——————–+——+———+—————-+———————+———————+——————-+</SPAN><BR /><SPAN>| 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 |</SPAN><BR /><SPAN>+———+———-+———–+————+—————+——————+—————+————+————-+————–+————–+——————–+——+———+—————-+———————+———————+——————-+</SPAN><BR /><SPAN>| 1022197 | 79 | 1 | -1 | 21 | 3 | | 436329 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |</SPAN><BR /><SPAN>| 1022209 | 79 | 1 | -1 | 21 | 3 | | 436314 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |</SPAN><BR /><SPAN>+———+———-+———–+————+—————+——————+—————+————+————-+————–+————–+——————–+——+———+—————-+———————+———————+——————-+</SPAN><BR /><SPAN>2 rows in set (5.55 sec)</SPAN><BR /><BR /><SPAN>I would like to repair this data.&nbsp; I have a cold backup, but it is a month old.</SPAN><BR /><BR /><SPAN>Also I am not sure it is related, but I can no longer login to admin/admin. </SPAN><BR /><BR /><SPAN>I would attach my alfresco.log but I can't seem to see where to do it in the forum interface.</SPAN><BR /><BR /><SPAN>Please help!</SPAN><BR /><BR /><SPAN>Jay</SPAN></BODY></HTML> Thu, 20 Oct 2011 13:54:26 GMT jjungalwala 2011-10-20T13:54:26Z 'No ContentData value exists for ID' errors https://connect.hyland.com/t5/alfresco-archive/no-contentdata-value-exists-for-id-errors/m-p/254611#M207741 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-2719But that ticket does not describe all the ways to fix the problem. We are n Thu, 20 Oct 2011 13:54:26 GMT https://connect.hyland.com/t5/alfresco-archive/no-contentdata-value-exists-for-id-errors/m-p/254611#M207741 jjungalwala 2011-10-20T13:54:26Z Re: 'No ContentData value exists for ID' errors https://connect.hyland.com/t5/alfresco-archive/no-contentdata-value-exists-for-id-errors/m-p/254612#M207742 <HTML><HEAD></HEAD><BODY><SPAN>Will the upgrade "fix" the problem – this seems like a data corruption issue.&nbsp; Don't I need to fix the database before I can upgrade?</SPAN></BODY></HTML> Thu, 20 Oct 2011 16:52:43 GMT https://connect.hyland.com/t5/alfresco-archive/no-contentdata-value-exists-for-id-errors/m-p/254612#M207742 jjungalwala 2011-10-20T16:52:43Z Re: 'No ContentData value exists for ID' errors https://connect.hyland.com/t5/alfresco-archive/no-contentdata-value-exists-for-id-errors/m-p/254613#M207743 <HTML><HEAD></HEAD><BODY><SPAN>I have the same error. Using Alfresco 3.4 CE</SPAN><BR /><BR /><SPAN>Is there a way to repair data? FULL reindex doesn't help.</SPAN><BR /><BR /><SPAN>Thank you</SPAN></BODY></HTML> Mon, 16 Apr 2012 07:41:26 GMT https://connect.hyland.com/t5/alfresco-archive/no-contentdata-value-exists-for-id-errors/m-p/254613#M207743 sebek72 2012-04-16T07:41:26Z