You need to sign in to do that
Don't have an account?
SharathChandra
Batch Apex Exception : First error: SQLException [common.exception.SfdcSqlException: ORA-01013: user requested cancel of current operation
Hi I'm facing the SQLException [common.exception.SfdcSqlException: ORA-01013 in my batch, i have used index field and selective filters in my query in batch but i'm not able to resolve the error. Can you please help me.
Thanks in advance.
Thanks in advance.
All Answers
Then based on that try optimising the same.
1.) Try reducing the Date range.
2.) Try to put some more filters in query
2.) Try contacting salesforce support to get Fields Contract_Type__c or Date__c custom indexed.
Hope this helps !!
Alternatively,why don't you make your field Contract_Type__c as external Id if it allows to make.