Log event when data source connection attempts exceeded

Manish shared this idea 2 years ago
Idea Logged

Related to this item: Never mark a data source as unavailable when volatile is enabled.

When we have configured volatile sources (or not) and trying to connect to a data source.. it will eventually give up (based on data source / volatile settings). However once this happens, we don't know.


E.g. If had a retry x 5 over 10mins.. after 10mins the report will simply stop trying to connect and fail to run.

We can see this in the source logs, but how can we track this via the event table for remediation . E.g. Attempt 5 of 5 failed. Giving up.

Can we please have a way to track this via the DB?

Replies (4)

photo
1

Have logged this feature request on your behalf Manish.

Please let me know if you needed anything in the interim.


Regards,David

photo
1

In this case, you can try to use odbc connection and check if it helps.

photo
1

This would be handy. Recently had issue with broadcasts failing with code REPORT_RUN_ERROR, which seems to be related to DB connections. Only evidence I found was that the Event.EventData duration was inline with volatile sources timeout/retries config (timeout x retries -1 = duration).

If this is timeout is occurring during report broadcasts I want to know how often its happening during other usage as it may explain sporadic performance issues with reports.

photo
1

Hi Nick,

I hope all is well,

I appreciate your use case in this scenario, with this I will make sure our development team are aware of this. If you require this to be escalated further, please let me know. I can reach out to your CSM to discuss further.

Regards,

Mark

Leave a Comment
 
Attach a file