vista release 5

7/24/2019 Vista release 5

1/40

Copyright Open Text Corporation. All rights reserved.

This software product and documentation is licensed subject to the terms of the license agreement shipped with the product.

Vista Plus 5.5.2 Release Notes (April 2, 2012) 60131552.6

Page 1

Vista Plus

Version 5.5.2

Release Notes

April 2, 2012

IMPORTANT:This document describes new features and updates in version 5.5.2 of VistaPlusthe April 2011 SP (Service Pack). It includes compatibility information, descriptionsof the changes in version 5.5.2, and upgrade instructions. OpenText recommends that youread this document in conjunction with the other documentation included with thesoftware. If any conflicts exist, the information inthis document supersedes other VistaPlus documentation.

Check the Vista Plus section of the OpenText Knowledge Center at https://knowledge.opentext.comfor any patches or documentation updates that may have beenposted after the initial release of this version of Vista Plus.

Note The Vista Plus product suite is now marketed as OpenText Report and OutputManagement. It is listed on the Knowledge Center under both the old andnew names.

Table of Contents

General Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

Supported Configurations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Enhancements in Version 5.5.2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

Software Fixes and Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

Known Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

Update Instructions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
https://knowledge.opentext.com/https://knowledge.opentext.com/https://knowledge.opentext.com/https://knowledge.opentext.com/


2/40

General Information




Page 2

General Information

While Vista Plus 5.5.2 is a Service Pack, it does include enhancements in addition to fixesand performance improvements. It includes changes to the Vista Plus server, Web View,vadmin, rcapture, the Server Admin Client, and the Windows Client, and new modulesfor TransVue Tagging and LDAP user authentication. It includes all patches to Vista Plus5.5.1 up through April 12, 2011; patches created after that date are not included.

This document contains five sections: supported configurations, descriptions of theenhancements in version 5.5.2, a list of fixes and changes in the release, a list of knownissues, and installation information. For complete instructions on using Vista Plus, pleasesee the Vista Plus manuals and the online help.

As with any upgrade, please contact Vista Plus technical support before upgrading toversion 5.5.2.


3/40

Supported Configurations




Page 3


Note Important!All Vista Plus components are supported only with releasedversions of underlying software. Using Vista Plus with any beta or pre-releaseversion of a host operating system, Web browser, or other required software isnot supported.

These software versions were supported when this document was published.However, we can effectively support Vista Plus only with software versionsthat are also supported by their suppliers. Therefore, if a software vendordrops support for one of the listed versions, we will no longer be able tosupport Vista Plus with that version.

Note Although we use virtual environments when developing and testing VistaPlus, we do not specifically develop for or test Vista Plus for properperformance with any server virtual environment, such as VMware, or

desktop virtual environment, such as Citrix. Therefore we do not list specificvirtual environment versions and configurations. We do, however, continueto provide the same level of support described in the OpenText MaintenanceHandbook for customers who run Vista Plus in a virtual environment.

Note For complete system requirements for any part of Vista Plus, see the Vista PlusServer Installation Guideor, for the Windows Client, the Vista Plus WindowsClient Users Guide.

Vista Plus Server

Operating Sys. Version Notes

HP-UX 11i v1 BUNDLE 11i (B11.11.0306), GOLDAPPS11i (B11.11.0606.446),

GOLDBASE11i (B11.11.0606.446), and PHSS_312211

11i v2 For Itanium and RISC processors; requires 11.23 Standard PatchBundle and patches PHSS_32502, PHSS_33349, PHSS_33350,and PHSS_33352

11i v3 For Itanium and RISC processors

Note We strongly suggest you follow HPs recommendation and migrate toItanium processors rather than RISC. Although we will still supportcustomers who use RISC, we have not fully tested 5.5.2 on 11i v3 with aRISC processor.

IBM AIX 5.3 Tested with Technology Level 5, SP 6, and C++ runtime 10.1.0.2and 8.0.0.7

6.1 Tested with:

Technology Level 6, SP3, with C++ runtime 11.1.0.1

Technology Level 3, with C++ runtime 10.1.0.2 and 9.0.0.1


4/40





Page 4

Database Support

Note Important!To install more than one Vista Plus database on the same UNIXserver host, you must use Oracle. You can have only one Vista Plus databaseusing MySQL on a server host. Installing one Vista Plus database usingMySQL and another using Oracle on the same host is not supported.

Sun Solaris 9 Requires UltraSPARC architecture; patch #111711-12 and, for 64-bit versions, #111712-122

10 Requires UltraSPARC architecture and SUNWlibC patch#119963-23

Windows Server 2003Standard orEnterprise

Service Pack 2 or later

1.You can install the above patches or any patch listed by HP as superseding one of them. Youcan see what patches are installed by entering the command swlist l patch.

2.The patches listed are the minimum revision levels. You can also install a later revision of thesame patch, if available. For example, for Solaris 9, you can install patch #111711-12 or anyhigher available version. To see what patches are installed, enter the command showrev -p.

Database Software Version Notes

Oracle 10g For both: RAC environment and DataDirect 6.0ODBC drivers; the necessary drivers are shippedwith Vista Plus as the Vista Plus Oracle ODBCConnector

11g

MySQL 4.1.13 (UNIX)4.1.13a (Windows)

With MyODBC 3.51 and ODBC Driver version

3.51.121

1.If you use MySQL, it must be installed on the Vista Plus server host. If you do not already haveMySQL installed, it is installed and configured for Vista Plus as part of a full server installation.

Operating Sys. Version Notes


5/40





Page 5

Remote Capture Tools

In addition to the operating system versions listed above for the Vista Plus server, theVista Plus remote capture tools are supported on these operating systems.

Legacy Remote Capture Tools

Several operating system versions on which the Vista Plus remote capture tools weresupported in previous versions of Vista Plus are no longer fully supported by theiroperating system vendors. Therefore, Vista Plus technical support can offer only limitedsupport for the remote capture tools on these platforms:

Customers who want to capture reports from a host using one of these operating systemversions can follow one of these procedures to install the remote capture tools on thathost:

To install the remote capture tools on one of the listed UNIX versions, use theinstallation files contained in the server\Legacy Capture Toolsdirectory. Do not use thestandard remote capture tools files found in the server\unixdirectory.

To install the remote capture tools on Windows 2000, perform a custom installation ofthe Vista Plus Windows Server and select only the remote capture tools forinstallation.

Note Legacy remote capture tools for older operating system versions may also beavailable. Contact technical support for more information.

Host Operating System Version Notes

SUSE Linux EnterpriseServer

SLE 9

SLE 10

RedHat EnterpriseServer

5.x

HP Tru64 UNIX (OSF1) 5.1 B-2


HP-UX 11.0

Sun Solaris 5.8 These are the 5.3 capture tools, and do not have anyfeatures introduced since that version, notably theability for vadminto create text file renditions ofreports.

IBM AIX 5.1

