Give me a approach for exceeds lines in excel

Question

Waiting Time: 0.9 seconds

Data Fetch Time: 2.4 minutes

Total Execution Time: 5.4 minutes

Job Priority: Normal

Output failed.

[INSTANCE_ID=bip.bi_serverHA] [OUTPUT_ID=358226] oracle.xdo.XDORuntimeException: Your data is more than 65531 rows in a sheet, which exceeds Microsoft Excel (.xls) limitation. Stop processing. Suggest to turn on Excel Template Scalable Mode to true from Runtime Properties.

[INSTANCE_ID=bip.bi_serverHA]

Gianni Ceresa · Answer

@User_9BUCP ,

No need to post your question again, it has been moved to the Publisher category.

Harriet Huang-Oracle · Answer

Hi @User_9BUCP,

Please check below document and see if that helps.

Scheduled Job of BIP Report of Excel Template Failed by Error 'oracle.xdo.XDORuntimeExeption: Your data is more than 65531 rows in a sheet' (Doc ID 2982923.1)

Looks like this is BIP question, and actually this is forum for Oracle Business Intelligence product, so please post your question in BIP forum below to get better assistance if above document does not help.

https://community.oracle.com/products/oracleanalytics/categories/bi-publisher

Thank you!