It appears that as long as there are more than 1000 reports in the report library Category/Domain, when we execute the getContentInfoList web service call on the
LibraryContentManagerWS we get:
SQL exception: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

1000 expressions is a common limit for a lot of SQL DBMS WHERE statements.

I'd open a case with IBI - they may be able to change the code for the getContentInfoList web service.

Like perhaps using SQL something like this:

SELECT * FROM table1 WHERE col1 IN
(SELECT col2 FROM table2) 

where table2 is a temporary table containing a set of values - pure speculation.

Thanks Francis.
I'd rather they create a SQL statement like:
SELECT * FROM table1 WHERE col1 = "Category name"
I don't suppose you are aware of any work arounds?

I think this works:

SELECT * FROM table1 WHERE (col1 in ("a", "b",... up to 1000 entries)( or (col1 in ("zq", "zr",... up to 1000 entries))

David/Francis,

We are aslo facing the same problem. Any updates on this issue?