Which fineract version are you using Mexina. This might be something that changed during the migration process.
Regards, On March 16, 2022 at 2:12:04 pm +02:00, Mexina Daniel <mexina@singo.africa> wrote: > Hello team > We were able to identify the cause of SMS gateway failing to run. The issue > was with the connection to the datasource. It seems there were already enough > connections so the gateway was not connected. > One thing which is strange is when we checked to "show processlist" on the > database to see how many connections are in use, we saw databases (tenants) > made five connections each which are in sleep state and this lead to many > connections. > Can anyone help to understand why more than one connection made in one > database and how to fix this? > Kind Regards > > -- > > > > Mexina Daniel > > Chief Executive Officer > > Singo Africa LimitedSingo Africa Limited Email: mexina@singo.africaCompany > Website: <https://singo.africa>Amala Website: <https://amala.co.tz>KopaSmart > <https://kopasmart.app>Mobile: +255 71 211 0791Address: Magomeni Usalama, > Watumishi House, 1st FloorP.O.BOX 78908 | 14121 Dar es Salaamlinkedin > <https://tz.linkedin.com/in/mexina-daniel-0aaa64b8?trk=pub-pbmap>facebook > <http://this-is-a-sample-url.com>twitter > <https://twitter.com/mexinamiel?lang=en>instagram > <https://www.instagram.com/miel_beckie/?hl=en> > > > > On 07-03-2022 12:04, Mexina Daniel wrote: > > > Hi Arnold > > Thank you for your response. > > The URL has not changed from the time it was working, and I have checked it > > is still correct. > > Regarding to their services, the same service is used in another server > > which use the same platform and it is working fine, I have tested even in > > my local computer and the messagegateway ran successfully. > > Kind Regards > > > > -- > > > > > > > > Mexina Daniel > > > > Chief Executive Officer > > > > Singo Africa LimitedSingo Africa Limited Email: mexina@singo.africaCompany > > Website: <https://singo.africa>Amala Website: > > <https://amala.co.tz>KopaSmart <https://kopasmart.app>Mobile: +255 71 211 > > 0791Address: Magomeni Usalama, Watumishi House, 1st FloorP.O.BOX 78908 | > > 14121 Dar es Salaamlinkedin > > <https://tz.linkedin.com/in/mexina-daniel-0aaa64b8?trk=pub-pbmap>facebook > > <http://this-is-a-sample-url.com>twitter > > <https://twitter.com/mexinamiel?lang=en>instagram > > <https://www.instagram.com/miel_beckie/?hl=en> > > > > > > > > On 04-03-2022 12:50, Arnold Galovics wrote: > > > > > Hi Mexina, > > > > > > > > > Which fineract version are you running? > > > > > > > > > I took a quick look at the logs you attached and there's this piece: > > > > > > > > > > > > Exception in thread "pool-6-thread-1" > > > org.springframework.web.client.HttpClientErrorException$NotFound: 404 Not > > > Found: [<html><head><title>Apache Tomcat/7.0.82 - Error > > > report</title><style><!--H1 > > > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} > > > H2 {font-family:Tahoma,Arial,sans... (1003 bytes)] > > > at > > > org.springframework.web.client.HttpClientErrorException.create(HttpClientErrorException.java:113) > > > at > > > org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:170) > > > at > > > org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:112) > > > at > > > org.springframework.web.client.ResponseErrorHandler.handleError(ResponseErrorHandler.java:63) > > > at > > > org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:785) > > > at > > > org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:743) > > > at > > > org.springframework.web.client.RestTemplate.execute(RestTemplate.java:717) > > > at > > > org.springframework.web.client.RestTemplate.exchange(RestTemplate.java:635) > > > at > > > org.apache.fineract.infrastructure.sms.scheduler.SmsMessageScheduledJobServiceImpl.connectAndSendToIntermediateServer(SmsMessageScheduledJobServiceImpl.java:179) > > > This suggests that either the Gateway URL is misconfigured (which I > > > assume is not the case) or that the Gateway is responding with a 404 - > > > i.e. it's an issue with their service. > > > > > > > > > Can you please double-check if the URL is 100% correct? If it is, it's > > > probably worth reaching out to them and asking if they have changed > > > anything. > > > > > > > > > Best, > > > Arnold > > > > > > > > > On Fri, Mar 4, 2022 at 12:46 AM Mexina Daniel <mexina@singo.africa> wrote: > > > > > > > Hi James > > > > We have been using tomcat 7 even when the SMS was working. > > > > The MaxSpareThreads is provided in the connector that runs the platform > > > > and I tried to remove the variable and the result is the same, SMS > > > > gateways gives the same errors. > > > > Kind Regards > > > > > > > > -- > > > > > > > > > > > > > > > > Mexina Daniel > > > > > > > > Chief Executive Officer > > > > > > > > Singo Africa LimitedSingo Africa Limited Email: > > > > mexina@singo.africaCompany Website: <https://singo.africa>Amala > > > > Website: <https://amala.co.tz>KopaSmart <https://kopasmart.app>Mobile: > > > > +255 71 211 0791Address: Magomeni Usalama, Watumishi House, 1st > > > > FloorP.O.BOX 78908 | 14121 Dar es Salaamlinkedin > > > > <https://tz.linkedin.com/in/mexina-daniel-0aaa64b8?trk=pub-pbmap>facebook > > > > <http://this-is-a-sample-url.com>twitter > > > > <https://twitter.com/mexinamiel?lang=en>instagram > > > > <https://www.instagram.com/miel_beckie/?hl=en> > > > > > > > > > > > > > > > > On 02-03-2022 19:56, James Dailey wrote: > > > > > > > > > Hi Mexina > > > > > > > > > > > > > > > I'm not sure this helps, but the error showing was MaxSpareThreads, > > > > > "Setting property 'maxSpareThreads' to '75' did not find a matching > > > > > property."which was (apparently) removed in Tomcat 6. > > > > > <https://stackoverflow.com/questions/4756918/tomcat-7-maxsparethreads-livedeploy-debug#4821354> > > > > > > > > > > > > > > > > > > > > Did you upgrade? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Wed, Mar 2, 2022 at 12:29 AM Mexina Daniel <mexina@singo.africa> > > > > > wrote: > > > > > > > > > > > Hi devs > > > > > > I hope you are all doing well. > > > > > > I would like to ask if someone have encountered the issue or can > > > > > > understand what is an issue and help. > > > > > > Our SMS gateway was running okay with configurations of Infobip and > > > > > > was sending sms just fine. But after some days it stopped to run > > > > > > (SMS wasn't sent and the dropdown for service provider wasn't > > > > > > available) > > > > > > We decide to restart the tomcat server so that it can restart the > > > > > > messagegateway but now it throwing an error (attached the > > > > > > catalina.out) > > > > > > I have also attached the server.xml file and application.yml file > > > > > > for message-gateway to see the configurations. > > > > > > Thank you in advance. > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > > > > > > > > > Mexina Daniel > > > > > > > > > > > > Chief Executive Officer > > > > > > > > > > > > Singo Africa LimitedSingo Africa Limited Email: > > > > > > mexina@singo.africaCompany Website: <https://singo.africa>Amala > > > > > > Website: <https://amala.co.tz>KopaSmart > > > > > > <https://kopasmart.app>Mobile: +255 71 211 0791Address: Magomeni > > > > > > Usalama, Watumishi House, 1st FloorP.O.BOX 78908 | 14121 Dar es > > > > > > Salaamlinkedin > > > > > > <https://tz.linkedin.com/in/mexina-daniel-0aaa64b8?trk=pub-pbmap>facebook > > > > > > <http://this-is-a-sample-url.com>twitter > > > > > > <https://twitter.com/mexinamiel?lang=en>instagram > > > > > > <https://www.instagram.com/miel_beckie/?hl=en> > > > > > > > > > > > > > > > > > > >