OHDSI / OHDSI/WebAPI

Configuring Broadsea WebAPI

Open
#2,306 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Java
Stars
151
Forks
183
Avg merge
14m
Merged PRs (30d)
2

Description

Expected behavior

When we run the WebAPI docker container, we expected the server http://127.0.0.1/ to be opened. However, after we pulled the missing drivers (Oracle, Cloudera Impala, Starschema BigQuery, Netezza, simbam1Postgres) in addition to our existing drivers (ohdsi-atlas, broadsea-atlasdb, ohdsi-webapi), and tried to run this command "docker compose pull && docker compose --profile webapi-from-image --profile atlas-from-image --profile atlasdb --profile cloudera_driver --profile starschema_driver --profile oracle_driver --profile netezza_driver --profile apacheHive_driver --profile simbam1Postgres_driver up", the server start running but there is a schema called "starschema" running again and again. But it's not stopping.
#2304


How we can fix the start level of the WebAPI configurations, including the all the docker images that required by the OHDSI/WebAPI ?

==================================================================================
STACK TRACE:

starschema | [20:41:04 INF HostedJob 'AppConfigAutoRefresh'] Executed DbCommand (0ms) [Parameters=[@__p_0='?' (Size = 22)], CommandType='Text', CommandTimeout='30']
starschema | SELECT "f"."Name", "f"."Content", "f"."ContentType", "f"."LastUpdated"
starschema | FROM "Files" AS "f"
starschema | WHERE "f"."Name" = @__p_0
starschema | LIMIT 1
starschema | [20:41:04 INF HostedJob 'AppConfigAutoRefresh'] Hosted job: 'AppConfigAutoRefresh' completed successfully
starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Entity Framework Core 6.0.6 initialized 'SqliteDbContext' using provider 'Microsoft.EntityFrameworkCore.Sqlite:6.0.6' with options: DetailedErrorsEnabled MigrationsHistoryTable=__EFMigrationsHistory
starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Executed DbCommand (0ms) [Parameters=[@__p_0='?' (Size = 15)], CommandType='Text', CommandTimeout='30']
starschema | SELECT "f"."Name", "f"."Content", "f"."ContentType", "f"."LastUpdated"
starschema | FROM "Files" AS "f"
starschema | WHERE "f"."Name" = @__p_0
starschema | LIMIT 1
starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Entity Framework Core 6.0.6 initialized 'SqliteDbContext' using provider 'Microsoft.EntityFrameworkCore.Sqlite:6.0.6' with options: DetailedErrorsEnabled MigrationsHistoryTable=__EFMigrationsHistory
starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Executed DbCommand (0ms) [Parameters=[@__p_0='?' (Size = 22)], CommandType='Text', CommandTimeout='30']
starschema | SELECT "f"."Name", "f"."Content", "f"."ContentType", "f"."LastUpdated"
starschema | FROM "Files" AS "f"
starschema | WHERE "f"."Name" = @__p_0
starschema | LIMIT 1
starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Hosted job: 'AppConfigAutoRefresh' completed successfully

=================================================================================

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the reported docker compose command with the listed WebAPI, Atlas, database, and driver profiles, then inspect the compose configuration and the repeated starschema logs. Determine which service or dependency prevents startup from completing. Done means the WebAPI container starts reliably, the expected server is reachable at http://127.0.0.1/, and starschema no longer loops unexpectedly.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, docker-compose, java
Domain
backend-api-design, devops, infrastructure
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.