Post reply

Limit Records to Clients

  • October 24, 2011 at 10:35 am

    #250598

    I have an SQL 2008 R2 System, with a Java front end. I am only having the following problem at One location, and have several of these systems out there (about 50) that are setup just like this.

    I run a report within the Java front end on a client machine connecting into the SQL DB, and receive a message:

    There are 5783 records for this report, please reduce the report to less than 5000 records.

    I run the exact same report, from the exact same software version from the server (where the SQL DB is located) and I have no problems at all. I believe I have seen a problem like this before in the past, but don't recall how it was resolved. I am trying to locate in SQL where this limit maybe set. I'm guessing it has something to do with the SQL Browser and connecting to the DB though the network.

    Any help or even direction to look is much appreciated.

    Thanks

    LD

  • October 24, 2011 at 10:42 am

    #1398806

    Never seen this in any standard installs.

    The only remotely possible explaination I can find is this => http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx#_Toc264017709

  • October 24, 2011 at 11:40 am

    #1398827

    I saw this page, but didn't think much of it. I am checking with my customer to verify they don't have a SharePoint server, and I was mistaken on the front end of this application. We are using .NET for the front end.

    Any other ideas or directions?

    Thanks

    LD

  • October 24, 2011 at 11:44 am

    #1398829

    Nope.

    Never seen this other than something manually coded in the application.

  • October 24, 2011 at 11:49 am

    #1398831

    SQL has no such limitations or errors. If you ask it for a million rows, it'll send you a million rows. Has to be something, some setting, in the front end or data access library (most likely front end)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 24, 2011 at 12:35 pm

    #1398850

    It's either in SQL stored procedure or in Java app. To find a sp which contains this text you can use something like this:

    select OBJECT_SCHEMA_NAME(object_id) +'.'+ OBJECT_NAME(object_id), definition

    from sys.sql_modules where definition like '%There are % records for this report, please reduce the report to less than % records%'

    Alex Suprun

  • October 25, 2011 at 10:47 am

    #1399226

    How are you using .NET to connect for this report? LINQ? Or ODBC?

    Also, is the report an SSRS report or HTML? Or something else? (The settings are probably here in the connection to the report)

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • October 25, 2011 at 2:30 pm

    #1399311

    Thanks everyone for your help, but it helps to know everything your user is doing. I guess they were also trying to Graph the data as well, and we do have a hard code on that. When I originally asked for all the steps they were preforming, they insisted they were just running the report.

    Thanks again

    LD

  • October 25, 2011 at 2:33 pm

    #1399317

    Ahh yes... PEBCAC and a ID-10T error 🙂

    Jared

    Jared
    CE - Microsoft

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply