Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeyarajerp
Contributor II
Contributor II

Qliksense dashboard refresh does not happen for the 2nd time

Hi,

Have setup a dashboard recently in Qliksense . In the data load editor , configured a simple query that connects to a sybase ASE database  and gets the data.

Now have setup an autosys job ( that runs twice a day) to refresh the data into Qliksense Dashboard. The first run of autosys job gets the actual data from dataserver and loads into Qliksense , so all good.

But when the job runs for the 2nd time , it does not really seem to get data from Dataserver. Rather just reloads the same data that was loaded during the 1st run(picks up from some sort of QS cache?).  I have confirmed this by comparing number of rows getting loaded vs the no. of rows in the DB.  Would greatly appreciate any inputs regarding this.

Thanks,

Jeyaraj

1 Solution

Accepted Solutions
NadiaB
Support
Support

It shouldn't be a problem

Could you verify the app is pointing to the right data source and that the new data in the DB is available at the time the task is executed?

Kind regards.

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/

View solution in original post

5 Replies
NadiaB
Support
Support

Hi @Jeyarajerp 

Have you compared the log from the first execution vs the one that correspond of the second execution?

 

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/
Jeyarajerp
Contributor II
Contributor II

Hi Nadia,

I have compared this and number of rows being fetched in the 2nd time is
same as first time. Even though data base has diff number of rows during
2nd time. Is there a reload frequency on the dashboard which can restrict
the number of data loads in a day.

Regards,
Jeyaraj
NadiaB
Support
Support

It shouldn't be a problem

Could you verify the app is pointing to the right data source and that the new data in the DB is available at the time the task is executed?

Kind regards.

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/

View solution in original post

Jeyarajerp
Contributor II
Contributor II

The data source is correct. In fact , for the first time in a given
day,data gets loaded properly. Only an issue with sub sequent loads.

Also checked the data in source during refresh and it has expected data.
Even I forced the refresh multiple times after confirming data in the
source. But it just loads same data from the refresh happened for first
time in the day.

Regards,
Jeyaraj
Jeyarajerp
Contributor II
Contributor II

For some reason , out data connection configured in qliksense was pointing to the DR server instead of main server.

There is a lag in replication to DR server from main , which was causing all of the refresh issue.

Thanks for the help.

 

Regards,

Jeyaraj