search cancel

17.2 installation is failing with error "Creation of CDB failed. Please refer to the log file"

book

Article ID: 189448

calendar_today

Updated On:

Products

CA Service Desk Manager SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager - Mobile Application CA Service Desk Manager - Xtraction

Issue/Introduction

Issue:
======
During installation of SDM 17.2 to add new application server in AA set up , getting the below error:

"Creation of CDB failed. Please refer to the log file"


Environmental Details:
======================
Service Desk Manager 17.2

In the mdb.log below errors are seen:
=====================================

INFO -    ALTER TABLE [ca_asset] ADD CONSTRAINT [FKca_asset_tnt] FOREIGN KEY ( [tenant] ) REFERENCES [ca_tenant] ( [id] )
Update sql failed:ALTER TABLE [ca_asset] ADD CONSTRAINT [FKca_asset_tnt] FOREIGN KEY ( [tenant] ) REFERENCES [ca_tenant] ( [id] )
04-21,23:35:14 DEBUG - The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FKca_asset_tnt". The conflict occurred in database "mdb", table "dbo.ca_tenant", column 'id'.
INFO - MDBTools_0308I - Installation of last object failed, requeuing it to the end of the list.
INFO - MDBTools_0305E - Error processing foreign key 'fkca_asset_tnt.xml'; details follow:
ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FKca_asset_tnt". The conflict occurred in database "mdb", table "dbo.ca_tenant", column 'id'.
com.microsoft.sqlserver.jdbc.SQLServerException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FKca_asset_tnt". The conflict occurred in database "mdb", table "dbo.ca_tenant", column 'id'.
.
ERROR - MDBTools_0307E - SQL text:
ERROR -    ALTER TABLE [ca_asset] ADD CONSTRAINT [FKca_asset_tnt] FOREIGN KEY ( [tenant] ) REFERENCES [ca_tenant] ( [id] )
ERROR - MDBTools_0309E - DBDriver failed to install!
INFO - MDBTools_0104I - Total time: 0H:0M:35S.
MDBTools install error=3 
Setupmdb exit /B return code=3 

Environment

Release : 17.2

Component : SERVICE DESK MANAGER

Resolution

It indicates that in asset table "ca_asset" there are some assets which are pointing to a non-existing tenant in ca_tenant table. 
Need to check ca_asset table and either update it with valid tenant value for such rows or delete those rows if not needed.
Once all the records are corrected, rerun the installer.

Before making any changes please make sure to take a backup of the MDB.