ARD: Deployment error for .War File

Products

• CA Agile Requirements Designer

Issue/Introduction

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

 

Environment

Release : 3.0

Component : CA Agile Requirements Designer

Resolution

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.