You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Ed Cable <ed...@mifos.org> on 2016/09/16 13:29:28 UTC

Fwd: Data Import Tool Issue reported by Moses on Gitter

Hi all,

Moses reported this issue with the data import tool reported this error a
while back - could anyone please try to help him?

Thanks,

Ed
---------- Forwarded message ----------
From: Ed Cable <ed...@mifos.org>
Date: Tue, Sep 13, 2016 at 10:10 AM
Subject: Data Import Tool Issue reported by Moses on Gitter
To: Nayan Ambali <na...@confluxtechnologies.com>, Avik Ganguly <
avikganguly010@gmail.com>, Shreyaank Byadagi <
shreyaank@confluxtechnologies.com>


Hi all,

Have we had a chance to look into this issue?

mossngugi @mossngugi Sep 05 06:06
@awasum I have checked the port number, mifos is running on 8443 here is
the server config file
<?xml version='1.0' encoding='utf-8'?>
<Server port="8005" shutdown="SHUTDOWN">
<Listener className="org.apache.catalina.core.JasperListener" />
<Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener"
/>
<Listener className="org.apache.catalina.mbeans.
GlobalResourcesLifecycleListener" />
<Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener"
/>

<GlobalNamingResources>
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />

<Resource type="javax.sql.DataSource" name="jdbc/mifosplatform-tenants"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="org.drizzle.jdbc.DrizzleDriver" url="jdbc:mysql:thin://
localhost:3306/mifosplatform-tenants" username="root" password="mysql"
initialSize="3" maxActive="10" maxIdle="6" minIdle="3"
validationQuery="SELECT 1" testOnBorrow="true" testOnReturn="true"
testWhileIdle="true" timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="60000" logAbandoned="true" suspectTimeout="60"
/>
</GlobalNamingResources>

<Service name="Catalina">

<Connector protocol="org.apache.coyote.http11.Http11Protocol" port="8443"
maxThreads="200" scheme="https" secure="true" SSLEnabled="true"
keystoreFile="C:/Users/mose/.keystore" keystorePass="wDVhU8!"
clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
compression="force" compressableMimeType="text/
html,text/xml,text/plain,text/javascript,text/css"/>

<Engine name="Catalina" defaultHost="localhost">

<Realm className="org.apache.catalina.realm.LockOutRealm">
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"
resourceName="UserDatabase"/>
</Realm>

<Host name="localhost" appBase="webapps" unpackWARs="true"
autoDeploy="true">

<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="localhost_access_log." suffix=".log" pattern="%h
%l %u %t "%r" %s %b" />
</Host>
</Engine>
</Service>
</Server>
I have changed mifos end point URL and mifos user ID as suggested above.
Unfortunately I have not succeed clearing the error.
java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at
line 1 column 1
I am using mifos version
Release Version: 16.06.01.RELEASE | Mifos X Release Date: 27/Jun/2016

Thanks,

Ed





-- 
*Ed Cable*
Director of Community Programs, Mifos Initiative
edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649

*Collectively Creating a World of 3 Billion Maries | *http://mifos.org
<http://facebook.com/mifos>  <http://www.twitter.com/mifos>

Re: Data Import Tool Issue reported by Moses on Gitter

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

My Skype id: mifos.support

Regards
Shreyaank

On Mon, Sep 19, 2016 at 12:21 PM, Moses gmail <mo...@gmail.com> wrote:

