I'm attempting to start my Jira container using a SQL Server database and seeing a long chain of errors starting with the lines below. I suspect this is related to an error I saw elsewhere (https://community.atlassian.com/t5/Jira-questions/Jira-6-2-3-SQL-exception-on-start/qaq-p/116007) where a schema name 'public' was specified in the dbconfig.xml file, but since I'm running in a container (and on Azure using ACI which is more constrained) I'm trying to use the environment variable config model from the atlassian/jira-core container and this container does not seem to expose a way to config the schema name. I have created the schema named "jiraschema" as suggested in the SQL Server docs. I've also tried creating a schema named 'public' but that is a reserved keyword in SQL Server.
Any suggestions on how I can proceed? Thank you!
2019-08-13 22:35:30,383 JIRA-Bootstrap INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Driver Version is 7.2.1.0
2019-08-13 22:35:30,488 JIRA-Bootstrap WARN [o.o.c.entity.jdbc.DatabaseUtil] Entity "Action" has no table in the database
2019-08-13 22:35:30,491 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not create table "public.jiraaction"
2019-08-13 22:35:30,491 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE TABLE public.jiraaction (ID NUMERIC NOT NULL, issueid NUMERIC, AUTHOR NVARCHAR(255), actiontype NVARCHAR(255), actionlevel NVARCHAR(255), rolelevel NUMERIC, actionbody NTEXT, CREATED DATETIME, UPDATEAUTHOR NVARCHAR(255), UPDATED DATETIME, actionnum NUMERIC, CONSTRAINT PK_jiraaction PRIMARY KEY (ID))
Error was: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'public'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.