On 2019/05/27 06:23:11, Kelvin Ikome <[email protected]> wrote:
> Take a look at this:
> https://github.com/apache/fineract-cn-portfolio/blob/develop/service/src/main/java/org/apache/fineract/cn/portfolio/service/rest/InitializeRestController.java
>
> On Mon, May 27, 2019 at 7:19 AM Kelvin Ikome <[email protected]> wrote:
>
> > There should be an "/initialize" endpoint for every microservice. I think
> > you can trigger the process by making an API call to this endpoint.
> >
> > On Mon, May 27, 2019 at 7:07 AM [email protected] <
> > [email protected]> wrote:
> >
> >>
> >>
> >> On 2019/05/27 04:52:25, Kelvin Ikome <[email protected]> wrote:
> >> > Hi Robert,
> >> >
> >> > Check if the portfolio service has been provisioned. If not, you would
> >> need
> >> > to provision it to create the database tables.
> >> >
> >> > Kelvin
> >> >
> >> > On Mon, May 27, 2019 at 4:18 AM [email protected] <
> >> > [email protected]> wrote:
> >> >
> >> > >
> >> > >
> >> > > On 2019/05/23 05:13:27, [email protected] <
> >> > > [email protected]> wrote:
> >> > > > Hello everyone,
> >> > > >
> >> > > > I have managed to deploy Fineract CN on Docker. I used the scripts
> >> from
> >> > > here: https://github.com/openMF/fineract-cn-containers
> >> > > >
> >> > > > After running start-up.sh, I then run the provision.sh script using
> >> > > 'bash set-up.sh provision samplethree'
> >> > > >
> >> > > > I am able to sucessfully log-in and access the Office, Employee, and
> >> > > edit Roles and Permissions functions. However for the other functions
> >> like
> >> > > Member, Loan Product, Deposit Account Management I am unable to do
> >> anything
> >> > > with them. When I go to their respective pages, I get the error
> >> message:
> >> > > >
> >> > > > Service not available
> >> > > > We are very sorry, it seems there is a problem with our servers.
> >> Please
> >> > > contact your administrator if the problem occurs.
> >> > > >
> >> > > > Upon checking the logs, I get the following error:
> >> > > java.sql.SQLSyntaxErrorException: Table 'samplethree.bastet_products'
> >> > > doesn't exist
> >> > > >
> >> > > > https://pastebin.com/VhMp8hCT
> >> > > >
> >> > > > So how do I generate the various tables like bastet_products?
> >> > > >
> >> > > > Thank you.
> >> > > >
> >> > > > Regards,
> >> > > >
> >> > > > Robert Di
> >> > > >
> >> > >
> >> > > Hello Fineract community,
> >> > >
> >> > > Just want to follow up on this.
> >> > >
> >> > > Thank you!
> >> > >
> >> > > Robert Di
> >> > >
> >> > Hi Kelvin,
> >>
> >> Thank you for replying! Yes I have provisioned the portfolio service for
> >> my tenant. However the tables are not generated. I have tried already
> >> generating many tenants using the set-up.sh and provision.sh scripts, (e.g.
> >> bash set-up.sh provision tenantone)
> >>
> >> Sometimes all tables for all services are created successfully, sometimes
> >> only a few tables are generated, sometimes not even one table is created. I
> >> also sometimes get Access Denied errors like this one below:
> >>
> >> {
> >> "timestamp": 1558936951136,
> >> "status": 403,
> >> "error": "Forbidden",
> >> "message": "Access Denied",
> >> "path": "/identity/v1/users/operator/password"
> >> }
> >>
> >> Can this be the cause for the tables sometimes not being generated? Do
> >> you have any idea how Flyway for each service is being triggered by the
> >> provisioner?
> >>
> >> Thank you.
> >>
> >> Robert Di
> >>
> >
>
Hi Kelvin,
Thank you for that. I was able to successfully generate tables by running the
provision method again for each service with missing tables. But I would like
to ask why this does not work on the first run of provision.sh? This script
already provisions all applications upon creation of the tenant.
Also, in the cassandra.seshat database, I noticed that the tenant_application
table only stores one application by default as seen below. This is the last
application that was provisioned to the tenant.
tenant_identifier | assigned_applications
-------------------+-----------------------
samplethree | {'accounting-v1'}
Shouldn't it store all applications provisioned for it like this?
tenant_identifier | assigned_applications
-------------------+-----------------------
samplethree | {'accounting-v1', {office-v1}
Regards,
Robert Di
