Report does not display - PC 100% CPU and 1GB memory attempting to run

Posted by: apazurik on 4 August 2017, 6:01 am EST

  • Posted 4 August 2017, 6:01 am EST

    Hi,

    Have a user who has ActiveReports 2 installed and is unable to run the VB samples that come with ActiveReports.  Have tried both XML and SecureDB sample and in both cases, the application causes the system to go to 100% CPU and allocates 1GB of memory and the report does not display

    User running Windows XP Pro, German edition.

    any help is greatly appreciated.

  • Posted 4 August 2017, 6:01 am EST

    I suggest that you make sure that your user have installed the latest build of ActiveReports. He can get it from here:



    http://www.datadynamics.com/forums/37/ShowForum.aspx



    and also have the latest service pack for VB. SP6 can be downloaded from here:



    http://www.microsoft.com/downloads/details.aspx?familyid=a8494edb-2e89-4676-a16a-5c5477cb9713&displaylang=en



    Let us know if the problem persisted.

  • Posted 4 August 2017, 6:01 am EST

    thanks, ensured they have the latest ActiveReports files but didn’t ensure they had the latest VB service packs.  Will check that.  Assumed that it was being included in our install but might not be.

  • Posted 4 August 2017, 6:01 am EST

    Hi,

    latest ActiveReports and VB6 runtime patches have been applied.  No change.

    btw, this is occurring on more than one PC at the location.

    Is there any connection to German version of Windows XP?

  • Posted 4 August 2017, 6:01 am EST

    It must be related to the version of XP. Is this a localized Windows XP SP2 OS or an English version with German MUI pack?

  • Posted 4 August 2017, 6:01 am EST

    Thanks,  more info from a reseller assisting me with this:

    they use a German Windows XP. In the screenshot I sent you last week, you can see that the path tells you “Gemeinsame Dateien” which is common files in an English environment.

    I will check if they run Service Pack 2 of XP.

    However: I run also windows XP German Version here without any problems…

    And: They use one laptop without problems. This one is not connected to the internet, and so soes not use any virus scanner, etc. 

  • Posted 4 August 2017, 6:01 am EST

    I switched my machine to a German (Germany) locale and ran the above mentioned samples but like you didn’t have the CPU spike problem. Can you please ask your customer to update the MDAC on his machine:



    MDAC Downloads

    http://msdn2.microsoft.com/en-us/data/aa937730.aspx



    P.S: I didn’t receive any screenshots.



  • Posted 4 August 2017, 6:01 am EST

    Is there anything in the application section of the Event Viewer (Control Panel–>Performance and Maintenance–>Admin Tools–>Event Viewer) after the process is killed?

    What build of ActiveReports do you use in your application?

  • Posted 4 August 2017, 6:01 am EST

    It was suggested that you try changing the default printer on the machines experiencing the problem. Can you ask your customer to set the default printer to a local printer and let us know if the problem persisted. Also, does the report get generated and the memory usage subside if he give the report enough time to generate?

  • Posted 4 August 2017, 6:01 am EST

    The fact that a machine without anti-virus is able to run has caught my attention. I do not mean to intrude here but finding out the AV that is in use on the other machines and doing some research on it would be a good idea in my humble opinion.

     puz wrote:

    And: They use one laptop without problems. This one is not connected to the internet, and so soes not use any virus scanner, etc. 

  • Posted 4 August 2017, 6:01 am EST

    Hi,

    thanks for the input.  Yes, we have used the same AV (f-prot) here in our office for a while without problems.

    I'm still thinking there must be some debug AR version that could dump out a log of some sort.

  • Posted 4 August 2017, 6:01 am EST

    thanks, they have the latest MDAC.

    Any other ideas?  We would really like to get this resolved. 

    Should I try to get them to download the full install of ActiveReports?

  • Posted 4 August 2017, 6:01 am EST

    Why does your user have the samples installed on his machine, aren’t they part of a full install of ActiveReports? If he uses an application that you developed, it is not necessary to install ActiveReports.

    If he made sure that he has the latest versions of the above components, he can try to reinstall ActiveReports. You can also ask him to get us a crash dump after he kills the process and I will ask a developer to check it. Here is more information about this utility:

    http://support.microsoft.com/kb/308538

    I  am not sure what else to check at this point but try to get us more information about his OS: is it an English version of Windows + plus German MUI pack? I need some way to reproduce the problem.

  • Posted 4 August 2017, 6:01 am EST

    I sent them a couple of the samples to see if the problem was our software.  They were unable to run the sample apps.

    I could be wrong but by his description, it sounds like the system is a German  XP version not a converted English version since he makes reference to how the Program Files folder is in German language.

    Is there anything else I could try?  Any debug samples?

    thanks.

  • Posted 4 August 2017, 6:01 am EST

    ActiveReports doesn’t dump a log. Can you update us on what did the user try so far and what has he found out? Has he tried what wsmith suggested and disabled the Anti-virus software? Did he try changing the printer? What exactly is happening? does the memory subside if he gives the application enough time to run or does it hang and he has to kill the process? Is there anything in the event log? Was he able to get a log from Dr. Watson?

  • Posted 4 August 2017, 6:01 am EST

    Have requested the printer change but have not heard back, already weekend in Germany

    I'm fairly certain they tried disabling the AV software.

    Working on getting a gotomeeting session setup so can witness first hand how the PC is behaving

    thanks for all your assistance.

  • Posted 4 August 2017, 6:01 am EST

    Hi,

    Was able to connect to the users PC and witness this first hand.  Here's the summary:

    • Attempting to run the VB samples included with active reports caues same behaviour as running the report from within our app.  Determine that problem is not our application.
    • Problem behaviour is as follows:
      • user is able to run the application that includes the activereport previewer but on report generation, memory jumps up 500MB and CPU goes to 100%.  Report never completes and user must kill process to free memory.
    • Have ensured user has the following:
      • latest VB runtime
      • latest MDAC
      • latest ActiveReport components
      • all service packs
    • Interesting: Ran the sample web samples that are included with the AR install and those worked!!  Does this help any??
    • PC summary
      • 2 PCs with this problem. 
      • One laptop does not have this problem, reports run fine
      • All systems run same version of German XP Pro Edition
      • Only difference appears to be a virus scanner - f-secure.  Will attempt to install this to see if this is the culprit

     

  • Posted 4 August 2017, 6:01 am EST

    While you are connected:

    1. Remove the viewer and just run the report and save it or export it.

    2. Get the exact Windows version from Help–>About of Windows Explorer.

    3. Let us know what you find out after you uninstall the virus scanner.

  • Posted 4 August 2017, 6:01 am EST

    Just tried installing f-secure AV under a Win2k VMWare session and it worked fine.  ugh.  was hoping that was it.

  • Posted 4 August 2017, 6:01 am EST

    1. Remove the viewer and just run the report and save it or export it.

    Tried this, modified one of the samples to simply run the report and export to PDF.  Verified that it worked here.  User tried it and got this result:

    "Error 5000 : Error in processing report.

     [ Extended Info:XML Load failed.
    Please check fileName. [ Extended Info:Systemfehler: -2146697210.

     Line     0]]"

    "Error: ActiveReports PDF export DLL error. Pages collection contains 0 pages. Export Fails."

    2. Get the exact Windows version from Help-->About of Windows Explorer.

    Will get this.

    3. Let us know what you find out after you uninstall the virus scanner.

    Did you mean what happens after "installing" the virus scanner.  I tried it and it worked fine.

  • Posted 4 August 2017, 6:01 am EST

    1. Probably there is a hard-coded path to the XML file which is not the same on the user’s machine as it is on yours. What about the other problematic sample? did you try it without a viewer?



      3. If there is no virus scanner on the computer having the problem, there is no need to install it.

  • Posted 4 August 2017, 6:01 am EST

    There is no hardcoded path. 

    I did remove the viewer from the last sample.  The report still did not run

    The PCs with the problem so have the f-secure AV.  I installed it here to see if it had an impact and it did not.

  • Posted 4 August 2017, 6:01 am EST

    Here is the win version (attached)

  • Posted 4 August 2017, 6:01 am EST

    Did you get any errors from the other samples when you ran it other than the report didn’t get generated? I was trying to narrow down the problem on the assumption that the viewer could be the culprit. Also, have you tried installed different printer driver on the user’s machine.

    I will be installing the German MUI pack on a windows xp machine and test these samples on it if we have a problem.

  • Posted 4 August 2017, 6:01 am EST

    The other reports do not error, they just never complete.  As stated before, CPU goes to 100% and memory jumps.  User must kill process.

    Yes, we tried changing to a different printer.

  • Posted 4 August 2017, 6:01 am EST

    More interesting news on this...

    The user installed VB6 and compiled the AR samples and they ran without a problem.  The same ones that would not run when compiled on our PC and sent to them.

    So, the question is, what is different about compiling on the target system?

  • Posted 4 August 2017, 6:01 am EST

     It could be that installing VB6 fixed some registered DLLs on the system, probably the VB6 runtime. Did he install SP6 also? Did that fix your application? What happens after he uninstalls VB6 and runs your application and the samples?

    P.S: Unfortunately, I am having difficutlties connecting to MSDN to get the MUI pack to test on a German operating system.

  • Posted 4 August 2017, 6:01 am EST

    Running the sample report that we compiled here after the user installed VB6 still did not work.  The user is only able to run the reports compile on his PC.

  • Posted 8 October 2018, 11:46 pm EST

    When you’re getting the CPU to overclock at the 100% efficiency and that too with 1GB RAM. I think that is happening due to some windows error. I experienced this issue way back and didn’t even get this issue twice. If you have any query regarding the Acer laptops or PCs than taking help from this site:* “https://www.acersupportnumber.com/

  • Posted 8 October 2018, 11:48 pm EST

    When you’re getting the CPU to overclock at the 100% efficiency and that too with 1GB RAM. I think that is happening due to some windows error. I experienced this issue way back and didn’t even get this issue twice. If you have any query regarding the Acer laptops or PCs than taking help from this site:* “https://www.acersupportnumber.com/

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels