Row Return Limit to 65535 Rows

general discussion
1

Morning All,

I’m using BO 5.1.8 and there seems to be an issue where reports are returning a row limit of 65535 rows but no partial result warning is displayed.

The reprocusions of this is that there is missing data rows and I need to know how to stop this from happening.

Many Thanks
Gordon :hb:

gordon_black :uk: (BOB member since 2008-05-30)

2

That sounds like the MS excel row limit.

Are you running the report to Excel?

Damocles :uk: (BOB member since 2006-10-05)

3

We have an add-in that allows the export to excel, I did realise that that was the row limit and did disable the add-in but still the same thing happens.

Many Thanks for your speedy response!

Gordon :hb:

gordon_black :uk: (BOB member since 2008-05-30)

4

If you create a similar report from scratch does it still limit the result set? Also are you certain there’s no limit in the universe?

Damocles :uk: (BOB member since 2006-10-05)

5

Hi,

I have recreated the report and still get the same row limit and there are no row limits set i.e. the check box is not checked, in the universe properties.

Hope this helps?

Many Thanks!!

gordon_black :uk: (BOB member since 2008-05-30)

6

I’m going to hazard a guess that someone has put a limit in somewhere, probably hard coded.

It may be time to get out the finest of your toothcombs and hunt.

Just what you need of a Monday morning.

Damocles :uk: (BOB member since 2006-10-05)

7

Check whether there is a limit imposed in the query itself, within the query panel.

This may have been done, in this reports case, to prevent too many rows been retrieved for Excel.

Mak 1 :uk: (BOB member since 2005-01-06)

8

this was a known issue in BO 5.1.8. cant recollect what the work around was. Are you using ZABO by any chance?

vparikh1 :india: (BOB member since 2003-02-20)

9

Check this solution

vparikh1 :india: (BOB member since 2003-02-20)

10

Hi All,

Thanks for the replies!!

I’ve looked in the query panel at the SQL that is written and there is no limit at that point.

We’re using the full client Business Objects app.

With regards to the solution posted, I’ve lokked at the ODBC.SBO file but am unsure where to enter the line - HardRefresh = 1 in the SBO file itself as it does not appear anywahere in the files contents.

If anyone can give me any advice on that, that would be great?

Many thanks for all you peoples time, it’s much appreciated!!

Gordon

gordon_black :uk: (BOB member since 2008-05-30)

11

You won’t see this in the SQL.

Go To DATA → Edit Data Provider → Options Button (bottom left) and heres where you can limit the result set to the desired no of rows.

Mak 1 :uk: (BOB member since 2005-01-06)

12

Can you add that entry HardRefresh = 1 in the odbc.sbo file and try. Hopefully the error should go away. Remember doing this a long time ago (2004-2005 timeframe)

vparikh1 :india: (BOB member since 2003-02-20)

13

Hi vparikh1,

At what point in the file do I add this line in?

I’ve added it to the Defaults section is this correct?

Many Thanks
Gordon

gordon_black :uk: (BOB member since 2008-05-30)

14

You can add it at the end of the file and save it. Let us know if this works. As I said earlier I had done this around 2005 timeframe.

vparikh1 :india: (BOB member since 2003-02-20)

15

Hi vparikh1,

This fix hasn’t sorted it. Also I have recreated the universe and still the limit continues.

How frustrating!!

Is there anything else I could try?

Many Thanks
Gordon

gordon_black :uk: (BOB member since 2008-05-30)

16

This is all I could recollect on the problem. What database are you using and wonder if there is another .sbo file that needs to be referred to?

vparikh1 :india: (BOB member since 2003-02-20)