Root cause ORA -01795

[Former Member]

Hi, I trace the root cause for the following error ORA message : ORA-01795 Maximum  number of expression 1000 and this is the result :

**ERROR: QT_LocalServer:Unsupported operator for data provider reference [sql/SQL_Prompt.cpp;1568]

can some one explain me more about   "[sql/SQL_Prompt.cpp;1568] " ?

[Former Member]

Dear Foued,

The error message ORA -01795 can be caused by the following reasons:

1. Webi Processing Server setting: "List of Value Batch Size" is small than
   1000.
2. Data base limitation: Query result reached Oracle limitation -Generate more
   than 1000 items.

Kind regards,

Wafa

[Former Member]

thanks wafa , Did u mean that i have to increase the value showen in the screen ?