> Morning Shreyaank,
>
>
>
> Its ok we are still in time. Please share with me your skype ID.
>
> My skype ID is mosswaweru.
>
>
>
> Regards,
>
> Moses.
>
> *From:* Shreyaank Byadagi [mailto:shreyaank@confluxtechnologies.com]
> *Sent:* Monday, September 19, 2016 8:58 AM
> *To:* Moses gmail
> *Cc:* Ed Cable; dev@fineract.incubator.apache.org; Nayan Ambali; Avik
> Ganguly
>
> *Subject:* Re: Data Import Tool Issue reported by Moses on Gitter
>
>
>
> Hi Moses,
>
>
>
> Sorry for the delayed response, Please come over skype, I want check with
> your configuration settings.
>
>
>
> Regards
>
> Shreyaank
>
>
>
> On Fri, Sep 16, 2016 at 7:40 PM, Moses gmail <mo...@gmail.com> wrote:
>
> Ed,
>
>
>
> This error occurs when we try to *download the import sheet* from
> dataimport tool page and not at the time of actual import of data.
>
>
>
>
>
> Regards,
>
> Moses.
>
>
>
>
>
> *From:* Ed Cable [mailto:edcable@mifos.org]
> *Sent:* Friday, September 16, 2016 17:05 PM
> *To:* dev@fineract.incubator.apache.org; moses ngugi
> *Cc:* Nayan Ambali; Shreyaank Byadagi; Avik Gangulpic.twitter.com/
> 1doJI0HxLJ <https://t.co/1doJI0HxLJ>y
> *Subject:* Re: Data Import Tool Issue reported by Moses on Gitter
>
>
>
> Moses,
>
>
>
> Can you please reply to Nazeer's question?
>
>
>
> Thanks,
>
>
>
> Ed
>
>
>
> On Fri, Sep 16, 2016 at 7:01 AM, Nazeer Shaik <nazeer.shaik@
> confluxtechnologies.com> wrote:
>
> Hi,
>
> This error is seen when we try to import huge JSON data or when we try to
> import alpha numeric account numbers.
>
> Can you check whether account number is numeric or not?
>
> Thanks,
> Nazeer
>
>
> On Fri, Sep 16, 2016 at 6:59 PM, Ed Cable <ed...@mifos.org> wrote:
>
> > Hi all,
> >
> > Moses reported this issue with the data import tool reported this error a
> > while back - could anyone please try to help him?
> >
> > Thanks,
> >
> > Ed
> > ---------- Forwarded message ----------
> > From: Ed Cable <ed...@mifos.org>
> > Date: Tue, Sep 13, 2016 at 10:10 AM
> > Subject: Data Import Tool Issue reported by Moses on Gitter
> > To: Nayan Ambali <na...@confluxtechnologies.com>, Avik Ganguly <
> > avikganguly010@gmail.com>, Shreyaank Byadagi <
> > shreyaank@confluxtechnologies.com>
> >
> >
> > Hi all,
> >
> > Have we had a chance to look into this issue?
> >
> > mossngugi @mossngugi Sep 05 06:06
> > @awasum I have checked the port number, mifos is running on 8443 here is
> > the server config file
> > <?xml version='1.0' encoding='utf-8'?>
> > <Server port="8005" shutdown="SHUTDOWN">
> > <Listener className="org.apache.catalina.core.JasperListener" />
> > <Listener className="org.apache.catalina.core.
> > JreMemoryLeakPreventionListener"
> > />
> > <Listener className="org.apache.catalina.mbeans.
> > GlobalResourcesLifecycleListener" />
> > <Listener className="org.apache.catalina.core.
> > ThreadLocalLeakPreventionListener"
> > />
> >
> > <GlobalNamingResources>
> > <Resource name="UserDatabase" auth="Container"
> > type="org.apache.catalina.UserDatabase"
> > description="User database that can be updated and saved"
> > factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
> > pathname="conf/tomcat-users.xml" />
> >
> > <Resource type="javax.sql.DataSource" name="jdbc/mifosplatform-tenants"
> > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> > driverClassName="org.drizzle.jdbc.DrizzleDriver" url="jdbc:mysql:thin://
> > localhost:3306/mifosplatform-tenants" username="root" password="mysql"
> > initialSize="3" maxActive="10" maxIdle="6" minIdle="3"
> > validationQuery="SELECT 1" testOnBorrow="true" testOnReturn="true"
> > testWhileIdle="true" timeBetweenEvictionRunsMillis="30000"
> > minEvictableIdleTimeMillis="60000" logAbandoned="true"
> suspectTimeout="60"
> > />
> > </GlobalNamingResources>
> >
> > <Service name="Catalina">
> >
> > <Connector protocol="org.apache.coyote.http11.Http11Protocol"
> port="8443"
> > maxThreads="200" scheme="https" secure="true" SSLEnabled="true"
> > keystoreFile="C:/Users/mose/.keystore" keystorePass="wDVhU8!"
> > clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
> > compression="force" compressableMimeType="text/
> > html,text/xml,text/plain,text/javascript,text/css"/>
> >
> > <Engine name="Catalina" defaultHost="localhost">
> >
> > <Realm className="org.apache.catalina.realm.LockOutRealm">
> > <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
> > resourceName="UserDatabase"/>
> > </Realm>
> >
> > <Host name="localhost" appBase="webapps" unpackWARs="true"
> > autoDeploy="true">
> >
> > <Valve className="org.apache.catalina.valves.AccessLogValve"
> > directory="logs" prefix="localhost_access_log." suffix=".log" pattern="%h
> > %l %u %t "%r" %s %b" />
> > </Host>
> > </Engine>
> > </Service>
> > </Server>
> > I have changed mifos end point URL and mifos user ID as suggested above.
> > Unfortunately I have not succeed clearing the error.
> > java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at
> > line 1 column 1
> > I am using mifos version
> > Release Version: 16.06.01.RELEASE | Mifos X Release Date: 27/Jun/2016
> >
> > Thanks,
> >
> > Ed
> >
> >
> >
> >
> >
> > --
>
> > *Ed Cable*
> > Director of Community Programs, Mifos Initiative
> > edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
> >
> > *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> > <http://facebook.com/mifos>  <http://www.twitter.com/mifos>
> >
>
>
>
>
>
> --
>
> *Ed Cable*
>
> Director of Community Programs, Mifos Initiative
>
> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
>
>
>
> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> <http://facebook.com/mifos>  <http://www.twitter.com/mifos>
>
>
>
>
>
>
>
> --
>
> Thanks and Regards
>
> Shreyaank
>
> E-mail:shreyaank@confluxtechnologies.com
>
>
>



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

