BusinessObjects Board

Too many selected values (LOV0001) SQL Generated is too long

building reports desktopintelligence
#1

I’m stuck in situation where i have pull out some records in report by linking one excel sheet to it.The sheet contains around 30K records.When i’m trying to apply condition on the report to pull out records present only in excel sheet it gives error as “SQL generated is too long”…

At universe level
MAX_INLIST_VALUES is 99999

Can nebudy tell me what is the limit for using InList condition.
Also
Is der ne other way to do this??

Thnxx in advance. :? [/img]

chitra :india: (BOB member since 2008-08-20)

#2

This link has a discussion about what you are asking.

Also have a look into the page no. 204 of this

Jansi :india: (BOB member since 2008-05-12)

#3

Hi

Have a look on the link…

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

#4

Thnx for your replies…

chitra :india: (BOB member since 2008-08-20)

#5

Did you get rid of your problems? If yes, how? Post please…

Jansi :india: (BOB member since 2008-05-12)

#6

As per the link provided…
in my case MAX_INLIST_VALUES parameter value is set to 99999

still it is giving the same error… :hb:

chitra :india: (BOB member since 2008-08-20)

#7

That setting may allow the SQL to TRY to generate with all of the values, but even if the SQL was short enough (<64k, unless you change another parameter), your database probably has a much smaller limit. For example, Oracle will allow a maximum of 1,000 values for an IN () operator.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#8

Thanx Dwayne…

I want to compare some 4K-5K entries from excel sheet against the entries in database(more than 500,000)…

Is there any other way to do this…

chitra :india: (BOB member since 2008-08-20)

#9

One approach is discussed here … Create an InList from an Excel spreadsheet. You’ll need to “OR” several together if you can only do 1,000 at a time.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)