CA Service Management

Expand all | Collapse all

ITAM installation fails on shared MDB with SDM

Jump to Best Answer
  • 1.  ITAM installation fails on shared MDB with SDM

    Posted 08-20-2015 02:47 AM
      |   view attached

    Hi,

     

    I am installing ITAM 14.1 & pointed the installation to a remote MDB where the CA SDM was installed previously.

     

    When the installation reaches to Configuration part it fails. In the install.log it shows the below java runtime exception.

     

    2015/08/18 08.33.24.347 DEBUG [AWT-EventQueue-0] [ITAMConfigValidator] With in ITAMConfigValidator...

    2015/08/18 08.33.26.218 ERROR [AWT-EventQueue-0] [ITAMConfig] Caught Exception

    java.lang.NullPointerException

      at com.ca.smsi.installcore.model.ITAMConfigValidator.validateAPMPwdForUpgrade(ITAMConfigValidator.java:163)

      at com.ca.smsi.installcore.model.ITAMConfigValidator.validate(ITAMConfigValidator.java:61)

      at com.ca.smsi.installcore.model.ITAMConfig.validate(ITAMConfig.java:26)

      at com.ca.smsi.wizard.WizardPage.validateConfig(WizardPage.java:116)

      at com.ca.smsi.installui.wizard.APMServerDetailsPage.validateConfig(APMServerDetailsPage.java:562)

      at com.ca.smsi.wizard.Wizard.next(Wizard.java:774)

      at com.ca.smsi.wizard.Wizard.actionPerformed(Wizard.java:456)

      at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

      at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

      at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

      at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

      at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)

      at java.awt.Component.processMouseEvent(Unknown Source)

      at javax.swing.JComponent.processMouseEvent(Unknown Source)

      at java.awt.Component.processEvent(Unknown Source)

      at java.awt.Container.processEvent(Unknown Source)

      at java.awt.Component.dispatchEventImpl(Unknown Source)

      at java.awt.Container.dispatchEventImpl(Unknown Source)

      at java.awt.Component.dispatchEvent(Unknown Source)

      at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

      at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

      at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

      at java.awt.Container.dispatchEventImpl(Unknown Source)

      at java.awt.Window.dispatchEventImpl(Unknown Source)

      at java.awt.Component.dispatchEvent(Unknown Source)

      at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

      at java.awt.EventQueue.access$200(Unknown Source)

      at java.awt.EventQueue$3.run(Unknown Source)

      at java.awt.EventQueue$3.run(Unknown Source)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

      at java.awt.EventQueue$4.run(Unknown Source)

      at java.awt.EventQueue$4.run(Unknown Source)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

      at java.awt.EventQueue.dispatchEvent(Unknown Source)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

      at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

      at java.awt.EventDispatchThread.run(Unknown Source)

    2015/08/18 08.33.26.222 INFO  [AWT-EventQueue-0] [EEMPage] In checkConflictingEEMServer method



  • 2.  Re: ITAM installation fails on shared MDB with SDM

    Broadcom Employee
    Posted 08-20-2015 09:33 AM

    Mohamed,

    Are you able to connect to EEM from the server you are doing the install on?

    Try to connect with the below link using the same username and password. Substitute the correct server name with the EEM server.

     

    http://server name:port/spin/eiam/eiam.csp


    Thank you,

    Doug Hendricks

    Ca Technologies



  • 3.  Re: ITAM installation fails on shared MDB with SDM

    Posted 08-23-2015 07:02 AM

    Hi Douglas,

     

    Yes, I am able to connect to the eem without issues, as it is installed on the same server where I am trying to install the APM.

     

    Regards,

    Mohamed...



  • 4.  Re: ITAM installation fails on shared MDB with SDM

    Broadcom Employee
    Posted 08-20-2015 02:10 PM

    Apart from what Doug suggested, do you have this table in the MDB database the installer would have created by now?

     

    dbo.al_process_account

     

    EEM Default URL:   https://servername:5250/spin/eiam/eiam.csp      you could try to login as the APM admin credentials and see if created the account there.

     

    _R



  • 5.  Re: ITAM installation fails on shared MDB with SDM

    Posted 08-23-2015 07:27 AM

    Hi Raghu,

     

    The table dbo.al_process_account is there.

     

    process_idprocess_namecertificatecreation_usercreation_datelast_update_userlast_update_dateversion_numbersource_type_iddescriptioncontact_uuidcertificate_keyadmin_password
    10000uapmadminNULLmdbadmin1250071544mdbadmin125007154401NULL0xF401CA10A0EE0143BD89085F7104BAEDNULLNULL
    20000CASMAdminNULLInstallScript 14.11439803631InstallScript 14.1143980363101NULL0xF4C2A60100EA154695D233F90ABFFD21NULLNULL

     

    In eem i am not able to login using the uapmadmin account.

     

    Regards,

    Mohamed...



  • 6.  Re: ITAM installation fails on shared MDB with SDM

    Posted 08-24-2015 04:45 AM

    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



  • 7.  Re: ITAM installation fails on shared MDB with SDM
    Best Answer

    Posted 08-24-2015 01:48 PM

    Hello Mohamed,

     

    The database error above:

    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.

     

    Please see this URL for an explanation of the problem:   MERGE statement failing

     

    Reason for error:

    The reason for this error is when attempting to run query or procedure or logic which is not compatible with previous version of the SQL Server. When SQL Server 2000 is upgraded to SQL Server 2005 or SQL Server 2008, the database object compatibility should be also upgraded to next version.


    To upgrade the database compatibility for a specific database in SQL Server 2008, use this command:

    EXEC sp_dbcmptlevel 'DatabaseName', 100

     

    Let us know how this goes.

     

    Best Regards,

    Gale Bacon

    CA Technologies



  • 8.  Re: ITAM installation fails on shared MDB with SDM

    Posted 08-25-2015 05:47 AM

    Hello Gale,

     

    Thanks for your input. The issue got fixed.

     

    Regards,

    Mohamed...



  • 9.  Re: ITAM installation fails on shared MDB with SDM

    Posted 08-25-2015 03:38 PM

    This is also listed in the Known Issues documentation for both 12.9 and 14.1

     

    Upgrade to SQL Server 2008 Does not Update Compatibility Level when Attaching a Database ...

    ---------------------------------------------------------------------------------------------------------

    The compatibility level for an upgraded mdb should have been changed.



  • 10.  Re: ITAM installation fails on shared MDB with SDM

    Posted 08-26-2015 01:58 AM

    I was freshly installing the APM and not upgrading.

     

    On the same MDB the SDM was upgraded earlier with no issues!!!  And the DB was MS SQL 2005 to MS SQL 2008.

    And the install.log error was not indicative at all. Just java runtime exception!!!



  • 11.  Re: ITAM installation fails on shared MDB with SDM

    Broadcom Employee
    Posted 08-26-2015 02:04 AM

    The database is very likely to still be running in an earlier SQL compatibility mode after an SQL upgrade.  Upgrades typically leave the databases running at their original compatibility mode just to avoid creating problems.

     

    Regards,

    James