You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Mexina M Daniel <me...@singo.co.tz> on 2016/07/26 08:08:11 UTC

Connection problem in Data import tool

Hi devs

I would like someone to assist me of this problem am facing

I have installed Data Import Tool successfully, i just have started to 
try to import clients, am facing a problem when downloading the 
template. It gives an error "java.net.ConnectException: Connection 
refused ".

Also when i ran "gradle clean tomcatRunWar" it build up to 85%

What could be the problem?

Thanks in advance


-- 
Mexina M Daniel
Lead Software Developer
Research & Development

Tel:+255 222 618 511 | Mob: +255 712 110 791

Singo Africa Limited
Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam

singo.co.tz

Lets grow together


Re: Connection problem in Data import tool

Posted by Mexina M Daniel <me...@singo.co.tz>.
Hi Yannick

Thank you

I have corrected the url in dataimport.properties and now when i
download and import, it import completely but i can not find the client
i imported in Mifos.

Regards

On 07/26/2016 03:26 PM, Yannick Awasum wrote:
> Make sure your server is running and check dataimport.properties files for
> correct endpoint.
> See:
> https://github.com/openMF/DataImportTool/blob/develop/dataimport.properties
>
> On Tue, Jul 26, 2016 at 12:49 PM, Mexina M Daniel <me...@singo.co.tz>
> wrote:
>
>> Hi Shreyaank
>>
>> I have changed the port 8009 which was used by another process and make it
>> free, when i run that command now it hives this
>>
>>
>> -------------------------------------------------------------------------------------------------------------------------------------------------
>> singo@singo-HP-ProBook-450-G2 ~/Documents/Mifos/DataImportTool $ gradle
>> clean tomcatRunWar
>> :clean
>> :pmdMain
>> :compileJava
>> warning: [options] bootstrap class path not set in conjunction with
>> -source 1.6
>> 1 warning
>> :processResources UP-TO-DATE
>> :classes
>> :war
>> :tomcatRunWar
>> Started Tomcat Server
>> The Server is running at http://localhost:8070/DataImportTool
>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>> refused
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>      at
>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>      at
>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>      at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>      at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>      at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>      at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>      at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>      at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>      at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>      at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>      at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>      at org.apache.tomcat.util.net
>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>      at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>      at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>      at java.lang.Thread.run(Thread.java:745)
>> Caused by: java.net.ConnectException: Connection refused
>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>      at java.net
>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>      at java.net
>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>      at java.net.Socket.connect(Socket.java:589)
>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>      at
>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>      at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>      at
>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>      at
>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>      at
>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>      ... 21 more
>>> Building 85% > :tomcatRunWar
>> -------------------------------------------------------------------------------------------------------------------------------------
>>
>> On 07/26/2016 12:05 PM, Shreyaank Byadagi wrote:
>>
>>> Hi Mexina,
>>> Make sure that your not running multiple applications on the same port
>>> number.
>>>
>>> Regards
>>> Shreyaank
>>>
>>> On Tue, Jul 26, 2016 at 2:28 PM, Mexina M Daniel <me...@singo.co.tz>
>>> wrote:
>>>
>>> Hi Shreyaank
>>>> When i run "gradle clean tomcatRunWar" this is what it display in the
>>>> command prompt though it doesn't display from the beginning due to many
>>>> contents to be displayed.
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------------------------------------------------------------------
>>>> at org.gradle.internal.reflect.JavaMethod.invoke(JavaMethod.java:75)
>>>>       at
>>>>
>>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.doExecute(AnnotationProcessingTaskFactory.java:226)
>>>>       at
>>>>
>>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:219)
>>>>       at
>>>>
>>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:208)
>>>>       at
>>>>
>>>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:585)
>>>>       at
>>>>
>>>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:568)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeAction(ExecuteActionsTaskExecuter.java:80)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeActions(ExecuteActionsTaskExecuter.java:61)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.execute(ExecuteActionsTaskExecuter.java:46)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.PostExecutionAnalysisTaskExecuter.execute(PostExecutionAnalysisTaskExecuter.java:35)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipUpToDateTaskExecuter.execute(SkipUpToDateTaskExecuter.java:64)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ValidatingTaskExecuter.execute(ValidatingTaskExecuter.java:58)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipEmptySourceFilesTaskExecuter.execute(SkipEmptySourceFilesTaskExecuter.java:52)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipTaskWithNoActionsExecuter.execute(SkipTaskWithNoActionsExecuter.java:52)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipOnlyIfTaskExecuter.execute(SkipOnlyIfTaskExecuter.java:53)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteAtMostOnceTaskExecuter.execute(ExecuteAtMostOnceTaskExecuter.java:43)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:203)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:185)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.processTask(AbstractTaskPlanExecutor.java:62)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.run(AbstractTaskPlanExecutor.java:50)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskPlanExecutor.process(DefaultTaskPlanExecutor.java:25)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter.execute(DefaultTaskGraphExecuter.java:110)
>>>>       at
>>>>
>>>> org.gradle.execution.SelectedTaskExecutionAction.execute(SelectedTaskExecutionAction.java:37)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.access$000(DefaultBuildExecuter.java:23)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter$1.proceed(DefaultBuildExecuter.java:43)
>>>>       at
>>>>
>>>> org.gradle.execution.DryRunBuildExecutionAction.execute(DryRunBuildExecutionAction.java:32)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:30)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher$4.run(DefaultGradleLauncher.java:158)
>>>>       at org.gradle.internal.Factories$1.create(Factories.java:22)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:52)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.doBuildStages(DefaultGradleLauncher.java:155)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.access$200(DefaultGradleLauncher.java:36)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:103)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:97)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:62)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.doBuild(DefaultGradleLauncher.java:97)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.run(DefaultGradleLauncher.java:86)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.InProcessBuildActionExecuter$DefaultBuildController.run(InProcessBuildActionExecuter.java:102)
>>>>       at
>>>>
>>>> org.gradle.tooling.internal.provider.ExecuteBuildActionRunner.run(ExecuteBuildActionRunner.java:28)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.ChainingBuildActionRunner.run(ChainingBuildActionRunner.java:35)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:47)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:32)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:77)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:47)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:51)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:28)
>>>>       at
>>>> org.gradle.launcher.cli.RunBuildAction.run(RunBuildAction.java:43)
>>>>       at
>>>>
>>>> org.gradle.internal.Actions$RunnableActionAdapter.execute(Actions.java:170)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:237)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:210)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:35)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:24)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:206)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:169)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:33)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:22)
>>>>       at org.gradle.launcher.Main.doAction(Main.java:33)
>>>>       at org.gradle.launcher.bootstrap.EntryPoint.run(EntryPoint.java:45)
>>>>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>       at
>>>>
>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>>>       at
>>>>
>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>>       at java.lang.reflect.Method.invoke(Method.java:498)
>>>>       at
>>>>
>>>> org.gradle.launcher.bootstrap.ProcessBootstrap.runNoExit(ProcessBootstrap.java:54)
>>>>       at
>>>>
>>>> org.gradle.launcher.bootstrap.ProcessBootstrap.run(ProcessBootstrap.java:35)
>>>>       at org.gradle.launcher.GradleMain.main(GradleMain.java:23)
>>>> Caused by: org.apache.catalina.LifecycleException: Protocol handler
>>>> initialization failed
>>>>       at
>>>> org.apache.catalina.connector.Connector.initInternal(Connector.java:983)
>>>>       at
>>>> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)
>>>>       ... 153 more
>>>> Caused by: java.net.BindException: Address already in use <null>:8009
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint.bind(JIoEndpoint.java:406)
>>>>       at org.apache.tomcat.util.net
>>>> .AbstractEndpoint.init(AbstractEndpoint.java:610)
>>>>       at
>>>> org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:429)
>>>>       at
>>>> org.apache.catalina.connector.Connector.initInternal(Connector.java:981)
>>>>       ... 154 more
>>>> Caused by: java.net.BindException: Address already in use
>>>>       at java.net.PlainSocketImpl.socketBind(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
>>>>       at java.net.ServerSocket.bind(ServerSocket.java:375)
>>>>       at java.net.ServerSocket.<init>(ServerSocket.java:237)
>>>>       at java.net.ServerSocket.<init>(ServerSocket.java:181)
>>>>       at org.apache.tomcat.util.net
>>>>
>>>> .DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:49)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint.bind(JIoEndpoint.java:393)
>>>>       ... 157 more
>>>> Started Tomcat Server
>>>> The Server is running at http://localhost:8070/DataImportTool
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.CenterWorkbookPopulator.downloadAndParse(CenterWorkbookPopulator.java:58)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>>
>>>>> Building 85% > :tomcatRunWar
>>>>>
>>>> -------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>
>>>>
>>>> On 07/26/2016 11:46 AM, Shreyaank Byadagi wrote:
>>>>
>>>> Hi Mexina,
>>>>> Please share your complete  error log, so that I can guide you.
>>>>>
>>>>> Regards
>>>>> Shreyaank
>>>>>
>>>>> On Tue, Jul 26, 2016 at 1:38 PM, Mexina M Daniel <me...@singo.co.tz>
>>>>> wrote:
>>>>>
>>>>> Hi devs
>>>>>
>>>>>> I would like someone to assist me of this problem am facing
>>>>>>
>>>>>> I have installed Data Import Tool successfully, i just have started to
>>>>>> try
>>>>>> to import clients, am facing a problem when downloading the template.
>>>>>> It
>>>>>> gives an error "java.net.ConnectException: Connection refused ".
>>>>>>
>>>>>> Also when i ran "gradle clean tomcatRunWar" it build up to 85%
>>>>>>
>>>>>> What could be the problem?
>>>>>>
>>>>>> Thanks in advance
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Mexina M Daniel
>>>>>> Lead Software Developer
>>>>>> Research & Development
>>>>>>
>>>>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>>>>
>>>>>> Singo Africa Limited
>>>>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>>>>> Salaam
>>>>>>
>>>>>> singo.co.tz
>>>>>>
>>>>>> Lets grow together
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>> Mexina M Daniel
>>>> Lead Software Developer
>>>> Research & Development
>>>>
>>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>>
>>>> Singo Africa Limited
>>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>>> Salaam
>>>>
>>>> singo.co.tz
>>>>
>>>> Lets grow together
>>>>
>>>>
>>>>
>> --
>> Mexina M Daniel
>> Lead Software Developer
>> Research & Development
>>
>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>
>> Singo Africa Limited
>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>>
>> singo.co.tz
>>
>> Lets grow together
>>
>>
>>
>

