Symptoms

When attempting to open a document on the Verification Station, the following error message is displayed: "Could not load binary data ( version ...) for page with ID '...' from the Application Server", where "..." stand for actual file versions and page ID)

Causes

If the file storage folder is used, ABBYY FlexiCapture stores documents in two locations - in the ABBYY FlexiCapture database (which stores the titles of the documents) and in the file storage folder (which stores the binary bodies of the documents, i.e. their images and copies in the ABBYY FlexiCapture internal formats). This error message means that the program cannot load the binary body of the document referenced by the title. From our past experience, this error message is displayed if

• the hard disk drive with the file storage folder is damaged;
• the file storage folder and the database are out of sync because of some user actions (e.g. incorrect recovery of data from a backup copy);
• there has been some network malfunction while reading or writing the binary document body.

Resolution

The instructions below may help you identify the reason for this error message. Please complete the steps below:

• Try opening the document once again. If there has been a network glitch while reading the binary body from the file storage folder, the document should open on a second attempt.
• Analyze the Windows event log on the computer hosting the Application Server and the Verification Station. 
  This log may contain records which explain the reasons behind this error message. These may be HDD read/write failures or network errors.
• Check the hard disk drive with the file storage folder for errors and bad sectors.
• Check the structure of the file storage folder for integrity.
  The file storage folder has a hierarchical structure. The error may have been caused by a violation of the hierarchy. Check the locations of the folder and the files that store the bad batch:
  • When the "Could not load binary data..." error message is displayed, open SQL Server Management Studio and execute the following SQL query:
    

    -- ======================
    
    Use FC10DB -- the name of the FlexiCapture database
    
    Go
    
    Select dbo.Page.Id As 'PageId', dbo.Page.DocumentId, dbo.Document.BatchId, dbo.Batch.ProjectId
    
    From dbo.Page
    
    INNER JOIN
    
    dbo.Document
    
    On dbo.Document.Id = dbo.Page.DocumentId
    
    INNER JOIN
    
    dbo.Batch
    
    On dbo.Batch.Id = dbo.Document.BatchId
    
    Where dbo.Page.Id = 2377 -- ID of the page that you see in the error message
    
    -- ======================

    
    The result will look like this:
    
    PageId DocumentId BatchId ProjectId
    2377 2287 140 20
• Go to file storage folder (you can specify the path in the File Storage Folder field of the Administration and Monitoring Console: Service → Application Server).
• Open the folder with a GUID name (e.g. 6C65C249-9965-40BE-AE27-5F22BC7F1EBF). If there are several folders with GUID names, you can find out the required GUID name by executing the following SQL query:
• Select dbo.Settings.Value as 'GUID' from dbo.Settings where dbo.Settings.Name = 'DatabaseGuid'
• You will see folders with names like project_12, where the number corresponds to the ID of the project. Open the folder with the appropriate ID (see the ProjectId returned by the SQL query in step 1). In our example, ID = 20, so we need to open the folder named project_20. Next, we will see a number of files and folders named 0000-0999, etc. The digits indicate the range of batch IDs.
• Open the folder whose range of IDs contains the BatchId returned by the SQL query. In our example, BatchId = 140, so we need to open the folder named 0000-0999. Inside, there are folders corresponding to the batches, and we are looking for folder 0140.
• Can you see the necessary folder in the file storage facility? If you cannot see the necessary folder, try to locate it and find out why it has been misplaced.
• If you can see the necessary folder, open it and check to see if it contains all the files for the page with the required ID. You should see the file with names like 1-2377-1, 1-2377-BlackWhiteImage1, 1-2377-ColorImage1, 1-2377-RecognizedWords0. Note that the second digit in the names of the files corresponds to the BatchId. If you cannot see the files for the required page in this folder, try locating them and finding out how they were moved to a different location.