List of Changes for Laserfiche Server 8.3.2 Hotfix 1013152.

January 29, 2013 | KB: 1013152
Laserfiche 8.3.2

Summary

This article details hotfix 1013152 for Laserfiche Server 8.3.2. This hotfix resolves the following issues:

  • Laserfiche Server 8.3.2 now fully supports Laserfiche Forms. Previously, you could encounter an "A connection to the Laserfiche Server could not be established." error message. (98386)
  • The Modify Trustee audit event now displays the full name of the modified trustee. (98410)
  • An internal query for calculating volume size is now better optimized. Previously, when opening documents, the inefficient query could cause Laserfiche to appear to stop responding as the query would simply take a long time to finish. (98745)
  • Search performance is improved when doing both a Basic Search and Within Folder search and the Resolve shortcuts option is disabled. (98208)
  • The briefcase import process no longer loses track of the file extensions of certain types of electronic documents. (98831)
  • The Within Folder search type may not return correct search results on newly created 8.3.2 Oracle repositories. (97005)

The .msp updates the following files:

  • httpserv.dll (8.3.2.751)
  • cr.dll (8.3.2.751)
  • LfBriefcase.dll (8.3.2.751)
  • ora-schema.sql (last modified on January 23, 2013)

More Information

Note: This update is included as part of the Laserfiche 8.3.2 installation packages available on the Laserfiche Support Site after January 29, 2013. The updated download packages contain an "updates" subfolder with the .msp patch files. When using the updated installation to install Laserfiche Server 8.3.2 for the first time, the installation process will automatically detect and install the appropriate .msp files located in that subfolder. If you have not yet installed Laserfiche Server 8.3.2, please download the most recent version of the Laserfiche Avante or Laserfiche Rio installations.

Click the following link to download a zip file containing the Server hotfix.

KB1013152.zip

The zip file contains lfsw32_832751.msp for 32-bit Laserfiche Server and lfsx64_832751.msp for 64-bit Laserfiche Server. Double-click the appropriate .msp file to update your Laserfiche Server installation.

If you have previously created a new Laserfiche 8.3.2 repository for Oracle, and are encountering the issue listed above with bug ID 97005, you can manually run the following SQL statement to update the affected stored procedure. Note that this potential issue only affected newly created 8.3.2 Oracle repositories. This issue did not affect Oracle repositories upgraded from a previous version of Laserfiche 8 to Laserfiche 8.3.2.

create or replace
procedure is_tocid_in_folder(
    p_tocid    toc.tocid%type,
    p_fid       toc.tocid%type,
    p_recurse    number,
    p_result    out number)
as
  v_temp number;
begin

    select parentid
  into v_temp
    from toc
    where tocid = p_tocid;

    if v_temp = p_fid
    then
        p_result := 1;
        return;
    elsif v_temp = 1
    then
        p_result := 0;
        return;
    end if;

    if p_recurse = 0
    then
        select 1
        into p_result
        from dual
        where exists (select *
            from toc
            where parentid = p_fid
            and tocid = p_tocid);
    else
        select 1
        into p_result
        from dual
        where exists (select *
            from toc
            where tocid = p_fid
            and p_tocid <> p_fid
            start with tocid = p_tocid
            connect by tocid = prior parentid);
    end if;
    exception
    when no_data_found
    then
        p_result := 0;
end is_tocid_in_folder;
/

Related Links

1013128 List of Changes for Laserfiche Server 8.3.2 Hotfix 1013128.