You are viewing limited content. For full access, please sign in.

Question

Question

couldn't find text or image for page

asked on June 2, 2015

User had a 15 page document.  First page was PDF and that was combined with 14 pages of TIFF images.  regenerate pages was run and all but the first page (original PDF) were gone.  I found them in the recycle bin, and restored, but now I just see:  "Couldn't find text or image for page"

 

Anyone know how I can get the TIFF's back?

0 0

Replies

replied on August 11, 2022

I know this is an old feed but wanted to post this on here in case this helps anyone else. 

I am recently new to Laserfiche and inherited a repository that needed to have a lot of clean up.  I wanted a way to find all documents that said they had a document assigned to it but like the original post stated "Couldn't find text or image for page". I created a work flow to 1st query the Laserfiche repository. Then foreach of those entries ran I ran a query to get the Windows file location of the file. I then used a C# script to check if file existed if it did it updates a token for a report, and if it didn't exist it did the same updated a different token that would create a different report. This would allow me to view the documents in Laserfiche Repository that didn't have an actual windows file associated to it. 

 

This is the query I used to get where the file was from the LF database.

SELECT dbo.toc.name AS DocumentName, dbo.doc.pagenum + 1 AS PageNum, dbo.vol.fixpath + '\' + 
SUBSTRING(CONVERT(VARCHAR(8),CONVERT(VARBINARY(4), dbo.doc.storeid),2),1,2) + '\' + 
SUBSTRING(CONVERT(VARCHAR(8),CONVERT(VARBINARY(4), dbo.doc.storeid),2),3,2) + '\' +
SUBSTRING(CONVERT(VARCHAR(8),CONVERT(VARBINARY(4), dbo.doc.storeid),2),5,2) + '\' +
CONVERT(VARCHAR(8),CONVERT(VARBINARY(4), dbo.doc.storeid),2) + '.TIF' AS FullPathAndFilename
FROM dbo.doc  
LEFT JOIN dbo.toc ON dbo.doc.tocid = dbo.toc.tocid
LEFT JOIN dbo.vol ON dbo.toc.vol_id = dbo.vol.vol_id
WHERE dbo.doc.tocid = ?
ORDER BY dbo.doc.pagenum

 

This is the script I used to check if the file existed.

namespace WorkflowActivity.Scripting.CheckWindows
{
    using System;
    using System.IO;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Data.SqlClient;
    using System.Text;
    using Laserfiche.RepositoryAccess;
    using Laserfiche.DocumentServices;

    /// <summary>
    /// Provides one or more methods that can be run when the workflow scripting activity is performed.
    /// </summary>
    public class Script1 : RAScriptClass104
    {
        /// <summary>
        /// This method is run when the activity is performed.
        /// </summary>
protected override void Execute()
{
    // Write your code here. The BoundEntryInfo property will access the entry, RASession will get the Repository Access session
    //try
    //{
        // Get Path to Image
        String ImageLocation = (String)GetTokenValue("WindowsPath");
        // Update Token if File Exists
        //System.IO.DirectoryInfo di = new System.IO.DirectoryInfo(WindowsPath);
        if (File.Exists(@ImageLocation))
        {
         SetActivityTokenValue("WindowPathTrue",true);
            Console.WriteLine("Yes file is there");
        }
        else
        {
            SetActivityTokenValue("WindowPathTrue",false);
            Console.WriteLine("No file is there");
        }
    //}

}}}

 

Hope this might help someone else.

1 0
replied on June 2, 2015

Is there a way to restore just a single document?  I was under the impression that I needed to resotre the entire data store and then grab it from there.

0 0
replied on June 2, 2015

Using a separate system, you can restore the repository and volume (for that specific document) from backup. Then export the document as a briefcase and import it back into their production repository. If licensing is a concern for standing up a temporary system for this process, you can speak with your Laserfiche Regional Manager.
If the first option isn't feasible, then another option would be to migrate all new documents (since the last backup) to a temporary volume and then export that volume. Then restore the backed up repository and volumes into their current environment and then attach the volume containing the new documents to it. You can then migrate those new documents back to their respective volumes.

0 0
replied on June 9, 2016

Had a customer report this same issue on a 9.0.x system... has this been resolved in 9.1 or higher?? If so, i will obviously upgrade them.

0 0
replied on June 2, 2015

Hi Jim,

We can recreate the issue and will be looking into the matter. For now though, you can restore the document from a backup.

Regards

0 1
replied on June 3, 2015

This has been an issue for quite some time. I have reported it previously, as well. Is there a plan to address this behavior? Maybe putting the images in the recycle bin?

Thanks for the update.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.