Windows 2000 Server orAdvanced Server Service Pack 4


6/40





Page 6

Capture Printer Port

LDAP Authentication Module

Note The LDAP Authentication module is a new feature of Vista Plus 5.5.2. SeeUser Authentication Using LDAP Passwords on page 9.

TransVue Tagging

The Vista Plus Output Manager and Kofax Capture versions apply only to the KofaxCapture export connector portion of TransVue Tagging. They are not required forvp_load_indexand rcapture.

Note TransVue Tagging is an optional, and separately licensed, new feature of Vista

Plus 5.5.2. See Indexing for TransVue Files on page 9.

Windows Version Notes

Server 2003 Standard or Enterprise Service Pack 1 or 2

Server 2008 R2 Standard or Enterprise 32-bit or 64-bit

Product Versions

Vista Plus Server 5.5.x

LDAP Supports LDAPv3; tested using OpenLDAP2.4.16.

Product Versions

Vista Plus Server 5.5.2

Operating Systems For rcaptureand vp_load_index, any operatingsystem which supports the remote capture tools,as listed in Remote Capture Tools on page 5.

The export connector for Kofax Capture can be

installed on any Windows version whichsupports the Kofax Capture version being used.

Note Export connectors are called releasescripts in earlier versions of KofaxCapture.

Vista Plus Output Manager 5.4.x.

Kofax Capture 8 and 9


7/40





Page 7

Client Compatibility

Web View

Web Server Host

Note Using Web View with the Oracle 10gAS Web server has not been fully testedby OpenText, but is supported. If you attempt to use this configuration, you

may receive an Internal Server Error 500 (a Java NoClassDefFoundErrormessage) when starting Web View. If this happens, copy the file commons-logging.jarfrom the Oracle installation to thej2ee\home\applibdirectory, thenstop and restart Oracle 10gAS.


Windows XP SP3

Server 2003,Standard orEnterprise

SP2

Server 2008 R2,Standard orEnterprise

Tomcat only; tested with Tomcat 6 and JDK 1.6.0_26;integration with IIS is not supported.

HP-UX Supported versions of these operating systems are the same as for theVista Plus server software, as listed on page 3.IBM AIX

Sun Solaris

Web Server/ServletEngine

Version Notes

Microsoft IIS 5.0, 6.0 Needs Cumulative Patch for Internet Information Service(Q327696). IIS cannot present Java Server Pages (JSPs); touse Web View with IIS, you must also install a servletengine such as Tomcat.

Apache Tomcat 5.5.x xshould be 9 or higher; testing was done on 5.5.27 using

JDK 1.5.0_16-b021

1.Important!If you obtain your copy of Tomcat anywhere other than the www.apache.org Website, you may need to make some changes to the installation before you can use Web View.Please see Customizing Web Viewfor detailed instructions.

6 On Windows 2008 R2; testing was done with 6.0.33 using

JDK 1.6.0_261

BEA WebLogic Server 8.1, 10.0 Service Pack 3 for version 8.1

IBM WebSphere 5.1.1, 6.1 Tested on 6.1.0.7


8/40





Page 8

Workstation

All browsers are supported on Windows only and must have JavaScript enabled. For allfeatures to work, cookies should also be enabled. For best performance with InternetExplorer, we recommend you set the browser to check for new page contentAutomatically, especially if you are using a low-bandwidth connection.

To download and view files in PDF format, you must have Adobe Acrobat or Reader 9.x.

Note Pop-up blocker software, including the integrated pop-up blockers in InternetExplorer and Firefox, can interfere with Web Views ability to open reportgenerations and display certain other windows. For more information, pleasesee Web Browser Requirements and Settings in the Web View online help.

Server Administration

The Server Administration client requires a version of Microsoft Management Console(MMC) that is supported on your Windows version.

Windows Client

Web Browser Version Notes

Internet Explorer 7.0 Tested with 7.0.5730.13

8.0 Tested with 8.0.7600.16385

Firefox 3.5.x or 3.6.x Tested with 3.5.16

5.0 Tested with 5.0.1


Windows 2008 Both 32- and 64-bit versions

Windows 7 Professional 32- and 64-bit

Windows Vista Business Service Pack 2, 32- and 64-bit

2003 Server Standard Service Pack 1, 32- and 64-bit

2003 Server Enterprise Service Pack 2, 32- and 64-bit

XP Professional Service Pack 3, 32- and 64-bit


Windows 2008 Both 32- and 64-bit versions

Windows 7 Professional 32- and 64-bit

Windows Vista Business Service Pack 2, 32- and 64-bitWindows Vista Enterprise Service Pack 2, 32- and 64-bit

2003 Server Standard Service Pack 1, 32- and 64-bit

XP Professional Service Pack 3, or Service Pack 2 with KB935448, 32- and 64-bit


9/40

Enhancements in Version 5.5.2




Page 9


In addition to the problem fixes and minor enhancements in the next section, Vista Plus5.5.2 includes these new features and improvements.

User Authentication Using LDAP Passwords

LDAP Authentication is an external module which you can use for passwordauthentication for some or all Vista Plus users. It functions as a user suppliedauthentication module which verifies users signing in to any Vista Plus client against theuser names and passwords in one or more LDAP databases.

The LDAP Authentication module works only with Vista Plus servers on UNIX hosts. Ifyou have a Vista Plus Windows server host and want to authenticate users against anActive Directory LDAP database, you can do so by selecting Windows authenticationwhen creating the users in Vista Plus.

Installing LDAP Authentication is described in the Vista Plus Server Installation Guide.Configuring and using it is covered in the Vista Plus Server Administration Guide.

Indexing for TransVue Files

The optional TransVue Tagging feature allows you to create indexes for TransVue reportgenerations. You can add any number of values to each index for any generation; thevalues do not need to appear in the TransVue file. This allows you to associate metadatavalues with scanned images, Microsoft Word documents, or other types of TransVue files.

TransVue Tagging index values are always stored in the Vista Plus database, whetherother index values are or not. You can search them using Web Views global index searchor Find in Report feature (the Content tab of the Find pane). When you find and open a

TransVue generation through an index search, it always opens to the first page. Thetagging index values are not associated with any particular page of the file.

Note To search TransVue Tagging values, the server.cfgpropertyIndexSearchMethodmust be set to either autoor db. Make sure this settingis compatible with the StoreIndexValuesInDB setting, which controls howother index values are stored. See Appendix B of the Vista Plus Server

Administration Guide.

You can add index values either when capturing the TransVue file using rcaptureor aftercapture by using the new vp_load_indexcommand. There is also a Kofax Capture exportconnector (export connectors were called release scripts in earlier versions of KofaxCapture) for Vista Plus Output Manager to automate scanning and capture of image filesand their associated index values to Vista Plus through Vista Plus Output Manager.

TransVue Tagging is an optional module. It is sold and licensed separately from the VistaPlus server. Contact your OpenText representative if you are interested in using it.

