Loading Error: Failed to obtain activity list

Version 1

    Details

    User experiences issues in Goldmine Mobile app after upgrading Goldmine from a previous version. 
    When a user tries to view an activity list in the Goldmine Mobile the error "Failed to obtain activity list" will appear on the screen. 
     
     
     
     Error in log files:
     
     2013-10-16 11:21:25,013    Thread ID[9]    ERROR  GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, one of the arguments provided to a method is not valid. ,Object of type 'System.String' cannot be converted to type 'System.Byte[]'.

    2013-10-16 11:21:25,013    Thread ID[9]    ERROR  GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, failed to get activity list in histroy. ,Error, one of the arguments provided to a method is not valid.
    2013-10-16 11:21:36,526    Thread ID[8]    ERROR  GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, one of the arguments provided to a method is not valid. ,Object of type 'System.String' cannot be converted to type 'System.Byte[]'.
    2013-10-16 11:21:36,526    Thread ID[8]    ERROR  GoldMine.Models.ApplicationExceptions.ClientInformationException: Error, failed to get activity list in histroy. ,Error, one of the arguments provided to a method is not valid.

     


    Resolution

    This can be caused due to compatibility mode in MSSQL not set properly, because of an older Goldmine database was migrated to new MSSQL version (e.g. Moved from GM 8.x with MSSQL 2000 to GM 9.x with MSSQL 2005/2008) then upgraded to a newer version of Goldmine.  Change the compatibility mode accordingly to the MSSQL version installed (i.e. if compatibility is seen as 80 and running MSSQL 2008, then set the compatibility mode to 100 for the database).  

    The database will have to be restored prior to an upgraded version of Goldmine, then the compatibility mode set. After the compatibility mode is set correctly, an upgrade will need to be performed again. The upgrade will then update the table structure accordingly. 
     
     
    To view or change the compatibility level of a database

    1. Connect to the appropriate instance of the SQL Server Database Engine and select the server name.

    2. Expand Databases and select a user database or expand System Databases and select a system database.

    3. Right-click the database, and then click Properties.

      The Database Properties dialog box opens.

    4. In the Select a page pane, click Options.

      The current compatibility level is displayed in the Compatibility level list box.

    5. To change the compatibility level, select a different option from the list. The choices are SQL Server 2005 (90)SQL Server 2008 (100), or SQL Server 2012 (110).

      More Information, please visit: http://technet.microsoft.com/en-us/library/bb933794.aspx  Provided as-is with no warranty or support from Goldmine/FRS support.