17.2 installation is failing with error "Creation of CDB failed. Please refer to the log file"
Article ID: 189448
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
======
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.
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.
Feedback
Yes
No
Powered by
