Pentaho

 View Only
  • 1.  Issue with CDA cache in CDE Dashboards

    Posted 01-31-2024 09:54

    Hi,

    I have a problem with the cache in the pentaho CDE dashboards, version 7.1.

    After excecute the ETL processes in PDI to update the data I can check the data updated using a tool to display data, but in the dashboard the data isn't updated. If I excute the queries availables in the dashboard with other tools the data is already updated.

    I cleared the CDA cache manually in the Pentaho Server (Tools, Refresh, CDA Caché), but the data isn't updated in the dashboard. Then, I restarted the Pentaho Server and the data has been updated.

    I need help to know how I can clear this cache without restart the server. Any idea?

    Thanks in advance.

    Jason



    ------------------------------
    Jason Serrano
    Systems Engineer
    ITCR
    ------------------------------


  • 2.  RE: Issue with CDA cache in CDE Dashboards

    Posted 01-31-2024 11:32

    Hi Jason,

    if cache is empty you can check in CDA Cache Manager.

    And IMHO it's depends on used data access type in CDA file. There can be another underlay cache, ex. Mondrian, report cache.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------



  • 3.  RE: Issue with CDA cache in CDE Dashboards

    Posted 02-01-2024 10:02

    Hi Petr,

    Thanks for your quick response.

    I used the "CDA Cache Manager" and it didn't help me solve the problem either. Also, I have used Mondrian Schema Cache and Reporting Data Cache but the problem still persists.

    Also, I have a script to clean the caches after the execution of the ETL processes, but it didn't help me either.

    Script used:
    execCacheClear "CDA" "http://server:port/pentaho/content/cda/clearCache"

    I agree with you that there must be another cache where the data is stored.

    Thanks in advance.



    ------------------------------
    Jason Serrano
    Systems Engineer
    ITCR
    ------------------------------



  • 4.  RE: Issue with CDA cache in CDE Dashboards

    Posted 02-02-2024 06:19

    If you don't see cached CDA file via manager. So problem is what you call in CDA. How is defined data access?



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------



  • 5.  RE: Issue with CDA cache in CDE Dashboards

    Posted 02-05-2024 10:24

    Hi Petr,

    I checked the CDA cache manager, and I can see some queries. Then, after clicking on the "Clear cache" button the CDA cache manager displays the message "Cache is empty", but the data isn't updated.

    CDA Cache Manager

    The queries (MDX and SQL) have been created using CDE with a JNDI connection and the charts have been created using the CDE too.



    ------------------------------
    Jason Serrano
    Systems Engineer
    ITCR
    ------------------------------



  • 6.  RE: Issue with CDA cache in CDE Dashboards

    Posted 02-05-2024 11:16

    Hi Jason,

    for MDX queries have to clean cache too, if you called before update data. SQL queries is not required IMHO.

    Pls, could you provide called URI in browser? Or try call CDA file directly in file browser if data is changed.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------



  • 7.  RE: Issue with CDA cache in CDE Dashboards

    Posted 02-06-2024 09:16

    Hi Petr,

     

    First, thank you for following up on this issue.

     

    I made a new test using a new dashboard with a basic Line Chart with a MDX query and the issue continue happening.

    The data in the cube is the next:

     

    Query Cube OLAP

    I checked the CDA file, and the information isn't updated.

     

    CDA Query

    Also, I used the CDE file directly in the browser and the data isn't changed.

    Query by URL
    Thanks in advance.


    ------------------------------
    Jason Serrano
    Systems Engineer
    ITCR
    ------------------------------