Skip to Content
0
Jan 25 at 05:33 PM

Bo4.2--error ORA-01795

79 Views

Hello,

I work with Sap Bo 4.2 Sp7.

I have two queries:

1- "SDT request" which returns 4400 lines/Id Resources

2- "DispoRess" request, in which I have the filter on Resource Id reported by the 1st SDT request.

image.png

When executing these Bo queries, I got the following error message:

"The following database error occurred: ORA-01795: the maximum number of expressions allowed in a list is 1000"

Is there a solution so that the 4400 resources uploaded from the 1st SDT request are all integrated into the filter of the 2nd "DispoRess" request?

Thanks in advance.

Regards

Attachments

image.png (19.5 kB)