-- 
Mexina M Daniel
Lead Software Developer
Research & Development

Tel:+255 222 618 511 | Mob: +255 712 110 791

Singo Africa Limited
Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam

singo.co.tz

Lets grow together





Re: Connection problem in Data import tool

Posted by Mexina M Daniel <me...@singo.co.tz>.
Hi Yannick

Thank you

I have corrected the url in dataimport.properties and now when i 
download and import, it import completely but i can not find the client 
i imported in Mifos.

Regards

On 07/26/2016 03:26 PM, Yannick Awasum wrote:
> Make sure your server is running and check dataimport.properties files for
> correct endpoint.
> See:
> https://github.com/openMF/DataImportTool/blob/develop/dataimport.properties
>
> On Tue, Jul 26, 2016 at 12:49 PM, Mexina M Daniel <me...@singo.co.tz>
> wrote:
>
>> Hi Shreyaank
>>
>> I have changed the port 8009 which was used by another process and make it
>> free, when i run that command now it hives this
>>
>>
>> -------------------------------------------------------------------------------------------------------------------------------------------------
>> singo@singo-HP-ProBook-450-G2 ~/Documents/Mifos/DataImportTool $ gradle
>> clean tomcatRunWar
>> :clean
>> :pmdMain
>> :compileJava
>> warning: [options] bootstrap class path not set in conjunction with
>> -source 1.6
>> 1 warning
>> :processResources UP-TO-DATE
>> :classes
>> :war
>> :tomcatRunWar
>> Started Tomcat Server
>> The Server is running at http://localhost:8070/DataImportTool
>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>> refused
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>      at
>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>      at
>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>      at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>      at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>      at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>      at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>      at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>      at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>      at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>      at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>      at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>      at org.apache.tomcat.util.net
>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>      at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>      at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>      at java.lang.Thread.run(Thread.java:745)
>> Caused by: java.net.ConnectException: Connection refused
>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>      at java.net
>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>      at java.net
>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>      at java.net.Socket.connect(Socket.java:589)
>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>      at
>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>      at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>      at
>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>      at
>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>      at
>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>      ... 21 more
>>> Building 85% > :tomcatRunWar
>> -------------------------------------------------------------------------------------------------------------------------------------
>>
>> On 07/26/2016 12:05 PM, Shreyaank Byadagi wrote:
>>
>>> Hi Mexina,
>>> Make sure that your not running multiple applications on the same port
>>> number.
>>>
>>> Regards
>>> Shreyaank
>>>
>>> On Tue, Jul 26, 2016 at 2:28 PM, Mexina M Daniel <me...@singo.co.tz>
>>> wrote:
>>>
>>> Hi Shreyaank
>>>> When i run "gradle clean tomcatRunWar" this is what it display in the
>>>> command prompt though it doesn't display from the beginning due to many
>>>> contents to be displayed.
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------------------------------------------------------------------
>>>> at org.gradle.internal.reflect.JavaMethod.invoke(JavaMethod.java:75)
>>>>       at
>>>>
>>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.doExecute(AnnotationProcessingTaskFactory.java:226)
>>>>       at
>>>>
>>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:219)
>>>>       at
>>>>
>>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:208)
>>>>       at
>>>>
>>>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:585)
>>>>       at
>>>>
>>>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:568)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeAction(ExecuteActionsTaskExecuter.java:80)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeActions(ExecuteActionsTaskExecuter.java:61)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.execute(ExecuteActionsTaskExecuter.java:46)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.PostExecutionAnalysisTaskExecuter.execute(PostExecutionAnalysisTaskExecuter.java:35)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipUpToDateTaskExecuter.execute(SkipUpToDateTaskExecuter.java:64)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ValidatingTaskExecuter.execute(ValidatingTaskExecuter.java:58)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipEmptySourceFilesTaskExecuter.execute(SkipEmptySourceFilesTaskExecuter.java:52)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipTaskWithNoActionsExecuter.execute(SkipTaskWithNoActionsExecuter.java:52)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipOnlyIfTaskExecuter.execute(SkipOnlyIfTaskExecuter.java:53)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteAtMostOnceTaskExecuter.execute(ExecuteAtMostOnceTaskExecuter.java:43)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:203)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:185)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.processTask(AbstractTaskPlanExecutor.java:62)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.run(AbstractTaskPlanExecutor.java:50)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskPlanExecutor.process(DefaultTaskPlanExecutor.java:25)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter.execute(DefaultTaskGraphExecuter.java:110)
>>>>       at
>>>>
>>>> org.gradle.execution.SelectedTaskExecutionAction.execute(SelectedTaskExecutionAction.java:37)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.access$000(DefaultBuildExecuter.java:23)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter$1.proceed(DefaultBuildExecuter.java:43)
>>>>       at
>>>>
>>>> org.gradle.execution.DryRunBuildExecutionAction.execute(DryRunBuildExecutionAction.java:32)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:30)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher$4.run(DefaultGradleLauncher.java:158)
>>>>       at org.gradle.internal.Factories$1.create(Factories.java:22)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:52)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.doBuildStages(DefaultGradleLauncher.java:155)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.access$200(DefaultGradleLauncher.java:36)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:103)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:97)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:62)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.doBuild(DefaultGradleLauncher.java:97)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.run(DefaultGradleLauncher.java:86)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.InProcessBuildActionExecuter$DefaultBuildController.run(InProcessBuildActionExecuter.java:102)
>>>>       at
>>>>
>>>> org.gradle.tooling.internal.provider.ExecuteBuildActionRunner.run(ExecuteBuildActionRunner.java:28)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.ChainingBuildActionRunner.run(ChainingBuildActionRunner.java:35)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:47)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:32)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:77)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:47)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:51)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:28)
>>>>       at
>>>> org.gradle.launcher.cli.RunBuildAction.run(RunBuildAction.java:43)
>>>>       at
>>>>
>>>> org.gradle.internal.Actions$RunnableActionAdapter.execute(Actions.java:170)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:237)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:210)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:35)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:24)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:206)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:169)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:33)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:22)
>>>>       at org.gradle.launcher.Main.doAction(Main.java:33)
>>>>       at org.gradle.launcher.bootstrap.EntryPoint.run(EntryPoint.java:45)
>>>>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>       at
>>>>
>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>>>       at
>>>>
>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>>       at java.lang.reflect.Method.invoke(Method.java:498)
>>>>       at
>>>>
>>>> org.gradle.launcher.bootstrap.ProcessBootstrap.runNoExit(ProcessBootstrap.java:54)
>>>>       at
>>>>
>>>> org.gradle.launcher.bootstrap.ProcessBootstrap.run(ProcessBootstrap.java:35)
>>>>       at org.gradle.launcher.GradleMain.main(GradleMain.java:23)
>>>> Caused by: org.apache.catalina.LifecycleException: Protocol handler
>>>> initialization failed
>>>>       at
>>>> org.apache.catalina.connector.Connector.initInternal(Connector.java:983)
>>>>       at
>>>> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)
>>>>       ... 153 more
>>>> Caused by: java.net.BindException: Address already in use <null>:8009
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint.bind(JIoEndpoint.java:406)
>>>>       at org.apache.tomcat.util.net
>>>> .AbstractEndpoint.init(AbstractEndpoint.java:610)
>>>>       at
>>>> org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:429)
>>>>       at
>>>> org.apache.catalina.connector.Connector.initInternal(Connector.java:981)
>>>>       ... 154 more
>>>> Caused by: java.net.BindException: Address already in use
>>>>       at java.net.PlainSocketImpl.socketBind(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
>>>>       at java.net.ServerSocket.bind(ServerSocket.java:375)
>>>>       at java.net.ServerSocket.<init>(ServerSocket.java:237)
>>>>       at java.net.ServerSocket.<init>(ServerSocket.java:181)
>>>>       at org.apache.tomcat.util.net
>>>>
>>>> .DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:49)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint.bind(JIoEndpoint.java:393)
>>>>       ... 157 more
>>>> Started Tomcat Server
>>>> The Server is running at http://localhost:8070/DataImportTool
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.CenterWorkbookPopulator.downloadAndParse(CenterWorkbookPopulator.java:58)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>>
>>>>> Building 85% > :tomcatRunWar
>>>>>
>>>> -------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>
>>>>
>>>> On 07/26/2016 11:46 AM, Shreyaank Byadagi wrote:
>>>>
>>>> Hi Mexina,
>>>>> Please share your complete  error log, so that I can guide you.
>>>>>
>>>>> Regards
>>>>> Shreyaank
>>>>>
>>>>> On Tue, Jul 26, 2016 at 1:38 PM, Mexina M Daniel <me...@singo.co.tz>
>>>>> wrote:
>>>>>
>>>>> Hi devs
>>>>>
>>>>>> I would like someone to assist me of this problem am facing
>>>>>>
>>>>>> I have installed Data Import Tool successfully, i just have started to
>>>>>> try
>>>>>> to import clients, am facing a problem when downloading the template.
>>>>>> It
>>>>>> gives an error "java.net.ConnectException: Connection refused ".
>>>>>>
>>>>>> Also when i ran "gradle clean tomcatRunWar" it build up to 85%
>>>>>>
>>>>>> What could be the problem?
>>>>>>
>>>>>> Thanks in advance
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Mexina M Daniel
>>>>>> Lead Software Developer
>>>>>> Research & Development
>>>>>>
>>>>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>>>>
>>>>>> Singo Africa Limited
>>>>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>>>>> Salaam
>>>>>>
>>>>>> singo.co.tz
>>>>>>
>>>>>> Lets grow together
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>> Mexina M Daniel
>>>> Lead Software Developer
>>>> Research & Development
>>>>
>>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>>
>>>> Singo Africa Limited
>>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>>> Salaam
>>>>
>>>> singo.co.tz
>>>>
>>>> Lets grow together
>>>>
>>>>
>>>>
>> --
>> Mexina M Daniel
>> Lead Software Developer
>> Research & Development
>>
>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>
>> Singo Africa Limited
>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>>
>> singo.co.tz
>>
>> Lets grow together
>>
>>
>>
>

