Troubleshooting
Problem
Cause
Resolving The Problem
select object_id, content_referral_blob, datalength(content_referral_blob)as LenghtOfRefferalBlob FROM [OS0004].[dbo].[DocVersion] where object_id = '{guid}';
The length returned should be computed as 1.
2. Use the length to locate the other documents with the migration status:
select object_id, u1708_documenttitle FROM [OS0004].[dbo].[DocVersion] where datalength(content_referral_blob) = 1;
3. To remove such documents, you will need to perform a direct SQL against CE database to reset the content_referral_blob back to null. A SQL similar to:
Update docversion set content_referral_blob = null where object_id = ‘<document id>’;
Once the content_referral_blob has been reset to null, user can can delete/remove the document through the usual means through ACCE or Content Navigator.
4. Add the content or document in question if you still have a copy as new to Filenet Content Manager.
Was this topic helpful?
Document Information
Modified date:
15 March 2024
UID
swg21978744