SQL String can not be NULL error in MySQL DB

[Methma]

Description:
The following error observed in MySQL DB intermittently during the insert/update records.
TID: [-1] [] [2020-06-17 14:17:28,446] ERROR {org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor} - Dropping event chunk EventChunk{first=StreamEvent{timestamp=1592403368794, beforeWindowData=[null, null, null], onAfterWindowData=null, outputData=[null, null, null, null], type=TIMER, next=null}}, error in processing org.wso2.carbon.analytics.apim.siddhi.stream.processor.MarkovChainMatrixTimeBatchStreamProcessor, Error in adding records to analytics event table: Error in adding records: SQL String can not be NULL {org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor} java.lang.IllegalStateException: Error in adding records to analytics event table: Error in adding records: SQL String can not be NULL

This is occurring due to the following configurations are missing for the MySQL database in the <DAS_HOME>/repository/conf/analytics/rdbms-config.xm file.

<recordInsertQuery>INSERT INTO {{TABLE_NAME}} (partition_key, timestamp, data, record_id) VALUES (?, ?, ?, ?)</recordInsertQuery> <recordUpdateQuery>UPDATE {{TABLE_NAME}} SET partition_key = ?, timestamp = ?, data = ? WHERE record_id = ?</recordUpdateQuery>

Suggested Labels:
das

Affected Product Version:
wso2das-3.1.0

OS, DB, other environment details and versions:
MySQL DB

Steps to reproduce:
This is an intermittent issue. The above fix has been verified by providing a preQA fix.