Server Error. Get Local Exclude String error GoldMine.Models.ApplicationExceptions.ClientInformationException: Get Local Exclude string error, System.InvalidOperationException: Sequence contains more than one element

Version 1

    Details

    (GMWeb) Server Error. Get Local Exclude String error
    GoldMine.Models.ApplicationExceptions.ClientInformationException: Get Local Exclude string error,
    System.InvalidOperationException: Sequence contains more than one element


    Resolution

    [CAUSE]
    - GoldMine Web (same as GoldMine Mobile) needs to verify if any screens need to 'excluded'. This information is stored in the CONTSUPP table's system record (ACCOUNTNO = 90CF-SYSTEM-REC) in the field NOTES (for example:{ExcludeViews:.v100002})

    - Therefore Within 1 GoldMine Contact Set only 1 system record should be available and GoldMine Web requires that only 1 row is within the Contact Set and the error occurs when there are more than 1 system records available.

    - It cannot be determined why a GoldMine system may have more than 1 system record, but this needs to be cleaned up by a GoldMine Administrator or the Microsoft SQL DBA


    [STEPS TO RESOLVE]

    -   Make sure to have a full running backup of the GoldMine database

    1. Stop IIS on the GoldMine Web server
    2. Open SQL Management Studio
    3. Via the New Query button > Run the following query against the GoldMine database or specific Contact Set database:

    SELECT * FROM CONTSUPP WHERE ACCOUNTNO = '90CF-SYSTEM-REC' ORDER BY RECID DESC



    4. Keep the oldest entry (with the lowest RECID) and delete any duplicates
    5. Start IIS again on the GoldMine Web server
    6. Verify the behavior again in the GoldMine Web Client.




    Note: It is recommended to verify also all remote sites or undocked machines if there are duplicate “90CF-SYSTEM-REC” records





    NOTE: We found 5 entries in the CONTSUPP table for this user's database
    - Also advised running other SQL health check queries and fix the data issues