Instant error message - Server Error - An error has occurred on the server. Please contact your system administrator. - when accessing GoldMine Web (GMWEB) after upgrading/installing to GoldMine Connect 2015.2 GA

Version 1

    Details

    After upgrading to GMConnect 2015.2 GA - Server  Error - An error has occurred on the server. Please contact your system  administrator.  when accessing GoldMine Web (GMWEB) due to a missing  Record Type 'Other'

    [PRE-REQUISITES]

    - Having a installation where there is no Record Type 'Other' available in the Record Type Administration Center
    verify via
    1. Log on with master rights
    2. Tools > Configure > Record Types
    3. Expand the Record Types
    a. There is no record Type 'Other'
    b. rename the record type 'Other' for example to 'Other123'
    4. If applicable save/apply changes




    - Have GoldMine Connect 2015.2 GA (gmconnect-2015.2.0.326) installed and correctly configured


    [STEPS TO REPRODUCE]


    1. Browse to the GoldMine Web page
    2. Log in as any user (regardless with or without master rights)

    [RESULT]

    - After logging in instantly an error appears on screen  Server Error -  An error has occurred on the server. Please contact your system  administrator.



    - The related GMConnect.log file shows nothing by default or even when set to ALL in the logging options:

    +++ with Log level set to INFO as it is set by default +++
    2015-11-24 10:06:36,502 - [INFO] Thread id[10] - Loaded Mobile Settings: Retrieval Interval(15) UseAutoEmail(True)
    2015-11-24 10:10:22,230 - [INFO] Thread id[14] - Validating user:patricks
    2015-11-24 10:10:27,638 - [INFO] Thread id[14] - user: patricks signed in
    2015-11-24 10:10:38,057 - [INFO] Thread id[14] - fire AutoLinkEMail: USER(PATRICKS) TIME(last_check:)
    2015-11-24 10:10:38,057 - [INFO] Thread id[14] - Start to auto-retrieve and auto-linking emails for USER:PATRICKS
    2015-11-24 10:10:38,613 - [INFO] Thread id[14] - Auto-retrieve and auto-linking emails for USER:PATRICKS completed

    +++ with Log level set to ALL +++
    2015-11-24  10:17:01,595 - [DEBUG] Thread id[9] - SQL statements:SELECT [e].[NAME],  [e].[VAL], [e].[USERID], [e].[PARENTRECID], [e].[RECTYPE], [e].[SYNC],  [e].[recid] FROM [Environment] [e]
    WHERE [e].[NAME] = 'GmMobileSettings' AND [e].[RECTYPE] = 'G' AND [e].[USERID] = ''

    2015-11-24 10:17:01,603 - [INFO] Thread id[9] - Loaded Mobile Settings: Retrieval Interval(15) UseAutoEmail(True)
    2015-11-24  10:17:01,618 - [DEBUG] Thread id[9] - SQL statements:SELECT [e].[NAME],  [e].[VAL], [e].[USERID], [e].[PARENTRECID], [e].[RECTYPE], [e].[SYNC],  [e].[recid] FROM [Environment] [e]
    WHERE [e].[NAME] = 'GmMobileSettings' AND [e].[RECTYPE] = 'G' AND [e].[USERID] = ''

    2015-11-24  10:17:06,791 - [DEBUG] Thread id[9] - SQL statements:SELECT [e].[NAME],  [e].[VAL], [e].[USERID], [e].[PARENTRECID], [e].[RECTYPE], [e].[SYNC],  [e].[recid] FROM [Environment] [e]
    WHERE [e].[NAME] = 'clPasswordPolicy' AND [e].[RECTYPE] = 'S' AND [e].[USERID] = ''

    2015-11-24 10:17:06,791 - [INFO] Thread id[9] - Validating user:patricks
    2015-11-24  10:17:06,791 - [DEBUG] Thread id[9] - SQL statements:SELECT [e].[NAME],  [e].[VAL], [e].[USERID], [e].[PARENTRECID], [e].[RECTYPE], [e].[SYNC],  [e].[recid] FROM [Environment] [e]
    WHERE [e].[NAME] = 'GmMobileSettings' AND [e].[RECTYPE] = 'G' AND [e].[USERID] = ''

    2015-11-24  10:17:06,791 - [DEBUG] Thread id[9] - SQL statements:SELECT [e].[NAME],  [e].[VAL], [e].[USERID], [e].[PARENTRECID], [e].[RECTYPE], [e].[SYNC],  [e].[recid] FROM [Environment] [e]
    WHERE [e].[NAME] = 'CCustomizationCase' AND [e].[RECTYPE] = 'G' AND [e].[USERID] = ''

    2015-11-24  10:17:06,869 - [DEBUG] Thread id[9] - SQL statements:SELECT [e].[NAME],  [e].[VAL], [e].[USERID], [e].[PARENTRECID], [e].[RECTYPE], [e].[SYNC],  [e].[recid] FROM [Environment] [e]
    WHERE [e].[NAME] = 'CCustomizationCase' AND [e].[RECTYPE] = 'G' AND [e].[USERID] = 'PATRICKS'

    2015-11-24 10:17:07,292 - [DEBUG] Thread id[12] - SQL statements:select [RECID] FROM [dbo].[SYSLOG] WHERE [RECTYPE] = 'M'

    2015-11-24 10:17:09,160 - [DEBUG] Thread id[12] - Command:User patricks connected successfully

    2015-11-24 10:17:09,163 - [DEBUG] Thread id[12] - The loadAPI Thread is end.( USER:PATRICKS )
    2015-11-24 10:17:09,165 - [INFO] Thread id[9] - user: patricks signed in
    2015-11-24  10:17:10,698 - [DEBUG] Thread id[9] - c => (c.sName ==  value(GoldMineMobile.Controllers.RecordTypeController+<>c__DisplayClass2).data.Data.Id)
    2015-11-24  10:17:10,698 - [DEBUG] Thread id[9] - c => (c.sName ==  value(GoldMineMobile.Controllers.RecordTypeController+<>c__DisplayClass2).data.Data.Id)


    Resolution

    [CAUSE]

    This is RM # 234650

    [WORKAROUND]


    This  should be addressed in GMPE 2015.2 Hot fix 1 (please make sure to  review the Release Notes once GMPE 2015.2. Hot fix 1 is released) but  for GMPE 2015.2 GA release (GoldMine Connect 2015.2.0.326) the only  workaround is to create a Record Type called 'Other'

    1. Make sure to have a full running backup of your GoldMine database
    2. Log in with master rights
    3. Tools > Configure > Record Types
    4. Browse to Record Types and
    a. Verify if there is a record type 'Other' (there should be no 'Other' record type)
    b. If there is no record type 'Other'
    5. Right Click > New Record Type
    6. In the upcoming Window
    a. Record Type Name = Other
    b. Relationship Tree Section Name = enter any desired name OR enter Other or leave as default
    c. Select any Primary Fields View
    d. Select any Custom Screen
    e. Select any GM+View Template



    f. OK
    5. Apply Changes (5th icon on the Record Type Administration Center)



    6. IIS reset
    7. Verify the behavior in GoldMine Web




    If  you experience any further error messages - the original reported or  other ones - please make sure to provide a new screenshot and the  related Log files

    Please make sure to provide the related log  files which are located in the GoldMine Connect installation folder  along with the new submission.
    On default installations they are  located in C:\Program Files\GoldMine Connect (32-bit systems) and  C:\Program Files (x86)\GoldMine Connect (64-bit systems) >> then  the sub folder Logs.
    The minimum required log files are  GMConnect.log and the GMWeb.log in the Web folder, but it would be much  appreciated if you can provide all available log files from this folder  in compressed form via

    1. Right Click on Logs > Send to > Compressed (zipped) folder
    2. In the GoldMine Connect Folder a file Logs.zip appears which can be  attached to the submission e-mail or attached via Self Service