RE: Data Import Tool Issue reported by Moses on Gitter

Posted by Moses gmail <mo...@gmail.com>.
Morning Shreyaank,

 

Its ok we are still in time. Please share with me your skype ID.

My skype ID is mosswaweru.

 

Regards,

Moses.

From: Shreyaank Byadagi [mailto:shreyaank@confluxtechnologies.com] 
Sent: Monday, September 19, 2016 8:58 AM
To: Moses gmail
Cc: Ed Cable; dev@fineract.incubator.apache.org; Nayan Ambali; Avik Ganguly
Subject: Re: Data Import Tool Issue reported by Moses on Gitter

 

Hi Moses,

 

Sorry for the delayed response, Please come over skype, I want check with your configuration settings.

 

Regards

Shreyaank

 

On Fri, Sep 16, 2016 at 7:40 PM, Moses gmail <mo...@gmail.com> wrote:

Ed,

 

This error occurs when we try to download the import sheet from dataimport tool page and not at the time of actual import of data.

 

 

Regards,

Moses.

 

 

From: Ed Cable [mailto:edcable@mifos.org] 
Sent: Friday, September 16, 2016 17:05 PM
To: dev@fineract.incubator.apache.org; moses ngugi
Cc: Nayan Ambali; Shreyaank Byadagi; Avik Gangulpic.twitter.com/1doJI0HxLJ <https://t.co/1doJI0HxLJ> y
Subject: Re: Data Import Tool Issue reported by Moses on Gitter

 

Moses,

 

Can you please reply to Nazeer's question?

 

Thanks,

 

Ed

 

On Fri, Sep 16, 2016 at 7:01 AM, Nazeer Shaik <na...@confluxtechnologies.com> wrote:

Hi,

This error is seen when we try to import huge JSON data or when we try to
import alpha numeric account numbers.

Can you check whether account number is numeric or not?

Thanks,
Nazeer


On Fri, Sep 16, 2016 at 6:59 PM, Ed Cable <ed...@mifos.org> wrote:

