Same Azure Cosmos DB one time it runs other time shows message Size is too large










0














I am writing Azure Cosmos DB stored procedure in azure portal , I am checking the what is max size response it can give initially it gave me 4.8 MB response later on any size more that it was showing error of message size is too large . Later on after 5 min executed same procedure and same parameters it was showing error of too large page size.



 // SAMPLE STORED PROCEDURE
function sample(prefix)
var collection = getContext().getCollection();

// Query documents and take 1st item.
var isAccepted = collection.queryDocuments(
collection.getSelfLink(),
'SELECT r.data.truckSerialNo FROM root r',pageSize : -1,
function (err, feed, options)
if (err) throw err;

// Check the feed and if empty, set the body to 'no docs found', 
// else take 1st element from feed
if (!feed );

if (!isAccepted) throw new Error('The query was not accepted by the server.');



and error




Failed to execute stored procedure testProcedure for collection
iotcollection:
"code":400,"body":""code":"BadRequest","message":"Message:
\"Errors\":[\"Encountered exception while executing function.
Exception = Error: Resulting message would be too large because of
\\"Body\\". Return from script with current message and use
continuation token to call the script again or modify your
script.\r\nStack trace: Error: Resulting message would be too
large because of \\"Body\\". Return from script with current
message and use continuation token to call the script again or modify
your script.\n at validateSize (bulkUpsert_v_1_0.js:177:25)\n
at setValueInternal (bulkUpsert\"]rnActivityId:
d61226ab-4d5e-4a3d-aa09-83351649ce4c, Request URI:
/apps/59d3b9ef-17ca-4bbf-8a11-39d0199a8d29/services/1b26e00f-1f51-4d34-88ec-4090b8e7db00/partitions/45a313b7-2cf2-419e-9885-48bf9cfe6277/replicas/131862936473830809p/,
RequestStats: rnRequestStartTime: 2018-11-10T06:41:26.3320532Z,
Number of regions attempted: 1rn, SDK:
Microsoft.Azure.Documents.Common/2.1.0.0"","activityId":"d61226ab-4d5e-4a3d-aa09-83351649ce4c","substatus":413











share|improve this question























  • Possible duplicate of Cosmos DB out of Memory exception while executing stored procedure
    – Josh
    Nov 11 '18 at 23:18










  • Please refrain from asking the same question more than once with tweaks to the verbiage. This is the third time you’ve pasted the same code and asked about oversized responses.
    – Josh
    Nov 11 '18 at 23:21










  • Hi,Amjath,does my answer helps you?
    – Jay Gong
    Dec 3 '18 at 5:54















0














I am writing Azure Cosmos DB stored procedure in azure portal , I am checking the what is max size response it can give initially it gave me 4.8 MB response later on any size more that it was showing error of message size is too large . Later on after 5 min executed same procedure and same parameters it was showing error of too large page size.



 // SAMPLE STORED PROCEDURE
function sample(prefix)
var collection = getContext().getCollection();

// Query documents and take 1st item.
var isAccepted = collection.queryDocuments(
collection.getSelfLink(),
'SELECT r.data.truckSerialNo FROM root r',pageSize : -1,
function (err, feed, options)
if (err) throw err;

// Check the feed and if empty, set the body to 'no docs found', 
// else take 1st element from feed
if (!feed );

if (!isAccepted) throw new Error('The query was not accepted by the server.');



and error




Failed to execute stored procedure testProcedure for collection
iotcollection:
"code":400,"body":""code":"BadRequest","message":"Message:
\"Errors\":[\"Encountered exception while executing function.
Exception = Error: Resulting message would be too large because of
\\"Body\\". Return from script with current message and use
continuation token to call the script again or modify your
script.\r\nStack trace: Error: Resulting message would be too
large because of \\"Body\\". Return from script with current
message and use continuation token to call the script again or modify
your script.\n at validateSize (bulkUpsert_v_1_0.js:177:25)\n
at setValueInternal (bulkUpsert\"]rnActivityId:
d61226ab-4d5e-4a3d-aa09-83351649ce4c, Request URI:
/apps/59d3b9ef-17ca-4bbf-8a11-39d0199a8d29/services/1b26e00f-1f51-4d34-88ec-4090b8e7db00/partitions/45a313b7-2cf2-419e-9885-48bf9cfe6277/replicas/131862936473830809p/,
RequestStats: rnRequestStartTime: 2018-11-10T06:41:26.3320532Z,
Number of regions attempted: 1rn, SDK:
Microsoft.Azure.Documents.Common/2.1.0.0"","activityId":"d61226ab-4d5e-4a3d-aa09-83351649ce4c","substatus":413











share|improve this question























  • Possible duplicate of Cosmos DB out of Memory exception while executing stored procedure
    – Josh
    Nov 11 '18 at 23:18










  • Please refrain from asking the same question more than once with tweaks to the verbiage. This is the third time you’ve pasted the same code and asked about oversized responses.
    – Josh
    Nov 11 '18 at 23:21










  • Hi,Amjath,does my answer helps you?
    – Jay Gong
    Dec 3 '18 at 5:54













0












0








0







I am writing Azure Cosmos DB stored procedure in azure portal , I am checking the what is max size response it can give initially it gave me 4.8 MB response later on any size more that it was showing error of message size is too large . Later on after 5 min executed same procedure and same parameters it was showing error of too large page size.



 // SAMPLE STORED PROCEDURE
function sample(prefix)
var collection = getContext().getCollection();

// Query documents and take 1st item.
var isAccepted = collection.queryDocuments(
collection.getSelfLink(),
'SELECT r.data.truckSerialNo FROM root r',pageSize : -1,
function (err, feed, options)
if (err) throw err;

// Check the feed and if empty, set the body to 'no docs found', 
// else take 1st element from feed
if (!feed );

if (!isAccepted) throw new Error('The query was not accepted by the server.');



and error




Failed to execute stored procedure testProcedure for collection
iotcollection:
"code":400,"body":""code":"BadRequest","message":"Message:
\"Errors\":[\"Encountered exception while executing function.
Exception = Error: Resulting message would be too large because of
\\"Body\\". Return from script with current message and use
continuation token to call the script again or modify your
script.\r\nStack trace: Error: Resulting message would be too
large because of \\"Body\\". Return from script with current
message and use continuation token to call the script again or modify
your script.\n at validateSize (bulkUpsert_v_1_0.js:177:25)\n
at setValueInternal (bulkUpsert\"]rnActivityId:
d61226ab-4d5e-4a3d-aa09-83351649ce4c, Request URI:
/apps/59d3b9ef-17ca-4bbf-8a11-39d0199a8d29/services/1b26e00f-1f51-4d34-88ec-4090b8e7db00/partitions/45a313b7-2cf2-419e-9885-48bf9cfe6277/replicas/131862936473830809p/,
RequestStats: rnRequestStartTime: 2018-11-10T06:41:26.3320532Z,
Number of regions attempted: 1rn, SDK:
Microsoft.Azure.Documents.Common/2.1.0.0"","activityId":"d61226ab-4d5e-4a3d-aa09-83351649ce4c","substatus":413











share|improve this question















I am writing Azure Cosmos DB stored procedure in azure portal , I am checking the what is max size response it can give initially it gave me 4.8 MB response later on any size more that it was showing error of message size is too large . Later on after 5 min executed same procedure and same parameters it was showing error of too large page size.



 // SAMPLE STORED PROCEDURE
function sample(prefix)
var collection = getContext().getCollection();

// Query documents and take 1st item.
var isAccepted = collection.queryDocuments(
collection.getSelfLink(),
'SELECT r.data.truckSerialNo FROM root r',pageSize : -1,
function (err, feed, options)
if (err) throw err;

// Check the feed and if empty, set the body to 'no docs found', 
// else take 1st element from feed
if (!feed );

if (!isAccepted) throw new Error('The query was not accepted by the server.');



and error




Failed to execute stored procedure testProcedure for collection
iotcollection:
"code":400,"body":""code":"BadRequest","message":"Message:
\"Errors\":[\"Encountered exception while executing function.
Exception = Error: Resulting message would be too large because of
\\"Body\\". Return from script with current message and use
continuation token to call the script again or modify your
script.\r\nStack trace: Error: Resulting message would be too
large because of \\"Body\\". Return from script with current
message and use continuation token to call the script again or modify
your script.\n at validateSize (bulkUpsert_v_1_0.js:177:25)\n
at setValueInternal (bulkUpsert\"]rnActivityId:
d61226ab-4d5e-4a3d-aa09-83351649ce4c, Request URI:
/apps/59d3b9ef-17ca-4bbf-8a11-39d0199a8d29/services/1b26e00f-1f51-4d34-88ec-4090b8e7db00/partitions/45a313b7-2cf2-419e-9885-48bf9cfe6277/replicas/131862936473830809p/,
RequestStats: rnRequestStartTime: 2018-11-10T06:41:26.3320532Z,
Number of regions attempted: 1rn, SDK:
Microsoft.Azure.Documents.Common/2.1.0.0"","activityId":"d61226ab-4d5e-4a3d-aa09-83351649ce4c","substatus":413








azure-cosmosdb azure-cosmosdb-sqlapi






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 12 '18 at 7:56









Jay Gong

7,9461512




7,9461512










asked Nov 10 '18 at 7:30









Amjath Khan

488




488











  • Possible duplicate of Cosmos DB out of Memory exception while executing stored procedure
    – Josh
    Nov 11 '18 at 23:18










  • Please refrain from asking the same question more than once with tweaks to the verbiage. This is the third time you’ve pasted the same code and asked about oversized responses.
    – Josh
    Nov 11 '18 at 23:21










  • Hi,Amjath,does my answer helps you?
    – Jay Gong
    Dec 3 '18 at 5:54
















  • Possible duplicate of Cosmos DB out of Memory exception while executing stored procedure
    – Josh
    Nov 11 '18 at 23:18










  • Please refrain from asking the same question more than once with tweaks to the verbiage. This is the third time you’ve pasted the same code and asked about oversized responses.
    – Josh
    Nov 11 '18 at 23:21










  • Hi,Amjath,does my answer helps you?
    – Jay Gong
    Dec 3 '18 at 5:54















Possible duplicate of Cosmos DB out of Memory exception while executing stored procedure
– Josh
Nov 11 '18 at 23:18




Possible duplicate of Cosmos DB out of Memory exception while executing stored procedure
– Josh
Nov 11 '18 at 23:18












Please refrain from asking the same question more than once with tweaks to the verbiage. This is the third time you’ve pasted the same code and asked about oversized responses.
– Josh
Nov 11 '18 at 23:21




Please refrain from asking the same question more than once with tweaks to the verbiage. This is the third time you’ve pasted the same code and asked about oversized responses.
– Josh
Nov 11 '18 at 23:21












Hi,Amjath,does my answer helps you?
– Jay Gong
Dec 3 '18 at 5:54




Hi,Amjath,does my answer helps you?
– Jay Gong
Dec 3 '18 at 5:54












1 Answer
1






active

oldest

votes


















0














Per my experience, pageSize : -1 setting is not recommanded strongly when your data is too huge in cosmos db query operation. Continuation token(namely x-ms-continuation-token in cosmos db rest api) need to be considered into your business. Please refer to my previous case:CosmosDB stored procedure not returning all documents.



As you said, later on after 5 min executed same procedure and same parameters it was showing error of too large page size. The size limit is total response which including other Response Headers,not only the body part. In addition, the query operation returns maximum results based on current performance if you set pageSize : -1. It's not fixed.






share|improve this answer




















    Your Answer






    StackExchange.ifUsing("editor", function ()
    StackExchange.using("externalEditor", function ()
    StackExchange.using("snippets", function ()
    StackExchange.snippets.init();
    );
    );
    , "code-snippets");

    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "1"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53236915%2fsame-azure-cosmos-db-one-time-it-runs-other-time-shows-message-size-is-too-large%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Per my experience, pageSize : -1 setting is not recommanded strongly when your data is too huge in cosmos db query operation. Continuation token(namely x-ms-continuation-token in cosmos db rest api) need to be considered into your business. Please refer to my previous case:CosmosDB stored procedure not returning all documents.



    As you said, later on after 5 min executed same procedure and same parameters it was showing error of too large page size. The size limit is total response which including other Response Headers,not only the body part. In addition, the query operation returns maximum results based on current performance if you set pageSize : -1. It's not fixed.






    share|improve this answer

























      0














      Per my experience, pageSize : -1 setting is not recommanded strongly when your data is too huge in cosmos db query operation. Continuation token(namely x-ms-continuation-token in cosmos db rest api) need to be considered into your business. Please refer to my previous case:CosmosDB stored procedure not returning all documents.



      As you said, later on after 5 min executed same procedure and same parameters it was showing error of too large page size. The size limit is total response which including other Response Headers,not only the body part. In addition, the query operation returns maximum results based on current performance if you set pageSize : -1. It's not fixed.






      share|improve this answer























        0












        0








        0






        Per my experience, pageSize : -1 setting is not recommanded strongly when your data is too huge in cosmos db query operation. Continuation token(namely x-ms-continuation-token in cosmos db rest api) need to be considered into your business. Please refer to my previous case:CosmosDB stored procedure not returning all documents.



        As you said, later on after 5 min executed same procedure and same parameters it was showing error of too large page size. The size limit is total response which including other Response Headers,not only the body part. In addition, the query operation returns maximum results based on current performance if you set pageSize : -1. It's not fixed.






        share|improve this answer












        Per my experience, pageSize : -1 setting is not recommanded strongly when your data is too huge in cosmos db query operation. Continuation token(namely x-ms-continuation-token in cosmos db rest api) need to be considered into your business. Please refer to my previous case:CosmosDB stored procedure not returning all documents.



        As you said, later on after 5 min executed same procedure and same parameters it was showing error of too large page size. The size limit is total response which including other Response Headers,not only the body part. In addition, the query operation returns maximum results based on current performance if you set pageSize : -1. It's not fixed.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 12 '18 at 8:10









        Jay Gong

        7,9461512




        7,9461512



























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53236915%2fsame-azure-cosmos-db-one-time-it-runs-other-time-shows-message-size-is-too-large%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            𛂒𛀶,𛀽𛀑𛂀𛃧𛂓𛀙𛃆𛃑𛃷𛂟𛁡𛀢𛀟𛁤𛂽𛁕𛁪𛂟𛂯,𛁞𛂧𛀴𛁄𛁠𛁼𛂿𛀤 𛂘,𛁺𛂾𛃭𛃭𛃵𛀺,𛂣𛃍𛂖𛃶 𛀸𛃀𛂖𛁶𛁏𛁚 𛂢𛂞 𛁰𛂆𛀔,𛁸𛀽𛁓𛃋𛂇𛃧𛀧𛃣𛂐𛃇,𛂂𛃻𛃲𛁬𛃞𛀧𛃃𛀅 𛂭𛁠𛁡𛃇𛀷𛃓𛁥,𛁙𛁘𛁞𛃸𛁸𛃣𛁜,𛂛,𛃿,𛁯𛂘𛂌𛃛𛁱𛃌𛂈𛂇 𛁊𛃲,𛀕𛃴𛀜 𛀶𛂆𛀶𛃟𛂉𛀣,𛂐𛁞𛁾 𛁷𛂑𛁳𛂯𛀬𛃅,𛃶𛁼

            Crossroads (UK TV series)

            ữḛḳṊẴ ẋ,Ẩṙ,ỹḛẪẠứụỿṞṦ,Ṉẍừ,ứ Ị,Ḵ,ṏ ṇỪḎḰṰọửḊ ṾḨḮữẑỶṑỗḮṣṉẃ Ữẩụ,ṓ,ḹẕḪḫỞṿḭ ỒṱṨẁṋṜ ḅẈ ṉ ứṀḱṑỒḵ,ḏ,ḊḖỹẊ Ẻḷổ,ṥ ẔḲẪụḣể Ṱ ḭỏựẶ Ồ Ṩ,ẂḿṡḾồ ỗṗṡịṞẤḵṽẃ ṸḒẄẘ,ủẞẵṦṟầṓế