Thread Details

 SOQL query with stadard object retur the error ERR-2147467261


Post by Igor Chtcherbakov
Joined 12/11/2018
Posted 12/12/2018 6:59 PM

Hello,

I tried to run SOQL with standard SalesFirce objects an I've got the error message below

ERR-2147467261 Object reference not set to an instance of an object. SOQL Query 3

The query is:

SELECT Id, Name, (SELECT Id, Name FROM Contacts) FROM Account

Post by Administrator
Visual Software Systems
Joined 1/01/2016
Posted 12/12/2018 7:23 PM

Hi Igor,

I was able to run this query in our org. Which version of SOQL Studio are you using?  The latest version (2018.2.270) corrected an issue very similar to this. If your are on an earlier version, please install the latest and try it again. 

Post by Administrator
Visual Software Systems
Joined 1/01/2016
Posted 12/12/2018 9:32 PM

Hi Igor,

Can you provide the steps to reproduce the error?

Post by Igor Chtcherbakov
Joined 12/11/2018
Posted 12/13/2018 8:08 PM

I just opened studio, made connection to salesforce. I can see all objects and fields. Created new file and typed in the query.

 

How to check the studio version?

Thank you

Post by Administrator
Visual Software Systems
Joined 1/01/2016
Posted 12/13/2018 8:19 PM

On the File tab, select Account and click the About button. 

Have you been able to run any queries? Can you try running this one again today?  We’ve been trying to recreate the problem but so far have not been able to. 

Post by Igor Chtcherbakov
Joined 12/11/2018
Posted 12/13/2018 8:24 PM

Thank you. The version is latest. I can run any simple query without referencing dependent object.

Post by Administrator
Visual Software Systems
Joined 1/01/2016
Posted 12/13/2018 8:28 PM

Ok. What happens when you run this same query in the Developer Console using the same logon Id you’re using in SOQL Studio?

Post by Igor Chtcherbakov
Joined 12/11/2018
Posted 12/13/2018 10:24 PM

Sorry, I start work with salesforce few days ago. My credentials not allow me to access Developer Consul ( I really do not know where it is in salesforce). That's why I need a tool to browse objects and find out how they related to each other. Eventually the task is to bring some information into SQL and build reports.

Post by Administrator
Visual Software Systems
Joined 1/01/2016
Posted 12/14/2018 6:15 PM

Hi Igor,

The Developer Console is accessed from within Salesforce.  If you are using the Lightning UI, click on the gear icon at the top right of the page.  For Classic UI, click on your Name (or Setup, if that's visible) at the top of the page.  Developer Console should be a choice from within those menus.  You could also try Workbench, which is accessed from https://workbench.developerforce.com.  I'd be curious to know if you receive any error when you try to run that relationship query and if you do, what that error is.

For now, maybe you can tell me a bit about the environment you are running in.  Which version of Windows are you using (7, 8.x, 10)?  Which Salesforce edition?  What org type are you accessing (Sandbox, Developer Edition, Production)?  Are you using a custom domain URL for the API logon? 

Log in to reply to this post.