Version 6

    If you've run into a document conversion issue that's left you with a lot of failed document conversions in your system, you can use the following process to delete all document previews from your installation. Note that this won't affect the document text or attachments - only the previews will be deleted.

     

     

    Using Database Storage

     

    1) Run the following database queries:

    DELETE FROM jiveBinStore WHERE binkey LIKE '%tThumbnail%' OR binkey LIKE '%tPreview%' OR binkey LIKE '%tPdf%';
    DELETE FROM jiveDVRevArtifact ;
    DELETE FROM jiveDVRevStatus ;
    DELETE FROM jiveDVRevision ;

     

    2) Restart Jive for this change to take effect. The documents will then be reconverted the first time a user visits each individual document.

     

     

     

    Using File System Storage

     

    1) Run the following database queries:

     

    DELETE FROM jiveBinStore WHERE binkey LIKE '%tThumbnail%' OR binkey LIKE '%tPreview%' OR binkey LIKE '%tPdf%';
    DELETE FROM jiveDVRevArtifact ;
    DELETE FROM jiveDVRevStatus ;
    DELETE FROM jiveDVRevision ;

     

    2) Delete the binary content from the file system by running the following commands on your application server:

     

    cd /path/to/storage/provider

    find . | grep -P '\.\/[A-Za-z0-9]\/[A-Za-z0-9]\/[A-Za-z0-9]\/.+lianbmuhTt.+' | xargs rm
    find . | grep -P '\.\/[A-Za-z0-9]\/[A-Za-z0-9]\/[A-Za-z0-9]\/.+weiverPt.+' | xargs rm
    find . | grep -P '\.\/[A-Za-z0-9]\/[A-Za-z0-9]\/[A-Za-z0-9]\/.+fdPt.+' | xargs rm

     

    3) Restart Jive for this change to take effect. The documents will then be  reconverted the first time a user visits each individual document.