-- 
Mexina M Daniel
Lead Software Developer
Research & Development

Tel:+255 222 618 511 | Mob: +255 712 110 791

Singo Africa Limited
Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam

singo.co.tz

Lets grow together



Re: Connection problem in Data import tool

Posted by Yannick Awasum <ya...@gmail.com>.
Make sure your server is running and check dataimport.properties files for
correct endpoint.
See:
https://github.com/openMF/DataImportTool/blob/develop/dataimport.properties

On Tue, Jul 26, 2016 at 12:49 PM, Mexina M Daniel <me...@singo.co.tz>
wrote:

> Hi Shreyaank
>
> I have changed the port 8009 which was used by another process and make it
> free, when i run that command now it hives this
>
>
> -------------------------------------------------------------------------------------------------------------------------------------------------
> singo@singo-HP-ProBook-450-G2 ~/Documents/Mifos/DataImportTool $ gradle
> clean tomcatRunWar
> :clean
> :pmdMain
> :compileJava
> warning: [options] bootstrap class path not set in conjunction with
> -source 1.6
> 1 warning
> :processResources UP-TO-DATE
> :classes
> :war
> :tomcatRunWar
> Started Tomcat Server
> The Server is running at http://localhost:8070/DataImportTool
> java.lang.IllegalStateException: java.net.ConnectException: Connection
> refused
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>     at
> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>     at
> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>     at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>     at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>     at org.apache.tomcat.util.net
> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>     at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>     at java.lang.Thread.run(Thread.java:745)
> Caused by: java.net.ConnectException: Connection refused
>     at java.net.PlainSocketImpl.socketConnect(Native Method)
>     at java.net
> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>     at java.net
> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>     at java.net
> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>     at java.net.Socket.connect(Socket.java:589)
>     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>     at
> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>     at
> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>     at
> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>     at
> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>     ... 21 more
> > Building 85% > :tomcatRunWar
>
> -------------------------------------------------------------------------------------------------------------------------------------
>
> On 07/26/2016 12:05 PM, Shreyaank Byadagi wrote:
>
>> Hi Mexina,
>> Make sure that your not running multiple applications on the same port
>> number.
>>
>> Regards
>> Shreyaank
>>
>> On Tue, Jul 26, 2016 at 2:28 PM, Mexina M Daniel <me...@singo.co.tz>
>> wrote:
>>
>> Hi Shreyaank
>>>
>>> When i run "gradle clean tomcatRunWar" this is what it display in the
>>> command prompt though it doesn't display from the beginning due to many
>>> contents to be displayed.
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------------------------------------------------------------------
>>> at org.gradle.internal.reflect.JavaMethod.invoke(JavaMethod.java:75)
>>>      at
>>>
>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.doExecute(AnnotationProcessingTaskFactory.java:226)
>>>      at
>>>
>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:219)
>>>      at
>>>
>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:208)
>>>      at
>>>
>>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:585)
>>>      at
>>>
>>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:568)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeAction(ExecuteActionsTaskExecuter.java:80)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeActions(ExecuteActionsTaskExecuter.java:61)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.execute(ExecuteActionsTaskExecuter.java:46)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.PostExecutionAnalysisTaskExecuter.execute(PostExecutionAnalysisTaskExecuter.java:35)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.SkipUpToDateTaskExecuter.execute(SkipUpToDateTaskExecuter.java:64)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.ValidatingTaskExecuter.execute(ValidatingTaskExecuter.java:58)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.SkipEmptySourceFilesTaskExecuter.execute(SkipEmptySourceFilesTaskExecuter.java:52)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.SkipTaskWithNoActionsExecuter.execute(SkipTaskWithNoActionsExecuter.java:52)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.SkipOnlyIfTaskExecuter.execute(SkipOnlyIfTaskExecuter.java:53)
>>>      at
>>>
>>> org.gradle.api.internal.tasks.execution.ExecuteAtMostOnceTaskExecuter.execute(ExecuteAtMostOnceTaskExecuter.java:43)
>>>      at
>>>
>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:203)
>>>      at
>>>
>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:185)
>>>      at
>>>
>>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.processTask(AbstractTaskPlanExecutor.java:62)
>>>      at
>>>
>>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.run(AbstractTaskPlanExecutor.java:50)
>>>      at
>>>
>>> org.gradle.execution.taskgraph.DefaultTaskPlanExecutor.process(DefaultTaskPlanExecutor.java:25)
>>>      at
>>>
>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter.execute(DefaultTaskGraphExecuter.java:110)
>>>      at
>>>
>>> org.gradle.execution.SelectedTaskExecutionAction.execute(SelectedTaskExecutionAction.java:37)
>>>      at
>>>
>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>>      at
>>>
>>> org.gradle.execution.DefaultBuildExecuter.access$000(DefaultBuildExecuter.java:23)
>>>      at
>>>
>>> org.gradle.execution.DefaultBuildExecuter$1.proceed(DefaultBuildExecuter.java:43)
>>>      at
>>>
>>> org.gradle.execution.DryRunBuildExecutionAction.execute(DryRunBuildExecutionAction.java:32)
>>>      at
>>>
>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>>      at
>>>
>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:30)
>>>      at
>>>
>>> org.gradle.initialization.DefaultGradleLauncher$4.run(DefaultGradleLauncher.java:158)
>>>      at org.gradle.internal.Factories$1.create(Factories.java:22)
>>>      at
>>>
>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>>      at
>>>
>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:52)
>>>      at
>>>
>>> org.gradle.initialization.DefaultGradleLauncher.doBuildStages(DefaultGradleLauncher.java:155)
>>>      at
>>>
>>> org.gradle.initialization.DefaultGradleLauncher.access$200(DefaultGradleLauncher.java:36)
>>>      at
>>>
>>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:103)
>>>      at
>>>
>>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:97)
>>>      at
>>>
>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>>      at
>>>
>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:62)
>>>      at
>>>
>>> org.gradle.initialization.DefaultGradleLauncher.doBuild(DefaultGradleLauncher.java:97)
>>>      at
>>>
>>> org.gradle.initialization.DefaultGradleLauncher.run(DefaultGradleLauncher.java:86)
>>>      at
>>>
>>> org.gradle.launcher.exec.InProcessBuildActionExecuter$DefaultBuildController.run(InProcessBuildActionExecuter.java:102)
>>>      at
>>>
>>> org.gradle.tooling.internal.provider.ExecuteBuildActionRunner.run(ExecuteBuildActionRunner.java:28)
>>>      at
>>>
>>> org.gradle.launcher.exec.ChainingBuildActionRunner.run(ChainingBuildActionRunner.java:35)
>>>      at
>>>
>>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:47)
>>>      at
>>>
>>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:32)
>>>      at
>>>
>>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:77)
>>>      at
>>>
>>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:47)
>>>      at
>>>
>>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:51)
>>>      at
>>>
>>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:28)
>>>      at
>>> org.gradle.launcher.cli.RunBuildAction.run(RunBuildAction.java:43)
>>>      at
>>>
>>> org.gradle.internal.Actions$RunnableActionAdapter.execute(Actions.java:170)
>>>      at
>>>
>>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:237)
>>>      at
>>>
>>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:210)
>>>      at
>>>
>>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:35)
>>>      at
>>>
>>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:24)
>>>      at
>>>
>>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:206)
>>>      at
>>>
>>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:169)
>>>      at
>>>
>>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:33)
>>>      at
>>>
>>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:22)
>>>      at org.gradle.launcher.Main.doAction(Main.java:33)
>>>      at org.gradle.launcher.bootstrap.EntryPoint.run(EntryPoint.java:45)
>>>      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>      at
>>>
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>>      at
>>>
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>      at java.lang.reflect.Method.invoke(Method.java:498)
>>>      at
>>>
>>> org.gradle.launcher.bootstrap.ProcessBootstrap.runNoExit(ProcessBootstrap.java:54)
>>>      at
>>>
>>> org.gradle.launcher.bootstrap.ProcessBootstrap.run(ProcessBootstrap.java:35)
>>>      at org.gradle.launcher.GradleMain.main(GradleMain.java:23)
>>> Caused by: org.apache.catalina.LifecycleException: Protocol handler
>>> initialization failed
>>>      at
>>> org.apache.catalina.connector.Connector.initInternal(Connector.java:983)
>>>      at
>>> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)
>>>      ... 153 more
>>> Caused by: java.net.BindException: Address already in use <null>:8009
>>>      at org.apache.tomcat.util.net
>>> .JIoEndpoint.bind(JIoEndpoint.java:406)
>>>      at org.apache.tomcat.util.net
>>> .AbstractEndpoint.init(AbstractEndpoint.java:610)
>>>      at
>>> org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:429)
>>>      at
>>> org.apache.catalina.connector.Connector.initInternal(Connector.java:981)
>>>      ... 154 more
>>> Caused by: java.net.BindException: Address already in use
>>>      at java.net.PlainSocketImpl.socketBind(Native Method)
>>>      at java.net
>>> .AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
>>>      at java.net.ServerSocket.bind(ServerSocket.java:375)
>>>      at java.net.ServerSocket.<init>(ServerSocket.java:237)
>>>      at java.net.ServerSocket.<init>(ServerSocket.java:181)
>>>      at org.apache.tomcat.util.net
>>>
>>> .DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:49)
>>>      at org.apache.tomcat.util.net
>>> .JIoEndpoint.bind(JIoEndpoint.java:393)
>>>      ... 157 more
>>> Started Tomcat Server
>>> The Server is running at http://localhost:8070/DataImportTool
>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>> refused
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>      at
>>>
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>      at
>>>
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>      at
>>>
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>      at
>>>
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>      at
>>>
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>      at
>>>
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>      at
>>>
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>      at
>>>
>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>      at
>>>
>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>      at org.apache.tomcat.util.net
>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>      at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.net.ConnectException: Connection refused
>>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>      at java.net
>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>      at java.net
>>>
>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>      at java.net
>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>      at java.net.Socket.connect(Socket.java:589)
>>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>      at
>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>      at
>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>      at
>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>      at
>>>
>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>      ... 21 more
>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>> refused
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>      at
>>>
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>      at
>>>
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>      at
>>>
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>      at
>>>
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>      at
>>>
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>      at
>>>
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>      at
>>>
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>      at
>>>
>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>      at
>>>
>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>      at org.apache.tomcat.util.net
>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>      at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.net.ConnectException: Connection refused
>>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>      at java.net
>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>      at java.net
>>>
>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>      at java.net
>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>      at java.net.Socket.connect(Socket.java:589)
>>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>      at
>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>      at
>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>      at
>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>      at
>>>
>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>      ... 21 more
>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>> refused
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>      at
>>>
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>      at
>>>
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>      at
>>>
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>      at
>>>
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>      at
>>>
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>      at
>>>
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>      at
>>>
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>      at
>>>
>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>      at
>>>
>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>      at org.apache.tomcat.util.net
>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>      at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.net.ConnectException: Connection refused
>>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>      at java.net
>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>      at java.net
>>>
>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>      at java.net
>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>      at java.net.Socket.connect(Socket.java:589)
>>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>      at
>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>      at
>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>      at
>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>      at
>>>
>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>      ... 21 more
>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>> refused
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>      at
>>>
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>      at
>>>
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>      at
>>>
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>      at
>>>
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>      at
>>>
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>      at
>>>
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>      at
>>>
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>      at
>>>
>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>      at
>>>
>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>      at org.apache.tomcat.util.net
>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>      at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.net.ConnectException: Connection refused
>>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>      at java.net
>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>      at java.net
>>>
>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>      at java.net
>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>      at java.net.Socket.connect(Socket.java:589)
>>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>      at
>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>      at
>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>      at
>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>      at
>>>
>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>      ... 21 more
>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>> refused
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.client.CenterWorkbookPopulator.downloadAndParse(CenterWorkbookPopulator.java:58)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>      at
>>>
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>      at
>>>
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>      at
>>>
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>      at
>>>
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>      at
>>>
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>      at
>>>
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>      at
>>>
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>      at
>>>
>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>      at
>>>
>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>      at org.apache.tomcat.util.net
>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>      at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.net.ConnectException: Connection refused
>>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>      at java.net
>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>      at java.net
>>>
>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>      at java.net
>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>      at java.net.Socket.connect(Socket.java:589)
>>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>      at
>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>      at
>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>      at
>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>      at
>>>
>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>      ... 21 more
>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>> refused
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>      at
>>>
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>      at
>>>
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>      at
>>>
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>      at
>>>
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>      at
>>>
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>      at
>>>
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>      at
>>>
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>      at
>>>
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>      at
>>>
>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>      at
>>>
>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>      at org.apache.tomcat.util.net
>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>      at
>>>
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>      at java.lang.Thread.run(Thread.java:745)
>>> Caused by: java.net.ConnectException: Connection refused
>>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>      at java.net
>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>      at java.net
>>>
>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>      at java.net
>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>      at java.net.Socket.connect(Socket.java:589)
>>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>      at
>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>      at
>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>      at
>>>
>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>      at
>>>
>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>      at
>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>      at
>>>
>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>      at
>>>
>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>      ... 21 more
>>>
>>>> Building 85% > :tomcatRunWar
>>>>
>>>
>>> -------------------------------------------------------------------------------------------------------------------------------------------------------
>>>
>>>
>>> On 07/26/2016 11:46 AM, Shreyaank Byadagi wrote:
>>>
>>> Hi Mexina,
>>>>
>>>> Please share your complete  error log, so that I can guide you.
>>>>
>>>> Regards
>>>> Shreyaank
>>>>
>>>> On Tue, Jul 26, 2016 at 1:38 PM, Mexina M Daniel <me...@singo.co.tz>
>>>> wrote:
>>>>
>>>> Hi devs
>>>>
>>>>> I would like someone to assist me of this problem am facing
>>>>>
>>>>> I have installed Data Import Tool successfully, i just have started to
>>>>> try
>>>>> to import clients, am facing a problem when downloading the template.
>>>>> It
>>>>> gives an error "java.net.ConnectException: Connection refused ".
>>>>>
>>>>> Also when i ran "gradle clean tomcatRunWar" it build up to 85%
>>>>>
>>>>> What could be the problem?
>>>>>
>>>>> Thanks in advance
>>>>>
>>>>>
>>>>> --
>>>>> Mexina M Daniel
>>>>> Lead Software Developer
>>>>> Research & Development
>>>>>
>>>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>>>
>>>>> Singo Africa Limited
>>>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>>>> Salaam
>>>>>
>>>>> singo.co.tz
>>>>>
>>>>> Lets grow together
>>>>>
>>>>>
>>>>>
>>>>> --
>>> Mexina M Daniel
>>> Lead Software Developer
>>> Research & Development
>>>
>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>
>>> Singo Africa Limited
>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>> Salaam
>>>
>>> singo.co.tz
>>>
>>> Lets grow together
>>>
>>>
>>>
>>
> --
> Mexina M Daniel
> Lead Software Developer
> Research & Development
>
> Tel:+255 222 618 511 | Mob: +255 712 110 791
>
> Singo Africa Limited
> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>
> singo.co.tz
>
> Lets grow together
>
>
>


