[AMBARI-25632] Verify custom queries with "IN" clause for ORA-01795 issue

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.6.2, 2.7.3, 2.7.4, 2.7.5
• Fix Version/s: 2.8.0, 2.7.6
• Component/s: ambari-server
• Labels: oracle server sql
• Assignee: Tamas Payer
• Reporter: Tamas Payer
• Created: 15/Mar/21 13:10
• Updated: 28/Nov/22 14:25
• Resolved: 20/Apr/21 13:27

Description

Review all custom queries with "IN clause" if they are vulnerable by ORA-01795 issue. Approximate the possible max size of passed list in-to the query and in case of need apply wrapper to batch process the query.

Issue Links

• links to: GitHub PR#3298
• links to: GitHub PR#3585