SOQL query causes internal Salesforce errorError selecting User.SmallProfileUrl from UserFeed query with SOQLNo such column 'AccountNumber' on entity 'Name'Internal Service Error when using not null in Geolocation SOQLSearch by '.' causes non-selective query exceptionNo records returned from SOQL query on FeedComment with Left Inner JoinSOQL error on enabling namespaceSoql outer query exceptionINVALID_FIELD on SOQL Query through REST APIWhy are the columns of the SOQL query result not in the order of the fields in the SELECT?SOQL query to extract only the most recent attachment IDs

Lock in SQL Server and Oracle

How to delegate to implementing class

Why are the 2nd/3rd singular forms of present of « potere » irregular?

Reverse the word in a string with the same order in javascript

Why is current rating for multicore cable lower than single core with the same cross section?

How to back up a running remote server?

Why the difference in metal between 銀行 and お金?

Python "triplet" dictionary?

Is it possible to measure lightning discharges as Nikola Tesla?

Can not tell colimits from limits

Is there a way to detect if the current member function is operating on an lvalue or rvalue?

Subtleties of choosing the sequence of tenses in Russian

Help, my Death Star suffers from Kessler syndrome!

Were there two appearances of Stan Lee?

Please, smoke with good manners

Will a top journal at least read my introduction?

TikZ how to make supply and demand arrows for nodes?

Examples of non trivial equivalence relations , I mean equivalence relations without the expression " same ... as" in their definition?

What does "rf" mean in "rfkill"?

How can I record the screen and the rear camera on an iPhone simultaneously?

Modify locally tikzset

Stop and Take a Breath!

Unexpected email from Yorkshire Bank

Electric guitar: why such heavy pots?



SOQL query causes internal Salesforce error


Error selecting User.SmallProfileUrl from UserFeed query with SOQLNo such column 'AccountNumber' on entity 'Name'Internal Service Error when using not null in Geolocation SOQLSearch by '.' causes non-selective query exceptionNo records returned from SOQL query on FeedComment with Left Inner JoinSOQL error on enabling namespaceSoql outer query exceptionINVALID_FIELD on SOQL Query through REST APIWhy are the columns of the SOQL query result not in the order of the fields in the SELECT?SOQL query to extract only the most recent attachment IDs






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








6















I've hit an unhandled exception when writing a query, and I'm curious if anyone here has seen the same thing. This is not a timeout issue - the error happens almost immediately, so it's not a query efficiency issue. The following query causes an "Internal Salesforce.com Error":
(Note that End_Client__c is an Account lookup on Opportunity, and accountIds is a Set<Id> of parents of both Account and End Client)



[
SELECT Name
FROM Account
WHERE Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND (
Id IN :accountIds
OR ParentId IN :accountIds
OR Parent.ParentId IN :accountIds
OR Parent.Parent.ParentId IN :accountIds
OR Parent.Parent.Parent.ParentId IN :accountIds
)
ORDER By Name
]


However, it is fixed if I reduce the number of items in the OR chain to 2, regardless of which items I select. This means the merge fields are not the issue causing the error. The following works successfully:



[
SELECT Name
FROM Account
WHERE Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND (
OR Parent.Parent.ParentId IN :accountIds
OR Parent.Parent.Parent.ParentId IN :accountIds
)
ORDER By Name
]


I was fortunately able to find a workaround, which has left me even more confused. I changed the query to less efficient logic. The query below evaluates properly, which suggests to me that the query parser is failing.



[
SELECT Name
FROM Account
WHERE (Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Id IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.Parent.ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.Parent.Parent.ParentId IN :accountIds)
ORDER By Name
]


Can anyone shed some light on what is going on here?










share|improve this question






















  • How many items are in your Set<Id>? I can't repo this with 50.

    – battery.cord
    Mar 20 at 18:51











  • Can you provide something that runs in the developer console that crashes? I'm unable to repo it on my org.

    – battery.cord
    Mar 20 at 19:00











  • @battery.cord see my answer below. The issue had to do with the accountIds set containing only the excluded opp.AccountId

    – SFDC Neuf
    Mar 20 at 19:22

















6















I've hit an unhandled exception when writing a query, and I'm curious if anyone here has seen the same thing. This is not a timeout issue - the error happens almost immediately, so it's not a query efficiency issue. The following query causes an "Internal Salesforce.com Error":
(Note that End_Client__c is an Account lookup on Opportunity, and accountIds is a Set<Id> of parents of both Account and End Client)