-- 



Yannick Awasum N. A.

CTO @ Skylabase
Developer @ Mifos
Implementer @ Odoo

+237 676683945

===Providing Smart Enterprise Solutions===

Re: Connection problem in Data import tool

Posted by Mexina M Daniel <me...@singo.co.tz>.
Hi Shreyaank

I have changed the port 8009 which was used by another process and make 
it free, when i run that command now it hives this

-------------------------------------------------------------------------------------------------------------------------------------------------
singo@singo-HP-ProBook-450-G2 ~/Documents/Mifos/DataImportTool $ gradle 
clean tomcatRunWar
:clean
:pmdMain
:compileJava
warning: [options] bootstrap class path not set in conjunction with 
-source 1.6
1 warning
:processResources UP-TO-DATE
:classes
:war
:tomcatRunWar
Started Tomcat Server
The Server is running at http://localhost:8070/DataImportTool
java.lang.IllegalStateException: java.net.ConnectException: Connection 
refused
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
     at 
org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
     at 
org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
     at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
     at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
     at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
     at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
     at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
     at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
     at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.ConnectException: Connection refused
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at 
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
     at 
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
     at 
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
     at java.net.Socket.connect(Socket.java:589)
     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
     at 
sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
     at 
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
     at 
sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
     at 
org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
     ... 21 more
 > Building 85% > :tomcatRunWar
