by sapiens.bi

Dynamic Reports and Interactive Charts. A powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is very user-friendly, no need for technical knowledge or SQL. The Sapiens.BI tool comes with over 100 pre-built reports that are ready to be used on day one.

Cancel at any time!
Free Trial

#108 - How to setup/enable scheduled reports

Closed Installation created by BoXBo 7 years ago

I've tried to setup a scheduled report according the manual. But nothing was sent out. Do I have to setup a scheduler first which will be triggered by cron.php? I've checked all available jobs in schedulers, but there is nothing similar to the Analytic Reporting Tool Basic. Also missing are any helpful hints inside the installation manual.

What are the additional steps to get the scheduled reports working?

Thanks in advance.

  1. sapiens-bi member avatar

    sapiens.bi Provider

    7 years ago

    Hello BoXBo,

    Under Scheduler you should create new Scheduler and select 'Analytic Reporting Send Scheduled Reports'

    Scheduler.png

    And then cronjobs should be enabled on the server and for SuiteCRM.

    You are actually right about Manual / Installation guide - we will add the instruction to both ;). Thank you for the feedback!

    Let us know, if this solved the issue or if you need any more help!

    Thank you!

    Best Regards, IT Sapiens Team

    • BoXBo member avatar

      BoXBo

      7 years ago

      Thanks for the quick reply. After setting up scheduler correctly I can see that it's running in the log-file. But it's not sending out any reports. Log file error is

      Fri Oct 28 13:25:07 2016 [6792][1][FATAL] Job 91496d27-9f05-5c33-9f4c-581335e7e4da (Analytic Reporting) failed in CRON run
      Fri Oct 28 13:25:07 2016 [6792][1][INFO] Resolving job 91496d27-9f05-5c33-9f4c-581335e7e4da as failure: Unerwarteter Fehler, bitte überprüfen Sie die Logs von SuiteCRM und php.
      

      Looks like the same issues described in bug #53 and #78. At least the error message is the same. All other scheduled SuiteCRM tasks are working fine. Do you have any suggestions about this issue?

    • sapiens-bi member avatar

      sapiens.bi Provider

      7 years ago

      Thank you for the information! We will investigate this.
      Just to be sure - can you send the e-mails from your SuiteCRM system at all (i.e. e-mailing is configured?)

      Thank you!

      Best Regards, IT Sapiens Team

    • sapiens-bi member avatar

      sapiens.bi Provider

      7 years ago

      Hello Chris,

      The #53 fix should be there in the latest version, but in just in case, we have sent the fix to your e-mail as well.

      Hoping, you have received it?

      Best Regards, IT Sapiens Team

    • BoXBo member avatar

      BoXBo

      7 years ago

      Yes, got it. After copied the file onto the system everything is working as expected. Your file was definitely different to the one which is included in our package (AR_1.7.10_suite_basic.zip).

      Thanks for your help!

  2. sapiens-bi member avatar

    sapiens.bi Provider

    7 years ago

    Ok, thank you so much for this feedback, - we have most likely missed this update while packing the latest upgrade, will make the general package fix now as well.

    Best Regards, IT Sapiens Team

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...