[
SELECT Name
FROM Account
WHERE Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND (
Id IN :accountIds
OR ParentId IN :accountIds
OR Parent.ParentId IN :accountIds
OR Parent.Parent.ParentId IN :accountIds
OR Parent.Parent.Parent.ParentId IN :accountIds
)
ORDER By Name
]


However, it is fixed if I reduce the number of items in the OR chain to 2, regardless of which items I select. This means the merge fields are not the issue causing the error. The following works successfully:



[
SELECT Name
FROM Account
WHERE Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND (
OR Parent.Parent.ParentId IN :accountIds
OR Parent.Parent.Parent.ParentId IN :accountIds
)
ORDER By Name
]


I was fortunately able to find a workaround, which has left me even more confused. I changed the query to less efficient logic. The query below evaluates properly, which suggests to me that the query parser is failing.



[
SELECT Name
FROM Account
WHERE (Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Id IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.Parent.ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.Parent.Parent.ParentId IN :accountIds)
ORDER By Name
]


Can anyone shed some light on what is going on here?










share|improve this question






















  • How many items are in your Set<Id>? I can't repo this with 50.

    – battery.cord
    Mar 20 at 18:51











  • Can you provide something that runs in the developer console that crashes? I'm unable to repo it on my org.

    – battery.cord
    Mar 20 at 19:00











  • @battery.cord see my answer below. The issue had to do with the accountIds set containing only the excluded opp.AccountId

    – SFDC Neuf
    Mar 20 at 19:22













6












6








6








I've hit an unhandled exception when writing a query, and I'm curious if anyone here has seen the same thing. This is not a timeout issue - the error happens almost immediately, so it's not a query efficiency issue. The following query causes an "Internal Salesforce.com Error":
(Note that End_Client__c is an Account lookup on Opportunity, and accountIds is a Set<Id> of parents of both Account and End Client)



[
SELECT Name
FROM Account
WHERE Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND (
Id IN :accountIds
OR ParentId IN :accountIds
OR Parent.ParentId IN :accountIds
OR Parent.Parent.ParentId IN :accountIds
OR Parent.Parent.Parent.ParentId IN :accountIds
)
ORDER By Name
]


However, it is fixed if I reduce the number of items in the OR chain to 2, regardless of which items I select. This means the merge fields are not the issue causing the error. The following works successfully:



[
SELECT Name
FROM Account
WHERE Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND (
OR Parent.Parent.ParentId IN :accountIds
OR Parent.Parent.Parent.ParentId IN :accountIds
)
ORDER By Name
]


I was fortunately able to find a workaround, which has left me even more confused. I changed the query to less efficient logic. The query below evaluates properly, which suggests to me that the query parser is failing.



[
SELECT Name
FROM Account
WHERE (Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Id IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.Parent.ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.Parent.Parent.ParentId IN :accountIds)
ORDER By Name
]


Can anyone shed some light on what is going on here?










share|improve this question














I've hit an unhandled exception when writing a query, and I'm curious if anyone here has seen the same thing. This is not a timeout issue - the error happens almost immediately, so it's not a query efficiency issue. The following query causes an "Internal Salesforce.com Error":
(Note that End_Client__c is an Account lookup on Opportunity, and accountIds is a Set<Id> of parents of both Account and End Client)



[
SELECT Name
FROM Account
WHERE Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND (
Id IN :accountIds
OR ParentId IN :accountIds
OR Parent.ParentId IN :accountIds
OR Parent.Parent.ParentId IN :accountIds
OR Parent.Parent.Parent.ParentId IN :accountIds
)
ORDER By Name
]


However, it is fixed if I reduce the number of items in the OR chain to 2, regardless of which items I select. This means the merge fields are not the issue causing the error. The following works successfully:



[
SELECT Name
FROM Account
WHERE Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND (
OR Parent.Parent.ParentId IN :accountIds
OR Parent.Parent.Parent.ParentId IN :accountIds
)
ORDER By Name
]


I was fortunately able to find a workaround, which has left me even more confused. I changed the query to less efficient logic. The query below evaluates properly, which suggests to me that the query parser is failing.



[
SELECT Name
FROM Account
WHERE (Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Id IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.Parent.ParentId IN :accountIds)
OR
(Id != :opp.AccountId
AND Id != :opp.End_Client__c
AND Parent.Parent.Parent.ParentId IN :accountIds)
ORDER By Name
]


Can anyone shed some light on what is going on here?







apex soql error






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Mar 20 at 18:36









SFDC NeufSFDC Neuf

775623