-------------------------------------------------------------------------------------------------------------------------------------

On 07/26/2016 12:05 PM, Shreyaank Byadagi wrote:
> Hi Mexina,
> Make sure that your not running multiple applications on the same port
> number.
>
> Regards
> Shreyaank
>
> On Tue, Jul 26, 2016 at 2:28 PM, Mexina M Daniel <me...@singo.co.tz> wrote:
>
>> Hi Shreyaank
>>
>> When i run "gradle clean tomcatRunWar" this is what it display in the
>> command prompt though it doesn't display from the beginning due to many
>> contents to be displayed.
>>
>>
>> ------------------------------------------------------------------------------------------------------------------------------------------
>> at org.gradle.internal.reflect.JavaMethod.invoke(JavaMethod.java:75)
>>      at
>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.doExecute(AnnotationProcessingTaskFactory.java:226)
>>      at
>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:219)
>>      at
>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:208)
>>      at
>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:585)
>>      at
>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:568)
>>      at
>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeAction(ExecuteActionsTaskExecuter.java:80)
>>      at
>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeActions(ExecuteActionsTaskExecuter.java:61)
>>      at
>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.execute(ExecuteActionsTaskExecuter.java:46)
>>      at
>> org.gradle.api.internal.tasks.execution.PostExecutionAnalysisTaskExecuter.execute(PostExecutionAnalysisTaskExecuter.java:35)
>>      at
>> org.gradle.api.internal.tasks.execution.SkipUpToDateTaskExecuter.execute(SkipUpToDateTaskExecuter.java:64)
>>      at
>> org.gradle.api.internal.tasks.execution.ValidatingTaskExecuter.execute(ValidatingTaskExecuter.java:58)
>>      at
>> org.gradle.api.internal.tasks.execution.SkipEmptySourceFilesTaskExecuter.execute(SkipEmptySourceFilesTaskExecuter.java:52)
>>      at
>> org.gradle.api.internal.tasks.execution.SkipTaskWithNoActionsExecuter.execute(SkipTaskWithNoActionsExecuter.java:52)
>>      at
>> org.gradle.api.internal.tasks.execution.SkipOnlyIfTaskExecuter.execute(SkipOnlyIfTaskExecuter.java:53)
>>      at
>> org.gradle.api.internal.tasks.execution.ExecuteAtMostOnceTaskExecuter.execute(ExecuteAtMostOnceTaskExecuter.java:43)
>>      at
>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:203)
>>      at
>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:185)
>>      at
>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.processTask(AbstractTaskPlanExecutor.java:62)
>>      at
>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.run(AbstractTaskPlanExecutor.java:50)
>>      at
>> org.gradle.execution.taskgraph.DefaultTaskPlanExecutor.process(DefaultTaskPlanExecutor.java:25)
>>      at
>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter.execute(DefaultTaskGraphExecuter.java:110)
>>      at
>> org.gradle.execution.SelectedTaskExecutionAction.execute(SelectedTaskExecutionAction.java:37)
>>      at
>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>      at
>> org.gradle.execution.DefaultBuildExecuter.access$000(DefaultBuildExecuter.java:23)
>>      at
>> org.gradle.execution.DefaultBuildExecuter$1.proceed(DefaultBuildExecuter.java:43)
>>      at
>> org.gradle.execution.DryRunBuildExecutionAction.execute(DryRunBuildExecutionAction.java:32)
>>      at
>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>      at
>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:30)
>>      at
>> org.gradle.initialization.DefaultGradleLauncher$4.run(DefaultGradleLauncher.java:158)
>>      at org.gradle.internal.Factories$1.create(Factories.java:22)
>>      at
>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>      at
>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:52)
>>      at
>> org.gradle.initialization.DefaultGradleLauncher.doBuildStages(DefaultGradleLauncher.java:155)
>>      at
>> org.gradle.initialization.DefaultGradleLauncher.access$200(DefaultGradleLauncher.java:36)
>>      at
>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:103)
>>      at
>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:97)
>>      at
>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>      at
>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:62)
>>      at
>> org.gradle.initialization.DefaultGradleLauncher.doBuild(DefaultGradleLauncher.java:97)
>>      at
>> org.gradle.initialization.DefaultGradleLauncher.run(DefaultGradleLauncher.java:86)
>>      at
>> org.gradle.launcher.exec.InProcessBuildActionExecuter$DefaultBuildController.run(InProcessBuildActionExecuter.java:102)
>>      at
>> org.gradle.tooling.internal.provider.ExecuteBuildActionRunner.run(ExecuteBuildActionRunner.java:28)
>>      at
>> org.gradle.launcher.exec.ChainingBuildActionRunner.run(ChainingBuildActionRunner.java:35)
>>      at
>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:47)
>>      at
>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:32)
>>      at
>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:77)
>>      at
>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:47)
>>      at
>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:51)
>>      at
>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:28)
>>      at org.gradle.launcher.cli.RunBuildAction.run(RunBuildAction.java:43)
>>      at
>> org.gradle.internal.Actions$RunnableActionAdapter.execute(Actions.java:170)
>>      at
>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:237)
>>      at
>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:210)
>>      at
>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:35)
>>      at
>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:24)
>>      at
>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:206)
>>      at
>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:169)
>>      at
>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:33)
>>      at
>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:22)
>>      at org.gradle.launcher.Main.doAction(Main.java:33)
>>      at org.gradle.launcher.bootstrap.EntryPoint.run(EntryPoint.java:45)
>>      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>      at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>      at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>      at java.lang.reflect.Method.invoke(Method.java:498)
>>      at
>> org.gradle.launcher.bootstrap.ProcessBootstrap.runNoExit(ProcessBootstrap.java:54)
>>      at
>> org.gradle.launcher.bootstrap.ProcessBootstrap.run(ProcessBootstrap.java:35)
>>      at org.gradle.launcher.GradleMain.main(GradleMain.java:23)
>> Caused by: org.apache.catalina.LifecycleException: Protocol handler
>> initialization failed
>>      at
>> org.apache.catalina.connector.Connector.initInternal(Connector.java:983)
>>      at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)
>>      ... 153 more
>> Caused by: java.net.BindException: Address already in use <null>:8009
>>      at org.apache.tomcat.util.net.JIoEndpoint.bind(JIoEndpoint.java:406)
>>      at org.apache.tomcat.util.net
>> .AbstractEndpoint.init(AbstractEndpoint.java:610)
>>      at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:429)
>>      at
>> org.apache.catalina.connector.Connector.initInternal(Connector.java:981)
>>      ... 154 more
>> Caused by: java.net.BindException: Address already in use
>>      at java.net.PlainSocketImpl.socketBind(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
>>      at java.net.ServerSocket.bind(ServerSocket.java:375)
>>      at java.net.ServerSocket.<init>(ServerSocket.java:237)
>>      at java.net.ServerSocket.<init>(ServerSocket.java:181)
>>      at org.apache.tomcat.util.net
>> .DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:49)
>>      at org.apache.tomcat.util.net.JIoEndpoint.bind(JIoEndpoint.java:393)
>>      ... 157 more
>> Started Tomcat Server
>> The Server is running at http://localhost:8070/DataImportTool
>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>> refused
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>      at
>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>      at
>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>      at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>      at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>      at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>      at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>      at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>      at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>      at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>      at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>      at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>      at org.apache.tomcat.util.net
>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>      at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>      at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>      at java.lang.Thread.run(Thread.java:745)
>> Caused by: java.net.ConnectException: Connection refused
>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>      at java.net
>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>      at java.net
>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>      at java.net.Socket.connect(Socket.java:589)
>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>      at
>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>      at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>      at
>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>      at
>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>      at
>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>      ... 21 more
>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>> refused
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>      at
>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>      at
>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>      at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>      at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>      at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>      at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>      at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>      at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>      at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>      at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>      at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>      at org.apache.tomcat.util.net
>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>      at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>      at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>      at java.lang.Thread.run(Thread.java:745)
>> Caused by: java.net.ConnectException: Connection refused
>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>      at java.net
>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>      at java.net
>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>      at java.net.Socket.connect(Socket.java:589)
>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>      at
>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>      at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>      at
>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>      at
>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>      at
>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>      ... 21 more
>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>> refused
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>      at
>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>      at
>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>      at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>      at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>      at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>      at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>      at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>      at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>      at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>      at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>      at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>      at org.apache.tomcat.util.net
>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>      at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>      at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>      at java.lang.Thread.run(Thread.java:745)
>> Caused by: java.net.ConnectException: Connection refused
>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>      at java.net
>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>      at java.net
>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>      at java.net.Socket.connect(Socket.java:589)
>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>      at
>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>      at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>      at
>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>      at
>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>      at
>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>      ... 21 more
>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>> refused
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>      at
>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>      at
>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>      at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>      at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>      at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>      at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>      at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>      at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>      at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>      at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>      at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>      at org.apache.tomcat.util.net
>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>      at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>      at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>      at java.lang.Thread.run(Thread.java:745)
>> Caused by: java.net.ConnectException: Connection refused
>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>      at java.net
>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>      at java.net
>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>      at java.net.Socket.connect(Socket.java:589)
>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>      at
>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>      at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>      at
>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>      at
>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>      at
>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>      ... 21 more
>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>> refused
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>      at
>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>      at
>> org.openmf.mifos.dataimport.populator.client.CenterWorkbookPopulator.downloadAndParse(CenterWorkbookPopulator.java:58)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>      at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>      at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>      at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>      at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>      at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>      at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>      at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>      at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>      at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>      at org.apache.tomcat.util.net
>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>      at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>      at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>      at java.lang.Thread.run(Thread.java:745)
>> Caused by: java.net.ConnectException: Connection refused
>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>      at java.net
>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>      at java.net
>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>      at java.net.Socket.connect(Socket.java:589)
>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>      at
>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>      at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>      at
>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>      at
>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>      at
>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>      ... 21 more
>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>> refused
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>      at
>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>      at
>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>      at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>      at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>      at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>      at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>      at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>      at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>      at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>      at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>      at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>      at org.apache.tomcat.util.net
>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>      at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>      at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>      at java.lang.Thread.run(Thread.java:745)
>> Caused by: java.net.ConnectException: Connection refused
>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>      at java.net
>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>      at java.net
>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>      at java.net.Socket.connect(Socket.java:589)
>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>      at
>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>      at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>      at
>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>      at
>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>      at
>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>      ... 21 more
>>> Building 85% > :tomcatRunWar
>> -------------------------------------------------------------------------------------------------------------------------------------------------------
>>
>>
>> On 07/26/2016 11:46 AM, Shreyaank Byadagi wrote:
>>
>>> Hi Mexina,
>>>
>>> Please share your complete  error log, so that I can guide you.
>>>
>>> Regards
>>> Shreyaank
>>>
>>> On Tue, Jul 26, 2016 at 1:38 PM, Mexina M Daniel <me...@singo.co.tz>
>>> wrote:
>>>
>>> Hi devs
>>>> I would like someone to assist me of this problem am facing
>>>>
>>>> I have installed Data Import Tool successfully, i just have started to
>>>> try
>>>> to import clients, am facing a problem when downloading the template. It
>>>> gives an error "java.net.ConnectException: Connection refused ".
>>>>
>>>> Also when i ran "gradle clean tomcatRunWar" it build up to 85%
>>>>
>>>> What could be the problem?
>>>>
>>>> Thanks in advance
>>>>
>>>>
>>>> --
>>>> Mexina M Daniel
>>>> Lead Software Developer
>>>> Research & Development
>>>>
>>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>>
>>>> Singo Africa Limited
>>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>>> Salaam
>>>>
>>>> singo.co.tz
>>>>
>>>> Lets grow together
>>>>
>>>>
>>>>
>> --
>> Mexina M Daniel
>> Lead Software Developer
>> Research & Development
>>
>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>
>> Singo Africa Limited
>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>>
>> singo.co.tz
>>
>> Lets grow together
>>
>>
>

