Fresh Installation of Broadsea with MSSQL

[yangliu2009 (Yang Liu)]

I have read Fresh installation using Broadsea (Fresh installation using BroadSea) which is very helpful. I followed the steps there. But I install Broadsea with

1. MSSQL server 2019 Express
2. Windows 10 Home
3. Docker Desktop for Windows
4. mssql-jdbc-9.2.1.jre15.jar
5. Java version 16
6. Common Data Model v6.0 for MSSQL (CommonDataModel/Sql Server at master · OHDSI/CommonDataModel · GitHub)

I have done the followings:

1. Set up MSSQL database (SQL Server Setup Guide · OHDSI/WebAPI Wiki · GitHub). I could connect to the database using Microsoft SQL Server Management Studio.
2. I ran the ddl.txt (CommonDataModel/Sql Server at master · OHDSI/CommonDataModel · GitHub) in SQL Server Manager Studio, and the OHDSI database now has dbo.* tables, e.g. dbo.care_site.
3. Followed the instructions (GitHub - OHDSI/Broadsea: Broadsea deploys the full OHDSI technology stack (R methods library & web tools), using cross-platform Docker container technology.) to modify the docker-compose.yml
   
   
   
   4.In Windows Powershell, ran docker-compose up -d, docker-compose ps, and then docker exec -it test_broadsea-webtools_1 bash
4. In the docker container, here is the stderr file:
   
   
   
   Here is the stdout file
   
   
   
   
   

Then the ohdsi.source and ohdsi.source_daimon tables were not created. I received the following error when running the source_source_daimon.sql.

How to fix the issue so that the dhsi.source and dhsi.source_daimon table can be created?

Thanks.
Yang