Jasper Domain Based Report on Derived Tables Cache Issue?

[nithyanand11]

I Created domin(Postgres Datasource) with derived table.. Then i create chart pro report using studio and published in Jasper server is in Cloud.

The report have Domain Query 

<query>

  <queryFields>

    <queryField id="Merchant_Sales.country"/>

    <queryField id="Merchant_Sales.transdate"/>

    <queryField id="Merchant_Sales.transpoint"/>

    <queryField id="Merchant_Sales.year"/>

  </queryFields>

  <queryFilterString>Merchant_Sales.year == year_1

  </queryFilterString>

</query>

 

The issue is each time when i run the report the report showing inconsistance data.? Some time records counts coming in millions,, some times in Thousands... 

 

Any idea ? please help..... 

[marianol]

Strange indeed!!!! Some tips that may help you troubleshoot this:

- Enable logging in the domain queries and check the log to see what is really hapening in the backend. Log in as superuser and go to Manage -> Server Settings -> Log

- Chech the Adhoc Cache and the Adhoc settings to see if something looks off.  log in as superuser and go to Manage -> Server Settings -> Adhoc Cache