'Call was rejected by callee' using VB.Net with Excel Pivot Auto Refresh RRS feed

  • Question

  • Hi All,

    We have couple of Excel report in a shared folder and they were need to refreshed automatically to catch up the new data from the SQL database.  Few of the reports are refreshed automatically. But the one of the excel getting the below exception. Is this due to the size of the file? the one it is failing is 45MB. Other are less than 10MB.

    Environment: 2008 R2 X64.  Console app is developed using VS2012 -

    While debugging the code, the same file is refreshed. But when the exe is invoke through SQL job, this file is getting the below exception.

    The description for Event ID 0 from source Application cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event:

    System.Runtime.InteropServices.COMException (0x80010001): Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED))

       at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)

       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)

       at Microsoft.VisualBasic.CompilerServices.VBBinder.InvokeMember(String name, BindingFlags invokeAttr, Type objType, IReflect objIReflect, Object target, Object[] args, String[] namedParameters)

       at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn)

       at Microsoft.BIF.Reports.Microsoft.BIF.Reports.AutoRefresh.Main()

    the message resource is present but the message is not found in the string/message table

    Any help is appreciated.



    Madhavan Thasu Ramachandran

    Tuesday, December 11, 2012 6:32 PM