In the install_mdb the below errors are showing:
08-24,08:37:47 INFO - MDBTools_0303I - Processing other: sql_7_012_0_meta_RTC187197.xml timestamp: 2014-04-14T06:56:59+0000
08-24,08:37:47 INFO - MDBTools_0306I - SQL text:
08-24,08:37:47 INFO - declare @script_id int
08-24,08:37:47 INFO - declare @script_name nvarchar(255)
08-24,08:37:47 INFO - declare @script_type int
08-24,08:37:47 INFO - declare @description nvarchar(255)
08-24,08:37:47 INFO - declare @user nvarchar(50)
08-24,08:37:47 INFO - declare @app_filter int
08-24,08:37:47 INFO - declare @update_date int
08-24,08:37:47 INFO - declare @stmt nvarchar(255)
08-24,08:37:47 INFO - -- Set these variables to appropriate values for this script --
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - /* script_name */
08-24,08:37:47 INFO - /* Must be a unique script name. */
08-24,08:37:47 INFO - /* Follow the naming convention found in */
08-24,08:37:47 INFO - /* SwCMProjectSetup.doc in Share Point */
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - set @script_name = 'sql_7_012_0_meta_RTC187197.sql'
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - /* script_type */
08-24,08:37:47 INFO - /* 0 = structure (DDL) */
08-24,08:37:47 INFO - /* 1 = meta (system or ui) */
08-24,08:37:47 INFO - /* 2 = data (non ui or system metadata) */
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - set @script_type = 0
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - /* description */
08-24,08:37:47 INFO - /* Add description as needed. */
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - set @description = 'Models created in SDM do not have FamilyId, Fill them'
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - /* app_filter */
08-24,08:37:47 INFO - /* Indicates which application is */
08-24,08:37:47 INFO - /* affected by this change */
08-24,08:37:47 INFO - /* 1 = SWCM, 2 = UAPM, 3 = SWCM/UAPM */
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - set @app_filter = 2
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - /* user */
08-24,08:37:47 INFO - /* Set to db user by default. */
08-24,08:37:47 INFO - /* No change should be necessary */
08-24,08:37:47 INFO - /*****************************************/
08-24,08:37:47 INFO - set @user = user
08-24,08:37:47 INFO - if (select count(0) from al_db_scripts where script_name = @script_name) > 0
08-24,08:37:47 INFO - begin
08-24,08:37:47 INFO - print 'Script ' + @script_name + ' has already been applied to this database.'
08-24,08:37:47 INFO - return
08-24,08:37:47 INFO - end
08-24,08:37:47 INFO - BEGIN TRY
08-24,08:37:47 INFO - print 'Begin script: ' + @script_name
08-24,08:37:47 INFO - -- BEGIN SQL Statements
08-24,08:37:47 INFO - /****************************************************************************************************************/
08-24,08:37:47 INFO - /* Note: Statements that need to be run in a separate batch should be executed via the sp_executesql procedure. */
08-24,08:37:47 INFO - /* The following statements will require a separate batch and will not run without using sp_executesql: */
08-24,08:37:47 INFO - /* CREATE PROCEDURE, CREATE TRIGGER, CREATE VIEW, CREATE DEFAULT, CREATE FUNCTION, CREATE RULE. */
08-24,08:37:47 INFO - /* Example: EXEC sp_executesql @statement = N'CREATE VIEW dbo.sample_view */
08-24,08:37:47 INFO - /* AS SELECT * from ca_owned_resource WHERE resource_name = ''abc'' ' */
08-24,08:37:47 INFO - /* */
08-24,08:37:47 INFO - /* Multiple EXEC sp_executesql statements can be included within a BEGIN TRY / END TRY block. */
08-24,08:37:47 INFO - /* Multiple BEGIN TRY / END TRY blocks can be included with corresponding BEGIN CATCH / END CATCH blocks. */
08-24,08:37:47 INFO - /****************************************************************************************************************/
08-24,08:37:47 INFO - MERGE ca_model_def AS md
08-24,08:37:47 INFO - USING (SELECT id, family_id from ca_resource_class with(readpast) where family_id is not null) AS rc
08-24,08:37:47 INFO - ON md.class_id = rc.id
08-24,08:37:47 INFO - WHEN MATCHED and md.family_id is null THEN Update set md.family_id = rc.family_id;
08-24,08:37:47 INFO - END TRY
08-24,08:37:47 INFO - BEGIN CATCH
08-24,08:37:47 INFO - print 'Error on line ' + cast(ERROR_LINE() as varchar(10)) + ': ' + ERROR_MESSAGE()
08-24,08:37:47 INFO - return
08-24,08:37:47 INFO - END CATCH
08-24,08:37:47 INFO - set @update_date = datediff(ss, '1/1/1970', getutcdate())
08-24,08:37:47 INFO - set @script_id = (select max(script_id) from al_db_scripts) + 1
08-24,08:37:47 INFO - if @script_id is null
08-24,08:37:47 INFO - begin
08-24,08:37:47 INFO - set @script_id = 0
08-24,08:37:47 INFO - end
08-24,08:37:47 INFO - insert into al_db_scripts (script_id, script_name, script_type, description, creation_date, creation_user, last_update_date, last_update_user, app_filter)
08-24,08:37:47 INFO - values(@script_id, @script_name, @script_type, @description, @update_date, @user, @update_date, @user, @app_filter)
08-24,08:37:47 INFO - print 'End script: ' + @script_name
Update sql failed:declare @script_id int
declare @script_name nvarchar(255)
declare @script_type int
declare @description nvarchar(255)
declare @user nvarchar(50)
declare @app_filter int
declare @update_date int
declare @stmt nvarchar(255)
-- Set these variables to appropriate values for this script --
/*****************************************/
/* script_name */
/* Must be a unique script name. */
/* Follow the naming convention found in */
/* SwCMProjectSetup.doc in Share Point */
/*****************************************/
set @script_name = 'sql_7_012_0_meta_RTC187197.sql'
/*****************************************/
/* script_type */
/* 0 = structure (DDL) */
/* 1 = meta (system or ui) */
/* 2 = data (non ui or system metadata) */
/*****************************************/
set @script_type = 0
/*****************************************/
/* description */
/* Add description as needed. */
/*****************************************/
set @description = 'Models created in SDM do not have FamilyId, Fill them'
/*****************************************/
/* app_filter */
/* Indicates which application is */
/* affected by this change */
/* 1 = SWCM, 2 = UAPM, 3 = SWCM/UAPM */
/*****************************************/
set @app_filter = 2
/*****************************************/
/* user */
/* Set to db user by default. */
/* No change should be necessary */
/*****************************************/
set @user = user
if (select count(0) from al_db_scripts where script_name = @script_name) > 0
begin
print 'Script ' + @script_name + ' has already been applied to this database.'
return
end
BEGIN TRY
print 'Begin script: ' + @script_name
-- BEGIN SQL Statements
/****************************************************************************************************************/
/* Note: Statements that need to be run in a separate batch should be executed via the sp_executesql procedure. */
/* The following statements will require a separate batch and will not run without using sp_executesql: */
/* CREATE PROCEDURE, CREATE TRIGGER, CREATE VIEW, CREATE DEFAULT, CREATE FUNCTION, CREATE RULE. */
/* Example: EXEC sp_executesql @statement = N'CREATE VIEW dbo.sample_view */
/* AS SELECT * from ca_owned_resource WHERE resource_name = ''abc'' ' */
/* */
/* Multiple EXEC sp_executesql statements can be included within a BEGIN TRY / END TRY block. */
/* Multiple BEGIN TRY / END TRY blocks can be included with corresponding BEGIN CATCH / END CATCH blocks. */
/****************************************************************************************************************/
MERGE ca_model_def AS md
USING (SELECT id, family_id from ca_resource_class with(readpast) where family_id is not null) AS rc
ON md.class_id = rc.id
WHEN MATCHED and md.family_id is null THEN Update set md.family_id = rc.family_id;
END TRY
BEGIN CATCH
print 'Error on line ' + cast(ERROR_LINE() as varchar(10)) + ': ' + ERROR_MESSAGE()
return
END CATCH
set @update_date = datediff(ss, '1/1/1970', getutcdate())
set @script_id = (select max(script_id) from al_db_scripts) + 1
if @script_id is null
begin
set @script_id = 0
end
insert into al_db_scripts (script_id, script_name, script_type, description, creation_date, creation_user, last_update_date, last_update_user, app_filter)
values(@script_id, @script_name, @script_type, @description, @update_date, @user, @update_date, @user, @app_filter)
print 'End script: ' + @script_name
08-24,08:37:47 DEBUG - Incorrect syntax near 'MERGE'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.
08-24,08:37:47 INFO - MDBTools_0308I - Installation of last object failed, requeuing it to the end of the list.
08-24,08:37:47 INFO - MDBTools_0305E - Error processing other 'sql_7_012_0_meta_RTC187197.xml'; details follow:
08-24,08:37:47 ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'MERGE'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'MERGE'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown Source)
at com.ca.mdbtools.DriverApp.updateDB(DriverApp.java:2697)
at com.ca.mdbtools.DriverApp.apply(DriverApp.java:2256)
at com.ca.mdbtools.DriverApp.installSchemaDriver(DriverApp.java:1085)
at com.ca.mdbtools.Utilities.run(Utilities.java:1678)
at com.ca.mdbtools.Utilities.main(Utilities.java:1042)
08-24,08:37:47 ERROR - MDBTools_0307E - SQL text:
08-24,08:37:47 ERROR - declare @script_id int
08-24,08:37:47 ERROR - declare @script_name nvarchar(255)
08-24,08:37:47 ERROR - declare @script_type int
08-24,08:37:47 ERROR - declare @description nvarchar(255)
08-24,08:37:47 ERROR - declare @user nvarchar(50)
08-24,08:37:47 ERROR - declare @app_filter int
08-24,08:37:47 ERROR - declare @update_date int
08-24,08:37:47 ERROR - declare @stmt nvarchar(255)
08-24,08:37:47 ERROR - -- Set these variables to appropriate values for this script --
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - /* script_name */
08-24,08:37:47 ERROR - /* Must be a unique script name. */
08-24,08:37:47 ERROR - /* Follow the naming convention found in */
08-24,08:37:47 ERROR - /* SwCMProjectSetup.doc in Share Point */
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - set @script_name = 'sql_7_012_0_meta_RTC187197.sql'
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - /* script_type */
08-24,08:37:47 ERROR - /* 0 = structure (DDL) */
08-24,08:37:47 ERROR - /* 1 = meta (system or ui) */
08-24,08:37:47 ERROR - /* 2 = data (non ui or system metadata) */
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - set @script_type = 0
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - /* description */
08-24,08:37:47 ERROR - /* Add description as needed. */
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - set @description = 'Models created in SDM do not have FamilyId, Fill them'
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - /* app_filter */
08-24,08:37:47 ERROR - /* Indicates which application is */
08-24,08:37:47 ERROR - /* affected by this change */
08-24,08:37:47 ERROR - /* 1 = SWCM, 2 = UAPM, 3 = SWCM/UAPM */
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - set @app_filter = 2
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - /* user */
08-24,08:37:47 ERROR - /* Set to db user by default. */
08-24,08:37:47 ERROR - /* No change should be necessary */
08-24,08:37:47 ERROR - /*****************************************/
08-24,08:37:47 ERROR - set @user = user
08-24,08:37:47 ERROR - if (select count(0) from al_db_scripts where script_name = @script_name) > 0
08-24,08:37:47 ERROR - begin
08-24,08:37:47 ERROR - print 'Script ' + @script_name + ' has already been applied to this database.'
08-24,08:37:47 ERROR - return
08-24,08:37:47 ERROR - end
08-24,08:37:47 ERROR - BEGIN TRY
08-24,08:37:47 ERROR - print 'Begin script: ' + @script_name
08-24,08:37:47 ERROR - -- BEGIN SQL Statements
08-24,08:37:47 ERROR - /****************************************************************************************************************/
08-24,08:37:47 ERROR - /* Note: Statements that need to be run in a separate batch should be executed via the sp_executesql procedure. */
08-24,08:37:47 ERROR - /* The following statements will require a separate batch and will not run without using sp_executesql: */
08-24,08:37:47 ERROR - /* CREATE PROCEDURE, CREATE TRIGGER, CREATE VIEW, CREATE DEFAULT, CREATE FUNCTION, CREATE RULE. */
08-24,08:37:47 ERROR - /* Example: EXEC sp_executesql @statement = N'CREATE VIEW dbo.sample_view */
08-24,08:37:47 ERROR - /* AS SELECT * from ca_owned_resource WHERE resource_name = ''abc'' ' */
08-24,08:37:47 ERROR - /* */
08-24,08:37:47 ERROR - /* Multiple EXEC sp_executesql statements can be included within a BEGIN TRY / END TRY block. */
08-24,08:37:47 ERROR - /* Multiple BEGIN TRY / END TRY blocks can be included with corresponding BEGIN CATCH / END CATCH blocks. */
08-24,08:37:47 ERROR - /****************************************************************************************************************/
08-24,08:37:47 ERROR - MERGE ca_model_def AS md
08-24,08:37:47 ERROR - USING (SELECT id, family_id from ca_resource_class with(readpast) where family_id is not null) AS rc
08-24,08:37:47 ERROR - ON md.class_id = rc.id
08-24,08:37:47 ERROR - WHEN MATCHED and md.family_id is null THEN Update set md.family_id = rc.family_id;
08-24,08:37:47 ERROR - END TRY
08-24,08:37:47 ERROR - BEGIN CATCH
08-24,08:37:47 ERROR - print 'Error on line ' + cast(ERROR_LINE() as varchar(10)) + ': ' + ERROR_MESSAGE()
08-24,08:37:47 ERROR - return
08-24,08:37:47 ERROR - END CATCH
08-24,08:37:47 ERROR - set @update_date = datediff(ss, '1/1/1970', getutcdate())
08-24,08:37:47 ERROR - set @script_id = (select max(script_id) from al_db_scripts) + 1
08-24,08:37:47 ERROR - if @script_id is null
08-24,08:37:47 ERROR - begin
08-24,08:37:47 ERROR - set @script_id = 0
08-24,08:37:47 ERROR - end
08-24,08:37:47 ERROR - insert into al_db_scripts (script_id, script_name, script_type, description, creation_date, creation_user, last_update_date, last_update_user, app_filter)
08-24,08:37:47 ERROR - values(@script_id, @script_name, @script_type, @description, @update_date, @user, @update_date, @user, @app_filter)
08-24,08:37:47 ERROR - print 'End script: ' + @script_name
08-24,08:37:47 ERROR - MDBTools_0309E - DBDriver failed to install!
08-24,08:37:47 INFO - MDBTools_0104I - Total time: 0H:0M:26S.
can't open C:\Program Files (x86)\CA\ITAM\MDB\jre\lib\tzmappings.
08-24,11:37:47 MDBTools install error=3
08-24,11:37:47 Setupmdb exit /B return code=3