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
john4sfdcjohn4sfdc 

Salesforce.com Internal error in Batch apex.does anyone have an idea on this?

20.0 APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO
12:01:10.119 (119157280)|EXECUTION_STARTED
12:01:10.119 (119200824)|CODE_UNIT_STARTED|[EXTERNAL]|01pE000000000a1|TerritoryAlignment
12:01:10.161 (161388605)|METHOD_ENTRY|[5]|01pE000000000a1|TerritoryAlignment.TerritoryAlignment()
12:01:10.161 (161466583)|METHOD_EXIT|[5]|TerritoryAlignment
12:01:10.182 (182010006)|METHOD_ENTRY|[8]|01pA0000001oPla|BatchJobUtils.BatchJobUtils()
12:01:10.182 (182084454)|SYSTEM_CONSTRUCTOR_ENTRY|[30]|<init>(Integer)
12:01:10.182 (182137857)|SYSTEM_CONSTRUCTOR_EXIT|[30]|<init>(Integer)
12:01:10.182 (182176141)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182194798)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182208546)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182219542)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182231733)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182242334)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182254105)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182264782)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182276570)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182287244)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182299032)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182309704)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182321427)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182336971)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182349212)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182359748)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182371449)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182382116)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182393862)|SYSTEM_METHOD_ENTRY|[30]|SET<String>.add(Object)
12:01:10.182 (182404537)|SYSTEM_METHOD_EXIT|[30]|SET<String>.add(Object)
12:01:10.182 (182429131)|METHOD_EXIT|[8]|BatchJobUtils
12:01:10.183 (183647973)|METHOD_ENTRY|[81]|01pA0000001oPla|BatchJobUtils.setRunning(Id)
12:01:10.185 (185580043)|SOQL_EXECUTE_BEGIN|[120]|Aggregations:0|select Id from Batch_Job__c where Id = :tmpVar1
12:01:10.188 (188411566)|SOQL_EXECUTE_END|[120]|Rows:1
12:01:10.188 (188550692)|SYSTEM_METHOD_ENTRY|[121]|LIST<Batch_Job__c>.isEmpty()
12:01:10.188 (188577929)|SYSTEM_METHOD_EXIT|[121]|LIST<Batch_Job__c>.isEmpty()
12:01:10.188 (188598904)|SYSTEM_METHOD_ENTRY|[122]|LIST<Batch_Job__c>.get(Integer)
12:01:10.188 (188646639)|SYSTEM_METHOD_EXIT|[122]|LIST<Batch_Job__c>.get(Integer)
12:01:10.188 (188740846)|DML_BEGIN|[124]|Op:Update|Type:Batch_Job__c|Rows:1
12:01:10.261 (261542811)|DML_END|[124]
12:01:10.261 (261592724)|METHOD_EXIT|[81]|01pA0000001oPla|BatchJobUtils.setRunning(Id)
12:01:10.261 (261659324)|SYSTEM_METHOD_ENTRY|[83]|System.debug(ANY)
12:01:10.261 (261692205)|USER_DEBUG|[83]|DEBUG|Query : SELECT Id, Customer__c, Territory_Custom__c,  Territory_Custom__r.Name, Territory_Custom__r.Territory_Id__c,  Territory_Custom__r.Group_Id__c,  Account_Share_Id__c, Is_Marked_for_Delete__c  FROM Account_Territory__c  WHERE Account_Share_Id__c = NULL and Is_Marked_for_Delete__c = FALSE  LIMIT 1000000
12:01:10.261 (261701167)|SYSTEM_METHOD_EXIT|[83]|System.debug(ANY)
12:01:10.272 (272605280)|METHOD_ENTRY|[12]|01pA0000001oPmU|CodeSettingUtils.CodeSettingUtils()
12:01:10.272 (272702512)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272753205)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272778685)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272794337)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272812314)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272826579)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272844713)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272858708)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272876043)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272889717)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272905891)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272919455)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272938113)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272951908)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272969423)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.272 (272983080)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273000441)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273015886)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273032566)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273046930)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273061714)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273075370)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273091822)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273105418)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273121497)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273135824)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273153465)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273167335)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273184698)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273198534)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273215033)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273229240)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273246458)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273260371)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273277037)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273290708)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273313062)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273327845)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273345652)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273359332)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273376709)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273390353)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273410616)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273425681)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273443366)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273457066)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273474137)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273487842)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273510383)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273526564)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273544474)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273558346)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273575787)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273589674)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273620909)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273635533)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273652403)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273666294)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273683891)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273697875)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273713313)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273726754)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273743582)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273757228)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273773558)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273787398)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273805115)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273818970)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273835793)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273849572)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273866608)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273880469)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273895803)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273909396)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273929531)|SYSTEM_METHOD_ENTRY|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273943837)|SYSTEM_METHOD_EXIT|[71]|MAP<String,String>.put(Object, Object)
12:01:10.273 (273970773)|METHOD_EXIT|[12]|CodeSettingUtils
12:01:10.275 (275575812)|METHOD_ENTRY|[85]|01pA0000001oPmU|CodeSettingUtils.getTargetID(String)
12:01:10.275 (275808916)|SYSTEM_METHOD_ENTRY|[223]|CommonSettings__c.getInstance(String)
12:01:10.277 (277516687)|SYSTEM_METHOD_EXIT|[223]|CommonSettings__c.getInstance(String)
12:01:10.277 (277580360)|SYSTEM_CONSTRUCTOR_ENTRY|[224]|<init>()
12:01:10.277 (277612047)|SYSTEM_CONSTRUCTOR_EXIT|[224]|<init>()
12:01:10.277 (277621769)|SYSTEM_CONSTRUCTOR_ENTRY|[225]|<init>()
12:01:10.277 (277634537)|SYSTEM_CONSTRUCTOR_EXIT|[225]|<init>()
12:01:10.277 (277672936)|SYSTEM_METHOD_ENTRY|[227]|String.split(String)
12:01:10.277 (277717624)|SYSTEM_METHOD_EXIT|[227]|String.split(String)
12:01:10.280 (280341599)|SOQL_EXECUTE_BEGIN|[229]|Aggregations:0|select Id from User where username IN :tmpVar1
12:01:10.285 (285461038)|SOQL_EXECUTE_END|[229]|Rows:0
12:01:10.285 (285638711)|SYSTEM_METHOD_ENTRY|[230]|LIST<User>.size()
12:01:10.285 (285667057)|SYSTEM_METHOD_EXIT|[230]|LIST<User>.size()
12:01:10.285 (285686223)|METHOD_EXIT|[85]|01pA0000001oPmU|CodeSettingUtils.getTargetID(String)
12:01:10.285 (285726722)|SYSTEM_METHOD_ENTRY|[85]|com.salesforce.api.interop.apex.bcl.DatetimeMethods.now()
12:01:10.285 (285749377)|SYSTEM_METHOD_EXIT|[85]|com.salesforce.api.interop.apex.bcl.DatetimeMethods.now()
12:01:10.285 (285773459)|SYSTEM_METHOD_ENTRY|[85]|String.valueOf(Object)
12:01:10.285 (285795208)|SYSTEM_METHOD_EXIT|[85]|String.valueOf(Object)
12:01:10.294 (294655813)|METHOD_ENTRY|[14]|01pA0000001oPmk|EmailUtils.EmailUtils()
12:01:10.294 (294682503)|METHOD_EXIT|[14]|EmailUtils
12:01:10.296 (296055727)|METHOD_ENTRY|[85]|01pA0000001oPmk|EmailUtils.sendEmail(LIST<String>, String, String, Boolean, LIST<Messaging.EmailFileAttachment>, Boolean)
12:01:10.296 (296089329)|SYSTEM_METHOD_ENTRY|[48]|LIST<String>.size()
12:01:10.296 (296134515)|SYSTEM_METHOD_EXIT|[48]|LIST<String>.size()
12:01:10.296 (296149751)|METHOD_EXIT|[85]|01pA0000001oPmk|EmailUtils.sendEmail(LIST<String>, String, String, Boolean, LIST<Messaging.EmailFileAttachment>, Boolean)
12:01:10.296 (296177294)|SYSTEM_METHOD_ENTRY|[90]|Database.getQueryLocator(String)
12:01:10.302 (302054710)|SOQL_EXECUTE_BEGIN|[90]|Aggregations:0|SELECT Id, Customer__c, Territory_Custom__c,  Territory_Custom__r.Name, Territory_Custom__r.Territory_Id__c,  Territory_Custom__r.Group_Id__c,  Account_Share_Id__c, Is_Marked_for_Delete__c  FROM Account_Territory__c 
12:31:17.661 (1807661545838)|EXCEPTION_THROWN|[90]|System.UnexpectedException: Internal Salesforce.com Query Error
12:31:17.661 (1807661671103)|SYSTEM_METHOD_EXIT|[90]|Database.getQueryLocator(String)
12:31:17.661 (1807661743998)|FATAL_ERROR|System.UnexpectedException: Internal Salesforce.com Query Error

Class.TerritoryAlignment.start: line 90, column 1
12:31:17.952 (1807661876825)|CUMULATIVE_LIMIT_USAGE
12:31:17.952|LIMIT_USAGE_FOR_NS|(default)|
  Number of SOQL queries: 0 out of 200
  Number of query rows: 0 out of 50000
  Number of SOSL queries: 0 out of 20
  Number of DML statements: 0 out of 150
  Number of DML rows: 0 out of 10000
  Maximum CPU time: 0 out of 60000
  Maximum heap size: 0 out of 12000000
  Number of callouts: 0 out of 0
  Number of Email Invocations: 0 out of 10
  Number of future calls: 0 out of 0
  Number of Mobile Apex push calls: 0 out of 10

12:31:17.952|CUMULATIVE_LIMIT_USAGE_END

12:31:17.661 (1807661912023)|CODE_UNIT_FINISHED|TerritoryAlignment
Shyam BhundiaShyam Bhundia
It could be because you're using "Limit 1000000", the limit for total number of records retrieve by a query is 50,000.  

See this link for more governor limits https://www.salesforce.com/us/developer/docs/apexcode/Content/apex_gov_limits.htm 
kibitzerkibitzer
The 1000000 limit can work if you're using the @readonly attribute on scheduled Apex or a web service call, but not batch executions. So it may be the issue here - or it may not.

Generally speaking, when you get an internal salesforce error, the best thing you can do is file a case. They can look at the log files and give you better information as to what the actual problem is. It's often something unexpected.
john4sfdcjohn4sfdc
I am using the database.getquerylocator to pull 1000000 records and return it to to the batch apex. I dont think governor limits are causing the problem..