This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- FlexNet Operations
- :
- FlexNet Operations Knowledge Base
- :
- Entitlement listing is no longer possible if the line item count exceeeds 1000
Subscribe
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Entitlement listing is no longer possible if the line item count exceeeds 1000
Entitlement listing is no longer possible if the line item count exceeeds 1000
Summary
Entitlement listing is no longer possible if the line item count exceeds 1000. The query to see all the line items for an entitlement on the entitlement landing page, produces an error. "ORA-01795: maximum number of expressions in a list is 1000"Symptoms
- Entitlement listing is no longer possible if the line item count exceeds 1000.
- The query to see all the line items for an entitlement on the entitlement landing page, produces the following error: "ORA-01795: maximum number of expressions in a list is 1000"
- The SQL command executing in this case is : SELECT (fields) FROM [table] WHERE [field] IN (query/list)
Cause
This is a constraint from within Orcale itself, the "IN" clause can't fetch records of count >1000. But there are ways to resolve this.
The following URL shows how you can achieve this: http://stackoverflow.com/questions/400255/how-to-put-more-than-1000-values-into-an-oracle-in-clause
The following URL shows how you can achieve this: http://stackoverflow.com/questions/400255/how-to-put-more-than-1000-values-into-an-oracle-in-clause
Setting the Line item page Size per Entitlement to "-1", leads to displaying all the line items present for the entitlement. If the count is >1000, then this leads to the error.
Workaround
1) Set the Line item page Size per Entitlement to a value(<1000).
2.) Add some code, just before execution of the query, similar to this:
if (param == -1 || param > 1000) {
param = 1000;
}
execute_query(querystring);
No ratings