Contacts appear duplicated in GoldMine reports - Report is repeating information from the GoldMine data

Version 1

    Details

    - Contacts appear duplicated in GoldMine reports
    - When running a report the correct records  are displayed and are in the correct order but then start to repeat a  second time though the repeating entries do not seem to be in any sort  of order.  Sometimes also the order of the contacts is wrong  all-together.


    Resolution

    This issue is related to a failed report being ran, then not cleared correctly from the REPORTTEMP database table.


    1. Backup the GoldMine database
    2. Delete all rows in the REPORTTEMP table of the GoldMine database

    SELECT * FROM REPORTTEMP
    (change query to a correct Delete statement)

    3. Re-launch GoldMine
    4. Re-run the desired report