After manually installing ARD Hub 3.0, when starting the Tomcat server, the following error appears:
2019-12-11 15:52:33.529 ERROR [flow-storage,,,] 10200 --- [ main] ardflowstorage.dal.TenantSchemaDao : Flyway migration failed.
org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateSqlException:
Migration V0_1_0_282__Create_Subflow_External_Links_Tables.sql failed
---------------------------------------------------------------------
SQL State : S0000
Error Code : 1767
Message : Foreign key 'FK_SubFlow_File' references invalid table 'DBO.File'.
Location : ardflowstorage/sql/tenant/mssql/V0_1_0_282__Create_Subflow_External_Links_Tables.sql (D:\ARDHome_new\apache-tomcat-9.0.27\webapps\ard#flow-storage\WEB-INF\classes\ardflowstorage\sql\tenant\mssql\V0_1_0_282__Create_Subflow_External_Links_Tables.sql)
Line : 7
Statement : declare @tenantName nvarchar(255)
set @tenantName = 'DBO'
declare @SQLString nvarchar(4000)
set @SQLString = 'CREATE TABLE [' + @tenantName + '].[SubFlow](
[id] [nvarchar](255) NOT NULL,
[idParentFlow] [nvarchar](255) NOT NULL,
[idChildFlowARD] [nvarchar](255) NOT NULL,
[idChildFlow] [nvarchar](255) NOT NULL,
[idParentFlowARD] [nvarchar](255) NOT NULL,
[idBlock] [int] NOT NULL
CONSTRAINT [PK_SubFlow] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [' + @tenantName + '].[SubFlow] WITH CHECK ADD CONSTRAINT [FK_SubFlow_File] FOREIGN KEY([idParentFlow])
REFERENCES [' + @tenantName + '].[File] ([id])
ALTER TABLE [' + @tenantName + '].[SubFlow] CHECK CONSTRAINT [FK_SubFlow_File]'
execute sp_executesql @SQLString
Release : 3.0
Component : CA Agile Requirements Designer
Obtain and review the settings.properties file located in the folder: C:\Users\<user>\.ard\conf
Find the string("dbo") and make sure it is not capitalized.