wso2 / wso2/docs-apim

Updating NLS_DATE_FORMAT config for Analytics

Open
#9,023 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Type/Improvement
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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.