Hi Robert, That should probably be a bug in the provision.sh script. Please could report the issue and we will work on it.
Regards, Courage. On Thu, May 30, 2019, 3:58 AM [email protected] < [email protected]> wrote: > > > 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 >