Installing TransVue Tagging is described in the Vista Plus Server Installation Guide.Configuring and using it is covered in the Vista Plus Server Administration Guide.


10/40





Page 10

Support for Additional Oracle Database Versions

The Vista Plus Server is now supported with the Oracle 11g and 11gR2 database.

Ability to Remove Index Entries from the Database

Vista Plus 5.5.0 added the ability to store index entries in the Vista Plus database as well asin the report warehouse. This speeds up certain types of searches and makes it possible tosearch offline report generations. However, it also increases the size of the Vista Plusdatabase. The new revert_genscommand removes index entries from the database forsome or all generations and sets the database flag for those generations indicating thatindex entries are in the report warehouse.

Tip Use revert_gensonly after consulting with Vista Plus technical support. Tomaintain proper index and search performance, including page security, youmust make sure server.cfgparameters relating to index storage and searching

are set correctly. See the Vista Plus Technical Addendumfor more information.


11/40

Software Fixes and Changes




Page 11


The following sections list the software problems fixed and issues addressed since therelease of Vista Plus 5.5.0. There are separate tables listing the changes in version 5.5.2 andthose in version 5.5.1.

Fixes and Changes in Version 5.5.2

JIRA Description

884 The Helpbutton did not work in any of the PC Capture tools.

917 Adds the revert_genscommand. See Ability to Remove Index Entries from theDatabase on page 10. Also tracked by issue 1543.

993 Changes the wording of certain server.debug.logerrors generated during searches to bemore informative.

1049 The convert_genscommand caused a core dump if generation files were missing fromthe Vista Plus report warehouse. It now notes the error in server.debug.logand continues.

1066 Updates the ODBC drivers used with Vista Plus and an Oracle database.

1134 Corrects the version number displayed in the Server Admin Client.

1184 Changes the match pane for Web View searches to remove previous results when a searchis started and to show more accurate messages while a search is in progress.

1190 Adds support for the Oracle 11g database.

1289 Adds LDAP Authentication module. See User Authentication Using LDAP Passwordson page 9.

1303 Output from the rcapturecommand was limited to 4000 characters.

1323 Changes the vadminModifyWarehouseConfigcommand vadminSecurityparameter toaccept y/n as values, as documented.

1328 Adds support for newer C++ Runtime packages on UNIX hosts. See Vista Plus Serveron page 3for tested versions.

1336 With certain combinations of user and group permissions on reports, Web View could notalways properly filter out the reports the user did not have permission for. This did notallow any user to see prohibited reports, but did cause Web View to display blank pagesin the Browse view report list, making it difficult for users to find the reports they wereallowed to open.

1337 Enhances server.debug.logmessages when re-indexing encounters a problem with a pagesecurity.

1341 Downloading a generation as a text file from Web View removed blank lines from the file,even if Include blank lineswas selected.

1345 Attempting to use the Windows Client to open some TIFF images captured as TransVue

generations failed with the message Unable to successfully download file.1347 When using short-lived connections, the Vista Plus server was not properly closing user

sessions for clients other than the Server Admin client. This resulted in various processes,such as VMIdentify, failing with messages indicating there were no processes available.


12/40





Page 12

1356 Allows Web View to display the correct original file name when opening TransVuegenerations. This was done by changing the Content-Disposition type in the HTTPheader. Files are now opened in a new window, not within the browser window.

1366 Closing the Windows Client caused an application error message on Windows XP SP3.

1386 Improves VMIdentifyperformance.

1388 See issue 1356.

1393 The patch installer would fail if the Vista Plus service had been stopped manually beforerunning the installer.

1403 After opening a generation from a SmartAlarm e-mail message, closing the report viewerwindow did not close the user session. This could cause Vista Plus to run out of userlicenses and prevent other users from logging in. The fix adds a Logoutbutton to thereport viewer window.

1406 Fixes two problems in Web View: In some cases, users were disconnected from Web Viewif several users were performing large searches at the same time, and opening severalTransVue generations at once could cause a too many reports openederrormessage.

1416 Changes Web View so users with View or Distribute permission for a report can savetheir own download columns. However, see Known Issues on page 18.

1417 Corrects errors that sometimes occurred during the del_genscommand.

1419 Corrects a memory leak that could occur under certain conditions during report captureand could eventually cause a core dump.

1421 Improves Web View performance when opening reports.

1423 Adds Microsoft Office 2007 file extensions to the default TransVue file extension list inspecial.cfg.

1429 When setting generation list options in Web View, the option to list generations for the

Lastxxxdaysdid not list the correct generations.

1436 After upgrading to 5.5.1, attempting to open the latest generation of a report by double-clicking the report in Web View failed with an Access deniederror even though theuser had pages to view in the report. Opening the generation from the generation listworked correctly.

1441 In some cases, users were not able to create or update indexes in Web View.

1472 Corrects problems viewing generations with page security after upgrading to 5.5.1.

1483 In the Server Admin client on newer versions of Windows, users were unable to viewpage security conditions if the page security was selected via the user or group.

1484 Corrects the version number display in the Server Admin client About box.

1486 File handles used by Vista Plus worker threads were not always being recovered whenthe worker process terminated.

1494 Users were unable to log in to Web View if they belonged to more than five groups. Thisoccurred only if users were required to select a group when logging in and the server.cfgALLGROUPSparameter was set to 1.

1543 See issue 917.

JIRA Description


13/40





Page 13

Fixes and Changes in Version 5.5.1

1560 Updates the Data Direct driver managers used with the Vista Plus server.1561 Improves Web View security.

1570 Adds support for Oracle 11gR2 database.

1586 Capturing TransVue files failed if there were bounding box capture rules in the captureconfiguration file.

1609 Adds support for C++ Runtime 11.1 on IBM AIX 6.1.

1610 Adds support for latest C++ Runtime on HP-UX 11iv3.

1611 Adds support for latest C++ Runtime on Sun Solaris 10.

1612 Adds the optional TransVue Tagging module. See TransVue Tagging on page 6.

1624 Attempting to capture certain Postscript reports with rcapture failed.

1625 An error when unloading certain tables using the unload_allcommand could later causeproblems when attempting to read index values.

1633 The Vista Plus server produced core files and, eventually, exhausted all user licenses,requiring the Vista Plus server to be restarted. This was seen only on a Windows serverhost using MySQL.

1635 Vista Plus occasionally lost its connection to the database. It had to be restarted to re-establish the connection. This was seen only on a Windows server host using MySQL.

1656 If you switched the value of the server.cfgflag StoreIndexValuesInDB from 1to 0, thenre-indexed one or more generations, and the IndexSearchMethodwas set to autoinserver.cfg, a global index or generation search would not find any values in thosegenerations. See Correcting Possible Index Search Problems on page 37for moreinformation.

SAR Description