775623












  • How many items are in your Set<Id>? I can't repo this with 50.

    – battery.cord
    Mar 20 at 18:51











  • Can you provide something that runs in the developer console that crashes? I'm unable to repo it on my org.

    – battery.cord
    Mar 20 at 19:00











  • @battery.cord see my answer below. The issue had to do with the accountIds set containing only the excluded opp.AccountId

    – SFDC Neuf
    Mar 20 at 19:22

















  • How many items are in your Set<Id>? I can't repo this with 50.

    – battery.cord
    Mar 20 at 18:51











  • Can you provide something that runs in the developer console that crashes? I'm unable to repo it on my org.

    – battery.cord
    Mar 20 at 19:00











  • @battery.cord see my answer below. The issue had to do with the accountIds set containing only the excluded opp.AccountId

    – SFDC Neuf
    Mar 20 at 19:22
















How many items are in your Set<Id>? I can't repo this with 50.

– battery.cord
Mar 20 at 18:51





How many items are in your Set<Id>? I can't repo this with 50.

– battery.cord
Mar 20 at 18:51













Can you provide something that runs in the developer console that crashes? I'm unable to repo it on my org.

– battery.cord
Mar 20 at 19:00





Can you provide something that runs in the developer console that crashes? I'm unable to repo it on my org.

– battery.cord
Mar 20 at 19:00













@battery.cord see my answer below. The issue had to do with the accountIds set containing only the excluded opp.AccountId

– SFDC Neuf
Mar 20 at 19:22





@battery.cord see my answer below. The issue had to do with the accountIds set containing only the excluded opp.AccountId

– SFDC Neuf
Mar 20 at 19:22










2 Answers
2






active

oldest

votes


















5














After a bit of investigation with explicitly stated IDs, I think I found the unique issue that causes the error, and it can be handled more elegantly than my workaround.



Upon further investigation, the error is only happening when accountIds contains only opp.AccountId.



This fails:



[
SELECT Name
FROM Account
WHERE Id != '0014000000SQyVGAA1'
AND Id != null
AND (
Id IN ('0014000000SQyVGAA1')
OR ParentId IN ('0014000000SQyVGAA1')
OR Parent.ParentId IN ('0014000000SQyVGAA1')
OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
)
ORDER By Name
]


This succeeds:



[
SELECT Name
FROM Account
WHERE Id != '0014000000SQyVGAA1'
AND Id != null
AND (
ParentId IN ('0014000000SQyVGAA1')
OR Parent.ParentId IN ('0014000000SQyVGAA1')
OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
)
ORDER By Name
]


And this also succeeds:



[
SELECT Name
FROM Account
WHERE Id != '0014000000SQyVGAA1'
AND Id != null
AND (
Id IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
OR ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
OR Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
OR Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
OR Parent.Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
)
ORDER By Name
]


So the it appears the parser has a hard time dealing with the contradictory inclusion statements. I can create a second set to eliminate the issue.



One last thing - this succeeds:



[
SELECT Name
FROM Account
WHERE Id != '0014000000SQyVGAA1'
AND Id != null
AND (
Id IN ('0014000000SQyVGAA1')
OR Parent.ParentId IN ('0014000000SQyVGAA1')
)
ORDER By Name
]


But this fails:



[
SELECT Name
FROM Account
WHERE Id != '0014000000SQyVGAA1'
AND Id != null
AND (
Id IN ('0014000000SQyVGAA1')
OR ParentId IN ('0014000000SQyVGAA1')
OR Parent.ParentId IN ('0014000000SQyVGAA1')
)
ORDER By Name
]


So it appears that in order to cause the error, there needs to be both the contradictory statement and at least 2 other inclusion statements within the OR.






