When executing a report against several contact records an error message appears: Error in ClearReportTempTable. openCursor failed and GoldMine crashes with a Microsoft Visual C++ Runtime Library error

Version 1

    Details

    When executing a report against several contact records an error message appears: Error in ClearReportTempTable. openCursor failed and GoldMine crashes with a Microsoft Visual C++ Runtime Library error

    [STEPS TO REPRODUCE]

    1. Go To > Reports > Reports
    2. Browse to any report for example
    a. User drop down (public)
    b. GoldMine Reports > Contact Reports > Contact Wide Line Report - Landscape
    3. Right Click > Print
    4. Select All Contact Records
    5. OK

    [RESULT]



    - Often followed by the following error:




    Resolution

    [CAUSE]
    - The REPORTTEMP table is a table which gathers and sorts data for generating reports with the desired data selected in the reports options.  Older data is first deleted then the new data is populated into the table.
    - The error message states that clearing the REPORTTEMP table is not possible and the reason is usually that the REPORTTEMP table is either corrupt or not available


    [STEPS TO RESOLVE]
    1. Make sure that all users are logged out of GoldMine and all services related to GoldMine are shut down (for example. GoldSync)

    2. Make sure that all users are logged off or have closed all applications with an integration into GoldMine (for example GMME/GMWEB, Outlook, Word etc)

    3. Make sure to have a full running backup of your GoldMine database

    4. In GoldMine with master rights

    5.Tools > Databases > Maintain Database…
    6. Individual Files > Next

    7. Select REPORTTEMP table from the list > Next

    8. Select Rebuild and Pack the database files > There appears a message that SQL tables need not to be rebuilt unless a table restructure is required… > Click OK to confirm this message

    9. Select Sort the database files and Verify the data and synchronization information > Next

    10. Although there should be no user logged in anymore it might be recommended to select the Force all users to exit GoldMine with 1 minute > Next

    11. Finish

    12. Re-test the behavior


    This will recreate the REPORTTEMP table based off the data dictionary files for the current version of GoldMine installed.