8 Replies · Latest reply on Jan 4, 2018 8:38 AM by Michael Ritchie

    Has Jakarta placed a limit on the length of reports?

      I have several reports which contain a (relatively) large number of lines.

      Recently, we upgraded to Jakarta Patch 4 and the reports come back with this error:

       

      Now a "full report" wojudl have a total number of lines  of about 1,400.  So I am NOT bumping up on the 10,000 limit.

      Has anyone else run into this?

      -----
      Always remember that you are absolutely unique. Just like everyone else.

        • Re: Has Jakarta placed a limit on the length of reports?
          Michael Ritchie

          I am not aware of any changes.  What type of report is this?  Where are you seeing this error message?

           

          I would also suggest navigating to sys_properties.list and search for name contains "limit" to see if you have any set at 1000 that shouldn't be that relate to exporting.


          Please mark this post or any post helpful or the correct answer so others viewing can benefit.

            • Re: Has Jakarta placed a limit on the length of reports?
              Steve Driscoll (OCLC)

              Hello Michael,

               

              Thank you for the quick reply.  The report is a list report of all active records in a simple, custom table, which does NOT extend any other table.

              The funny thing is that the report is limited to 1,000 rows when it runs as a scheduled job which sends the report via email.

              When I run the report in the UI, I get all the records.  It turns out that there are about 4,000 records.  Still way short of the 10,000 limit.

               

              I also took your advice and checked for sys_properties with a value of "1000" and found a possible clue:

              The property is com.snc.apps.publish.maxrows

              The comments for this property are:    "Maximum number of records included from each table in an application when the application is published with the Include Data option"

               

              So it's not a slam dunk, but it is a lead.  I'll get back to this thread with an update when I know more.

               

              EDIT: This is a follow up.  I increased the value of com.snc.apps.publish.maxrows to 2,000 and ran the scheduled job to generate the report.

              The report is still limited to 1,000 lines.  No improvement was seen.  Sigh...

                • Re: Has Jakarta placed a limit on the length of reports?
                  Michael Ritchie

                  Steve,

                  I don't believe that property is it unfortunately.  When you export an application you are prompted if you want to export demo data and that sets the limit on the number of records.

                   

                  When you say you email the report, does that come via Excel or it is just text within the email?  There are properties to set the max email size which could be affecting it too:

                  Message body size limit properties

                   

                  If the list is via Excel or CSV, there are properties you can set for the max rows too:

                  Export limit properties

                   

                  If these properties don't exist in your instance you can create them yourself - default values are hard coded via server side Java that get overwritten if the sys_property record exists.  Just make sure you set the Type to Integer.


                  Please mark this post or any post helpful or the correct answer so others viewing can benefit.

                    • Re: Has Jakarta placed a limit on the length of reports?
                      Steve Driscoll (OCLC)

                      The scheduled job is sending it as an attached PDF Landscape file.

                      The body of the email is fairly short.

                       

                      Interestingly enough, when viewing the doc on export limits, I see a property for PDF files:

                       

                       

                      I checked our instance and it doesn't have that property defined.  The default value in this doc applies to Geneva.

                      I wonder what the default value is for Jakarta?

                       

                      EDIT: Update, I checked the docs for Jakarta and the limit listed there is 5,000.  Still, I have to wonder if the value may be different if the property does not exist.  Looks like I'm going to do some experimentation in my dev instance...

                        • Re: Has Jakarta placed a limit on the length of reports?
                          Steve Driscoll (OCLC)

                          OK, I have enough data to make some sense of this.

                           

                          ----- start text of solution -----

                          The property glide.pdf.max_rows appears to control the number of lines allowed in a PDF file WITHIN LIMITS.

                          I tested by setting up a report of Linux servers which contains about 7,000 lines.

                          In the UI, I exported to PDF and ran into the 1,000 limit.

                          I then set the value of glide.pdf.max_rows to 2,000.

                          Again, I exported the report of Linux serves and ran into a limit of 2,000.

                          I was sure I had it!  But I was celebrating too soon!

                          I increased the value of glide.pdf.max_rows to 10,000 and exported the report and got this error:

                           

                           

                          Value of property 'glide.pdf.max_rows' must be less or equal than 5,000. Default max row number applied (1,000)

                           

                          List truncated, max rows (1,000) exceeded

                           

                           

                          Looks like I need to use a different format for the report.  

                          ----- end of text of solution -----

                           

                          Michael,  since your answer led me to the solution, would you copy the pertinent text, add any additional thoughts that you'd like and reply to this message?  I want to give you the credit for the Correct Answer.

                            • Re: Has Jakarta placed a limit on the length of reports?
                              Michael Ritchie

                              Steve,

                              Great research and I am sorry the documentation is wrong.  As mentioned in the Export limit properties product documentation the glide.pdf.max_rows system property will allow you to override the default setting of 1000.  This system property might not exist in your instance since the default is set in server side java by the ServiceNow developers but you can create your own system property with a name of glide.pdf.max_rows and type of Integer and set your own custom limit.  I have also confirmed that the server side code also sets a 5000 cap on the number of rows being exported.  So your custom system property can be between 1000 and 5000.

                               

                              I have submitted feedback on the Product Documentation site stating that the default should be updated to reflect 1000 instead of 5000.  I also suggested noting that the max cannot exceed 5000 as well.


                              Please mark this post or any post helpful or the correct answer so others viewing can benefit.