share|improve this answer
































    2














    Anecdotally, This query runs fine (via the developer consoles query editor) on one of my sandboxes:



    SELECT Name, ID
    FROM Account
    WHERE Id != ''
    AND Id != ''
    AND (
    Id IN ('')
    OR ParentId IN ('')
    OR Parent.ParentId IN ('')
    OR Parent.Parent.ParentId IN ('')
    OR Parent.Parent.Parent.ParentId IN ('')
    )
    ORDER By Name


    Using static id lists also works fine:



    SELECT Name, ID
    FROM Account
    WHERE Id != '001U000100qh0xJIAQ'
    AND Id != '001U000100qh0xJIAQ'
    AND (
    Id IN ('001U000000ASKzzIAH')
    OR ParentId IN ('001U000000ASKzzIAH')
    OR Parent.ParentId IN ('001U000000ASKzzIAH')
    OR Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
    OR Parent.Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
    )
    ORDER By Name


    Heres some code I used in the developer consoles execute anonymous code window:



    Id someId = '001U000100qh0xJIAQ';
    Id someOtherId = '001U000700qh0xJIAQ';

    Set<Id> accountIds = new Map<Id, Account>([SELECT Id FROM Account LIMIT 1000]).keySet();

    System.debug([
    SELECT Name
    FROM Account
    WHERE Id != :someId
    AND Id != :someOtherId
    AND (
    Id IN :accountIds
    OR ParentId IN :accountIds
    OR Parent.ParentId IN :accountIds
    OR Parent.Parent.ParentId IN :accountIds
    OR Parent.Parent.Parent.ParentId IN :accountIds
    )
    ORDER By Name
    ]);


    Even trying to look for 1000 items in 4 separate clauses I can't repo your error.




    Heres the results of running some queries on my org:



    SELECT Name
    FROM Account
    WHERE Id != '0014000000SQyVGAA1'
    AND Id != null
    AND (
    Id IN ('0014000000SQyVGAA1')
    )
    ORDER By Name



    No Results, but no crash.




    SELECT Name
    FROM Account
    WHERE Id != '0014000000SQyVGAA1'
    AND Id != null
    AND (
    Id IN ('0014000000SQyVGAA1')
    OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
    OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
    )
    ORDER By Name



    [object Object]: An unexpected error occurred. Please include this ErrorId if you contact support: 1038235189-47553 (730406045)




    SELECT Name
    FROM Account
    WHERE Id != '0014000000SQyVGAA1'
    AND Id != null
    AND (
    Id IN ('0014000000SQyVGAA1')
    OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
    )
    ORDER By Name



    No results




    SELECT Name
    FROM Account
    WHERE Id != '0014000000SQyVGAA1'
    AND Id != null
    AND (
    Id IN ('0014000000SQyVGAA1')
    OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
    )
    ORDER By Name



    No results.




    I have no idea why exactly it fails but it seems like adding that 3rd clause to the AND causes the failure. If it was just the ID != '' && Id == '' issue, I'd expect the first one to fail.






    share|improve this answer




















    • 2





      I think you meant "repro".

      – Adrian Larson
      Mar 20 at 19:07






    • 1





      Exactly my findings. Always fun to find a weird edge case where things break.

      – SFDC Neuf
      Mar 20 at 19:53






    • 2





      I dunno, the image of showing up to someone else's place of work, putting some chains around the workstation, tying it to a car, and gunning it to "repo" the error sounds like pretty good entertainment to me. :p

      – Derek F
      Mar 20 at 19:54












    Your Answer








    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "459"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f254657%2fsoql-query-causes-internal-salesforce-error%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    5














    After a bit of investigation with explicitly stated IDs, I think I found the unique issue that causes the error, and it can be handled more elegantly than my workaround.



    Upon further investigation, the error is only happening when accountIds contains only opp.AccountId.



    This fails:



    [
    SELECT Name
    FROM Account
    WHERE Id != '0014000000SQyVGAA1'
    AND Id != null
    AND (
    Id IN ('0014000000SQyVGAA1')
    OR ParentId IN ('0014000000SQyVGAA1')
    OR Parent.ParentId IN ('0014000000SQyVGAA1')
    OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
    OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
    )
    ORDER By Name
    ]


    This succeeds:



    [
    SELECT Name
    FROM Account
    WHERE Id != '0014000000SQyVGAA1'
    AND Id != null
    AND (
    ParentId IN ('0014000000SQyVGAA1')
    OR Parent.ParentId IN ('0014000000SQyVGAA1')
    OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
    OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
    )
    ORDER By Name
    ]


    And this also succeeds:



    [
    SELECT Name
    FROM Account
    WHERE Id != '0014000000SQyVGAA1'
    AND Id != null
    AND (
    Id IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
    OR ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
    OR Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
    OR Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
    OR Parent.Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
    )
    ORDER By Name
    ]


    So the it appears the parser has a hard time dealing with the contradictory inclusion statements. I can create a second set to eliminate the issue.



    One last thing - this succeeds:



    [
    SELECT Name
    FROM Account
    WHERE Id != '0014000000SQyVGAA1'
    AND Id != null
    AND (
    Id IN ('0014000000SQyVGAA1')
    OR Parent.ParentId IN ('0014000000SQyVGAA1')
    )
    ORDER By Name
    ]


    But this fails:



    [
    SELECT Name
    FROM Account
    WHERE Id != '0014000000SQyVGAA1'
    AND Id != null
    AND (
    Id IN ('0014000000SQyVGAA1')
    OR ParentId IN ('0014000000SQyVGAA1')
    OR Parent.ParentId IN ('0014000000SQyVGAA1')
    )
    ORDER By Name
    ]


    So it appears that in order to cause the error, there needs to be both the contradictory statement and at least 2 other inclusion statements within the OR.






    share|improve this answer





























      5














      After a bit of investigation with explicitly stated IDs, I think I found the unique issue that causes the error, and it can be handled more elegantly than my workaround.



      Upon further investigation, the error is only happening when accountIds contains only opp.AccountId.



      This fails:



      [
      SELECT Name
      FROM Account
      WHERE Id != '0014000000SQyVGAA1'
      AND Id != null
      AND (
      Id IN ('0014000000SQyVGAA1')
      OR ParentId IN ('0014000000SQyVGAA1')
      OR Parent.ParentId IN ('0014000000SQyVGAA1')
      OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
      OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
      )
      ORDER By Name
      ]


      This succeeds:



      [
      SELECT Name
      FROM Account
      WHERE Id != '0014000000SQyVGAA1'
      AND Id != null
      AND (
      ParentId IN ('0014000000SQyVGAA1')
      OR Parent.ParentId IN ('0014000000SQyVGAA1')
      OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
      OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
      )
      ORDER By Name
      ]


      And this also succeeds:



      [
      SELECT Name
      FROM Account
      WHERE Id != '0014000000SQyVGAA1'
      AND Id != null
      AND (
      Id IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
      OR ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
      OR Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
      OR Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
      OR Parent.Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
      )
      ORDER By Name
      ]


      So the it appears the parser has a hard time dealing with the contradictory inclusion statements. I can create a second set to eliminate the issue.



      One last thing - this succeeds:



      [
      SELECT Name
      FROM Account
      WHERE Id != '0014000000SQyVGAA1'
      AND Id != null
      AND (
      Id IN ('0014000000SQyVGAA1')
      OR Parent.ParentId IN ('0014000000SQyVGAA1')
      )
      ORDER By Name
      ]


      But this fails:



      [
      SELECT Name
      FROM Account
      WHERE Id != '0014000000SQyVGAA1'
      AND Id != null
      AND (
      Id IN ('0014000000SQyVGAA1')
      OR ParentId IN ('0014000000SQyVGAA1')
      OR Parent.ParentId IN ('0014000000SQyVGAA1')
      )
      ORDER By Name
      ]


      So it appears that in order to cause the error, there needs to be both the contradictory statement and at least 2 other inclusion statements within the OR.






      share|improve this answer



























        5












        5








        5







        After a bit of investigation with explicitly stated IDs, I think I found the unique issue that causes the error, and it can be handled more elegantly than my workaround.



        Upon further investigation, the error is only happening when accountIds contains only opp.AccountId.



        This fails:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        Id IN ('0014000000SQyVGAA1')
        OR ParentId IN ('0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000SQyVGAA1')
        OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
        OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        This succeeds:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        ParentId IN ('0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000SQyVGAA1')
        OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
        OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        And this also succeeds:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        Id IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        OR ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        OR Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        OR Parent.Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        So the it appears the parser has a hard time dealing with the contradictory inclusion statements. I can create a second set to eliminate the issue.



        One last thing - this succeeds:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        Id IN ('0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        But this fails:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        Id IN ('0014000000SQyVGAA1')
        OR ParentId IN ('0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        So it appears that in order to cause the error, there needs to be both the contradictory statement and at least 2 other inclusion statements within the OR.






        share|improve this answer















        After a bit of investigation with explicitly stated IDs, I think I found the unique issue that causes the error, and it can be handled more elegantly than my workaround.



        Upon further investigation, the error is only happening when accountIds contains only opp.AccountId.



        This fails:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        Id IN ('0014000000SQyVGAA1')
        OR ParentId IN ('0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000SQyVGAA1')
        OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
        OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        This succeeds:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        ParentId IN ('0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000SQyVGAA1')
        OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
        OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        And this also succeeds:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        Id IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        OR ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        OR Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        OR Parent.Parent.Parent.ParentId IN ('0014000000VqDVWAA3','0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        So the it appears the parser has a hard time dealing with the contradictory inclusion statements. I can create a second set to eliminate the issue.



        One last thing - this succeeds:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        Id IN ('0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        But this fails:



        [
        SELECT Name
        FROM Account
        WHERE Id != '0014000000SQyVGAA1'
        AND Id != null
        AND (
        Id IN ('0014000000SQyVGAA1')
        OR ParentId IN ('0014000000SQyVGAA1')
        OR Parent.ParentId IN ('0014000000SQyVGAA1')
        )
        ORDER By Name
        ]


        So it appears that in order to cause the error, there needs to be both the contradictory statement and at least 2 other inclusion statements within the OR.







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Mar 20 at 19:57

























        answered Mar 20 at 19:21









        SFDC NeufSFDC Neuf

        775623




        775623























            2














            Anecdotally, This query runs fine (via the developer consoles query editor) on one of my sandboxes:



            SELECT Name, ID
            FROM Account
            WHERE Id != ''
            AND Id != ''
            AND (
            Id IN ('')
            OR ParentId IN ('')
            OR Parent.ParentId IN ('')
            OR Parent.Parent.ParentId IN ('')
            OR Parent.Parent.Parent.ParentId IN ('')
            )
            ORDER By Name


            Using static id lists also works fine:



            SELECT Name, ID
            FROM Account
            WHERE Id != '001U000100qh0xJIAQ'
            AND Id != '001U000100qh0xJIAQ'
            AND (
            Id IN ('001U000000ASKzzIAH')
            OR ParentId IN ('001U000000ASKzzIAH')
            OR Parent.ParentId IN ('001U000000ASKzzIAH')
            OR Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
            OR Parent.Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
            )
            ORDER By Name


            Heres some code I used in the developer consoles execute anonymous code window:



            Id someId = '001U000100qh0xJIAQ';
            Id someOtherId = '001U000700qh0xJIAQ';

            Set<Id> accountIds = new Map<Id, Account>([SELECT Id FROM Account LIMIT 1000]).keySet();

            System.debug([
            SELECT Name
            FROM Account
            WHERE Id != :someId
            AND Id != :someOtherId
            AND (
            Id IN :accountIds
            OR ParentId IN :accountIds
            OR Parent.ParentId IN :accountIds
            OR Parent.Parent.ParentId IN :accountIds
            OR Parent.Parent.Parent.ParentId IN :accountIds
            )
            ORDER By Name
            ]);


            Even trying to look for 1000 items in 4 separate clauses I can't repo your error.




            Heres the results of running some queries on my org:



            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No Results, but no crash.




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            [object Object]: An unexpected error occurred. Please include this ErrorId if you contact support: 1038235189-47553 (730406045)




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No results




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No results.




            I have no idea why exactly it fails but it seems like adding that 3rd clause to the AND causes the failure. If it was just the ID != '' && Id == '' issue, I'd expect the first one to fail.






            share|improve this answer




















            • 2





              I think you meant "repro".

              – Adrian Larson
              Mar 20 at 19:07






            • 1





              Exactly my findings. Always fun to find a weird edge case where things break.

              – SFDC Neuf
              Mar 20 at 19:53






            • 2





              I dunno, the image of showing up to someone else's place of work, putting some chains around the workstation, tying it to a car, and gunning it to "repo" the error sounds like pretty good entertainment to me. :p

              – Derek F
              Mar 20 at 19:54
















            2














            Anecdotally, This query runs fine (via the developer consoles query editor) on one of my sandboxes:



            SELECT Name, ID
            FROM Account
            WHERE Id != ''
            AND Id != ''
            AND (
            Id IN ('')
            OR ParentId IN ('')
            OR Parent.ParentId IN ('')
            OR Parent.Parent.ParentId IN ('')
            OR Parent.Parent.Parent.ParentId IN ('')
            )
            ORDER By Name


            Using static id lists also works fine:



            SELECT Name, ID
            FROM Account
            WHERE Id != '001U000100qh0xJIAQ'
            AND Id != '001U000100qh0xJIAQ'
            AND (
            Id IN ('001U000000ASKzzIAH')
            OR ParentId IN ('001U000000ASKzzIAH')
            OR Parent.ParentId IN ('001U000000ASKzzIAH')
            OR Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
            OR Parent.Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
            )
            ORDER By Name


            Heres some code I used in the developer consoles execute anonymous code window:



            Id someId = '001U000100qh0xJIAQ';
            Id someOtherId = '001U000700qh0xJIAQ';

            Set<Id> accountIds = new Map<Id, Account>([SELECT Id FROM Account LIMIT 1000]).keySet();

            System.debug([
            SELECT Name
            FROM Account
            WHERE Id != :someId
            AND Id != :someOtherId
            AND (
            Id IN :accountIds
            OR ParentId IN :accountIds
            OR Parent.ParentId IN :accountIds
            OR Parent.Parent.ParentId IN :accountIds
            OR Parent.Parent.Parent.ParentId IN :accountIds
            )
            ORDER By Name
            ]);


            Even trying to look for 1000 items in 4 separate clauses I can't repo your error.




            Heres the results of running some queries on my org:



            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No Results, but no crash.




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            [object Object]: An unexpected error occurred. Please include this ErrorId if you contact support: 1038235189-47553 (730406045)




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No results




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No results.




            I have no idea why exactly it fails but it seems like adding that 3rd clause to the AND causes the failure. If it was just the ID != '' && Id == '' issue, I'd expect the first one to fail.






            share|improve this answer




















            • 2





              I think you meant "repro".

              – Adrian Larson
              Mar 20 at 19:07






            • 1





              Exactly my findings. Always fun to find a weird edge case where things break.

              – SFDC Neuf
              Mar 20 at 19:53






            • 2





              I dunno, the image of showing up to someone else's place of work, putting some chains around the workstation, tying it to a car, and gunning it to "repo" the error sounds like pretty good entertainment to me. :p

              – Derek F
              Mar 20 at 19:54














            2












            2








            2







            Anecdotally, This query runs fine (via the developer consoles query editor) on one of my sandboxes:



            SELECT Name, ID
            FROM Account
            WHERE Id != ''
            AND Id != ''
            AND (
            Id IN ('')
            OR ParentId IN ('')
            OR Parent.ParentId IN ('')
            OR Parent.Parent.ParentId IN ('')
            OR Parent.Parent.Parent.ParentId IN ('')
            )
            ORDER By Name


            Using static id lists also works fine:



            SELECT Name, ID
            FROM Account
            WHERE Id != '001U000100qh0xJIAQ'
            AND Id != '001U000100qh0xJIAQ'
            AND (
            Id IN ('001U000000ASKzzIAH')
            OR ParentId IN ('001U000000ASKzzIAH')
            OR Parent.ParentId IN ('001U000000ASKzzIAH')
            OR Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
            OR Parent.Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
            )
            ORDER By Name


            Heres some code I used in the developer consoles execute anonymous code window:



            Id someId = '001U000100qh0xJIAQ';
            Id someOtherId = '001U000700qh0xJIAQ';

            Set<Id> accountIds = new Map<Id, Account>([SELECT Id FROM Account LIMIT 1000]).keySet();

            System.debug([
            SELECT Name
            FROM Account
            WHERE Id != :someId
            AND Id != :someOtherId
            AND (
            Id IN :accountIds
            OR ParentId IN :accountIds
            OR Parent.ParentId IN :accountIds
            OR Parent.Parent.ParentId IN :accountIds
            OR Parent.Parent.Parent.ParentId IN :accountIds
            )
            ORDER By Name
            ]);


            Even trying to look for 1000 items in 4 separate clauses I can't repo your error.




            Heres the results of running some queries on my org:



            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No Results, but no crash.




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            [object Object]: An unexpected error occurred. Please include this ErrorId if you contact support: 1038235189-47553 (730406045)




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No results




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No results.




            I have no idea why exactly it fails but it seems like adding that 3rd clause to the AND causes the failure. If it was just the ID != '' && Id == '' issue, I'd expect the first one to fail.






            share|improve this answer















            Anecdotally, This query runs fine (via the developer consoles query editor) on one of my sandboxes:



            SELECT Name, ID
            FROM Account
            WHERE Id != ''
            AND Id != ''
            AND (
            Id IN ('')
            OR ParentId IN ('')
            OR Parent.ParentId IN ('')
            OR Parent.Parent.ParentId IN ('')
            OR Parent.Parent.Parent.ParentId IN ('')
            )
            ORDER By Name


            Using static id lists also works fine:



            SELECT Name, ID
            FROM Account
            WHERE Id != '001U000100qh0xJIAQ'
            AND Id != '001U000100qh0xJIAQ'
            AND (
            Id IN ('001U000000ASKzzIAH')
            OR ParentId IN ('001U000000ASKzzIAH')
            OR Parent.ParentId IN ('001U000000ASKzzIAH')
            OR Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
            OR Parent.Parent.Parent.ParentId IN ('001U000000ASKzzIAH')
            )
            ORDER By Name


            Heres some code I used in the developer consoles execute anonymous code window:



            Id someId = '001U000100qh0xJIAQ';
            Id someOtherId = '001U000700qh0xJIAQ';

            Set<Id> accountIds = new Map<Id, Account>([SELECT Id FROM Account LIMIT 1000]).keySet();

            System.debug([
            SELECT Name
            FROM Account
            WHERE Id != :someId
            AND Id != :someOtherId
            AND (
            Id IN :accountIds
            OR ParentId IN :accountIds
            OR Parent.ParentId IN :accountIds
            OR Parent.Parent.ParentId IN :accountIds
            OR Parent.Parent.Parent.ParentId IN :accountIds
            )
            ORDER By Name
            ]);


            Even trying to look for 1000 items in 4 separate clauses I can't repo your error.




            Heres the results of running some queries on my org:



            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No Results, but no crash.




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            [object Object]: An unexpected error occurred. Please include this ErrorId if you contact support: 1038235189-47553 (730406045)




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No results




            SELECT Name
            FROM Account
            WHERE Id != '0014000000SQyVGAA1'
            AND Id != null
            AND (
            Id IN ('0014000000SQyVGAA1')
            OR Parent.Parent.ParentId IN ('0014000000SQyVGAA1')
            )
            ORDER By Name



            No results.




            I have no idea why exactly it fails but it seems like adding that 3rd clause to the AND causes the failure. If it was just the ID != '' && Id == '' issue, I'd expect the first one to fail.







            share|improve this answer














            share|improve this answer



            share|improve this answer








            edited Mar 20 at 19:51

























            answered Mar 20 at 18:49









            battery.cordbattery.cord

            7,07551846




            7,07551846







            • 2





              I think you meant "repro".

              – Adrian Larson
              Mar 20 at 19:07






            • 1





              Exactly my findings. Always fun to find a weird edge case where things break.

              – SFDC Neuf
              Mar 20 at 19:53






            • 2





              I dunno, the image of showing up to someone else's place of work, putting some chains around the workstation, tying it to a car, and gunning it to "repo" the error sounds like pretty good entertainment to me. :p

              – Derek F
              Mar 20 at 19:54













            • 2





              I think you meant "repro".

              – Adrian Larson
              Mar 20 at 19:07






            • 1





              Exactly my findings. Always fun to find a weird edge case where things break.

              – SFDC Neuf
              Mar 20 at 19:53






            • 2





              I dunno, the image of showing up to someone else's place of work, putting some chains around the workstation, tying it to a car, and gunning it to "repo" the error sounds like pretty good entertainment to me. :p

              – Derek F
              Mar 20 at 19:54








            2




            2





            I think you meant "repro".

            – Adrian Larson
            Mar 20 at 19:07





            I think you meant "repro".

            – Adrian Larson
            Mar 20 at 19:07




            1




            1





            Exactly my findings. Always fun to find a weird edge case where things break.

            – SFDC Neuf
            Mar 20 at 19:53





            Exactly my findings. Always fun to find a weird edge case where things break.

            – SFDC Neuf
            Mar 20 at 19:53




            2




            2





            I dunno, the image of showing up to someone else's place of work, putting some chains around the workstation, tying it to a car, and gunning it to "repo" the error sounds like pretty good entertainment to me. :p

            – Derek F
            Mar 20 at 19:54






            I dunno, the image of showing up to someone else's place of work, putting some chains around the workstation, tying it to a car, and gunning it to "repo" the error sounds like pretty good entertainment to me. :p

            – Derek F
            Mar 20 at 19:54


















            draft saved

            draft discarded
















































            Thanks for contributing an answer to Salesforce Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f254657%2fsoql-query-causes-internal-salesforce-error%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Identifying “long and narrow” polygons in with PostGISlength and width of polygonWhy postgis st_overlaps reports Qgis' “avoid intersections” generated polygon as overlapping with others?Adjusting polygons to boundary and filling holesDrawing polygons with fixed area?How to remove spikes in Polygons with PostGISDeleting sliver polygons after difference operation in QGIS?Snapping boundaries in PostGISSplit polygon into parts adding attributes based on underlying polygon in QGISSplitting overlap between polygons and assign to nearest polygon using PostGIS?Expanding polygons and clipping at midpoint?Removing Intersection of Buffers in Same Layers

            Masuk log Menu navigasi

            อาณาจักร (ชีววิทยา) ดูเพิ่ม อ้างอิง รายการเลือกการนำทาง10.1086/39456810.5962/bhl.title.447410.1126/science.163.3863.150576276010.1007/BF01796092408502"Phylogenetic structure of the prokaryotic domain: the primary kingdoms"10.1073/pnas.74.11.5088432104270744"Towards a natural system of organisms: proposal for the domains Archaea, Bacteria, and Eucarya"1990PNAS...87.4576W10.1073/pnas.87.12.4576541592112744PubMedJump the queueexpand by handPubMedJump the queueexpand by handPubMedJump the queueexpand by hand"A revised six-kingdom system of life"10.1111/j.1469-185X.1998.tb00030.x9809012"Only six kingdoms of life"10.1098/rspb.2004.2705169172415306349"Kingdoms Protozoa and Chromista and the eozoan root of the eukaryotic tree"10.1098/rsbl.2009.0948288006020031978เพิ่มข้อมูล