Below is the error I got when I deleted the DBs in Cassandra, MySQL and started
the server with the given command.
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input
'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.
.
.
.
.
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter -
Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing failed;
nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22
no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed;
nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22
no viable alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
On 06/08/18, 10:24 PM, "Louis Niyongabo" <[email protected]> wrote:
No idea, let's rebuild those DBs:
1. delete ‘seshat’ and ‘playground’ databases from Cassandra and MySQL.
2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true
-Dcustom.cassandra.contactPoints=127.0.0.1:9042
-Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password
-Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root
-Dcustom.mariadb.password=mysql -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
And share the errors you get.
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:[email protected]]
Sent: Monday, August 6, 2018 18:37
To: [email protected]
Cc: [email protected]
Subject: Re: Fineract CN Setup issues
Thanks Louis. Will try this.
Any idea, why tables are not getting created in MySQL playground DB
schema.? Will they not be created when we start the Fineract server.?
On 06/08/18, 9:33 PM, "Louis Niyongabo" <[email protected]> wrote:
Hi Karthik,
Reference to your first email, I run into similar issues, down how the
workaround I used on Windows,
1. For the port 61616, I was getting this error "java.io.IOException:
Failed to bind to server socket: tcp://localhost:61616 due to:
java.net.BindException: Address already in use: JVM_Bind". I fixed it by
changing the config file activemq.xml, from 61616 into 51616.
2. For Cassandra, I realized that the service must be running during
setup. I had to change the config files cassandra.yaml and cassandra-env.sh for
hostname, listen_address, rpc_address to be 127.0.0.1, along created the folder
" cdc_raw" that wasn't there by default.
3. For local databases, when the services fail to start, delete the
databases in Casandra and start over until the services run successfully. Going
fotward, run the second command without " -Ddemoserver.provision=true". That
parameter was required to create the DBs the first time.
Regards,
Louis
-----Original Message-----
From: Karthik Ananthakrishnan
[mailto:[email protected]]
Sent: Monday, August 6, 2018 16:45
To: Dev <[email protected]>
Cc: [email protected]
Subject: Re: Fineract CN Setup issues
Hello All,
Below is the error logged when i try to start the FINERACT CN server
with provision = true. Don't get this when i set it to false. I need to get the
localstore created. So, not able to proceed. Can someone who has faced this and
resolved help me.?
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input
'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.'
.
.
.
13:17:28.435 [qtp630028734-22] INFO c.d.d.c.p.DCAwareRoundRobinPolicy
- Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this is
incorrect, please provide the correct datacenter name with
DCAwareRoundRobinPolicy constructor)
13:17:28.435 [qtp630028734-22] INFO com.datastax.driver.core.Cluster -
New Cassandra host /127.0.0.1:9042 added
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter
- Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing
failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing
failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
.
.
.
.
.
Caused by: org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561448970,"status":500,"error":"Internal Server
Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input 'date'","path":"/identity/v1/initialize"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy153.initialize(Unknown Source)
at
org.apache.fineract.cn.provisioner.internal.service.applications.IdentityServiceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
... 99 common frames omitted
13:17:29.023 [Thread-15] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@11438d26:
startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@7dc5e7b4
On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan <
[email protected]> wrote:
> Dear all,
>
> I am trying to setup Fineract CN in a EC2 machine following the
> instructions in https://cwiki.apache.org/confluence/display/FINERACT/
> How+To+Build+Apache+Fineract+CN
>
> I am facing the below issues. I am trying to create localstore DB to
> build the Jar. So i used the below command.
>
> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra
> -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> When i ran the above command, it created seshat and playground
schemas
> in MySQL and Cassandra. In MySQL - It didnot create any tables in
playground..
> It only created 1 entry in seshat - tenants table.
>
> Also i got the below error and server startup failed.
>
> Could not connect to broker URL: tcp://localhost:61616. Reason:
> java.net.ConnectException: Connection refused (Connection refused)
> Should i install Active MQ separately.? Also, i have not installed
> Maria DB. If anyone has done the setup successfully, please help us.
>
> Thanks,
> Karthik
>
>
>