-- 
Mexina M Daniel
Lead Software Developer
Research & Development

Tel:+255 222 618 511 | Mob: +255 712 110 791

Singo Africa Limited
Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam

singo.co.tz

Lets grow together



Re: Connection problem in Data import tool

Posted by Shreyaank Byadagi <sh...@confluxtechnologies.com>.
Hi Mexina,
Make sure that your not running multiple applications on the same port
number.

Regards
Shreyaank

On Tue, Jul 26, 2016 at 2:28 PM, Mexina M Daniel <me...@singo.co.tz> wrote:

> Hi Shreyaank
>
> When i run "gradle clean tomcatRunWar" this is what it display in the
> command prompt though it doesn't display from the beginning due to many
> contents to be displayed.
>
>
> ------------------------------------------------------------------------------------------------------------------------------------------
> at org.gradle.internal.reflect.JavaMethod.invoke(JavaMethod.java:75)
>     at
> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.doExecute(AnnotationProcessingTaskFactory.java:226)
>     at
> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:219)
>     at
> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:208)
>     at
> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:585)
>     at
> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:568)
>     at
> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeAction(ExecuteActionsTaskExecuter.java:80)
>     at
> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeActions(ExecuteActionsTaskExecuter.java:61)
>     at
> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.execute(ExecuteActionsTaskExecuter.java:46)
>     at
> org.gradle.api.internal.tasks.execution.PostExecutionAnalysisTaskExecuter.execute(PostExecutionAnalysisTaskExecuter.java:35)
>     at
> org.gradle.api.internal.tasks.execution.SkipUpToDateTaskExecuter.execute(SkipUpToDateTaskExecuter.java:64)
>     at
> org.gradle.api.internal.tasks.execution.ValidatingTaskExecuter.execute(ValidatingTaskExecuter.java:58)
>     at
> org.gradle.api.internal.tasks.execution.SkipEmptySourceFilesTaskExecuter.execute(SkipEmptySourceFilesTaskExecuter.java:52)
>     at
> org.gradle.api.internal.tasks.execution.SkipTaskWithNoActionsExecuter.execute(SkipTaskWithNoActionsExecuter.java:52)
>     at
> org.gradle.api.internal.tasks.execution.SkipOnlyIfTaskExecuter.execute(SkipOnlyIfTaskExecuter.java:53)
>     at
> org.gradle.api.internal.tasks.execution.ExecuteAtMostOnceTaskExecuter.execute(ExecuteAtMostOnceTaskExecuter.java:43)
>     at
> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:203)
>     at
> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:185)
>     at
> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.processTask(AbstractTaskPlanExecutor.java:62)
>     at
> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.run(AbstractTaskPlanExecutor.java:50)
>     at
> org.gradle.execution.taskgraph.DefaultTaskPlanExecutor.process(DefaultTaskPlanExecutor.java:25)
>     at
> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter.execute(DefaultTaskGraphExecuter.java:110)
>     at
> org.gradle.execution.SelectedTaskExecutionAction.execute(SelectedTaskExecutionAction.java:37)
>     at
> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>     at
> org.gradle.execution.DefaultBuildExecuter.access$000(DefaultBuildExecuter.java:23)
>     at
> org.gradle.execution.DefaultBuildExecuter$1.proceed(DefaultBuildExecuter.java:43)
>     at
> org.gradle.execution.DryRunBuildExecutionAction.execute(DryRunBuildExecutionAction.java:32)
>     at
> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>     at
> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:30)
>     at
> org.gradle.initialization.DefaultGradleLauncher$4.run(DefaultGradleLauncher.java:158)
>     at org.gradle.internal.Factories$1.create(Factories.java:22)
>     at
> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>     at
> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:52)
>     at
> org.gradle.initialization.DefaultGradleLauncher.doBuildStages(DefaultGradleLauncher.java:155)
>     at
> org.gradle.initialization.DefaultGradleLauncher.access$200(DefaultGradleLauncher.java:36)
>     at
> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:103)
>     at
> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:97)
>     at
> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>     at
> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:62)
>     at
> org.gradle.initialization.DefaultGradleLauncher.doBuild(DefaultGradleLauncher.java:97)
>     at
> org.gradle.initialization.DefaultGradleLauncher.run(DefaultGradleLauncher.java:86)
>     at
> org.gradle.launcher.exec.InProcessBuildActionExecuter$DefaultBuildController.run(InProcessBuildActionExecuter.java:102)
>     at
> org.gradle.tooling.internal.provider.ExecuteBuildActionRunner.run(ExecuteBuildActionRunner.java:28)
>     at
> org.gradle.launcher.exec.ChainingBuildActionRunner.run(ChainingBuildActionRunner.java:35)
>     at
> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:47)
>     at
> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:32)
>     at
> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:77)
>     at
> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:47)
>     at
> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:51)
>     at
> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:28)
>     at org.gradle.launcher.cli.RunBuildAction.run(RunBuildAction.java:43)
>     at
> org.gradle.internal.Actions$RunnableActionAdapter.execute(Actions.java:170)
>     at
> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:237)
>     at
> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:210)
>     at
> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:35)
>     at
> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:24)
>     at
> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:206)
>     at
> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:169)
>     at
> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:33)
>     at
> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:22)
>     at org.gradle.launcher.Main.doAction(Main.java:33)
>     at org.gradle.launcher.bootstrap.EntryPoint.run(EntryPoint.java:45)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>     at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>     at java.lang.reflect.Method.invoke(Method.java:498)
>     at
> org.gradle.launcher.bootstrap.ProcessBootstrap.runNoExit(ProcessBootstrap.java:54)
>     at
> org.gradle.launcher.bootstrap.ProcessBootstrap.run(ProcessBootstrap.java:35)
>     at org.gradle.launcher.GradleMain.main(GradleMain.java:23)
> Caused by: org.apache.catalina.LifecycleException: Protocol handler
> initialization failed
>     at
> org.apache.catalina.connector.Connector.initInternal(Connector.java:983)
>     at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)
>     ... 153 more
> Caused by: java.net.BindException: Address already in use <null>:8009
>     at org.apache.tomcat.util.net.JIoEndpoint.bind(JIoEndpoint.java:406)
>     at org.apache.tomcat.util.net
> .AbstractEndpoint.init(AbstractEndpoint.java:610)
>     at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:429)
>     at
> org.apache.catalina.connector.Connector.initInternal(Connector.java:981)
>     ... 154 more
> Caused by: java.net.BindException: Address already in use
>     at java.net.PlainSocketImpl.socketBind(Native Method)
>     at java.net
> .AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
>     at java.net.ServerSocket.bind(ServerSocket.java:375)
>     at java.net.ServerSocket.<init>(ServerSocket.java:237)
>     at java.net.ServerSocket.<init>(ServerSocket.java:181)
>     at org.apache.tomcat.util.net
> .DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:49)
>     at org.apache.tomcat.util.net.JIoEndpoint.bind(JIoEndpoint.java:393)
>     ... 157 more
> Started Tomcat Server
> The Server is running at http://localhost:8070/DataImportTool
> java.lang.IllegalStateException: java.net.ConnectException: Connection
> refused
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>     at
> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>     at
> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>     at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>     at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>     at org.apache.tomcat.util.net
> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>     at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>     at java.lang.Thread.run(Thread.java:745)
> Caused by: java.net.ConnectException: Connection refused
>     at java.net.PlainSocketImpl.socketConnect(Native Method)
>     at java.net
> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>     at java.net
> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>     at java.net
> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>     at java.net.Socket.connect(Socket.java:589)
>     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>     at
> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>     at
> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>     at
> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>     at
> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>     ... 21 more
> java.lang.IllegalStateException: java.net.ConnectException: Connection
> refused
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>     at
> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>     at
> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>     at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>     at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>     at org.apache.tomcat.util.net
> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>     at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>     at java.lang.Thread.run(Thread.java:745)
> Caused by: java.net.ConnectException: Connection refused
>     at java.net.PlainSocketImpl.socketConnect(Native Method)
>     at java.net
> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>     at java.net
> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>     at java.net
> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>     at java.net.Socket.connect(Socket.java:589)
>     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>     at
> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>     at
> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>     at
> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>     at
> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>     ... 21 more
> java.lang.IllegalStateException: java.net.ConnectException: Connection
> refused
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>     at
> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>     at
> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>     at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>     at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>     at org.apache.tomcat.util.net
> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>     at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>     at java.lang.Thread.run(Thread.java:745)
> Caused by: java.net.ConnectException: Connection refused
>     at java.net.PlainSocketImpl.socketConnect(Native Method)
>     at java.net
> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>     at java.net
> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>     at java.net
> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>     at java.net.Socket.connect(Socket.java:589)
>     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>     at
> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>     at
> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>     at
> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>     at
> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>     ... 21 more
> java.lang.IllegalStateException: java.net.ConnectException: Connection
> refused
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>     at
> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>     at
> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>     at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>     at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>     at org.apache.tomcat.util.net
> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>     at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>     at java.lang.Thread.run(Thread.java:745)
> Caused by: java.net.ConnectException: Connection refused
>     at java.net.PlainSocketImpl.socketConnect(Native Method)
>     at java.net
> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>     at java.net
> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>     at java.net
> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>     at java.net.Socket.connect(Socket.java:589)
>     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>     at
> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>     at
> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>     at
> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>     at
> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>     ... 21 more
> java.lang.IllegalStateException: java.net.ConnectException: Connection
> refused
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>     at
> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>     at
> org.openmf.mifos.dataimport.populator.client.CenterWorkbookPopulator.downloadAndParse(CenterWorkbookPopulator.java:58)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>     at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>     at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>     at org.apache.tomcat.util.net
> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>     at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>     at java.lang.Thread.run(Thread.java:745)
> Caused by: java.net.ConnectException: Connection refused
>     at java.net.PlainSocketImpl.socketConnect(Native Method)
>     at java.net
> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>     at java.net
> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>     at java.net
> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>     at java.net.Socket.connect(Socket.java:589)
>     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>     at
> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>     at
> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>     at
> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>     at
> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>     ... 21 more
> java.lang.IllegalStateException: java.net.ConnectException: Connection
> refused
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>     at
> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>     at
> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>     at
> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>     at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>     at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>     at org.apache.tomcat.util.net
> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>     at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>     at java.lang.Thread.run(Thread.java:745)
> Caused by: java.net.ConnectException: Connection refused
>     at java.net.PlainSocketImpl.socketConnect(Native Method)
>     at java.net
> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>     at java.net
> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>     at java.net
> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>     at java.net.Socket.connect(Socket.java:589)
>     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>     at
> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>     at
> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>     at
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>     at
> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>     at
> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>     at
> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>     at
> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>     at
> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>     ... 21 more
> > Building 85% > :tomcatRunWar
>
> -------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
> On 07/26/2016 11:46 AM, Shreyaank Byadagi wrote:
>
>> Hi Mexina,
>>
>> Please share your complete  error log, so that I can guide you.
>>
>> Regards
>> Shreyaank
>>
>> On Tue, Jul 26, 2016 at 1:38 PM, Mexina M Daniel <me...@singo.co.tz>
>> wrote:
>>
>> Hi devs
>>>
>>> I would like someone to assist me of this problem am facing
>>>
>>> I have installed Data Import Tool successfully, i just have started to
>>> try
>>> to import clients, am facing a problem when downloading the template. It
>>> gives an error "java.net.ConnectException: Connection refused ".
>>>
>>> Also when i ran "gradle clean tomcatRunWar" it build up to 85%
>>>
>>> What could be the problem?
>>>
>>> Thanks in advance
>>>
>>>
>>> --
>>> Mexina M Daniel
>>> Lead Software Developer
>>> Research & Development
>>>
>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>
>>> Singo Africa Limited
>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>> Salaam
>>>
>>> singo.co.tz
>>>
>>> Lets grow together
>>>
>>>
>>>
>>
> --
> Mexina M Daniel
> Lead Software Developer
> Research & Development
>
> Tel:+255 222 618 511 | Mob: +255 712 110 791
>
> Singo Africa Limited
> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>
> singo.co.tz
>
> Lets grow together
>
>


