function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Gregory Smith 10Gregory Smith 10 

Column Queries that Hang -- How to get SFDC to pay attention?

I have discovered a custom object on a customer's instance where:
  • SELECT column_name FROM Visit__c
returns an UNEXPECTED_EXCEPTION error for 8 of the columns in the table. All of the columns are forumula/checkbox columns types. In SOQL workbench, the queries also return an unexpected error type message. My question: The customer has basic support BUT in this case the problem appears to be with the Salesforce back-end. Since there is not work-around what steps will get Salesforce's attention?

How did we reduce this to a simple case? The problem started out with CopyStorm throwing an exception when trying to extract data from the table. Using a debug switch, we extracted the problem SELECT statement. Then we wrote a tiny Python script using the SQLForce module and let a program find the problem columns.  Then we verified the issue using Salesforce's workbench. Elapsed time: 15 minutes.
Gregory Smith 10Gregory Smith 10
The client verified that the same columns cause the report writer to hang in the standard SFDC GUI.