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
IC-TannerIC-Tanner 

chatterConnector.main System.Exception: Too many query rows: 1090

 

I tried to deploy a non 'Chatter' related Apex class & trigger today and received the following error fired by a the test method of the chatterConnector Class. Because the Chatter APEX classes/triggers are not part of a managed package, the chatter test methods are firing for my unrelated code. Therefore I cannot deploy, update, or delete any APEX classes/triggers which is a major issue. Salesforce, can you please update this test method or allow unpackaged classes/triggers to be deployed without calling the Chatter test methods?

 

Feel free to contact me directly with any database instance specific questions.

 

Thank you!

 

Related info from Debug log:

 

17:45:6.650|EXECUTION_STARTED

17:45:6.650|CODE_UNIT_STARTED|[EXTERNAL]chatterConnector.main

17:45:6.653|METHOD_ENTRY|[15,50]|MAP:String,String.get(String)

17:45:6.653|METHOD_ENTRY|[15,34]|System.PageReference.getparameters()

17:45:6.653|METHOD_ENTRY|[15,10]|ApexPages.currentpage()

17:45:6.653|METHOD_EXIT|[15,10]|currentPage()

17:45:6.653|METHOD_EXIT|[15,34]|getParameters()

17:45:6.653|METHOD_EXIT|[15,50]|get(ANY)

17:45:6.653|METHOD_ENTRY|[26,9]|chatterConnector.buildUserList()

17:45:6.653|SOQL_EXECUTE_BEGIN|[77,19]|Aggregations:0|select id, name, userroleid, profileid, department, state, country,

            managerid, manager.name, manager.managerid, manager.manager.managerid, manager.manager.manager.managerid, manager.manager.manager.manager.managerid

            from User

            where id = :Userinfo.getUserId()

17:45:6.661|METHOD_ENTRY|[80,25]|Userinfo.getUserId()

17:45:6.661|METHOD_EXIT|[80,25]|getUserId()

17:45:6.671|SOQL_EXECUTE_END|[77,19]|Rows:1|Duration:18

17:45:6.672|METHOD_ENTRY|[84,23]|integer.valueof(String)

17:45:6.672|METHOD_EXIT|[84,23]|valueOf(String)

17:45:6.674|METHOD_ENTRY|[89,79]|UserInfo.getUserId()

17:45:6.674|METHOD_EXIT|[89,79]|getUserId()

17:45:6.678|METHOD_ENTRY|[137,24]|Database.query(String)

17:45:6.681|SOQL_EXECUTE_BEGIN|[137,24]|Aggregations:0|select id, name, managerid, title, city, state, department, createddate from User where isactive = true and usertype = 'Standard' and id <> '00550000000ymonAAA'  limit 1000

17:45:6.685|SOQL_EXECUTE_END|[137,24]|Rows:41|Duration:4

17:45:6.685|METHOD_EXIT|[137,24]|query(String)

17:45:6.685|SOQL_EXECUTE_BEGIN|[141,45]|Aggregations:0|select id, subscriberid

            from EntitySubscription

            where subscriberid IN :uList

            and parentid = :UserInfo.getUserId()

17:45:6.699|METHOD_ENTRY|[144,29]|UserInfo.getUserId()

17:45:6.699|METHOD_EXIT|[144,29]|getUserId()

17:45:6.710|SOQL_EXECUTE_END|[141,45]|Rows:0|Duration:25

17:45:6.711|SOQL_EXECUTE_BEGIN|[152,44]|Aggregations:0|select id, parentid

            from EntitySubscription

            where subscriberid = :UserInfo.getUserId()

            and parentid IN :uList

17:45:6.715|METHOD_ENTRY|[154,35]|UserInfo.getUserId()

17:45:6.715|METHOD_EXIT|[154,35]|getUserId()

17:45:6.725|SOQL_EXECUTE_END|[152,44]|Rows:1|Duration:14

17:45:6.725|METHOD_ENTRY|[160,13]|SET:Id.add(Id)

17:45:6.727|METHOD_EXIT|[160,13]|add(ANY)

17:45:6.727|SOQL_EXECUTE_BEGIN|[163,45]|Aggregations:0|select subscriberid, count(id)

            from EntitySubscription

            where subscriberid IN :uList

            group by subscriberid

            order by count(id) desc

            limit 200

17:45:6.733|SOQL_EXECUTE_END|[163,45]|Rows:21|Duration:6

17:45:6.733|EXCEPTION_THROWN|[163,45]|System.Exception: Too many query rows: 1090

17:45:6.733|METHOD_EXIT|[26,9]|buildUserList()

17:45:6.733|FATAL_ERROR|System.Exception: Too many query rows: 1090

 

IC-TannerIC-Tanner

As a workaround I have commented out the 'chatterConnector' test method as the test coverage of the other unpackaged classes/triggers was still greater than 75% without the 'chatterConnector' class having test coverage.