> Hi all,
>
> Moses reported this issue with the data import tool reported this error a
> while back - could anyone please try to help him?
>
> Thanks,
>
> Ed
> ---------- Forwarded message ----------
> From: Ed Cable <ed...@mifos.org>
> Date: Tue, Sep 13, 2016 at 10:10 AM
> Subject: Data Import Tool Issue reported by Moses on Gitter
> To: Nayan Ambali <na...@confluxtechnologies.com>, Avik Ganguly <
> avikganguly010@gmail.com>, Shreyaank Byadagi <
> shreyaank@confluxtechnologies.com>
>
>
> Hi all,
>
> Have we had a chance to look into this issue?
>
> mossngugi @mossngugi Sep 05 06:06
> @awasum I have checked the port number, mifos is running on 8443 here is
> the server config file
> <?xml version='1.0' encoding='utf-8'?>
> <Server port="8005" shutdown="SHUTDOWN">
> <Listener className="org.apache.catalina.core.JasperListener" />
> <Listener className="org.apache.catalina.core.
> JreMemoryLeakPreventionListener"
> />
> <Listener className="org.apache.catalina.mbeans.
> GlobalResourcesLifecycleListener" />
> <Listener className="org.apache.catalina.core.
> ThreadLocalLeakPreventionListener"
> />
>
> <GlobalNamingResources>
> <Resource name="UserDatabase" auth="Container"
> type="org.apache.catalina.UserDatabase"
> description="User database that can be updated and saved"
> factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
> pathname="conf/tomcat-users.xml" />
>
> <Resource type="javax.sql.DataSource" name="jdbc/mifosplatform-tenants"
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> driverClassName="org.drizzle.jdbc.DrizzleDriver" url="jdbc:mysql:thin://
> localhost:3306/mifosplatform-tenants" username="root" password="mysql"
> initialSize="3" maxActive="10" maxIdle="6" minIdle="3"
> validationQuery="SELECT 1" testOnBorrow="true" testOnReturn="true"
> testWhileIdle="true" timeBetweenEvictionRunsMillis="30000"
> minEvictableIdleTimeMillis="60000" logAbandoned="true" suspectTimeout="60"
> />
> </GlobalNamingResources>
>
> <Service name="Catalina">
>
> <Connector protocol="org.apache.coyote.http11.Http11Protocol" port="8443"
> maxThreads="200" scheme="https" secure="true" SSLEnabled="true"
> keystoreFile="C:/Users/mose/.keystore" keystorePass="wDVhU8!"
> clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
> compression="force" compressableMimeType="text/
> html,text/xml,text/plain,text/javascript,text/css"/>
>
> <Engine name="Catalina" defaultHost="localhost">
>
> <Realm className="org.apache.catalina.realm.LockOutRealm">
> <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
> resourceName="UserDatabase"/>
> </Realm>
>
> <Host name="localhost" appBase="webapps" unpackWARs="true"
> autoDeploy="true">
>
> <Valve className="org.apache.catalina.valves.AccessLogValve"
> directory="logs" prefix="localhost_access_log." suffix=".log" pattern="%h
> %l %u %t "%r" %s %b" />
> </Host>
> </Engine>
> </Service>
> </Server>
> I have changed mifos end point URL and mifos user ID as suggested above.
> Unfortunately I have not succeed clearing the error.
> java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at
> line 1 column 1
> I am using mifos version
> Release Version: 16.06.01.RELEASE | Mifos X Release Date: 27/Jun/2016
>
> Thanks,
>
> Ed
>
>
>
>
>
> --

> *Ed Cable*
> Director of Community Programs, Mifos Initiative
> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649 <tel:%2B1.484.477.8649> 
>
> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> <http://facebook.com/mifos>  <http://www.twitter.com/mifos>
>





 

-- 

Ed Cable

Director of Community Programs, Mifos Initiative

edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649

 

Collectively Creating a World of 3 Billion Maries | http://mifos.org  <http://facebook.com/mifos>   <http://www.twitter.com/mifos> 

 





 

-- 

Thanks and Regards

Shreyaank

E-mail:shreyaank@confluxtechnologies.com

 


Re: Data Import Tool Issue reported by Moses on Gitter

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

Sorry for the delayed response, Please come over skype, I want check with
your configuration settings.

Regards
Shreyaank

On Fri, Sep 16, 2016 at 7:40 PM, Moses gmail <mo...@gmail.com> wrote:

