Excel Services Application user-defined function exception - Event 6467 (SharePoint Server 2010)

  • Article

 

Applies to: SharePoint Server 2010

Alert Name:   Excel Services Application user-defined function exception

Event ID:   6467

Summary:   A user-defined function has thrown an exception. User-defined functions are custom code assemblies that are deployed to the back-end server for Excel Services Application and are called from an Excel Services Application front-end application. Workbooks that require this user-defined function might not calculate properly. The user-defined function might have to be fixed and redeployed to the server.

Symptoms:   One or more of the following symptoms might appear:

  • Workbooks that use this user-defined function do not calculate correctly and might display errors in the spreadsheet.

  • This event appears in the event log: Event ID: 6467 Description: An exception occurred in a user-defined function. Assembly=<name and path of the assembly>, class= <class that threw exception>, function name=< name of function>, exception text=<exception message>

Cause:   The user-defined function code has encountered an error condition from which it cannot recover.

Resolution:   Correct the user-defined function code

  • This error occurs when a user-defined function often throws exceptions. User-defined functions are not Excel Services Application product code. Use the following steps to find the location of the deployed assembly.

    To correct the user-defined function:

    1. Consult with the developer of the user-defined function about deployment of more robust error handling for the function.

    2. Deploy the updated user-defined function. Ask the developer of the user-defined function to save the new user-defined function assembly to the server global assembly cache (GAC) or file share, depending on how the assembly was deployed initially.

    To find the location of the assembly:

    1. On the SharePoint Central Administration Web site, in the Application Management section, click Manage service applications.

    2. In the Name column, click the name of the Excel Services Application application. In the Type column Excel Services Application applications are of type Excel Services Application Web Service Application.

    3. On the Manage Excel Services Application page, click User Defined Function Assemblies.

    4. In the Assembly column, click the user-defined function that you plan to redeploy.

    5. In the Assembly details section, the Assembly text box shows the path to the assembly, or only its strong name if the user-defined function is installed to the global assembly cache (GAC), under <root>\windows\assembly. Note that the Assembly Location option indicates whether the assembly is in the global assembly cache or is a file path.