SEM reports take a long time to generate and sometimes give errors

s.calisto

Hi,

We deployed Solarwinds SEM at my client and from day one we had problems with the reporting application.

First of all, when we add the server and credentials in the report settings and test the connection, we get the error "Manager ping OK but the port 9001 on the LEM appliance could not be opened" if we ignore the error and run a report, it takes a long time to be generated (almost 1 hour for a short report) and sometimes we get an error message:

What we've done so far:

We removed the Crystal reports and then downloaded the installer for the SEM reports and Crystal runtime

We installed the certificate exported from the SEM web console.

Modified the settings in CRConfig.xml to allow the Java used by the report to use more memory:

<JVMMaxHeap>256000000</JVMMaxHeap>
 <JVMMinHeap>32000000</JVMMinHeap>

npatterson

Honest the new RC version with save you a lot of time as reports are not HTML 5 and do not need to use Crystal reports ever again.  

I running 2023.4RC1 which actually solves tons of issues regarding reports.