Analytics did not extract the complete report

[sudeshjaiswal]

Use Case

For a report that has more than 50000 lines, when a user wanted to extract the Excel file, the file was truncated to 50000 lines/rows.

Scenario: We observed that the report that is extracted in excel from the analytics page was seeing only 50K records although the actual number of records was around 65K.

 Error logs: Following messages were observed in the logs -  

 eName:analytics, zipfilename:V2___Full_WW_Identities_10Jul2020, createdate:Fri Jul 10 13:38:26 UTC 2020, dir:/opt/sharedappdrive/saviynt/reports/Tarek.MEHDI@globalservs

.com/analytics/2020-07-10_133826, JOB_INVOKED:Y, noOfRecordsinOneSheet:50000, fileprefix:V2___Full_WW_Identities_10Jul2020,

Pre-requisites

N/A

Applicable Version(s)

All

Solution

Reviewed the externalconfig/properties file,

Resolution: Update the below Configuration parameter in the externalconfig.properties file to 75000.

noOfRecordsinOneSheet= <total-no-of-records>  

For e.g. noOfRecordsinOneSheet=75000
 

Cause: The noOfRecordsinOneSheet parameter was set to 50000 hence 50000 records were getting displayed.

References
https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter17-EIC-Analytics/Managing-An... 

[Manu269]

@sudeshjaiswal Is there any limit range that can be specified?

[sudeshjaiswal]

Hello @Manu269,

To ensure the appropriate limits are set, it's crucial to confirm the file format for the downloaded data, whether it's in CSV or XLSX format. Additionally, it's essential to verify the maximum number of rows supported by the file format and set the limits accordingly.

To prevent adverse impacts on system performance, it's advisable to keep the limit at or below 100,000 rows.

Thanks,

[Manu269]

@sudeshjaiswal quick question, is this feature also applicable for SOD Workbench Reports (L1/L2,L3 Reports) and SOD Simulations Reports?

Also does this configs works on SSM v5.x and v3.x version?