Error retrieving results

Roger Smits shared this question 1 year ago
In Progress

Hi,

Often I get the error message "Error retrieving results" when I open a report in the morning. Every night the Tomcat is restarted.

When I go to data sources and open / save the specific data source; open the report again. The problem is gone and the report shows the results.

We have a lot of data marts stored in about 14 different data sources.

We did not customize any XML's or configs.

How can we keep this connection 'alive'?

Kind regards,

Roger

Comments (16)

photo
1

Hi Roger,

Thanks for your post.

I believe you need to enable the Volatile Data sources. What this does is, it will check the data source connections for every 30 seconds and if the connection is closed, it will reset the connection. For more information on how to set this up, please follow the article by clicking here.

See how you go with it and let me know if you have any questions or any issues.

Regards,

Mahe

photo
1

Hi Mahe,

Thanks for the reply.

I will consult the DBA and see he can do on short term.

Kind regards,

Roger

photo
1

One more question concerning the insert statements.

Will these be affected when YF is updated to a newer version (7.4)?

photo
1

Hi Roger,

I believe the new version (7.4) will not affect the changes, unless if there are any changes in the database schema.

As of now, I am not aware of any DB schema changes.

Let me know if you have any changes.

Regards,

Mahe

photo
1

Hi Roger,

Hope you are doing well.

Please let me know if you have any more questions.

If everything is good, I may close this ticket.

Regards,

Mahe

photo
1

Hi,

Sorry I didn't reply. This fixed the issues as mentioned.

The only issue we still have is that the dashboard generates a time-out.

See screen below

12503c097bc023b3052dd5797b54d2cf

The second or third time the report is displayed.

I hoped this issue would also be fixed. But it's the same.

Do you have a solution for this problem?

Kind regards,


Roger Smits

photo
1

Hi Roger,

Regarding a solution for the browser error message of ERR_CONNECTION_TIMED_OUT, please be aware that this is not a Yellowfin issue, a quick search of the internet with your favourite search engine will show you that it is most likely a browser issue or maybe a network congestion or a routing issue. I would recommend trying some of the many solutions suggested on the internet such as this one, or contacting your Network Administrator about this.


regards,

David

photo
1

Hi,

Thanks for the feedback. All users experience this issue. I was hoping there was an easy fix that you knew of. I will investigate this with the company where our servers are hosted.

You can close this ticket and thanks for the swift replies.

Kind regards,

Roger

photo
photo
1

Hi Roger,

yes, unfortunately there isn't one "easy fix" as such, however, you never know - there might be an "easy fix" out of the many possibilities suggested in that example article and other articles.

Good luck with it!

David

photo
1

Hey Dave! nice discussion on this topic, I having an issue on my server when I connect to my HP printer with windows 10 server. Then printer in error state, i have no idea about this error that this error how to remove this. I also try many Printers site but not getting any help...

photo
2

Hi Anurag,

what are you doing using a printer? In this day and age when our planet is suffering from deforestation, it is surely better to send an email rather than print on paper.

I hope resolves your issue.

regards,

Big Dave

photo
1

Thanks Dave............I would try to best option.

photo
1

that's good Anurag, always try your best!

photo
photo
1

With the increasing dependency on electronic devices, comes along its failure as well. Therefore Canon Printer Support ensures that the quality of service should not be compromised and hence we pledge to deliver 24x7 printer services at +1-888-621-0339 and also make sure that the problem does not recur by following up on our subscribed customers.


<a href='https://www.dialprintersupport.com/canon-printer-support.php'>Canon Printer Support</a>

photo
1

Eliminate the Hp printer offline issue with our technical team


Is your Hp printer unable to perform its most expected duties? Well, it is the embarrassing condition to get in touch with countless failures. As soon as some disturbance might be highlighted with HP printer and computer, you will go through with hp printer offline issue. Whenever such conflicted might be created in your output device, you may not longer the solid privilege to get the valid outcome at any cost. You should not make worry and eradicate technical problem. It is the imperative attitude of our professional team to conquer all problems as quick as possible. In order to know information, you can browse our web portal.

photo
photo
1

Hi JoeyTriab,

thanks for passing on that information to the Yellowfin Community, and very good to hear that you follow up on your subscribed customers!

regards,

Big Dave.