> Ed,
>
>
>
> This error occurs when we try to *download the import sheet* from
> dataimport tool page and not at the time of actual import of data.
>
>
>
>
>
> Regards,
>
> Moses.
>
>
>
>
>
> *From:* Ed Cable [mailto:edcable@mifos.org]
> *Sent:* Friday, September 16, 2016 17:05 PM
> *To:* dev@fineract.incubator.apache.org; moses ngugi
> *Cc:* Nayan Ambali; Shreyaank Byadagi; Avik Gangulpic.twitter.com/
> 1doJI0HxLJ <https://t.co/1doJI0HxLJ>y
> *Subject:* Re: Data Import Tool Issue reported by Moses on Gitter
>
>
>
> Moses,
>
>
>
> Can you please reply to Nazeer's question?
>
>
>
> Thanks,
>
>
>
> Ed
>
>
>
> On Fri, Sep 16, 2016 at 7:01 AM, Nazeer Shaik <nazeer.shaik@
> confluxtechnologies.com> wrote:
>
> Hi,
>
> This error is seen when we try to import huge JSON data or when we try to
> import alpha numeric account numbers.
>
> Can you check whether account number is numeric or not?
>
> Thanks,
> Nazeer
>
>
> On Fri, Sep 16, 2016 at 6:59 PM, Ed Cable <ed...@mifos.org> wrote:
>
> > Hi all,
> >
> > Moses reported this issue with the data import tool reported this error a
> > while back - could anyone please try to help him?
> >
> > Thanks,
> >
> > Ed
> > ---------- Forwarded message ----------
> > From: Ed Cable <ed...@mifos.org>
> > Date: Tue, Sep 13, 2016 at 10:10 AM
> > Subject: Data Import Tool Issue reported by Moses on Gitter
> > To: Nayan Ambali <na...@confluxtechnologies.com>, Avik Ganguly <
> > avikganguly010@gmail.com>, Shreyaank Byadagi <
> > shreyaank@confluxtechnologies.com>
> >
> >
> > Hi all,
> >
> > Have we had a chance to look into this issue?
> >
> > mossngugi @mossngugi Sep 05 06:06
> > @awasum I have checked the port number, mifos is running on 8443 here is
> > the server config file
> > <?xml version='1.0' encoding='utf-8'?>
> > <Server port="8005" shutdown="SHUTDOWN">
> > <Listener className="org.apache.catalina.core.JasperListener" />
> > <Listener className="org.apache.catalina.core.
> > JreMemoryLeakPreventionListener"
> > />
> > <Listener className="org.apache.catalina.mbeans.
> > GlobalResourcesLifecycleListener" />
> > <Listener className="org.apache.catalina.core.
> > ThreadLocalLeakPreventionListener"
> > />
> >
> > <GlobalNamingResources>
> > <Resource name="UserDatabase" auth="Container"
> > type="org.apache.catalina.UserDatabase"
> > description="User database that can be updated and saved"
> > factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
> > pathname="conf/tomcat-users.xml" />
> >
> > <Resource type="javax.sql.DataSource" name="jdbc/mifosplatform-tenants"
> > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> > driverClassName="org.drizzle.jdbc.DrizzleDriver" url="jdbc:mysql:thin://
> > localhost:3306/mifosplatform-tenants" username="root" password="mysql"
> > initialSize="3" maxActive="10" maxIdle="6" minIdle="3"
> > validationQuery="SELECT 1" testOnBorrow="true" testOnReturn="true"
> > testWhileIdle="true" timeBetweenEvictionRunsMillis="30000"
> > minEvictableIdleTimeMillis="60000" logAbandoned="true"
> suspectTimeout="60"
> > />
> > </GlobalNamingResources>
> >
> > <Service name="Catalina">
> >
> > <Connector protocol="org.apache.coyote.http11.Http11Protocol"
> port="8443"
> > maxThreads="200" scheme="https" secure="true" SSLEnabled="true"
> > keystoreFile="C:/Users/mose/.keystore" keystorePass="wDVhU8!"
> > clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
> > compression="force" compressableMimeType="text/
> > html,text/xml,text/plain,text/javascript,text/css"/>
> >
> > <Engine name="Catalina" defaultHost="localhost">
> >
> > <Realm className="org.apache.catalina.realm.LockOutRealm">
> > <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
> > resourceName="UserDatabase"/>
> > </Realm>
> >
> > <Host name="localhost" appBase="webapps" unpackWARs="true"
> > autoDeploy="true">
> >
> > <Valve className="org.apache.catalina.valves.AccessLogValve"
> > directory="logs" prefix="localhost_access_log." suffix=".log" pattern="%h
> > %l %u %t "%r" %s %b" />
> > </Host>
> > </Engine>
> > </Service>
> > </Server>
> > I have changed mifos end point URL and mifos user ID as suggested above.
> > Unfortunately I have not succeed clearing the error.
> > java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at
> > line 1 column 1
> > I am using mifos version
> > Release Version: 16.06.01.RELEASE | Mifos X Release Date: 27/Jun/2016
> >
> > Thanks,
> >
> > Ed
> >
> >
> >
> >
> >
> > --
>
> > *Ed Cable*
> > Director of Community Programs, Mifos Initiative
> > edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
> >
> > *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> > <http://facebook.com/mifos>  <http://www.twitter.com/mifos>
> >
>
>
>
>
>
> --
>
> *Ed Cable*
>
> Director of Community Programs, Mifos Initiative
>
> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
>
>
>
> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> <http://facebook.com/mifos>  <http://www.twitter.com/mifos>
>
>
>



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

RE: Data Import Tool Issue reported by Moses on Gitter

Posted by Moses gmail <mo...@gmail.com>.
Ed,

 

This error occurs when we try to download the import sheet from dataimport tool page and not at the time of actual import of data.

 

 

Regards,

Moses.

 

 

From: Ed Cable [mailto:edcable@mifos.org] 
Sent: Friday, September 16, 2016 17:05 PM
To: dev@fineract.incubator.apache.org; moses ngugi
Cc: Nayan Ambali; Shreyaank Byadagi; Avik Gangulpic.twitter.com/1doJI0HxLJ <https://t.co/1doJI0HxLJ> y
Subject: Re: Data Import Tool Issue reported by Moses on Gitter

 

