You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have an error since I'm trying to link one issue to KR.
My error is:
There was a SQL exception thrown by the Active Objects library: Database: - name:Oracle - version:Oracle Database 19c Enterprise Edition Release 188.8.131.52.0 - Production - minor version:0 - major version:19 Driver: - name:Oracle JDBC driver - version:184.108.40.206.0 java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
by reviewing the log file I found OKR plugin generates one SELECT command that has one WHERE clause with more than 1000 numbers in IN condition:
SELECT ....... FROM ........ ....... WHERE OBJECTIVE."ISS" = :1 AND OBJECTIVE."DELETED" = 0 AND (OBJECTIVE."ID" in (20,71,79,92,93,105, ........... ,1683,1684,1687)
How can I solve my problem?