Updating NLS_DATE_FORMAT config for Analytics
Nobody has claimed this yet.
- Dominant language
- CSS
- Stars
- 99
- Forks
- 708
- Avg merge
- 1d 7h
- Merged PRs (30d)
- 22
Description
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
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Open the linked summarizing-data documentation page and locate the configuration guidance for the Analytics database. Review the Oracle date-format error and the suggested NLS_DATE_FORMAT value from the issue, then verify that the page clearly explains the required configuration and its purpose.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- documentation
- Issue type
- Documentation
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 50/100