4930 Places all page securities in a single .pfile in the generation directory instead of usingindividual .p###files for each one. Also adds a .pidxfile, which is an index to the .pfile.This change can greatly reduce the number of files in the report warehouse. The new filestructure is used only for page securities created (or re-created through re-indexing) with5.5.1 or later. Page securities created in 5.5.0 or earlier remain in .p###files.

5337 Adds support for the Vista Plus Capture Printer Port on Windows 2003,.

5514 Adds the option to limit the number of generations searched for global index searchesand report or generation information searches (the Global Index and Name tabs of theWeb View Find pane).

5881 In version 5.5.0, for Windows Vista compatibility the Windows Client was changed to use

a CHM-format help file instead of a HLP file. This makes the same change for the PCCapture client.

5882 The new CHM-format help file for the Windows Client was not being installed to theproper location and had to be manually copied from the installation CD.

JIRA Description


14/40





Page 14

5908 Adds support for using migration to move generations from one online volume toanother online volume. The generations are not compressed when this is done.

6120 Trying to capture certain PostScript files using the capture printer port failed and causeda core dump.

6305 Adds the ability to turn on or off logging of user-group membership changes through theServer Admin client.

6331 Certain combinations of searches using the Find in Report feature (selecting Findfromthe menu bar, then the Contenttab), caused Web View to stop working. At times, WebView crashed with errors in server.debug.log; at other times, it went into an infinite loop.

6350 Adds the ability to search for report generations by generation description or generationfile name, and to limit the number of matching generations listed.

6351 In Web View generation list, the Select Allicon appeared inactive after switching from anoffline to online generation list, even though it was active and available.

6363 Under certain conditions, global index search results were inconsistentthe same searchwould sometimes find results and sometimes not. This was the result of an error inaccessing shared memory, which was reported in server.debug.log.

6408 Adds the ability to search offline generations when searching for generations by report orgeneration info (selecting Findfrom the menu bar, then the Nametab).

6412 In some cases, it was possible to create an illegal combination of search parameters (someusing an index name, others not) through the Content tab of the Find pane. Thesesearches found matches in some cases and not in others, but always caused errors in theserver.debug.logfile. Weve changed the user interface behavior to prevent this fromhappening.

Even after this fix, it is possible to type an illegal search stringmixing text and indexcriteriadirectly into the search expression box. This is notsupported, will cause an errorin server.debug.log, and may or may not find matches.

6421 If a user cancels a convert_gensoperation by typing x, convert_gensnow displays amessage saying how many generations had been converted before the cancellation.

6427 In some cases, convert_gensrequired you to press Enterafterp(pause), r(resume), or x(cancel). With 5.5.2, you do not need to press Enterafter typing one of these options.

6446 The Server Admin Client is now supported on Windows Vista.

6468 You can now use the convert_genscommand to add index values to the Vista Plusdatabase even if the server.cfgfile contains the statement StoreIndexValuesInDB=0 .

6472 The generation list created in the GensToConvert.txtfile by the convert_gens -lcommandnow includes the report name, file name, and generation description for each generation.

6480 On UNIX, after upgrading a 5.4 Vista Plus server owned by root to 5.5 and changing theowner to a non-root user, the vadmin c=v l=ycommand incorrectly showed that manycomponents had not been upgraded. This was because the upgrade was not properly

setting the ownership and permissions for the .version.longfile.

6487 On IBM AIX only, upgrading a Vista Plus server owned by a user other than root failedbecause it could not load required third-party libraries.

SAR Description


15/40





Page 15

6491 When viewing a TransVue file in the Windows Client, the original file name is nowincluded as part of the downloaded file name. This makes it possible to see the originalfile name in the title bar.

6495 The convert_genscommand caused a core dump if it could not find the files for ageneration listed for conversion. It now skips the missing generation and writes an errorto server.debug.log.

6526 When viewing a TransVue file in Web View, the original file name is now included as partof the downloaded file name. This makes it possible to see the original file name in thetitle bar.

6540 After a Web View session expired, performing certain actions on an open reportsuch asdownloadingresulted in HTTP 500 errors. These actions are still not possible after thesession times out, but Web View now displays a more informative session time-outmessage.

6564 Running check_gens -pgenerated an error for each TransVue report generation it found.6578 Adds three new options to report logging to log password changes and adding users to

or removing them from groups.

6605 When running Vista Plus under a non-rootuser name on UNIX, adding page securitiesusing the Server Admin client sometimes caused the client to hang. The problem wassometimes also seen when attempting to capture a report which had page securities.

6631 Users were sometimes unable to open a generation which had been archived, thenrestored.

6654 Adds the ability to run Web View on a Web server using some versions of Oracle 10gAS.

6719 Certain graphics in captured PostScript reports were not displaying properly.

6722 Users with the option set to force a password change at their next login set could not login using Web View.

6725 When performing a whole-text generation search with the Show Match Listoptionselected, not all matches were being found.

6781 You can now change a user name by using the newnameparameter with the vadminModifyUsercommand.

6814 The IndexSearchReportGens() API did not work with Vista Plus 5.5.0.

6827 Using vadmin ModifyWarehouseConfigto change the high watermark setting for onlinevolumes reset the client connection type to persistent instead of short-lived.

6877 Received APIStatus(451)error when trying to create an index using the WindowsClient with short-lived connections and a short time-out setting (one or two seconds).

6886 Upgrading from Vista Plus 5.3 to Vista Plus 5.5.0 caused some bounding box capturerules to stop working.

6887 On an HP-UX server, the unload_allutility failed to unload the vp_reporttable.

6913 When running the Vista Plus server as a non-rootuser on UNIX, remote printing, orSmartAlarms which included print actions, could cause an error code 16 inserver.debug.log, even though the print was successful.

6940 On IBM AIX, some customers were unable to open some report generations because VistaPlus was unable to extract the generation files from the compressed tar file.

SAR Description


16/40





Page 16

6995 Using autocaptureto capture multiple reports failed with database-related errors whenusing an Oracle database and dedicated ODBC connections.

7042 rcapturefailed with a String too long (truncated)message after changing localesetting.

7072 After opening a generation from a bundle instance, users could not open any othergenerations without logging out of and back into Vista Plus. Page security informationfrom the bundled generation was incorrectly being applied to any other generation theuser tried to open.

7076 Page breaks in text reports were not being interpreted properly when captured using thetext-only parser. One symptom of this was that the last page of a captured report couldnot be printed.

7085 After upgrading the Oracle database to 10.2.0.3, the connection between Vista Plus andOracle was being dropped frequently. This resulted in users being unable to log in.

7096 On IBM AIX servers, remote print requests caused error messages in server.debug.logandin the client (Web View or Windows Client), even though the print job completedsuccessfully.

7102 Adds path information to a verbose server.debug.logmessage if a generation file cannot beopened.

7111 Deleting generations created unneeded PAGE_ACCESS tables in the Vista Plus database.

7141 Adds an option to draw pattern objects before other objects when displaying in normalmode in Web View. This improves the display accuracy of some reports.

