Question about fhir-persistence-schema-4.11.1-cli.jar #351

m-onyshchuk · 2022-08-10T07:47:38Z

m-onyshchuk
Aug 10, 2022

Hello everybody!
I have question about fhir-persistence-schema-4.11.1-cli.jar tool from here:
https://github.com/LinuxForHealth/FHIR/tree/main/fhir-persistence-schema

Command to create the target schema:

java -jar fhir-persistence-schema-4.11.1-cli.jar \
--db-type postgresql \
--prop-file fhirdb.properties \
--schema-name fhirdata \
--create-schemas

works fine.
Command to create the tables and indexes:

java -jar fhir-persistence-schema-4.11.1-cli.jar \
--db-type postgresql \
--prop-file fhirdb.properties \
--schema-name fhirdata \
--update-schema \
--grant-to fhirserver \
--pool-size 1

created tables and indexes well but finished with error:

org.postgresql.util.PSQLException: ERROR: role "fhirserver" does not exist
com.ibm.fhir.database.utils.api.UndefinedNameException: org.postgresql.util.PSQLException: ERROR: role "fhirserver" does not exist
        at com.ibm.fhir.database.utils.postgres.PostgresTranslator.translate(PostgresTranslator.java:101)
        at com.ibm.fhir.database.utils.common.CommonDatabaseAdapter.runStatement(CommonDatabaseAdapter.java:252)
        at com.ibm.fhir.database.utils.common.CommonDatabaseAdapter.grantSequencePrivileges(CommonDatabaseAdapter.java:688)
        at com.ibm.fhir.database.utils.model.Sequence.grantGroupPrivileges(Sequence.java:71)
        at com.ibm.fhir.database.utils.model.BaseObject.grant(BaseObject.java:292)
        at com.ibm.fhir.database.utils.model.PhysicalDataModel.applyGrants(PhysicalDataModel.java:514)
        at com.ibm.fhir.schema.app.Main.grantPrivilegesForFhirData(Main.java:953)
        at com.ibm.fhir.schema.app.Main.updateFhirSchema(Main.java:567)
        at com.ibm.fhir.schema.app.Main.updateSchemas(Main.java:474)
        at com.ibm.fhir.schema.app.Main.process(Main.java:2680)
        at com.ibm.fhir.schema.app.Main.main(Main.java:2791)

Is this a critical error for FHIR Server? How can I fix it?