Moses,

 

Can you please reply to Nazeer's question?

 

Thanks,

 

Ed

 

On Fri, Sep 16, 2016 at 7:01 AM, Nazeer Shaik <na...@confluxtechnologies.com> wrote:

Hi,

This error is seen when we try to import huge JSON data or when we try to
import alpha numeric account numbers.

Can you check whether account number is numeric or not?

Thanks,
Nazeer


On Fri, Sep 16, 2016 at 6:59 PM, Ed Cable <ed...@mifos.org> wrote:

> Hi all,
>
> Moses reported this issue with the data import tool reported this error a
> while back - could anyone please try to help him?
>
> Thanks,
>
> Ed
> ---------- Forwarded message ----------
> From: Ed Cable <ed...@mifos.org>
> Date: Tue, Sep 13, 2016 at 10:10 AM
> Subject: Data Import Tool Issue reported by Moses on Gitter
> To: Nayan Ambali <na...@confluxtechnologies.com>, Avik Ganguly <
> avikganguly010@gmail.com>, Shreyaank Byadagi <
> shreyaank@confluxtechnologies.com>
>
>
> Hi all,
>
> Have we had a chance to look into this issue?
>
> mossngugi @mossngugi Sep 05 06:06
> @awasum I have checked the port number, mifos is running on 8443 here is
> the server config file
> <?xml version='1.0' encoding='utf-8'?>
> <Server port="8005" shutdown="SHUTDOWN">
> <Listener className="org.apache.catalina.core.JasperListener" />
> <Listener className="org.apache.catalina.core.
> JreMemoryLeakPreventionListener"
> />
> <Listener className="org.apache.catalina.mbeans.
> GlobalResourcesLifecycleListener" />
> <Listener className="org.apache.catalina.core.
> ThreadLocalLeakPreventionListener"
> />
>
> <GlobalNamingResources>
> <Resource name="UserDatabase" auth="Container"
> type="org.apache.catalina.UserDatabase"
> description="User database that can be updated and saved"
> factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
> pathname="conf/tomcat-users.xml" />
>
> <Resource type="javax.sql.DataSource" name="jdbc/mifosplatform-tenants"
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> driverClassName="org.drizzle.jdbc.DrizzleDriver" url="jdbc:mysql:thin://
> localhost:3306/mifosplatform-tenants" username="root" password="mysql"
> initialSize="3" maxActive="10" maxIdle="6" minIdle="3"
> validationQuery="SELECT 1" testOnBorrow="true" testOnReturn="true"
> testWhileIdle="true" timeBetweenEvictionRunsMillis="30000"
> minEvictableIdleTimeMillis="60000" logAbandoned="true" suspectTimeout="60"
> />
> </GlobalNamingResources>
>
> <Service name="Catalina">
>
> <Connector protocol="org.apache.coyote.http11.Http11Protocol" port="8443"
> maxThreads="200" scheme="https" secure="true" SSLEnabled="true"
> keystoreFile="C:/Users/mose/.keystore" keystorePass="wDVhU8!"
> clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
> compression="force" compressableMimeType="text/
> html,text/xml,text/plain,text/javascript,text/css"/>
>
> <Engine name="Catalina" defaultHost="localhost">
>
> <Realm className="org.apache.catalina.realm.LockOutRealm">
> <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
> resourceName="UserDatabase"/>
> </Realm>
>
> <Host name="localhost" appBase="webapps" unpackWARs="true"
> autoDeploy="true">
>
> <Valve className="org.apache.catalina.valves.AccessLogValve"
> directory="logs" prefix="localhost_access_log." suffix=".log" pattern="%h
> %l %u %t "%r" %s %b" />
> </Host>
> </Engine>
> </Service>
> </Server>
> I have changed mifos end point URL and mifos user ID as suggested above.
> Unfortunately I have not succeed clearing the error.
> java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at
> line 1 column 1
> I am using mifos version
> Release Version: 16.06.01.RELEASE | Mifos X Release Date: 27/Jun/2016
>
> Thanks,
>
> Ed
>
>
>
>
>
> --

> *Ed Cable*
> Director of Community Programs, Mifos Initiative
> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649 <tel:%2B1.484.477.8649> 
>
> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> <http://facebook.com/mifos>  <http://www.twitter.com/mifos>
>





 

-- 

Ed Cable

Director of Community Programs, Mifos Initiative

edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649

 

Collectively Creating a World of 3 Billion Maries | http://mifos.org  <http://facebook.com/mifos>   <http://www.twitter.com/mifos> 

 