7155 Adds the %T parameter to be used to include the generation description in remote printcommands

7156 Upgrading from Vista Plus 5.1.2 to Vista Plus 5.4 or 5.5 caused some bounding boxcapture rules to stop working

7171 Default on-demand migration rule set was not being properly cleared from warehouseconfiguration after VMIdentify was run.

7180 Vista Plus could not connect to an Oracle 10g database after installation on an HP-UX 11iserver.

7204 Fixes small problems remote printing entire reports in certain situations.

7213 In certain situations, running VMIdentify caused a core file.

7267 rcapturesometimes indicated a capture was successful (there was no error code) eventhough it failed.

7271 Updates Vista Plus to use a newer Data Direct ODBC driver which supports Oracle 10gR2(10.2.03 and 10.2.04).

7280 Adds support for using Web View in Internet Explorer 7.0.

7307 Adds the generation ID to the message displayed after a successful rcapturecommand.

7383 Adds a web.xml setting to include empty reports by default in Web View report lists.

7384 In Web View, users with Distributepermission for a report were being allowed to modifytheir column settings and save the new settings. Only users withModifyor Deletepermissions for a report are supposed to be able to save column settings.

SAR Description


17/40





Page 17

7388 Improves support for the Windows Admin Client on Windows Vista.7420 Improves performance when capturing generations of reports with a very large number

of generations (30,000 or more).

7451 Improves the performance of the load_indexutility when doing bulk migration ofindexes and there are blank lines in the source data.

7452 When using auto-recognition of file types, the PC Capture tools were looking for thespecial.cfgfile in the wrong location, and therefore were not recognizing file extensionsthat should be captured as TransVue files.

7507 Remote printing was failing in some instances when used with certain securityconfigurations on a UNIX server.

7521 Certain graphics in captured PostScript reports were not displaying properly.

7546 VMIdentifywas creating a core file when run on IBM AIX 5.3.

7587 Improves generation search performance when the report has a large number ofgenerations. This fix adds two new parameters to the server.cfgfile, DelayGenFilterandMatchIndexValueFirst .

7596 When performing a text search in Web View, the Show Match Listoption did not alwaysshow a list of matches.

SAR Description


18/40

Known Issues




Page 18

Known Issues

The issues described below are in addition to the known issues listed in the Vista Plus 5.5Release Notes.

Multiple concurrent captures: Vista Plus supports concurrent capturing of multiplefiles. However, capturing more than four files at once can cause the captures to failwith database errors. If you encounter this problem, we recommend you limit thenumber of concurrent file captures. If you use Vista Plus Output Manager to send filesto Vista Plus, you can use Output Managers MaxJobSetting parameter to limit thenumber of concurrent jobs.

Web View download columns: There are two issues when creating and editingdownload columns in Web View:

After the change for issue 1416 (see page 12), all users should be able to savedownload columns for their own use. However, while the columns created by

clicking Create Columnsare saved, any edits made to the column definitions aresaved only for users with Modify or Delete permission.

If you change columns while the column editing pane is shown (bySHIFT+clicking a different column heading), the column editing pane correctlyswitches to show information for the newly selected column, but the old columnremains highlighted in the generation window. Any changes you make areapplied to the newly selected column.

Correction to the Documentation

Web View help file: The Web View help file has not been updated for the change inissue 1416 (see page 12). It still says that only users with Modify or Delete permission

for a report can save column definitions for their own use.


19/40

Update Instructions




Page 19

Update Instructions

Vista Plus 5.5.2 is a Service Pack (SP). It does not include all server and client files. You caninstall version 5.5.2 only as an upgrade to an existing Vista Plus 5.5.0 or 5.5.1 installation.The procedures for updating the Vista Plus server host are slightly different depending onwhether you are updating from version 5.5.0 or 5.5.1. In addition, there are specialinstructions if you are installing 5.5.2 as a new installation on a server host which usessoftware that is not supported by Vista Plus 5.5.0. As you follow the procedures below, besure to perform only those steps which apply to your upgrade path and configuration.

Warning Before upgrading, contact Vista Plus Technical Support to discuss yourupgrade plan. Do not attempt to upgrade your Vista Plus server softwarewithout contacting technical support!If you have downloaded, installed, orreceived any patches or updates to the Vista Plus software after April 12,2011, be sure to ask technical support if your patches are included in thisrelease. Patches created afterApril 12, 2011, are not included in Vista Plus5.5.2.

Warning Open Text Corporation assumes no responsibility for data loss resulting fromfailure to contact technical support before upgrading or from failure to followtheir upgrade instructions, including failure to perform a full backup of allVista Plus information before the upgrade.

Before the Upgrade: Online to Online Migration

Note Follow this procedure only if you are upgrading from an existing Vista Plus5.5.0 host. Skip this section if you are upgrading from version 5.5.1 to 5.5.2, orif you installed 5.5.0 on a new host only as a step toward installing 5.5.2.

Even though it was not supported in any version before 5.5.1, some users migrated report

generations from one online volume to another online volume. This appeared to work,but actually wrote the generation to the online volume as if it was offline. (The filestructure of an offline volume is different than an online one.)

If you have migrated generations from one online volume to another, and you areupgrading from 5.5.0 to 5.5.2, you mustrestore all of these migrated generations back totheir original capture volume before you upgrade. If you do not, you will have problemsaccessing those generations, and possibly other generations of the same report.

To find the affected generations, look in the root directory of any online volume you usedas a destination. Any generation migrated to that volume will have a compressed file (a.zipfile on Windows or a .tar.Zfile on UNIX) in that directory. The name of the file is theID of the migrated generation.

When you restore the generations, you must use apermanentrestore. A temporary restorewill not avert the problem. You set the restore method on the Restore page of thewarehouse parameters dialog box, as described in the Vista Plus Server AdministrationGuide. After restoring the affected generations, you can return this parameter to yourpreferred setting.


20/40

Update Instructions




Page 20

Update Overview

Updating to Vista Plus 5.5.2 involves a combination of the following procedures. You willnot need to perform all of these procedures; there is no upgrade path that requires themall. Perform only the procedures which apply to your Vista Plus installation.

1. If you are installing Vista Plus 5.5.2 on a server host with no previous version of VistaPlus, download and install Vista Plus 5.5.0. If the server host uses software which isnot supported with Vista Plus 5.5.0, this requires an updated installation program, asdescribed below, and, if you are using an Oracle database, updated ODBC drivers.

2. Download the Vista Plus 5.5.2 files from the Knowledge Center.

3. Install the updated Vista Plus 5.5.2 server files.

4. If Vista Plus uses an Oracle database, install the updated ODBC drivers.

5. If you are updating from Vista Plus 5.5.0, run a script to update the Vista Plus

database schema.

6. If desired, run one or more of the optional post-installation procedures. Theseprocedures can improve Vista Plus performance and avoid errors in some situations.

7. Upgrade any Vista Plus remote hosts.

8. Upgrade the Vista Plus clients: the Server Admin Client, Web View, and the WindowsClient.

The following sections describe each of these procedures in detail. Again, be sure toperform only those procedure which apply to your Vista Plus installation.

Note Important! Vista Plus 5.5.2 is supported with operating system and databaseversions that are not supported with Vista Plus 5.5.0 or 5.5.1: the IBM AIX 6.1and HP-UX 11iv3 operating systems and the Oracle 11g and 11gR2 databases.If you want to upgrade your operating system or database to one of theseversions, we stronglyrecommend you upgrade Vista Plus to 5.5.2 firstfollowing the procedures in this document, then perform the operatingsystem or database upgrade.

Installing Version 5.5.0 on a New Vista Plus Host

Vista Plus 5.5.2 is a Service Pack (SP) release. It can only be installed on a host whichalready has Vista Plus 5.5.0 or 5.5.1 installed and working. Therefore, to install version5.5.2 on a new server host, you must first install Vista Plus 5.5.0, then update to 5.5.2.

In most cases, you simply follow the installation instructions for version 5.5.0 in the latestversion of the Vista Plus Server Installation Guide, then update to version 5.5.2 following the

instructions for upgrading from version 5.5.0. However, Vista Plus 5.5.2 is supported with


21/40

Update Instructions




Page 21

some operating system and database versions that are not supported with Vista Plus 5.5.0.If you want to install 5.5.2 in either of these conditions:

On a server host running the IBM AIX 6.1 or HP-UX 11iv3 operating system

On any UNIX server host and using an Oracle 11g or 11gR2 database, either on theserver host or a separate database host

Then you must follow the instructions below to install version 5.5.0 before upgrading to5.5.2.

Note If you want to use an Oracle 11g or 11gR2 database with a Vista PlusWindows server host, there are no special procedures to follow. Install VistaPlus 5.5.0 following the procedures in the Vista Plus Server Installation Guide,then perform all the procedures to update to version 5.5.2 from version 5.5.0.

Installing Vista Plus 5.5.0 with IBM AIX 6.1, HP-UX 11iv3, or Oracle 11g

To install Vista Plus 5.5.2 on a host which does not already have Vista Plus installed, youmust first install version 5.5.0, then update it to 5.5.2. The original installation script forVista Plus 5.5.0 will not work on a computer running IBM AIX 6.1 or HP-UX 11iv3, or onany UNIX host using an Oracle 11g or 11gR2 database, because these software versions arenot supported with version 5.5.0. There is an updated installation script for version 5.5.0which enables you to install it with these software versions. Follow these steps to installVista Plus 5.5.0 in these conditions:

1. Download the Vista Plus 5.5.0 release files for your operating system from theOpenText Knowledge Center. Create the Vista Plus installation directory and unpackthe installation files into it, as described in the Installation Guide, but do not performthe installation yet.

2. From the Knowledge Center 5.5.2 Server/UNIX/Install folder, download the files

installand setup_IPD(they dont have an extension). Copy them to the Vista Plus 5.5.0release directory, replacing the existing installation script.

3. If you will be using an Oracle database (11g or another supported version) with VistaPlus, download the updated ODBC driver file for your operating system from the5.5.2 Third Party Software/ODBC Drivers/Unixfolder of the Knowledge Center. Copy itto the ThirdPartySoftware/DataDirect/unixdirectory of the Vista Plus 5.5.0 releasedirectory.

4. Install version 5.5.0 as described in the Vista Plus Server Installation Guide.

5. Check the ddc_odbc/odbc.inifile to make sure it has all the necessary entries. Thestatements to check for are described in step 6on page 26. Make any needed changesand save the file. Be sure to make the proper changes for your host operating system.

While this procedure allows you to install Vista Plus 5.5.0, using it in these conditions isnot supported. You should immediately follow the procedures in the rest of this documentto upgrade to Vista Plus 5.5.2. Perform only those procedures which apply to a newinstallation of 5.5.2.


22/40

Update Instructions




Page 22

Downloading the 5.5.2 Files

Download the installation files for the 5.5.2 SP from the Vista Plus section of the OpenTextKnowledge Center. You must do this in all upgrade situations. To download the files:

1. Log in to the OpenText Knowledge Center: https://knowledge.opentext.com.

2. Go to the Vista Plus product section and navigate to the 5.5.2 Service Pack.

3. Download the files needed for your environment, as shown in the section below foryour host operating system.

UNIX Host

After downloading the files, copy the patch installation utility and any SQL script file orfiles to the Vista Plus home directory.

Copy the Web View file to a temporary location on the Web server.

Database Files

Either Server >UNIX > vista-patch552-nnn-yyyymmdd-OS.tar.Z

Server > UNIX > Install > patchinstall.ksh

Clients > WebView > vp_web.war

Clients > WinAdmin > setup.exe

Clients > WinClient > setup.exe

Note Download this to a different location than the Server Admin setup.exefile.

Documentation > *.pdf

Oracle Server > SQL_Scripts > Oracle_Upgrade_5.5.20.sql

Server > SQL_Scripts > Oracle_Upgrade_5.5.10.sql1

Third Party Software > ODBC Drivers > Unix > ddc_odbc-6.x-OS.tar.Z2

1.Download only if you are upgrading directly from Vista Plus 5.5.0.

2.If you just installed Vista Plus 5.5.0 as part of a new Vista Plus 5.5.2 installation with IBM AIX6.1, HP-UX 11iV3, or Oracle 11g, as described in Installing Vista Plus 5.5.0 with IBM AIX 6.1,HP-UX 11iv3, or Oracle 11g on page 21, you installed the updated drivers as part of that pro-cess, and do not need to download them again.

MySQL Server > SQL_Scripts > Oracle_Upgrade_5.5.10.sql1

Server > UNIX > post_install_script > check_db.ksh
https://knowledge.opentext.com/https://knowledge.opentext.com/


23/40

Update Instructions




Page 23

Windows Host

After downloading the files, copy the patch installation utility and any SQL script file orfiles to the Vista Plus bindirectory.

Copy the Web View file to a temporary location on the Web server.

Updating the Vista Plus Server Files

To install the 5.5.2 SP after downloading the files from the Knowledge Center, follow the

directions below for your operating system. There are separate procedures for installingthe service pack on UNIX and Windows. You must perform the procedure for youroperating system in all upgrade situations.

To Install the Service Pack on a UNIX Server Host

Warning Installing the SP stops the Vista Plus server. This disconnects all Vista Plusclients and stops any capture or migration processes that are running. Beforerunning the SP installation, make sure VMTransport is not running. If it is, donot stop it; let it complete before installing the SP.

1. Log on to the server host as root. Vista Plus does not support pseudo-root userscreated by the sudo, su, or pseudoUNIX commands. You must log on as rooteven ifVista Plus is being run as a non-root user.

2. Change to the Vista Plus home directory.

3. Make sure the installation script is executable by entering this command:

