You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
sakamati
changed the title
bulkDelete fails with RequestTimeout
bulkDelete fails with RequestTimeout error
Sep 3, 2019
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.
The text was updated successfully, but these errors were encountered: