This is one of those seemingly impossible to resolve issues - mainly because its happening so sporadically. I have a fairly large application that has been in production for over four years. There are about 40 reports (built native in Alpha) which were all working fine up until about a month ago. There are various xbasic functions that create these reports and output them as PDFs (or appended PDFs in many cases) Users started reporting two issues:
One other observation I can share about what's happening here: I have noticed quite a few failed brute force attempts on the database server. We have quite a few safeguards in place to handle this, however could this be affecting memory?
Thanks for any insight here!
- When the various xbasic functions that create the reports are called, users have very sporadically seen the attached xbasic error message. I understand the message and have spent many hours researching and attempting to identify and resolve the memory issue. The two major things I did in SQL were to increase the max memory and re-index the pertinent tables/creating new non-clustered indexes for these tables. No luck.
- Users have also reported that reports are sporadically missing the company logo at the header of the page. Some background here: for several reasons, there are a few different versions of this logo. All are stored in an accessible folder on the application server. The pertinent tables which are being used for the various reports all have a field with a file path to the necessary image. On the Alpha side, I added this field to the report as an HTML memo field, thus displaying the image on the report. This has all worked fine for several years up until about a month ago when this problem started happening.
One other observation I can share about what's happening here: I have noticed quite a few failed brute force attempts on the database server. We have quite a few safeguards in place to handle this, however could this be affecting memory?
Thanks for any insight here!
Comment