Analytics report failure

[Bharath]

The analytics query that runs to determine the users list configured as a sql query under V2 analytics started failing last week, and when the report is triggered, we see it loading for a longer time and the end shows up a dialogue bog, with only the word "Error."

When we observed the logs, we could see below entries.

result size after query execution 186919
Inside bulkRequestForBatchCount() for adding Document Size .... 186919
DEBUG services.SaviyntElasticService - elastic Index batchsize: 7500
DEBUG services.SaviyntElasticService - unable to set batchsize from config due to For input string: "[:]".. setting to default.
DEBUG services.SaviyntElasticService - bulkrequestmaxsize =25000000
DEBUG services.SaviyntElasticService - batch size met. write to elastic
7500 Data stored using bulk request..
DEBUG services.SaviyntElasticService - batch size met. write to elastic
DEBUG auth.LoginController - Default Setup
DEBUG auth.LoginController - URL TO SAML

the report is stuck processing 7500 records and it is not proceeding further. Any idea?

[pruthvi_t]

Hi @Bharath ,

Did you see anything specific printed in logs at the time of the error. From the snippet provided, if there is no log printed after that, then it would be ideal to raise an FD ticket with all the corresponding details so that our support engineers can analyze further on what's causing the issue.

Also, please check the below documentation to check if the configuration of the analytics control is configured as per the mentioned guidelines.

https://docs.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Chapter16-SSM-Analytics/Analytics-P...

Thanks,

[dgandhi]

Hi,

Is the elastic service up and running when you were trying to run the analytics report?

Thanks

Devang

[rushikeshvartak]

# Analytics v2 config for inserting data into ElasticSearch Refer SD-6273 for more details
analyticsindexbatchcount=7500

Change above config in externalconfig.properties