Skip to content

Updating NLS_DATE_FORMAT config for Analytics #9023

@lkokila

Description

@lkokila

Current Limitation

NLS_DATE_FORMAT should be configured as 'RRRR/fmMM/fmDD' since some Oracle versions result in errors (refer to below) without this.

`ERROR {io.siddhi.core.aggregation.persistedaggregation.CudStreamProcessorQueueManager} - Error occurred while executing the aggregation for data between 1712534400000 - 1712620800000 for duration DAYS. Attempted re-executing the query for 9 seconds. This Should be investigated since this will lead to a data mismatch
io.siddhi.core.exception.SiddhiAppRuntimeException: Error in manipulating records from datasource 'APIM_ANALYTICS_DB': ORA-01830: date format picture ends before converting entire input string

https://docs.oracle.com/error-help/db/ora-01830/
	at io.siddhi.extension.execution.rdbms.CUDStreamProcessor.process(CUDStreamProcessor.java:248)
	at io.siddhi.core.query.processor.stream.StreamProcessor.processEventChunk(StreamProcessor.java:41)
	at io.siddhi.core.query.processor.stream.AbstractStreamProcessor.process(AbstractStreamProcessor.java:132)
	at io.siddhi.core.aggregation.persistedaggregation.CudStreamProcessorQueueManager.run(CudStreamProcessorQueueManager.java:66)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.BatchUpdateException: ORA-01830: date format picture ends before converting entire input string

Refer internal: https://github.com/wso2-enterprise/wso2-apim-internal/issues/5980

Suggested Improvement

Better to update [1] with this information.
[1] https://apim.docs.wso2.com/en/4.0.0/use-cases/streaming-usecase/summarizing-data/

Version

3.2.0

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions