SQL error on inserting test-org organisation

[winy57]

Hello,

I installed the OSGP platform using Vagrant, and I have a concern about the last step "creating the test-org organization".

When I run the sql script, I get an error. Looking in the PGAdmin console, I see that no table has been created in osgp_core.

Attached is the startup log of the application.

Thanks,

log.txt

[smvdheijden]

What error do you get when running the sql script?

From the startup log it looks like not all components were successfully deployed in Tomcat. Could you try building and deploying the components again? The database tables should be created on startup of the osgp_core component.

[winy57]

Here are the screenshot of sql error and successful maven clean install

[smvdheijden]

Have you tried deploying and running the osgp-core component in Tomcat once more? If the osgp-core component is starting correctly you should see logging of the flyway scripts generating the tables in the database. It should be something similar to the logging for the device simulator database migrations in your previous log file, but then with a connection to the osgp_core database and a lot more migrations:

2020-02-06 09:45:05.713] [dev-box] [localhost-startStop-1] INFO o.f.c.i.license.VersionPrinter@info:49 - Flyway Community Edition 6.1.4 by Redgate 2020-02-06 09:45:05.788] [dev-box] [localhost-startStop-1] INFO o.f.c.i.database.DatabaseFactory@info:49 - Database: jdbc:postgresql://localhost:5432/osp_devicesimulator_web (PostgreSQL 9.5) 2020-02-06 09:45:05.918] [dev-box] [localhost-startStop-1] INFO o.f.core.internal.command.DbValidate@info:49 - Successfully validated 6 migrations (execution time 00:00.069s) 2020-02-06 09:45:05.969] [dev-box] [localhost-startStop-1] INFO o.f.c.i.s.JdbcTableSchemaHistory@info:49 - Creating Schema History table "public"."schema_version" ... 2020-02-06 09:45:06.042] [dev-box] [localhost-startStop-1] INFO o.f.core.internal.command.DbMigrate@info:49 - Current version of schema "public": << Empty Schema >> 2020-02-06 09:45:06.042] [dev-box] [localhost-startStop-1] WARN o.f.core.internal.command.DbMigrate@warn:53 - outOfOrder mode is active. Migration of schema "public" may not be reproducible. 2020-02-06 09:45:06.079] [dev-box] [localhost-startStop-1] INFO o.f.core.internal.command.DbMigrate@info:49 - Migrating schema "public" to version 2014.001 - Initial version PostgreSQL 2020-02-06 09:45:05.713] [dev-box] [localhost-startStop-1] INFO o.f.c.i.license.VersionPrinter@info:49 - Flyway Community Edition 6.1.4 by Redgate 2020-02-06 09:45:05.788] [dev-box] [localhost-startStop-1] INFO o.f.c.i.database.DatabaseFactory@info:49 - Database: jdbc:postgresql://localhost:5432/osp_devicesimulator_web (PostgreSQL 9.5) 2020-02-06 09:45:05.918] [dev-box] [localhost-startStop-1] INFO o.f.core.internal.command.DbValidate@info:49 - Successfully validated 6 migrations (execution time 00:00.069s) 2020-02-06 09:45:05.969] [dev-box] [localhost-startStop-1] INFO o.f.c.i.s.JdbcTableSchemaHistory@info:49 - Creating Schema History table "public"."schema_version" ... 2020-02-06 09:45:06.042] [dev-box] [localhost-startStop-1] INFO o.f.core.internal.command.DbMigrate@info:49 - Current version of schema "public": << Empty Schema >> 2020-02-06 09:45:06.042] [dev-box] [localhost-startStop-1] WARN o.f.core.internal.command.DbMigrate@warn:53 - outOfOrder mode is active. Migration of schema "public" may not be reproducible. 2020-02-06 09:45:06.079] [dev-box] [localhost-startStop-1] INFO o.f.core.internal.command.DbMigrate@info:49 - Migrating schema "public" to version 2014.001 - Initial version PostgreSQL