function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Internal Server Error

Help!  Please!


I've been using the Office Toolkit version 3 for years to query information from SF into an Excel spreadsheet.  Just recently I'm seeing an error:


Microsoft Visual Basic

Run-time error '-2147467259 (80004005)':


An internal server error has occured while processing your request.



 This does not appear to be a connection issue.  The code will login the user in with no error.  it then runs a successful query to get contacts and then another query to get some information from a related table and then a query to get a list of opportunities associated with the selected contact.  Once the chosen opportunity is selected, it then attempts to get some detail about the opportunity.  That is the specific query where it bombs with this error.


The specific line of code is:


Set qr = cSFComm.Query(sQueryString, False)


This same exact specific line is the same one all of the other queries has passed through to get query results.


This particular query string is:


Select Id, OwnerId, Distributor_or_Sales_Representative__c, Purchase_Order_Num__c, Sales_Order_Number__c, Quote_Num__c, Target_Ship_Date__c, Market_Level_1_Industry__c, Market_Level_2_Application__c, Market_Level_3_Substrate__c, Market_Level_4_End_Use__c, Valve__c, Name From Opportunity Where id = '0068000000i7IwbAAE'


I tried upgrading to toolkit version 4 but get the exact same issue.


Anyone have any ideas?

Best Answer chosen by Admin (Salesforce Developers) 

Solved.  I found some of the fields I was querying had been deleted from the SF Object....