Adding new datasource connection is unavailable error.
Hi,
I am trying to add a new datasource and though my test connection is successful, when I try to create a view it says "Unavailable. The connection to this datasource has failed". This is my error log:
YF:2017-01-24 14:02:53: WARN (MIDataSourceEditAction:execute) - Error setting connection pool status: java.lang.Exception: Failed to create DBConnectionPool
java.lang.Exception: Failed to create DBConnectionPool
at com.hof.pool.DBConnectionPool.createJDBCPool(DBConnectionPool.java:591)
at com.hof.pool.DBConnectionManager.createPool(DBConnectionManager.java:566)
at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:441)
at com.hof.pool.DBConnectionManager.setStatus(DBConnectionManager.java:733)
at com.hof.mi.web.action.MIDataSourceEditAction.execute(MIDataSourceEditAction.java:165)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Please Help!
The same question
Hi Vidhya,
I've got about half an hour before I head off, would you like a screenshare now to investigate this problem? Please let me know, if it's possible I'll send you a GoToMeeting invitation.
regards,
Davd
Hi Vidhya,
I've got about half an hour before I head off, would you like a screenshare now to investigate this problem? Please let me know, if it's possible I'll send you a GoToMeeting invitation.
regards,
Davd
Yes, I can share my screen now if you are free.
Yes, I can share my screen now if you are free.
Hi Vidhya,
I just emailed you the meeting invitation
david
Hi Vidhya,
I just emailed you the meeting invitation
david
yes I accepted it
yes I accepted it
you have a meeting id?
you have a meeting id?
yes, it should have been in that invitation:
anyway, here it is:
https://global.gotomeeting.com/join/505398317
Normal
0
false
false
false
EN-AU
X-NONE
X-NONE
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-fareast-language:EN-US;}
yes, it should have been in that invitation:
anyway, here it is:
https://global.gotomeeting.com/join/505398317
Normal
0
false
false
false
EN-AU
X-NONE
X-NONE
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-fareast-language:EN-US;}
apologies Vidhya, looks like we've run out of time. Please let me know what time you'd like tomorrow and I'll schedule in another meeting.
David
apologies Vidhya, looks like we've run out of time. Please let me know what time you'd like tomorrow and I'll schedule in another meeting.
David
hi David,
No problem, Can we schedule a meeting at 9.30 am tomorrow(Darwin Time)?
hi David,
No problem, Can we schedule a meeting at 9.30 am tomorrow(Darwin Time)?
Hi Vidhya,
I've just sent you a GoToMeeting screenshare invitation for 9:30 AM Darwin time. And just in case for some reason you don't receive the invitation, I'll paste it here as well (the 11 AM is Melbourne time):
New Meeting
Wed, Jan 25, 2017 11:00 AM - 11:30 AM AEDT
Please join my meeting from your computer, tablet or smartphone.
https://global.gotomeeting.com/join/821033245
You can also dial in using your phone.
Australia: +61 2 8355 1050
Access Code: 821-033-245
First GoToMeeting? Try a test session: http://help.citrix.com/getready
Hi Vidhya,
I've just sent you a GoToMeeting screenshare invitation for 9:30 AM Darwin time. And just in case for some reason you don't receive the invitation, I'll paste it here as well (the 11 AM is Melbourne time):
New Meeting
Wed, Jan 25, 2017 11:00 AM - 11:30 AM AEDT
Please join my meeting from your computer, tablet or smartphone.
https://global.gotomeeting.com/join/821033245
You can also dial in using your phone.
Australia: +61 2 8355 1050
Access Code: 821-033-245
First GoToMeeting? Try a test session: http://help.citrix.com/getready
ok I have accepted it.
ok I have accepted it.
bad news Vidhya, I have just tested making a Windows Authentication data source in the same version and build of 7.3 as you are using and it worked. I have attached a short video to show you.
Not sure how to progress with this issue now....I will come up with an idea and get back to you
David
bad news Vidhya, I have just tested making a Windows Authentication data source in the same version and build of 7.3 as you are using and it worked. I have attached a short video to show you.
Not sure how to progress with this issue now....I will come up with an idea and get back to you
David
oh. I am unsure as to how to proceed.
oh. I am unsure as to how to proceed.
Hi Vidhya,
I think we have to firstly prove it is a Yellowfin issue and then if it is, maybe you could get a connection opened up for our developers to connect to and debug.
So to temporarily remove Yellowfin from the picture, are you able to try doing a Windows Authentication connection to your DB with a db tool such as DBVisualiser or SQuirreL?
regards,
David
Hi Vidhya,
I think we have to firstly prove it is a Yellowfin issue and then if it is, maybe you could get a connection opened up for our developers to connect to and debug.
So to temporarily remove Yellowfin from the picture, are you able to try doing a Windows Authentication connection to your DB with a db tool such as DBVisualiser or SQuirreL?
regards,
David
Hi Vidhya,
if you are not familiar with DBVisualiser or SQuirreL I can give you a hand now if you would like, just let me know.
regards,
David
Hi Vidhya,
if you are not familiar with DBVisualiser or SQuirreL I can give you a hand now if you would like, just let me know.
regards,
David
Hi David,
I did a reinstall and it worked.. don't know why and how!
Hi David,
I did a reinstall and it worked.. don't know why and how!
Hi Vidhya,
that's fantastic news! Thanks for letting me know.
Sometimes an installer/upgrader may have been a little corrupted during the download process and this can cause strange behaviour, so a fresh download (and making sure the checksum is correct) and a fresh re-install can fix an issue. We have seen this in the past with both the Yellowfin installer/upgrader and also the Java installer.
However, do you mean you only reinstalled? Or did you download and reinstall?
regards,
David
Hi Vidhya,
that's fantastic news! Thanks for letting me know.
Sometimes an installer/upgrader may have been a little corrupted during the download process and this can cause strange behaviour, so a fresh download (and making sure the checksum is correct) and a fresh re-install can fix an issue. We have seen this in the past with both the Yellowfin installer/upgrader and also the Java installer.
However, do you mean you only reinstalled? Or did you download and reinstall?
regards,
David
Hi david, I downloaded and reinstalled
Hi david, I downloaded and reinstalled
Hi Vidhya,
that's very interesting indeed! Thanks for letting me know.
The reason I asked is that just occasionally clients have reported strange issues to us, and after we've tried all the standard steps we can think of to help them and they don't work, then as a last resort we suspect a corrupted download of either Yellowfin or Java might be the cause. And so we advise them to do a fresh download of both Yellowfin and Java, and make sure to check the MD5 or SHA1 checksum to ensure the download wasn't corrupted and install again.
You are now officially the 4th client in the last 5 years I am aware of who has struck this issue of a corrupted download causing a strange problem!
By the way, the Java checksum is obtained from the java website, however at the moment the Yellowfin checksums aren't available on the website - the only way to get them is by emailing us.
Thanks again for sharing your experience with us.
regards,
David
Hi Vidhya,
that's very interesting indeed! Thanks for letting me know.
The reason I asked is that just occasionally clients have reported strange issues to us, and after we've tried all the standard steps we can think of to help them and they don't work, then as a last resort we suspect a corrupted download of either Yellowfin or Java might be the cause. And so we advise them to do a fresh download of both Yellowfin and Java, and make sure to check the MD5 or SHA1 checksum to ensure the download wasn't corrupted and install again.
You are now officially the 4th client in the last 5 years I am aware of who has struck this issue of a corrupted download causing a strange problem!
By the way, the Java checksum is obtained from the java website, however at the moment the Yellowfin checksums aren't available on the website - the only way to get them is by emailing us.
Thanks again for sharing your experience with us.
regards,
David
Replies have been locked on this page!