Hello Tracy,

Did you install from source or binary?

Centric CRM uses a report queue to handle all reports that user's create in the system since report generation is demanding on the CPU. In most cases the report should appear as ready to download within 1-60 seconds.

Since the reports are not generating, it sounds like the queue has not been activated. If you installed from source, then it's possible that the cron process did not get installed due to an error. You can verify this by either looking at the build.log file that was generated during the "ant installdb" or you can look in the database table called "events" and see if there are any entries. If the table does not exist, or there are no events, then that's the problem.

Let us know and we can further help with a solution.

Matt,

this is what Tracy states.....

=================================================

When I generate a report, I see the report first appear in the "Reports scheduled to be processed by server" area. Then, shortly, I see the report appear in the "Generated Reports ready to be retrieved" area. In this area, the report status says "Queued", and the only option available under "Action" is "Delete".

=================================================

I believe the report status says 'Queued' even when it is is in the 'Generated Reports ready to be retrieved section'. If the cron process was not enabled, then ideally speaking shouldn't the report still be in the queue rather than being available in the 'Ready' section. Is it possible for the report to jump from the queue to the generated section without being processed?

My understanding is that the only possible status that a report can have, when it is in the 'Generated Reports ready to be retrieved' section is either 'Ready to Download' or 'Error generating report'.

Hmm... So why is the report in the generated section, but says queued? That I don't know. I didn't think this was possible either.

Taking a guess here... Does your "Pipeline" module graph work when you go into the "Pipeline" module? If not, then this might be related. Under Linux, the graphics engine needs: CATALINA_OPTS=-Djava.awt.headless=true, Search for CATALINA_OPTS on this site for more information.

Matt,

Thanks for the replies. I did install from binary. I indeed cannot display the Pipeline graph on the Pipeline page (I had not tried that option yet). I will check out the CATALINA_OPTS options and let you know what happens.

Thanks,
Tracy

Matt,

I added the CATALINA_OPTS as you describe to my Tomcat startup, and now I can generate and view/download reports. The ones I generated previously still could not be viewed, but any new reports are fine.

Thank you for your help.

Tracy