I am using bulkDelete stored procedure to delete stale data. This stored procedure fails with the error message - "The requested operation exceeded maximum alloted time."
I am guessing this is happening only when I execute the stored procedure on a partition that has huge data (close to 10 GB). I have executed this SP on a partition that has relatively less data and was working fine. Is there any problem with the way I am consuming the SP or is there any constraints for this SP?
The query I use to pass to this SP is
SELECT c._self FROM c WHERE c.documentType = 'DocumentType' and c.payload.NextExecution < '2019-03-01' and c.payload.NextExecution >= '2019-01-01'
I am using bulkDelete stored procedure to delete stale data. This stored procedure fails with the error message - "The requested operation exceeded maximum alloted time."
I am guessing this is happening only when I execute the stored procedure on a partition that has huge data (close to 10 GB). I have executed this SP on a partition that has relatively less data and was working fine. Is there any problem with the way I am consuming the SP or is there any constraints for this SP?
The query I use to pass to this SP is
SELECT c._self FROM c WHERE c.documentType = 'DocumentType' and c.payload.NextExecution < '2019-03-01' and c.payload.NextExecution >= '2019-01-01'
Looking forward for your help.