Re: Data Import Tool Issue reported by Moses on Gitter

Posted by Ed Cable <ed...@mifos.org>.
Moses,

Can you please reply to Nazeer's question?

Thanks,

Ed

On Fri, Sep 16, 2016 at 7:01 AM, Nazeer Shaik <
nazeer.shaik@confluxtechnologies.com> wrote:

> Hi,
>
> This error is seen when we try to import huge JSON data or when we try to
> import alpha numeric account numbers.
>
> Can you check whether account number is numeric or not?
>
> Thanks,
> Nazeer
>
> On Fri, Sep 16, 2016 at 6:59 PM, Ed Cable <ed...@mifos.org> wrote:
>
> > Hi all,
> >
> > Moses reported this issue with the data import tool reported this error a
> > while back - could anyone please try to help him?
> >
> > Thanks,
> >
> > Ed
> > ---------- Forwarded message ----------
> > From: Ed Cable <ed...@mifos.org>
> > Date: Tue, Sep 13, 2016 at 10:10 AM
> > Subject: Data Import Tool Issue reported by Moses on Gitter
> > To: Nayan Ambali <na...@confluxtechnologies.com>, Avik Ganguly <
> > avikganguly010@gmail.com>, Shreyaank Byadagi <
> > shreyaank@confluxtechnologies.com>
> >
> >
> > Hi all,
> >
> > Have we had a chance to look into this issue?
> >
> > mossngugi @mossngugi Sep 05 06:06
> > @awasum I have checked the port number, mifos is running on 8443 here is
> > the server config file
> > <?xml version='1.0' encoding='utf-8'?>
> > <Server port="8005" shutdown="SHUTDOWN">
> > <Listener className="org.apache.catalina.core.JasperListener" />
> > <Listener className="org.apache.catalina.core.
> > JreMemoryLeakPreventionListener"
> > />
> > <Listener className="org.apache.catalina.mbeans.
> > GlobalResourcesLifecycleListener" />
> > <Listener className="org.apache.catalina.core.
> > ThreadLocalLeakPreventionListener"
> > />
> >
> > <GlobalNamingResources>
> > <Resource name="UserDatabase" auth="Container"
> > type="org.apache.catalina.UserDatabase"
> > description="User database that can be updated and saved"
> > factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
> > pathname="conf/tomcat-users.xml" />
> >
> > <Resource type="javax.sql.DataSource" name="jdbc/mifosplatform-tenants"
> > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> > driverClassName="org.drizzle.jdbc.DrizzleDriver" url="jdbc:mysql:thin://
> > localhost:3306/mifosplatform-tenants" username="root" password="mysql"
> > initialSize="3" maxActive="10" maxIdle="6" minIdle="3"
> > validationQuery="SELECT 1" testOnBorrow="true" testOnReturn="true"
> > testWhileIdle="true" timeBetweenEvictionRunsMillis="30000"
> > minEvictableIdleTimeMillis="60000" logAbandoned="true"
> suspectTimeout="60"
> > />
> > </GlobalNamingResources>
> >
> > <Service name="Catalina">
> >
> > <Connector protocol="org.apache.coyote.http11.Http11Protocol"
> port="8443"
> > maxThreads="200" scheme="https" secure="true" SSLEnabled="true"
> > keystoreFile="C:/Users/mose/.keystore" keystorePass="wDVhU8!"
> > clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
> > compression="force" compressableMimeType="text/
> > html,text/xml,text/plain,text/javascript,text/css"/>
> >
> > <Engine name="Catalina" defaultHost="localhost">
> >
> > <Realm className="org.apache.catalina.realm.LockOutRealm">
> > <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
> > resourceName="UserDatabase"/>
> > </Realm>
> >
> > <Host name="localhost" appBase="webapps" unpackWARs="true"
> > autoDeploy="true">
> >
> > <Valve className="org.apache.catalina.valves.AccessLogValve"
> > directory="logs" prefix="localhost_access_log." suffix=".log" pattern="%h
> > %l %u %t "%r" %s %b" />
> > </Host>
> > </Engine>
> > </Service>
> > </Server>
> > I have changed mifos end point URL and mifos user ID as suggested above.
> > Unfortunately I have not succeed clearing the error.
> > java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at
> > line 1 column 1
> > I am using mifos version
> > Release Version: 16.06.01.RELEASE | Mifos X Release Date: 27/Jun/2016
> >
> > Thanks,
> >
> > Ed
> >
> >
> >
> >
> >
> > --
> > *Ed Cable*
> > Director of Community Programs, Mifos Initiative
> > edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
> >
> > *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> > <http://facebook.com/mifos>  <http://www.twitter.com/mifos>
> >
>



