request entity too large

[Tristan-bash]

Hi everyone
the spreadsheetuploader works in my projects, but has some limitations.
If i try to upload a .xlsx file with the size of 82,5 kB and 1.600 entries in it i get the following error:

Log-dbg.js:497 2025-03-05 12:49:13.340600 Error while calling the odata service - Error: request entity too large SpreadsheetUpload: callOdata 
 Error: request entity too large
    at Object.createError (_Helper-dbg.js:609:15)
    at Object.<anonymous> (_Requestor-dbg.js:2088:24)
    at Object.<anonymous> (jquery-compat-dbg.js:725:30)
    at u (jquery-dbg.js:3500:31)
    at Object.fireWith [as rejectWith] (jquery-dbg.js:3630:7)
    at k (jquery-dbg.js:9913:14)
    at XMLHttpRequest.<anonymous> (jquery-dbg.js:10172:9)
    
    
    

    
    [odata] [INFO] POST /odata/v4/manage-campaigns/$batch 
[cds] [WARN] PayloadTooLargeError: request entity too large
    at readStream (/home/user/projects/cs-sls_field_campaigns/node_modules/raw-body/index.js:163:17)
    at getRawBody (/home/user/projects/cs-sls_field_campaigns/node_modules/raw-body/index.js:116:12)
    at read (/home/user/projects/cs-sls_field_campaigns/node_modules/body-parser/lib/read.js:79:3)
    at textParser (/home/user/projects/cs-sls_field_campaigns/node_modules/body-parser/lib/types/text.js:86:5)
    at odata_batch (/home/user/projects/cs-sls_field_campaigns/node_modules/@sap/cds/libx/odata/middleware/batch.js:566:14)
    at Layer.handle [as handle_request] (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/route.js:149:13)
    at Route.dispatch (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/route.js:119:3)
    at Layer.handle [as handle_request] (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/layer.js:95:5)
    at /home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:284:15
    at Function.process_params (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:346:12)
    at next (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:280:10)
    at odata_streams (/home/user/projects/cs-sls_field_campaigns/node_modules/@sap/cds/libx/odata/ODataAdapter.js:74:20)
    at Layer.handle [as handle_request] (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/layer.js:95:5)
    at trim_prefix (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:328:13)
    at /home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:286:9
    at Function.process_params (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:346:12)
    at next (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:280:10)
    at odata_parse_url (/home/user/projects/cs-sls_field_campaigns/node_modules/@sap/cds/libx/odata/middleware/parse.js:8:48)
    at Layer.handle [as handle_request] (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/layer.js:95:5)
    at trim_prefix (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:328:13)
    at /home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:286:9
    at Function.process_params (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:346:12)
    at next (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:280:10)
    at odata_version (/home/user/projects/cs-sls_field_campaigns/node_modules/@sap/cds/libx/odata/ODataAdapter.js:60:11)
    at Layer.handle [as handle_request] (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/layer.js:95:5)
    at trim_prefix (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:328:13)
    at /home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:286:9
    at Function.process_params (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:346:12)
    at next (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:280:10)
    at http_log (/home/user/projects/cs-sls_field_campaigns/node_modules/@sap/cds/lib/srv/protocols/http.js:42:59)
    at Layer.handle [as handle_request] (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/layer.js:95:5)
    at trim_prefix (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:328:13)
    at /home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:286:9
    at Function.process_params (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:346:12)
    at next (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:280:10)
    at Function.handle (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:175:3)
    at router (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:47:12)
    at Layer.handle [as handle_request] (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/layer.js:95:5)
    at trim_prefix (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:328:13)
    at /home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:286:9
    at Function.process_params (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:346:12)
    at next (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:280:10)
    at basic_auth (/home/user/projects/cs-sls_field_campaigns/node_modules/@sap/cds/lib/auth/basic-auth.js:12:73)
    at Layer.handle [as handle_request] (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/layer.js:95:5)
    at trim_prefix (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:328:13)
    at /home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:286:9
    at Function.process_params (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:346:12)
    at next (/home/user/projects/cs-sls_field_campaigns/node_modules/express/lib/router/index.js:280:10)
    at AsyncLocalStorage.run (node:async_hooks:346:14) {
  expected: 1352691,
  length: 1352691,
  limit: 102400,
  type: 'entity.too.large'
}
[error] [WARN] 413 > { message: 'request entity too large', code: '413' }

Ive seen that you tested with ~10.000 entries, so the importer should handle this.
I ve already seen the batchSize and tried greater sizes. but the error is still the same.

Any suggestions?

Thanks in advance

[Tristan-bash]

Figured it out by myself:
you need to setup your package.json-file.
Add the following line to increase limit of the request size

	},
	"cds": {
    "server": {
      "body_parser": {
        "limit": "10mb" 
      }
    }

[marianfoo]

Good to know, i think i had the same error with CAP, you can also set the batchSize Parameter to a lower number

[marianfoo]

@Tristan-bash
again, thank you for debugging, i added a section in the docs:
https://docs.spreadsheet-importer.com/pages/GettingStarted/#handling-large-file-uploads-in-cap