chmod +x patchinstall.ksh

Database Files

Either Server >Windows > vista-patch552n-yyyymmdd-NT.zip

Server > Windows > Install > patchinstall.exe

Clients > WebView > vp_web.war

Clients > WinAdmin > setup.exe

Clients > WinClient > setup.exe

Note Download this to a different location than the Server Admin setup.exefile.

Documentation > *.pdf

Oracle Server > SQL_Scripts > Oracle_Upgrade_5.5.20.sql

Server > SQL_Scripts > Oracle_Upgrade_5.5.10.sql1

Third Party Software > ODBC Drivers > Windows > *.zip

1.Download only if you are upgrading directly from Vista Plus 5.5.0.

MySQL Server > SQL_Scripts > Oracle_Upgrade_5.5.10.sql1

Server > Windows > post_install_script > check_db.ksh


24/40

Update Instructions




Page 24

4. If the Vista Plus home directory does not have apatchessubdirectory, run the patchinstallation utility, with no options, to create it:

./patchinstall.ksh

5. Copy the tar.Zfile for the SP to the Vista Pluspatchessubdirectory.

6. Run the patch installation utility:

./patchinstall.ksh

7. The utility asks if you want to install an SP or a specific patch. Type Pfor SP and pressEnter.

8. It then asks if you are sure you want to shut down the Vista Plus server and proceedwith the installation. To continue, type yand press Enter.

9. This displays a list of all the patch files found in thepatchessubdirectory. Type thenumber for the SP file and press Enter.

You now see various messages as the patch installation utility backs up the files it willbe replacing, then installs the new files.

10. When the SP installation finishes, a prompt asks if you want to install any specificpatches. Type nand press Enter.

You are now asked if you want to restart the Vista Plus server:

If Vista Plus uses an Oracle database and you are updating from a previous5.5.0 or 5.5.1 installation, type nand press Enter.

If Vista Plus uses a MySQL database, or you are updating a fresh installation ofVista Plus 5.5.0 on an HP-UX 11iv3 or AIX 6.1 server host, as described inInstalling Version 5.5.0 on a New Vista Plus Host on page 20, type yand pressEnter.

There is a log of the service pack installation in thepatches/logsdirectory.

To Install the Service Pack on a Windows Server Host

Warning Installing the SP stops the Vista Plus server. This disconnects all Vista Plusclients and stops any capture or migration processes that are running. Beforerunning the SP installation, make sure VMTransport is not running. If it is, donot stop it; let it complete before installing the SP.

1. Log on to the server host as an Administrative user. You must be able to move andcopy files in the Vista Plus folder tree and stop and start the Vista Plus server.

2. Open a DOS command window and change to the Vista Plus bindirectory.

3. If the Vista Plus home directory does not have apatchessubdirectory, run the patch

installation utility, with no options, to create it:

patchinstall.exe

4. Copy thezipfile for the SP to the Vista Pluspatchessubdirectory.


25/40

Update Instructions




Page 25

5. Run the patch installation utility:

patchinstall.exe

6. The utility asks if you want to install an SP or a specific patch. Type Pfor SP and pressEnter.

7. It then asks if you are sure you want to shut down the Vista Plus server and proceedwith the installation. To continue, type yand press Enter.

8. This displays a list of all the patch files found in thepatchessubdirectory. Type thenumber for the SP file and press Enter.

You now see various messages as the patch installation utility backs up the files it willbe replacing, then installs the new files.

9. When the SP installation finishes, a prompt asks if you want to install any specificpatches. Type nand press Enter.

10. You are now asked if you want to restart the Vista Plus server: If Vista Plus uses an Oracle database, type nand press Enter. Continue by

updating the ODBC drivers.

If Vista Plus uses a MySQL database, type yand press Enter. After making surethat the Vista Plus server is up and running properly, continue by updating thedatabase schema.

There is a log of the service pack installation in thepatches/logsdirectory.

Updating the ODBC Drivers for Oracle

Note Follow this procedure only if you are upgrading from an existing Vista Plushost using an Oracle database. Skip this section if Vista Plus uses MySQL, or if

you just installed Vista Plus 5.5.0 as part of a new Vista Plus 5.5.2 installationwith IBM AIX 6.1, HP-UX 11iV3, or Oracle 11g, as described page 21.

If your Vista Plus server uses an Oracle database, you need to update the ODBC driversVista Plus uses to communicate with the database. Follow the procedure below for youroperating system.

Updating the ODBC Drivers on a UNIX Host

Tip These instructions assume you are performing this procedure immediatelyafter installing the service pack. You must be logged into the Vista Plus homedirectory as rootand the Vista Plus server must be stopped.

1. Rename the ddc_odbcsubdirectory to ddc_odbc.bk.

2. Recreate the ddc_odbcsubdirectory.3. Copy the ODBC tar file you downloaded from the Knowledge Center into the new

ddc_odbcdirectory.


26/40

Update Instructions




Page 26

4. Change directory to ddc_odbc, then uncompress and untar the ODBC tar file:

cd ddc_odbcuncompress ddc_odbc-6.x-UnixOS.tar.Ztar xvf ddc_odbc-6.x-UnixOS.tar

UnixOSvaries depending on your operating system.xmay be different for differentoperating systems.

5. Copy the odbc.inifile from ddc_odbc.bkto ddc_odbc.

6. Using vior another editor, open odbc.ini. The changes you need to make depend onthe operating system you are upgrading on. For Solaris and HP-UX, make thesechange to the data source section:

In the Driverstatement, change the file name at the end from VPora21.soorVPora23toVPora.so. For example:

Driver=/VistaPlus/ddc_odbc/lib/VPora.so

Tip If your operating system is HP-UX RISC, the file extension is .sl, not .so.

Change the OracleWireProtocolstatement to read:

OracleWireProtocol=DataDirect 6.0Oracle Wire Protocol

In the Descriptionstatement, change the version number to 6.0. Forexample:

Description=DataDirect 6.0Oracle Wire Protocol

If they are not already there, add these statements to the end of the section (ifyou are upgrading from 5.5.1, they should already be present):

AuthenticationMethod=1

ConnectionRetryCount=0

ConnectionRetryDelay=3

EncryptionMethod=0GSSClient=native

HostNameInCertificate=

KeyPassword=

KeyStore=

KeyStorePassword

LoadBalancing=0

LocalTimeZoneOffset=xx:xx

LockTimeOut=-1

ValidateServerCertificate=1

WireProtocolMode=1

In LocalTimeZoneOffset,xx:xxis the correct entry for your time zone. Forexample, for Eastern Standard Time, it would be-05:00.

Add these statements after the ones in the preceding step:BulkBinaryThreshold=32

BulkCharacterThreshold=-1

BulkLoadBatchSize=1024

ConnectionReset=0


27/40

Update Instructions




Page 27

EnableBulkLoad=0

FailoverGranularity=0

FailoverMode=0FailoverPreconnect=0

