I have the below query in a class that is the controller for a page.  The query is executed using Database.query(). There is only 15578 quotes in the database. I have also included below the lines from the error log. Why is thsi happing and how do I go aboutl correcting it. Also I am able to run thsi query with no problem in the developer console.

Thanks
Tom

Query
"select day_only(createdDate) createdonDate, count(createdDate) numCreated, sum(TotalPrice) amount, status,  grouping(status) grpStatus  FROM Quote WHERE ContactId != null  group by cube(day_only(createdDate), status) order by day_only(createdDate)  desc limit 1000" 

Error log
14:42:47.097 (97511178)|SYSTEM_METHOD_ENTRY|[177]|Database.query(String)
14:42:47.098 (98616275)|SOQL_EXECUTE_BEGIN|[177]|Aggregations:0|  select day_only(createdDate) createdonDate, count(createdDate) numCreated, sum(TotalPrice) amount, status,  grouping(status) grpStatus  FROM Quote WHERE ContactId != null  group by cube         (day_only(createdDate), status)   order by  day_only(createdDate)  desc limit 1000 
14:42:47.275 (275728038)|SOQL_EXECUTE_END|[177]|Rows:1000
14:42:47.275 (275768494)|EXCEPTION_THROWN|[177]|System.LimitException: Too many query rows: 50001

I have the below query in a class that is the controller for a page.  The query is executed using Database.query(). There is only 15578 quotes in the database. I have also included below the lines from the error log. Why is thsi happing and how do I go aboutl correcting it. Also I am able to run thsi query with no problem in the developer console.

Thanks
Tom

Query
"select day_only(createdDate) createdonDate, count(createdDate) numCreated, sum(TotalPrice) amount, status,  grouping(status) grpStatus  FROM Quote WHERE ContactId != null  group by cube(day_only(createdDate), status) order by day_only(createdDate)  desc limit 1000" 

Error log
14:42:47.097 (97511178)|SYSTEM_METHOD_ENTRY|[177]|Database.query(String)
14:42:47.098 (98616275)|SOQL_EXECUTE_BEGIN|[177]|Aggregations:0|  select day_only(createdDate) createdonDate, count(createdDate) numCreated, sum(TotalPrice) amount, status,  grouping(status) grpStatus  FROM Quote WHERE ContactId != null  group by cube         (day_only(createdDate), status)   order by  day_only(createdDate)  desc limit 1000 
14:42:47.275 (275728038)|SOQL_EXECUTE_END|[177]|Rows:1000
14:42:47.275 (275768494)|EXCEPTION_THROWN|[177]|System.LimitException: Too many query rows: 50001

I am trying to change the timeout on a developer account and the timeout is always no more than 10 seconds if I set the value to 8 seconds it times out at 8 seconds, if I set the timeout to 120 seconds it times out at 10 seconds. I tried changing the timeout the following ways:
CurrentInventory.SearchMultipleProducts(partlist, 'JSON', function(result, event){
                 if (event.status && event.result) {
                  data = event.result.replace(/(&quot\;)/g,"\"");
                  console.log("data = " + data);
                  LoadMultiPartGrid(data);
                 
            }
          },{timeout: 120000 } );

and I also tried Visualforce.remoting.timeout = 120000; in javascript. Is the developers account limit 10 seconds or am I doing this wrong?

Thanks
Tom

Hi

 

 

I have a webservices class and I generate a class from wsdl and now I need to write test class for it but here there are no methods in it and only having  variables and classes, here I wrote test class creating an object for each class and Inner class also but not covered it showing 0%.

 

 

can any one help in this plz

 

 

thanks

SRS