Can we able to run a query to find if the datasource has been disconnected?

shahul samad shared this question 34 days ago
Answered

Can we able to run a query to find if the data source has been disconnected?

Comments (7)

photo
1

Hi Shahul,


Data Source related messages such as a Database Disconnection would occur in the jdbc.log files. You might be able to find information in the 'EVENT' table (searching for WHERE 'EventData' LIKE '%DB%' or similar), however, this will only give you configuration changes to the Data Source, not Disconnection Errors.


What was the reason that you were looking for this information? I might be able to assist in other ways, i.e. pointing you toward articles that might help to create JSPs in order to test a Data Source connection.


Regards,

Simon

photo
1

Hi Simon,

We are having data source disconnect issues in a multi-tenant environment. Instead of logging through each client and check, it would be good to check in one place and reconnect the failed ones.


thanks.


Regards

Shahul

photo
1

Hi Shahul,


What kind of Data Source disconnect issues are you facing and how are they being caused? Also what method are you using to reconnect the failed connections? Ideally, you shouldn't be facing these issues at all.


The 'REPORTVIEWSOURCE' table shows all these Data Source connections in the Parent and Client Orgs where you could check for things like invalid connection credentials. The reason I don't think what you're requesting is possible is because the Database should be disconnected and refreshed at the end of each Connection Reset (configured in the Connection settings of each Data Source) to prevent memory leaks. Therefore, the 'Connection Status' of the Data Source is only valid as of the last time it was checked by way of testing the connection, running a report, running a dashboard etc.


Regards,

Simon

photo
1

Hi Simon,

Yellowfin is connected to cube data source for reporting. Yellowfin fail to reconnect sometimes, So we need to login through each client and click test connection to re-establish the connection again. This issue has been reported numerous times.


Thanks.

Regards

Shahul

photo
1

Hi Shahul,


Something that has worked for similar situations in the past is to run a JSP calling on the CLOSECONNECTIONPOOL web service, rather than performing the manual process you've described below.


Read the article above, and see an example of implementation in the file attached. You will need to expand on the example and provide other relevant details to your environment.


Regards,

Simon

photo
1

Hi Shahul,


I was just checking in to see if you require further assistance with this question. If so, please respond and I will get back to you shortly.


Otherwise, I will go ahead and mark this ticket as completed.


Kind regards,

Simon

photo
1

Hi Shahul,


I'm marking this question as completed for the time being.


If you still require assistance with this topic, please respond to this message to re-open this ticket and I will get back to you shortly.


Kind regards,

Simon