FetchTSWTZasTimestamp=0

InitializationString=

LoadBalanceTimeout=0

LoginTimeout=15

MaxPoolSize=100

MinPoolSize=0

Pooling=0

QueryTimeout=0

For IBM-AIX, make these change to the data source section:

In the Driverstatement, change the file name at the end from VPora21.soorVPora23toVPora25.so. For example:

Driver=/VistaPlus/ddc_odbc/lib/VPora25.so

Change the OracleWireProtocolstatement to read:

OracleWireProtocol=DataDirect 6.1.1Oracle Wire Protocol

In the Descriptionstatement, change the version number to 6.1.1. Forexample:

Description=DataDirect 6.1.1Oracle Wire Protocol

7. Save your changes and close the file.

8. Change to the libsubdirectory and make sure all files in that directory are executable:

cd libchmod +x *.*


28/40

Update Instructions




Page 28

9. Change to the Vista Plus home directory, source the ddc_odbc.cfgfile, and run thecommand vpsql -vto test the new driver:

cd ../... ./ddc_odbc.cfg./vpsql -v

On Sun Solaris and HP-UX, the information returned should look like this:

VPSQL version 5.5.0.129


This software product and documentation is licensed subject to the

terms of the license agreement shipped with the product.

WARNING: This utility is for Open Text Corporation installation

use only

Current ODBC connection info is as follows:

ODBC Connection: DBMS is Oracle

ODBC Connection: DBMS version is 10.02.0000 Oracle 10.2.0.3.0

ODBC Connection: DSN is MyVista

ODBC Connection: ODBC Driver name isVPora24.soODBC Connection: ODBC Driver ver is 06.00.0196 (B0141, U0059)ODBC Connection: ODBC version is 03.52

On IBM-AIX, the information returned should look like this:




terms of the

license agreement shipped with the product.


use only





ODBC Connection: ODBC Driver name isVPora25.soODBC Connection: ODBC Driver ver is 06.10.0082 (B0061, U0031)ODBC Connection: ODBC version is 03.52

The highlighted sections should match exactly if the driver update was successful.Other values, including the last four digits of the ODBC driver version, will vary atdifferent installations.

10. If vpsql -vwas successful, the upgrade is complete. You can now use vista_servicetorestart the Vista Plus server.


29/40

Update Instructions




Page 29

After making sure that the Vista Plus server is up and running properly, if you areupdating from version 5.5.0, continue by updating the database schema. If you are

updating from version 5.5.1, continue with the post-installation procedures.

To Update the ODBC Drivers on a Windows Host

You need to perform this procedure only if your Vista Plus server uses an Oracle database.If it uses a MySQL database, skip this section.

Tip These instructions assume you are performing this procedure immediatelyafter installing the service pack. The Vista Plus server must be stopped.

1. In the DataDirectsubfolder of the Vista Plus server home folder, create the folderODBC60.

2. Unzip the Drivers.zipand DriverReg.zipfiles to the new ODBC60folder. Drivers.zipwillcreate a Driverssubfolder and place its files there. Make sure you know the complete

path to this folder. By default, it would be c:\Program Files\Open Text\Vista Plus\VistaPlus Server\DataDirect\ODBC60\Drivers.

3. Make sure you know the name of the data source used by Vista Plus. You can find itin the db.cfgfile in the Vista Plus home folder.

4. Unzipping DriverReg.zipcreates four registry files in the ODBC60folder. You mayneed to make changes to three of these files. Check the highlighted text in each fileand correct it as needed:

In DataSources.reg, make sure the data source name is correct:

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]

"MyOracle"="DataDirect 6.0 Oracle Wire Protocol"

In DDC60.reg, make sure the paths to the Driversdirectory are correct:

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\DataDirect 6.0

Oracle Wire Protocol]

"ConnectFunctions"="YYY"

"APILevel"="1"

"CPTimeout"="60"

"Driver"="E:\\Program Files\\Open Text\\Vista Plus\\Vista PlusServer\\DataDirect\\ODBC60\\Drivers\\vpora24.dll""DriverODBCVer"="3.52"

"FileUsage"="0"

"Setup"="E:\\Program Files\\Open Text\\Vista Plus\\Vista PlusServer\\DataDirect\\ODBC60\\Drivers\\vpora24.dll""SQLLevel"="1"

"UsageCount"="1"

InMyOracle.reg, check the path to the Driversdirectory:[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MyOracle]

"Driver"="E:\\Program Files\\Open Text\\Vista Plus\\Vista PlusServer\\DataDirect\\ODBC60\\Drivers\\vpora24.dll"


30/40

Update Instructions




Page 30

"Description"="Data Direct Oracle Wire Protocol 6.0 ODBC Driver"

The Drivers.regfile does not need any changes.

5. Execute each registration filefor example, by double-clicking it in WindowsExplorer. You can execute the files in any order, but be sure to execute all four.

6. Check the connection through Data Sources control.

7. Make sure the time zone setting for the data source is set. This value must be presentor Vista Plus will be unable to connect to the database at certain times of the day. Tocheck the time zone setting:

Open the Windows Control Panel and select Administrative Tools, DataSources (ODBC).

On the ODBC Data Source Administrator, select the data source and clickConfigure.

On the Advanced tab page, set the time zone offset to the correct value for yourlocation. For example, for Eastern Standard Time, set it to -05:00.

Save your change.

8. Open a DOS command window and change to the Vista Plus home directory. Then,execute the command vpsql -vto test the new driver:

bin\vpsql -v

The information returned should look like this:




terms of the license agreement shipped with the product.


use only





ODBC Connection: ODBC Driver name isVPora24.soODBC Connection: ODBC Driver ver is 06.00.0196(B0141, U0059)ODBC Connection: ODBC version is 03.52

The highlighted sections should match exactly if the driver update was successful.Other values will vary at different installations.

9. If vpsql -vwas successful, the upgrade is complete. Restart the Vista Plus server usingvista_service.

After making sure that the Vista Plus server is up and running properly, if you areupdating from version 5.5.0, continue by updating the database schema. If you areupdating from version 5.5.1, continue with the post-installation procedures.


31/40

Update Instructions




Page 31

To Update the Database Schema

Note Follow this procedure if you are upgrading from Vista Plus 5.5.0, includingfresh installations of Vista Plus 5.5.0 with IBM AIX 6.1, HP-UX 11iV3, orOracle 11g. Skip this section if you are upgrading from version 5.5.1.

If you are upgrading from version 5.5.0, after installing the 5.5.2 software and, if you usean Oracle database, updating the ODBC drivers, you need to run the provided SQL scriptto update the Vista Plus database schema. Follow the instructions below for youroperating system and database.

You can perform this procedure while the Vista Plus server is running, as all it does is addindexes to existing tables.

To update the schema on UNIX

Type the appropriate command for your database:

For MySQL:/opt/mysql/bin/mysql --user=root--password=passworddatabase

vista release 5

Documents