GoldMine Web (GMWEB) - Opening Opportunities in GoldMine Web results in error: Server Error: An error has occurred on the server. Please contact your system administrator. - with no customization at all or not known offending customization for Opportunit

Version 1

    Details

    GoldMine Web (GMWEB) - Opening Opportunities in GoldMine Web results in error: Server Error: An error has occurred on the server. Please contact your system administrator. - with no customization at all or not known offending customization for Opportunities and Projects

    [PRE-REQUISITES]
    - GMConnect installed and functional
    - have several opportunities



    [STEPS TO REPRODUCE]

    1. Restart IIS
    2. Log into GoldMine Web
    3. Open the OPPORTUNITY page
    >> RESULT:
    Server Error: An error has occurred on the server. Please contact your system administrator.
    the related GMConnect and GMWEB log files do not log the error


    [PRE-INVESTIGATION]
    - due to related Knowledge Articles
    a. # 18539 - GoldMine Web (GMWEB) - Opening Opportunities in GoldMine Web results in error: Server Error: An error has occurred on the server. Please contact your system administrator. - when using labels for Opportunity and Project Management
    b. # 18540 - GoldMine Web (GMWEB) - Opening Opportunities in GoldMine Web results in error: Server Error: An error has occurred on the server. Please contact your system administrator. - When adding a user defined field in Opportunity Manager containing any parts of the field name as existing default field names
    the customization of the Opportunity and Project Management has been already reviewed and it does not seem to match any known behavior









    Resolution

    [CAUSE]
    - This behavior as described above  relates to a corruption, hidden or undefined issue of the responsible TABLEDEF table where the Labels and User defined fields definition for the Opportunity and/or Project Management reside
    - it is absolutely recommended first to upgrade to GoldMine Connect version 2015.1.0.380 (Hot fix 3) or higher in order to address potential 2 identified known issues for the Opportunities in GoldMine Web (RM issue 230676 - GMWEB - when using labels for Opportunity  and Project Management, opening GoldMine Web Opportunities results in  error: Server Error: An error has occurred on the server. Please contact  your system administrator. and RM issue 230665 - GMWEB - When adding a user defined  field in Opportunity Manager containing any value for existing default  field names like STATUS, STAGE, SOURCE opening GoldMine Web  Opportunities results in error: Server Error: An error has occurred on  the server. Please contact your system administrator.)

    Important information:
    - please make sure to review also the related Knowledge Articles
    a. # 18539  :  GoldMine Web (GMWEB) - Opening Opportunities in GoldMine Web results  in error: Server Error: An error has occurred on the server. Please  contact your system administrator. - when using labels for Opportunity  and Project Management
    b. # 18540 - GoldMine Web (GMWEB) - Opening Opportunities in GoldMine Web results in error: Server Error: An error has occurred on the server. Please contact your system administrator. - When adding a user defined field in Opportunity Manager containing any parts of the field name as existing default field names as this or also the other articles may need to be considered to resolve the experienced behavior


    [RESOLUTION]
    A. Upgrade GoldMine Connect to version 2015.1.0.380 (Hot fix 3 or higher)
    >> it is only necessary to  upgrade GoldMine Connect and not necessarily GoldMine Premium  Edition - see related Knowledge Article # 17021 -  Generic questions about Hot fixes and any new versions of  GoldMine Premium Edition (GMPE and GMConnect) - is it necessary to apply  every month?  Is it necessary to upgrade always both applications? Is  it necessary to uninstall and reinstall both applications?

    B. Re-set the Customization for Opportunity and also Project Management via the GoldMine Premium Edition interface
    1. Log in with master rights
    2. Go To >> Opportunities
    3. Button Customize
    4. Tab Labels
    5. Document current settings with a screenshot if any customization are used
    6. Click into New Label for the Manager field (this highlights the field)


    7. Press F2 (this marks the content)


    8. Press the Del key (this deletes the current content)


    9. Press the Tab key (this moves to the next label - Code and already marks the content)


    10. Press the Del key (this deletes the current content)
    11. Press the Tab key (this moves to the next label - Status and already marks the content)
    12. Repeat steps 9. - 10. for all all remaining labels
    13. Button OK 
    14. Go To >> Projects
    15. Button Customize
    16. Tab Labels
    17. Document current settings with a screenshot if any customization are used
    18. Click into New Label for the Manager field (this highlights the field)
    19. Press F2 (this marks the content)
    20. Press the Del key (this deletes the current content)
    21. Press the Tab key (this moves to the next label - Code and already marks the content)
    22. Press the Del key (this deletes the current content)
    23. Press the Tab key (this moves to the next label - Status and already marks the content)
    24. Repeat steps 20. - 21. for all all remaining labels
    25. Button OK
    26. Restart IIS
    27. Verify the Opportunities page in GoldMine Web again

    28. If applicable apply the documented customization again for Opportunity Management (from step 5.)
    29. Button OK
    30. Restart IIS
    31. Verify the Opportunities page in GoldMine Web again
    32. If applicable apply the documented customization again for Project Management (from step 17.)
    33. Button OK
    34. Restart IIS
    35. Verify the Opportunities page in GoldMine Web again