Design Corruption Patch #4555

This patch is intended for installation on top of ArcFM or Designer 9.2.0 SP3 (build 4474). This patch replaces the previously released patches #4520, #4524, #4530, and #4544.

Please note that if a patch shares DLL files with a previously-issued patch, all files from the previous patch are included, to prevent problems caused by dependencies between these files.

Functionality Included: This patch corrects several defects:

• Correction of a defect that causes the design tree to lose all geo-association under certain scenarios (see the Notes section below for details). What this means is that the GIS CUs within a design are no longer associated to a features in the map. (#4555)
• Correction of a defect where the date gets corrupted to the 12/30/1899. This affects APPROVED_DATE on MM_WMS_DESIGN and START_DATE, END_DATE on MM_WMS_WORK_REQUEST. After this date gets changed, errors occur when opening the design. (#4544)
• Removal of message boxes displayed during programmatic run of the Orphan Version Cleanup Tool. (#5430)
• Correction of a defect in the Design save functionality when the combined nodes for Work Locations and CUs in a design exceeded 1000. (#4524)
• Corrects a bug where opening designs in a particular sequence will change the state of the design's read-only lock. (#4520)

Recommended Users: Clients who use Designer side by side with Session Manager (#4555)
Clients who use Designer (#4544, #5430, #4524, #4520)

Notes: If a Design and Session have the same ID, when a session is either posted or deleted, the design with the matching ID has its row in the MM_HIDDEN_PACKAGES table deleted. The reverse is also occurring when a design is deleted, the session with the matching ID has its row in the MM_HIDDEN_PACKAGES table deleted. The MM_HIDDEN_PACKAGES table holds information about the design tree, structural analysis, and map extent.

Please note that we believe this is the source of the design corruption that we have researched with Designer users in the past. This can occur if you are using Telvent’s “out-of-the-box” Session Deleter or, in some circumstances, using a custom Session Deleter. If you have encountered this type of data loss, please contact Technical Support as there are instances when this data can be retrieved and restored.

If you are maintaining a custom PX Deleter that programmatically deletes records from the MM_Hidden_Packages table then you will need to ensure that each package is based on both Name and Category for correct identification. A list of categories is provided in the mmPackageCategory enumeration.

The following files are included in the patch and will replace existing files:

• mmDesignerAPI.dll (#4520, #4555)
• mmSessionManager.dll (#4555)
• mmWorkflowManager.dll (#4524, #5430, #4544, #4555)

Installation instructions:

1. Download the patch installer Patch_920SP3_4555.exe to any location on your desktop machine.
2. Double-click the file to launch the installation.
3. At the installer dialog, review the readme information if desired. Then click 'Install Patch'.
4. When the installer dialog displays 'Completed', click the 'Close' button.

Patch #4555 contains the following bug fixes:

• QFE40013 - Executing the SessionDeleter can cause design package records in MM_HIDDEN_PACKAGES to be deleted. (#4555)
• QFE35861 - Error reading date fields in Workflow Manager into variant type (#4544)
• QFE32907 - running IMMPxApplicationEx2_Cleanup can result in message boxes popping up. (#5430)
• QFE32595 - DBMS Query hitting a hard limit in oracle for larger designs. (#4524)
• MM32108 - Opening designs in sequence changes lock property (#4520)

Internationalization updates:
None.

For ArcGIS and ArcSDE issues, please seek assistance from ESRI Technical Support.