Massive Data loss issues in Goldmine 6.70.50123

The following issue has been discovered in 6.70.50123 and can lead to massive or complete CAL table data loss.

It boils down to if a user completes a multi-user activity using the day calendar view or the Activity List for a day that has many calendar items then Goldmine creates a SQL query that is too general and ends up deleting too much calendar data.

Here is the specific issue logged as RM# 30822:

ISSUE_ID .... 30822
PRIORITY .... 1
SEVERITY .... 1-Critical
STATUS ...... 4-Open

SUBJECT ..... Data - Loss: Global Calendar completions
Multiple calendar records are earmarked for completion without regard to USER or RECTYPE
[BUILD]
6.70.50123, 6.70.50808
[OS]
n/a
[STEPS]
1. View Calendar, Day Tab
2. Create a 1hr Appointment for three different contacts
(e.g. Contact1 9-10, Contact2 10-11, etc.)
3. Create a 1hr Appointment for multiple users and a contact record *not* used in step 2
4. From calendar, right-click on appointment created in step 3., select complete option
5. Click OK
6. Click Yes to Alert
7. Right-click on an appointment created in step 2., select complete option
8. Click OK, Click Yes (should be in close succession)
[RESULTS]
All calendar records are completed with values from the multiple user activity.
[DISCUSSION]
Trace shows the following query:

SELECT RECID, RECTYPE, NUMBER1, CREATEBY FROM dbo.CAL (NOLOCK) WHERE RECID LIKE '%' ORDER BY RECID ASC

Same occurs when actions are performed from activity list window.

Observations:
A modal Complete window is launched when 'Complete' is the selected action from an Alarm window popup; this is not the case when 'Complete' is selected from the local menu option of the Pending Tab, Activity list or Calendar.

Development is working on a patch for 6.7 that corrects the issue.