Manually Triggering the Recalculation of Volume Size.

December 16, 2005 | KB: 1011065
Server (MSDE) 7, Server (MSSQL) 7, Server (Oracle) 7

Summary

The Laserfiche Server provided no mechanism for triggering the recalculation of the size of the image, text and electronic documents in a volume. The Laserfiche Server is capable of automatically recalculating to handle normal changes to a volume. This article describes how to manually trigger a recalculation of the size of your volumes in response to particular issues.

More Information

Under most circumstances, it is not necessary for users to manually trigger a recalculation of the volume size. These instructions are only necessary for cases where the server's record of the size of the volumes is out of sync with the actual size of the volumes. This will not occur in standard operation, but can exist as a result of an issue. For instance, once the following issue has been resolved and the images compressed, this function can be used to recalculate the volume size:

1011040 FIX: Scanning with Laserfiche Twain Produces Unusually Large Images.

Resolution

There is an additional maintenance function for triggering re-calculation available for the Laserfiche Server version 7.1.2. This function is incorporated into an updated version of LFEng.dll. This maintenance function is included in LFEng.dll version 7.1.2.600 and later.

To update Laserfiche Server 7.1.2

  1. Stop the Laserfiche Server service.
    1. Click Start and navigate to Control Panel.
    2. Select Administrative Tools.
    3. Select Services.
    4. Scroll down and select Laserfiche Server 7.1.
    5. From the Action menu, click Stop.
  2. Click the following link to download a zip file containing LFEng.dll (version 7.1.2.600).
    Hotfix_SCR24021.zip
  3. Replace the LFEng.dll located in the Laserfiche Server installation folder with the updated version. By default, Laserfiche Server is installed at C:\Program Files\Laserfiche\Server.
  4. Restart the Laserfiche Server service.
    1. Click Start and navigate to Control Panel.
    2. Select Administrative Tools.
    3. Select Services.
    4. Scroll down and select Laserfiche Server 7.x.
    5. From the Action menu, click Start.

To recalculate volume size using Enterprise Manager

  1. Open Enterprise Manager.
  2. Expand Microsoft SQL Servers.
  3. Expand SQL Server Group.
  4. Expand your server.
  5. Expand Databases.
  6. Select your Laserfiche database.
  7. Select the Vol table.
  8. From the Action menu, select Open Table and then Return All Rows.
  9. Note the VolumeId values for the volume or volumes you wish to recalculate.
  10. From Tables, select the DBOptions table.
  11. From the Action table, select Open Table and then Return All Rows.
  12. Select the last cell in the OptionName column. This cell should be blank.
  13. Type "VolSizeReset" in the empty OptionName cell.
  14. Select the OptionValue cell in the same row as VolSizeReset.
  15. Set the OptionValue to the volume ID number or numbers for the volumes you wish to recalculate. To recalculate multiple volumes at once, separate the volume numbers with commas (for instance, '1,2,7,12'). To recalculate all volumes, input '0'.
  16. Restart the Laserfiche Server service to recalculate the size of the volume.
    1. Click Start and then click Control Panel.
    2. Select Administrative Tools.
    3. Select Services.
    4. Select Laserfiche Server 7.x.
    5. From the Action menu, select Restart.

    Note: The restart process can take a very long time, as the server must recalculate the size of every file within the specified volumes. You may receive a warning or error message during the restart process due to the length of time this process takes. This error can be ignored; you should allow the process to keep running. Logging information will continue to be placed in the error.log as volumes are completed. You can monitor this file to track the progress of the recalculation procedure.

Note: Once the recalculation operation is complete, the server will automatically set the value of 'VolSizeReset' to NULL. This will prevent the recalculation process from automatically repeating. The server does not need to be restarted following the recalculation operation. All logging related to the recalculation will be placed in the repository's error.log.

To recalculate volume size using osql commands

  1. From Start, select Run.
  2. Type the following and press ENTER.

    cmd

  3. Type the following and press ENTER.

    osql -E -S ServerName -d "DatabaseName"

    where ServerName is the name of your SQL server and DatabaseName is the name of the database associated with your Laserfiche repository.
  4. To determine the volume ID numbers for your volumes, type the following and press ENTER.

    select VolumeName,VolumeID from vol

  5. Type "go" and press ENTER.
  6. To recalculate the volume size:
    • If you have never recalculated volumes, do the following:
      1. Type the following and press ENTER.

        insert into dboptions(OptionName, OptionValue) values ('VolSizeReset', 'VolumeID')

        where VolumeID is the volume ID for the volume you wish to recalculate. To recalculate multiple volumes at once, separate the volume numbers with commas (for instance, '1,2,7,12'). To recalculate all volumes, input '0'.
      2. Type "go" and press ENTER.
    • If you have recalculated volumes previously and need to do so again, do the following:
      1. Type the following and press ENTER.

        update dboptions set OptionValue='VolumeID' where OptionName='VolSizeReset'

        where VolumeID is the volume ID for the volume you wish to recalculate. To recalculate multiple volumes at once, separate the volume numbers with commas (for instance, '1,2,7,12'). To recalculate all volumes, input '0'.
      2. Type "go" and press ENTER.
  7. Restart the Laserfiche Server service to recalculate the size of the volume.
    1. Click Start and then click Control Panel.
    2. Select Administrative Tools.
    3. Select Services.
    4. Select Laserfiche Server 7.x.
    5. From the Action menu, select Restart.

    Note: The restart process can take a very long time, as the server must recalculate the size of every file within the specified volumes. You may receive a warning or error message during the restart process due to the length of time this process takes. This error can be ignored; you should allow the process to keep running. Logging information will continue to be placed in the error.log as volumes are completed. You can monitor this file to track the progress of the recalculation procedure.

Note: Once the recalculation operation is complete, the server will automatically set the value of 'VolSizeReset' to NULL. This will prevent the recalculation process from automatically repeating. The server does not need to be restarted following the recalculation operation. All logging related to the recalculation will be placed in the repository's error.log.