Encountering an error in Report Fiori List via CAP CDS annotaions during Excel export

[amallari]

Hello Experts,

I have created a report fiori list application that contains more than 1000 records. I did not do any configuration related to the export since this was automatic when I created an app based on the template. However, when I export the table, I encounter this error:

I noticed this only happens when there are more than 1000 rows to be exported. Any ideas how to fix this?

[amallari]

Hello Experts,

Upon rechecking, we are encountering the problem when exporting more than 5500 rows.

[junwu]

need more detail error msg

probably call stack....

[amallari]

Hi Junsu,

Here are the details:

2023-03-29T09:31:43.875+0000 [APP/PROC/WEB/0] STDOUT [cds] - POST /catalog//$batch

2023-03-29T09:31:43.878+0000 [APP/PROC/WEB/0] STDOUT [cds] - > READ xxxRxxxUI {

2023-03-29T09:31:43.878+0000 [APP/PROC/WEB/0] STDOUT '$count': 'true',

2023-03-29T09:31:43.878+0000 [APP/PROC/WEB/0] STDOUT '$select': 'bxxxEndDate,bxxxRequestDate,bxxxStartDate,sxxxXxxxCode,sxxxExxxSxxxId,sxxxId,sxxxName,sxxxXxxId1,sxxxXxxId2,sxxxXxxId3',

2023-03-29T09:31:43.878+0000 [APP/PROC/WEB/0] STDOUT '$skip': '0',

2023-03-29T09:31:43.878+0000 [APP/PROC/WEB/0] STDOUT '$top': '1200',

2023-03-29T09:31:43.878+0000 [APP/PROC/WEB/0] STDOUT '$skiptoken': '1000'

2023-03-29T09:31:43.878+0000 [APP/PROC/WEB/0] STDOUT }

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR [cds] - Error: Cannot set parameter at row: 1. Wrong input for BIGINT type

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at next (/home/vcap/app/node_modules/hdb/lib/protocol/ExecuteTask.js:175:19)

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at ExecuteTask.getParameters (/home/vcap/app/node_modules/hdb/lib/protocol/ExecuteTask.js:189:3)

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at ExecuteTask.sendExecute (/home/vcap/app/node_modules/hdb/lib/protocol/ExecuteTask.js:196:8)

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at execute (/home/vcap/app/node_modules/hdb/lib/protocol/ExecuteTask.js:73:10)

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at ExecuteTask.run (/home/vcap/app/node_modules/hdb/lib/protocol/ExecuteTask.js:115:3)

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at run (/home/vcap/app/node_modules/hdb/lib/util/Queue.js:96:12)

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at next (/home/vcap/app/node_modules/hdb/lib/util/Queue.js:85:7)

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at receive (/home/vcap/app/node_modules/hdb/lib/util/Queue.js:114:5)

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at Connection.receive (/home/vcap/app/node_modules/hdb/lib/protocol/Connection.js:385:3)

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR at TLSSocket.ondata (/home/vcap/app/node_modules/hdb/lib/protocol/Connection.js:243:12) {

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR query: `SELECT bxxxEndDate AS "bxxxEndDate", bxxxRequestDate AS "bxxxRequestDate", bxxxStartDate AS "bxxxStartDate", sxxxXxxxCode AS "sxxxXxxxCode", sxxxExxxSxxxId AS "sxxxExxxSxxxId", sxxxId AS "sxxxId", sxxxName AS "sxxxName", sxxxXxxId1 AS "sxxxXxxId1", sxxxXxxId2 AS "sxxxXxxId2", sxxxXxxId3 AS "sxxxXxxId3" FROM CatalogService_xxxRxxxUI ALIAS_1 ORDER BY sxxxId ASC LIMIT 1000 OFFSET ? with parameters ('LOCALE' = 'en')`,

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR values: [ '***' ],

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR id: '1581255',

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR level: 'ERROR',

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR timestamp: 1680082303890

2023-03-29T09:31:43.890+0000 [APP/PROC/WEB/0] STDERR }

[amallari · Accepted solution]

Hello,

In case anyone else is encountering the same problem, I was able to resolve it by adding this in the service CDS:

@cds.query.limit.max: 10000