Modifying or updating views, multiviews, or distributors causes these objects to get deleted.

Affected Products

Dr.Sum EA (All Editions)

• Ver. 4.2.00.0000 to 4.2.00.0006
• Ver. 4.1.00.0000 to 4.1.00.0012
• Ver. 4.0.01.0000 to 4.0.01.0014

Defect Information

Defect Details
Modifying or updating views, multiviews, or distributors while the table they are referencing is in exclusive lock mode may cause these objects to get deleted. More specifically, the issue occurs when performing the following operations:

• For Enterprise Manager
  - Update the view: Right-click on the view, and clicke "Update" from the pop-up menu
  - Changing the settings: Clicking OK from the view property screen
  - Update the multiview: Right-click on the multiview, and click "Update" from the pop-up menu
  - Changing the settings: Clicking OK from the multiview property screen
  - Update the distributor: Right-click on the distributor, and click "Update" from the pop-up menu
  - Changing the settings: Clicking OK from the distributor property screen
• SQL Command
  - ALTER VIEW
  - ALTER MULTIVIEW
  - ALTER DISTRIBUTOR

How to Reproduce the Issue
The bug occurs when the the table, referenced by either a view, multiview, or distributor, is:

• updating itself by importing data
• referenced by a merge index, and the table pointing to that merge index is being updated either by
  importing data, write operations (Bulkinsert) from Dr.Sum EA Connect, or a new table is being added.

Preventing/Avoiding the Issue
Apply the necessary patches to fix this issue.
The only other work around is to avoid the conditions stated above.

Recovery Options
There is no way to recover the deleted objects. You need to recreate the deleted view, multiview, or distributor.

Additional Information
This issue may occur in cases other than those mentioned above, such as when a file update fails for whatever reason. Make sure that file access and DB update operations do not overlap with each other.
Note: This issue may occur on other versions of the software.

How to Fix The Issue
Apply the following patches:

• Dr.Sum EA Ver.4.2.00.0007
• Dr.Sum EA Ver.4.1.00.0013
• Dr.Sum EA Ver.4.0.01.0015

To receive a copy of the patches, please contact our support centre. Click here for instructions on how to do so.