topic Direct query - Direct Discovery - Error in QlikView

Direct query - Direct Discovery - Error

Mon, 01 Jun 2015 14:01:11 GMT

Hi All,

I am using direct query in one of my Qlik applications, but i am getting the below error

ErrorSource: OraOLEDB, ErrorMsg: ORA-01795: maximum number of expressions in a list is 1000

When i am selecting the filters to populate the table through Direct discovery.

Any help would be highly appreciated.

Thanks..

Re: Direct query - Direct Discovery - Error

Mon, 01 Jun 2015 14:07:10 GMT

Please post the query

Re: Direct query - Direct Discovery - Error

Vegar — Mon, 01 Jun 2015 18:07:13 GMT

You are sending to many values into your automatic generated sql where statement. Oracle have a limit on 1000 values in is where statement and you are sending.

WHERE

Field IN value1, value2, ..., value1000, value 1001 etc.

Try limit the number of values in your D discovery. Maybe you could use a dimension and not a transaction key?