• Error doing X-Ray By Year

    By Georg Leitner 1 decade ago

    Hello,

    i have got an error, when doing the X-Ray By Year. I only get following Error:

    X-Ray ERROR: 6: Overflow

    br
    Georg

    • By Dominic Porter 1 decade ago

      My, that is a lot of data you must have. Sounds like the numbers are too great to store in number fields.

      I'll revisit the agent and the X-Ray forms to cope with much larger numbers.

      • By Georg Leitner 1 decade ago

        Thank you for the quick response. i think data is around 650gb with mailfiles as big as 35gb

        • By Georg Leitner 1 decade ago

          so yes, a lot of data for some of our mailfiles

          • By Dominic Porter 1 decade ago

            I may have a workaround if the issue is what I think it is. If you're happy to delve in to the design you can alter the agent thus:

            (Declarations)
            Dim intPos As Integer –> Dim intPos As Long

            Sub Initialize
            Dim ii As Integer –> Dim ii As long

            Sub PopulateCount(doc As NotesDocument, intPtr As Integer, empty As Boolean) –> Sub PopulateCount(doc As NotesDocument, intPtr As long, empty As Boolean)

            Sub PopulateTotal(doc As NotesDocument, intPtr As Integer, empty As Boolean) –> Sub PopulateTotal(doc As NotesDocument, intPtr As Long, empty As Boolean)

            If you'd rather not, you can use http://www.dbpsolutions.com/contact to give me your email I'll send over a updated template for you to try.

            • By Georg Leitner 1 decade ago

              i have changed the data types to long, but the overflow is still there

              • By Dominic Porter 1 decade ago

                So, not what I thought it was. I'll generate some much larger data sets and get a proper root cause.

                I'll update you as soon as I have something.

                • By Georg Leitner 1 decade ago

                  i've looked into the code and started the lotusscript debugger. seems there is a problem with the years, somehow there are documents with years bigger than integer, so i exchanged every integer with long and now the x-ray works. the downside is, i've have years like 39234

                  • By Dominic Porter 1 decade ago

                    Hi, I've been trying to reproduce the issue on my dev system but no luck but yesterday I was at a customer site who had the same issue. I've traced it to the app not handling Mime encoded emails/calendar documents correctly. I'm not sure I will fix it in this version but I am working on a DOTS plug-in for version 2 so I will fix it there.