-- 
Thanks and Regards
Shreyaank
E-mail:shreyaank@confluxtechnologies.com

Re: Connection problem in Data import tool

Posted by Mexina M Daniel <me...@singo.co.tz>.
Hi Shreyaank

When i run "gradle clean tomcatRunWar" this is what it display in the 
command prompt though it doesn't display from the beginning due to many 
contents to be displayed.

------------------------------------------------------------------------------------------------------------------------------------------
at org.gradle.internal.reflect.JavaMethod.invoke(JavaMethod.java:75)
     at 
org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.doExecute(AnnotationProcessingTaskFactory.java:226)
     at 
org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:219)
     at 
org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:208)
     at 
org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:585)
     at 
org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:568)
     at 
org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeAction(ExecuteActionsTaskExecuter.java:80)
     at 
org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeActions(ExecuteActionsTaskExecuter.java:61)
     at 
org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.execute(ExecuteActionsTaskExecuter.java:46)
     at 
org.gradle.api.internal.tasks.execution.PostExecutionAnalysisTaskExecuter.execute(PostExecutionAnalysisTaskExecuter.java:35)
     at 
org.gradle.api.internal.tasks.execution.SkipUpToDateTaskExecuter.execute(SkipUpToDateTaskExecuter.java:64)
     at 
org.gradle.api.internal.tasks.execution.ValidatingTaskExecuter.execute(ValidatingTaskExecuter.java:58)
     at 
org.gradle.api.internal.tasks.execution.SkipEmptySourceFilesTaskExecuter.execute(SkipEmptySourceFilesTaskExecuter.java:52)
     at 
org.gradle.api.internal.tasks.execution.SkipTaskWithNoActionsExecuter.execute(SkipTaskWithNoActionsExecuter.java:52)
     at 
org.gradle.api.internal.tasks.execution.SkipOnlyIfTaskExecuter.execute(SkipOnlyIfTaskExecuter.java:53)
     at 
org.gradle.api.internal.tasks.execution.ExecuteAtMostOnceTaskExecuter.execute(ExecuteAtMostOnceTaskExecuter.java:43)
     at 
org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:203)
     at 
org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:185)
     at 
org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.processTask(AbstractTaskPlanExecutor.java:62)
     at 
org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.run(AbstractTaskPlanExecutor.java:50)
     at 
org.gradle.execution.taskgraph.DefaultTaskPlanExecutor.process(DefaultTaskPlanExecutor.java:25)
     at 
org.gradle.execution.taskgraph.DefaultTaskGraphExecuter.execute(DefaultTaskGraphExecuter.java:110)
     at 
org.gradle.execution.SelectedTaskExecutionAction.execute(SelectedTaskExecutionAction.java:37)
     at 
org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
     at 
org.gradle.execution.DefaultBuildExecuter.access$000(DefaultBuildExecuter.java:23)
     at 
org.gradle.execution.DefaultBuildExecuter$1.proceed(DefaultBuildExecuter.java:43)
     at 
org.gradle.execution.DryRunBuildExecutionAction.execute(DryRunBuildExecutionAction.java:32)
     at 
org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
     at 
org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:30)
     at 
org.gradle.initialization.DefaultGradleLauncher$4.run(DefaultGradleLauncher.java:158)
     at org.gradle.internal.Factories$1.create(Factories.java:22)
     at 
org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
     at 
org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:52)
     at 
org.gradle.initialization.DefaultGradleLauncher.doBuildStages(DefaultGradleLauncher.java:155)
     at 
org.gradle.initialization.DefaultGradleLauncher.access$200(DefaultGradleLauncher.java:36)
     at 
org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:103)
     at 
org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:97)
     at 
org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
     at 
org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:62)
     at 
org.gradle.initialization.DefaultGradleLauncher.doBuild(DefaultGradleLauncher.java:97)
     at 
org.gradle.initialization.DefaultGradleLauncher.run(DefaultGradleLauncher.java:86)
     at 
org.gradle.launcher.exec.InProcessBuildActionExecuter$DefaultBuildController.run(InProcessBuildActionExecuter.java:102)
     at 
org.gradle.tooling.internal.provider.ExecuteBuildActionRunner.run(ExecuteBuildActionRunner.java:28)
     at 
org.gradle.launcher.exec.ChainingBuildActionRunner.run(ChainingBuildActionRunner.java:35)
     at 
org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:47)
     at 
org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:32)
     at 
org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:77)
     at 
org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:47)
     at 
org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:51)
     at 
org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:28)
     at org.gradle.launcher.cli.RunBuildAction.run(RunBuildAction.java:43)
     at 
org.gradle.internal.Actions$RunnableActionAdapter.execute(Actions.java:170)
     at 
org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:237)
     at 
org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:210)
     at 
org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:35)
     at 
org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:24)
     at 
org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:206)
     at 
org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:169)
     at 
org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:33)
     at 
org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:22)
     at org.gradle.launcher.Main.doAction(Main.java:33)
     at org.gradle.launcher.bootstrap.EntryPoint.run(EntryPoint.java:45)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:498)
     at 
org.gradle.launcher.bootstrap.ProcessBootstrap.runNoExit(ProcessBootstrap.java:54)
     at 
org.gradle.launcher.bootstrap.ProcessBootstrap.run(ProcessBootstrap.java:35)
     at org.gradle.launcher.GradleMain.main(GradleMain.java:23)
Caused by: org.apache.catalina.LifecycleException: Protocol handler 
initialization failed
     at 
org.apache.catalina.connector.Connector.initInternal(Connector.java:983)
     at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)
     ... 153 more
Caused by: java.net.BindException: Address already in use <null>:8009
     at org.apache.tomcat.util.net.JIoEndpoint.bind(JIoEndpoint.java:406)
     at 
org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:610)
     at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:429)
     at 
org.apache.catalina.connector.Connector.initInternal(Connector.java:981)
     ... 154 more
Caused by: java.net.BindException: Address already in use
     at java.net.PlainSocketImpl.socketBind(Native Method)
     at 
java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
     at java.net.ServerSocket.bind(ServerSocket.java:375)
     at java.net.ServerSocket.<init>(ServerSocket.java:237)
     at java.net.ServerSocket.<init>(ServerSocket.java:181)
     at 
org.apache.tomcat.util.net.DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:49)
     at org.apache.tomcat.util.net.JIoEndpoint.bind(JIoEndpoint.java:393)
     ... 157 more
Started Tomcat Server
The Server is running at http://localhost:8070/DataImportTool
java.lang.IllegalStateException: java.net.ConnectException: Connection 
refused
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
     at 
org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
     at 
org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
     at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
     at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
     at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
     at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
     at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
     at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
     at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.ConnectException: Connection refused
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at 
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
     at 
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
     at 
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
     at java.net.Socket.connect(Socket.java:589)
     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
     at 
sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
     at 
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
     at 
sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
     at 
org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
     ... 21 more
java.lang.IllegalStateException: java.net.ConnectException: Connection 
refused
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
     at 
org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
     at 
org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
     at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
     at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
     at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
     at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
     at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
     at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
     at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.ConnectException: Connection refused
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at 
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
     at 
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
     at 
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
     at java.net.Socket.connect(Socket.java:589)
     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
     at 
sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
     at 
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
     at 
sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
     at 
org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
     ... 21 more
java.lang.IllegalStateException: java.net.ConnectException: Connection 
refused
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
     at 
org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
     at 
org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
     at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
     at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
     at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
     at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
     at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
     at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
     at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.ConnectException: Connection refused
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at 
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
     at 
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
     at 
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
     at java.net.Socket.connect(Socket.java:589)
     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
     at 
sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
     at 
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
     at 
sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
     at 
org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
     ... 21 more
java.lang.IllegalStateException: java.net.ConnectException: Connection 
refused
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
     at 
org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
     at 
org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
     at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
     at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
     at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
     at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
     at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
     at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
     at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.ConnectException: Connection refused
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at 
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
     at 
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
     at 
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
     at java.net.Socket.connect(Socket.java:589)
     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
     at 
sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
     at 
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
     at 
sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
     at 
org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
     ... 21 more
java.lang.IllegalStateException: java.net.ConnectException: Connection 
refused
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
     at 
org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
     at 
org.openmf.mifos.dataimport.populator.client.CenterWorkbookPopulator.downloadAndParse(CenterWorkbookPopulator.java:58)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
     at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
     at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
     at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
     at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
     at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
     at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
     at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.ConnectException: Connection refused
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at 
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
     at 
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
     at 
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
     at java.net.Socket.connect(Socket.java:589)
     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
     at 
sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
     at 
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
     at 
sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
     at 
org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
     ... 21 more
java.lang.IllegalStateException: java.net.ConnectException: Connection 
refused
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
     at 
org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
     at 
org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
     at 
org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
     at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
     at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
     at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
     at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
     at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
     at 
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
     at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.ConnectException: Connection refused
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at 
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
     at 
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
     at 
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
     at java.net.Socket.connect(Socket.java:589)
     at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
     at 
sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
     at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
     at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
     at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
     at 
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
     at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
     at 
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
     at 
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
     at 
sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
     at 
org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
     at 
org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
     ... 21 more
 > Building 85% > :tomcatRunWar
-------------------------------------------------------------------------------------------------------------------------------------------------------

On 07/26/2016 11:46 AM, Shreyaank Byadagi wrote:
> Hi Mexina,
>
> Please share your complete  error log, so that I can guide you.
>
> Regards
> Shreyaank
>
> On Tue, Jul 26, 2016 at 1:38 PM, Mexina M Daniel <me...@singo.co.tz> wrote:
>
>> Hi devs
>>
>> I would like someone to assist me of this problem am facing
>>
>> I have installed Data Import Tool successfully, i just have started to try
>> to import clients, am facing a problem when downloading the template. It
>> gives an error "java.net.ConnectException: Connection refused ".
>>
>> Also when i ran "gradle clean tomcatRunWar" it build up to 85%
>>
>> What could be the problem?
>>
>> Thanks in advance
>>
>>
>> --
>> Mexina M Daniel
>> Lead Software Developer
>> Research & Development
>>
>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>
>> Singo Africa Limited
>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>>
>> singo.co.tz
>>
>> Lets grow together
>>
>>
>

-- 
Mexina M Daniel
Lead Software Developer
Research & Development

Tel:+255 222 618 511 | Mob: +255 712 110 791

Singo Africa Limited
Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam

singo.co.tz

Lets grow together


Re: Connection problem in Data import tool

Posted by Shreyaank Byadagi <sh...@confluxtechnologies.com>.
Hi Mexina,

Please share your complete  error log, so that I can guide you.

Regards
Shreyaank

On Tue, Jul 26, 2016 at 1:38 PM, Mexina M Daniel <me...@singo.co.tz> wrote:

> Hi devs
>
> I would like someone to assist me of this problem am facing
>
> I have installed Data Import Tool successfully, i just have started to try
> to import clients, am facing a problem when downloading the template. It
> gives an error "java.net.ConnectException: Connection refused ".
>
> Also when i ran "gradle clean tomcatRunWar" it build up to 85%
>
> What could be the problem?
>
> Thanks in advance
>
>
> --
> Mexina M Daniel
> Lead Software Developer
> Research & Development
>
> Tel:+255 222 618 511 | Mob: +255 712 110 791
>
> Singo Africa Limited
> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>
> singo.co.tz
>
> Lets grow together
>
>


-- 
Thanks and Regards
Shreyaank
E-mail:shreyaank@confluxtechnologies.com