We found out that this is an Oracle SQL limitation. The IN statement in SQL only allows a max of 1000 values.
Related Articles
- How do I modify the Yellowfin startup settings?
- How do I manage and setup LDAP groups in Yellowfin?
- How do I filter the list of groups returned from LDAP groups within Yellowfin?
- Changing the default scheduled task to synchronize LDAP groups & users in Yellowfin?
- How do I enable the Tomcat Management Console?
- With Multicast licensing, is it possible to restrict the users to Broadcast reports to non YF users (unlicensed users)?
- What is a JSON Data Type and Does Yellowfin Support it?
- Our broadcasts are still running even though we've deleted the Client Org that they were created within?
- Stacktrace error is missing from Yellowfin log file?
- Connection Error occurred selecting data: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
- ORA-01017 error when connecting to Oracle database!
- "Failed to load values error - too many prompt values" displayed when running report
- What are all the Yellowfin log files and how is logging handled within the system?
- How to add a new JDBC driver for use in Yellowfin
- How to reset ANY Yellowfin user password by accessing ResetAdmin.jsp
- How do I change my user session timeout setting within Yellowfin?
- Is there a way to configure a Google BigQuery to only retrieve data from a specified Namespace?
- How do I backup and recover my Yellowfin database or export specific items from my database?
- How can I delete a tag in the database?
- How can I use the SQL Server Reporting Services (SSRS) functionality?
- How do I connect Yellowfin to a Hive Server 2 configuration?
- How do I provision the default user roles in Yellowfin?
- Is it possible for Yellowfin to interface with Active Directory for authentication?
- Is it possible to change the currency format to European standards?
- How do I turn on debug logging within Yellowfin?
- How can I turn on or off 'Ask' when multiple sessions are detected so we stop receiving 'Cannot log in from multiple hosts' errors message?
- How can I reduce or shrink the size of our Yellowfin log file?
- Can reports created in JasperSoft iReports or BIRT be uploaded to Yellowfin?
- How do multiple clients run the same report with different data sources?
- How can I access my report created in Yellowfin from the web?
- What is the difference between Same and Default row shading?
- Is there a way to limit the file size of the std.out or the catalin.out files?
- What are the ways I integrating or emdedding Yellowfin into a custom application or webpage?
- How to change Yellowfin's Java Path - WINDOWS
- What is the Yellowfin repository DB used for?
- Moving the JDBC ODBC bridge from Java 7 to Java 8
- Struts Related Startup Error in Yellowfin July 2016 Builds
- Connecting to the Yellowfin Repository DB (web.xml settings)
- how to turn on DEBUG logging for individual classes
- How to add new JDBC Drivers?
- How to disable the scroll bar on dashboard portlets
- How to add/remove/configure the Yellowfin Windows Service
- How to Upgrade Tomcat
- deploying YF 7.2 + into Weblogic - Failed to compile JSP
- Can Yellowfin scale?
- Can we rebrand Yellowfin to look like our product? How far can we really take this?
- Our database is huge, will Yellowfin be able to handle it?
- How do I integrate Yellowfin with my application?
- Why is my Yellowfin Database so large, and what can I do about it?
- How to export/import reports based off of CSVs
- How to take a clients Yellowfin folder, and have it start on your machine
- What is Yellowfin's 'info.jsp' Page?
- How to configure the Background Task Runner queue sizes
- Cannot find Views in Admin console in 7.35?
- Active Directory Federation Services (ADFS) and the Yellowfin SAML bridge
- How to Change Yellowfin's Default Listening Port
- LDAP Groups and Client Orgs
- How to limit the size of the Event tables
- How do I manage the health and adoption of my Yellowfin system?
- Setting Default Dashboard Tabs
- Queries to help reduce a huge Yellowfin DB by only keeping most recent 5 versions of reports
- Supported Languages
- Connecting to a database on Microsoft Azure via JDBC
- Minimum Database permissions required for Yellowfin Repository Database
- Bulk User Export Query
- How Access Filters work from a SQL perspective
- How to Reset Password in Amazon EC2 Yellowfin Instance
- Enabling nested LDAP group functionality in Yellowfin
- Yellowfin University - Access/Account Troubleshooting
Properties
Author
Lee Roquet