-- 
*Ed Cable*
Director of Community Programs, Mifos Initiative
edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649

*Collectively Creating a World of 3 Billion Maries | *http://mifos.org
<http://facebook.com/mifos>  <http://www.twitter.com/mifos>

Re: Data Import Tool Issue reported by Moses on Gitter

Posted by Nazeer Shaik <na...@confluxtechnologies.com>.
Hi,

This error is seen when we try to import huge JSON data or when we try to
import alpha numeric account numbers.

Can you check whether account number is numeric or not?

Thanks,
Nazeer

On Fri, Sep 16, 2016 at 6:59 PM, Ed Cable <ed...@mifos.org> wrote:

> Hi all,
>
> Moses reported this issue with the data import tool reported this error a
> while back - could anyone please try to help him?
>
> Thanks,
>
> Ed
> ---------- Forwarded message ----------
> From: Ed Cable <ed...@mifos.org>
> Date: Tue, Sep 13, 2016 at 10:10 AM
> Subject: Data Import Tool Issue reported by Moses on Gitter
> To: Nayan Ambali <na...@confluxtechnologies.com>, Avik Ganguly <
> avikganguly010@gmail.com>, Shreyaank Byadagi <
> shreyaank@confluxtechnologies.com>
>
>
> Hi all,
>
> Have we had a chance to look into this issue?
>
> mossngugi @mossngugi Sep 05 06:06
> @awasum I have checked the port number, mifos is running on 8443 here is
> the server config file
> <?xml version='1.0' encoding='utf-8'?>
> <Server port="8005" shutdown="SHUTDOWN">
> <Listener className="org.apache.catalina.core.JasperListener" />
> <Listener className="org.apache.catalina.core.
> JreMemoryLeakPreventionListener"
> />
> <Listener className="org.apache.catalina.mbeans.
> GlobalResourcesLifecycleListener" />
> <Listener className="org.apache.catalina.core.
> ThreadLocalLeakPreventionListener"
> />
>
> <GlobalNamingResources>
> <Resource name="UserDatabase" auth="Container"
> type="org.apache.catalina.UserDatabase"
> description="User database that can be updated and saved"
> factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
> pathname="conf/tomcat-users.xml" />
>
> <Resource type="javax.sql.DataSource" name="jdbc/mifosplatform-tenants"
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> driverClassName="org.drizzle.jdbc.DrizzleDriver" url="jdbc:mysql:thin://
> localhost:3306/mifosplatform-tenants" username="root" password="mysql"
> initialSize="3" maxActive="10" maxIdle="6" minIdle="3"
> validationQuery="SELECT 1" testOnBorrow="true" testOnReturn="true"
> testWhileIdle="true" timeBetweenEvictionRunsMillis="30000"
> minEvictableIdleTimeMillis="60000" logAbandoned="true" suspectTimeout="60"
> />
> </GlobalNamingResources>
>
> <Service name="Catalina">
>
> <Connector protocol="org.apache.coyote.http11.Http11Protocol" port="8443"
> maxThreads="200" scheme="https" secure="true" SSLEnabled="true"
> keystoreFile="C:/Users/mose/.keystore" keystorePass="wDVhU8!"
> clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
> compression="force" compressableMimeType="text/
> html,text/xml,text/plain,text/javascript,text/css"/>
>
> <Engine name="Catalina" defaultHost="localhost">
>
> <Realm className="org.apache.catalina.realm.LockOutRealm">
> <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
> resourceName="UserDatabase"/>
> </Realm>
>
> <Host name="localhost" appBase="webapps" unpackWARs="true"
> autoDeploy="true">
>
> <Valve className="org.apache.catalina.valves.AccessLogValve"
> directory="logs" prefix="localhost_access_log." suffix=".log" pattern="%h
> %l %u %t "%r" %s %b" />
> </Host>
> </Engine>
> </Service>
> </Server>
> I have changed mifos end point URL and mifos user ID as suggested above.
> Unfortunately I have not succeed clearing the error.
> java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at
> line 1 column 1
> I am using mifos version
> Release Version: 16.06.01.RELEASE | Mifos X Release Date: 27/Jun/2016
>
> Thanks,
>
> Ed
>
>
>
>
>
> --
> *Ed Cable*
> Director of Community Programs, Mifos Initiative
> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
>
> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> <http://facebook.com/mifos>  <http://www.twitter.com/mifos>
>