GoldMine Web (GMWEB) - Error, Run SQLcollation statements error when logging into GoldMine Web - Log file states: Cannot find configuration in 'GoldMine'/'CommonDir' in GMBase file Error code: 32

Version 1

    Details

    [STEPS TO REPRODUCE]
    1. Log into GoldMine Web client

    [RESULT:]
    a. on screen on the client side: Error, Run SQLcollation statements error




    b. The GMConnect.log shows the following error:

    2015-03-31 11:44:14,736 - [INFO] Thread id[5] - Validating user:patricks
    2015-03-31 11:44:14,801 - [ERROR] Thread id[8] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Cannot find configuration in 'GoldMine'/'CommonDir' in GMBase file Error code: 32
    2015-03-31 11:44:14,801 - [ERROR] Thread id[8] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Cannot find configuration in 'GoldMine'/'CommonDir' in GMBase file,
    GoldMine.Models.ApplicationExceptions.ClientInformationException: Cannot find configuration in 'GoldMine'/'CommonDir' in GMBase file
       at GoldMine.Models.ConfigurationModels.UserConfiguration.GetUserBaseInfo()
       at GoldMine.Models.ConfigurationModels.UserConfiguration.GetDataBaseInfo(ConnectionType connectionType)
    2015-03-31 11:44:14,830 - [ERROR] Thread id[8] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.,
    GoldMine.Models.ApplicationExceptions.ClientInformationException: Cannot find configuration in 'GoldMine'/'CommonDir' in GMBase file
       at GoldMine.Models.Log.GMLoggerFactory.GMLogger.ErrorClientAndServer(Object customMessage, Exception e)
       at GoldMine.Models.ConfigurationModels.UserConfiguration.GetDataBaseInfo(ConnectionType connectionType)
       at GoldMine.Models.DatabaseConnections.Database.ReplaceOwner(String sSQL)
       at GoldMine.Models.GoldMineAPI.GoldMineAPIEntry.DatabaseRebuildDependency.SetSqlDependency()
    2015-03-31 11:44:14,830 - [ERROR] Thread id[8] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.,
    GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.
       at GoldMine.Models.Log.GMLoggerFactory.GMLogger.ErrorClientAndServer(Object customMessage, Exception e)
       at GoldMine.Models.GoldMineAPI.GoldMineAPIEntry.DatabaseRebuildDependency.SetSqlDependency()
       at GoldMine.Models.GoldMineAPI.GoldMineAPIEntry.Load(String userName, String password, Boolean isWeb)
    2015-03-31 11:44:14,830 - [INFO] Thread id[5] - user:  signed out
    2015-03-31 11:44:14,830 - [ERROR] Thread id[5] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.,
    GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.
       at GoldMine.Models.Log.GMLoggerFactory.GMLogger.ErrorClientAndServer(Object customMessage, Exception e)
       at GoldMine.Models.GoldMineAPI.GoldMineAPIEntry.Load(String userName, String password, Boolean isWeb)
       at GoldMineMobile.Controllers.AccountController.<>c__DisplayClass8.<LogOnEncripted>b__5()


    c. or the  the GMConnect.log may show the following alternative error:

    2015-03-31 12:11:00,658 - [INFO] Thread id[8] - Validating user:patricks
    2015-03-31 12:11:02,038 - [ERROR] Thread id[5] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Cannot find section in alias file for Large Demo Error code: 32
    2015-03-31 12:11:02,038 - [ERROR] Thread id[5] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Cannot find section in alias file for Large Demo,
    GoldMine.Models.ApplicationExceptions.ClientInformationException: Cannot find section in alias file for Large Demo
       at GoldMine.Models.ConfigurationModels.GMConfiguration.GetDBAliasInfo(String aliasName)
       at GoldMine.Models.ConfigurationModels.UserConfiguration.GetUserBaseInfo()
       at GoldMine.Models.ConfigurationModels.UserConfiguration.GetDataBaseInfo(ConnectionType connectionType)
    2015-03-31 12:11:02,100 - [ERROR] Thread id[5] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.,
    GoldMine.Models.ApplicationExceptions.ClientInformationException: Cannot find section in alias file for Large Demo
       at GoldMine.Models.Log.GMLoggerFactory.GMLogger.ErrorClientAndServer(Object customMessage, Exception e)
       at GoldMine.Models.ConfigurationModels.UserConfiguration.GetDataBaseInfo(ConnectionType connectionType)
       at GoldMine.Models.DatabaseConnections.Database.ReplaceOwner(String sSQL)
       at GoldMine.Models.GoldMineAPI.GoldMineAPIEntry.DatabaseRebuildDependency.SetSqlDependency()
    2015-03-31 12:11:02,100 - [ERROR] Thread id[5] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.,
    GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.
       at GoldMine.Models.Log.GMLoggerFactory.GMLogger.ErrorClientAndServer(Object customMessage, Exception e)
       at GoldMine.Models.GoldMineAPI.GoldMineAPIEntry.DatabaseRebuildDependency.SetSqlDependency()
       at GoldMine.Models.GoldMineAPI.GoldMineAPIEntry.Load(String userName, String password, Boolean isWeb)
    2015-03-31 12:11:02,100 - [INFO] Thread id[8] - user:  signed out
    2015-03-31 12:11:02,100 - [ERROR] Thread id[8] - GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.,
    GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, Run SQLcollation statements error.
       at GoldMine.Models.Log.GMLoggerFactory.GMLogger.ErrorClientAndServer(Object customMessage, Exception e)
       at GoldMine.Models.GoldMineAPI.GoldMineAPIEntry.Load(String userName, String password, Boolean isWeb)
       at GoldMineMobile.Controllers.AccountController.<>c__DisplayClass8.<LogOnEncripted>b__5()


    Resolution

    [RESOLUTION]
    It is highly recommended to verify the GM.INI and also the USER.INI although usually the GMConnect.Log (b.) rather refers to the GM.INI while GMConnect.Log (c.) rather refers to the specific USER.INI.

    1. On the application server's GoldMine share
    2. Browse to the shared GM.INI (usually the one residing in same folder as the LicenseGM94.bin)
    3. Open the shared GM.INI with Notepad
    4. Verify that a COMMONDIR entry is available in the section [GoldMine] and has a valid entry

    for example:

    [GoldMine]
    GoldDir=LargeDemo:
    Commondir=LargeDemo:              
    SysDir=\\w12r2\programdata\GoldMine\

    5. If applicable save any changes
    6. Browse to the specific USER.INI (for example; MASTER.INI or in the above scenario PATRICKS.INI)
    7. Open the USER.INI with Notepad
    8. Verify that a COMMONDIR entry is available in the section [GoldMine] and has a valid entry

    for example:
    [GoldMine]

    MenuVer=2014.2.0.822
    ShowTaskbar=0
    OrgChartLastPos=510
    COMMONDIR=LargeDemo:
     

    9. If applicable save any changes
    10. Verify again by log into GoldMine Web client as the specific user
     
    [Additional Note:]
    - When the GM.INI entry is invalid or missing also the following message will appear when starting GoldMine Premium Edition