4 Replies Latest reply on Feb 16, 2018 6:09 AM by JoeDrwiega

    Install ivanti2017.3 - Datamart Faild

    Rookie

      Hi every one,

      I try to install Ivanti2017.3 on my virtual machine. First, i use Window Server 2012 R2 but it faild at "Configuring Datamart" Step. I continue try with Window server 2016. But it still stuck at same step.

       

      Here is the log from "LANDesk.Install.LDMS_2017-11-18 22_42_23" file :

      2017-11-18 22:42:23 INFO: WPF Rendering default mode supported. (WPFRenderTier.Check())

      2017-11-18 22:42:23 INFO: Using IProductSetup from file: C:\Ivanti2017-3\Resources\LANDesk.Install.LDMS.dll (SetupController.FindIProductSetupDll())

      2017-11-18 22:42:23 INFO: Loading Assembly file: C:\Ivanti2017-3\Resources\LANDesk.Install.LDMS.dll (SetupController.CreateIProductSetupInstance())

      2017-11-18 22:42:23 INFO: Create Product Setup instance. (SetupController.CreateIProductSetupInstance())

      2017-11-18 22:42:23 INFO: Starting Setup.exe (SetupController.CreateIProductSetupInstance())

      2017-11-18 22:42:24 INFO: Install Action: Install (ProductController.Start())

      2017-11-18 22:42:24 INFO: Restarting from Setup.exe to cached executable C:\ProgramData\LANDESK\ManagementSuite\Install\10.1.30\Data\Main\bin\Setup.exe. (App.ReloadCachedInstall())

      2017-11-18 22:42:24 INFO: Saving path to cache .config: C:\ProgramData\LANDESK\ManagementSuite\Install\10.1.30\Data\Main\bin (App.SaveMediaPathToExeConfig())

      2017-11-18 22:42:24 INFO: Media path for cached install: C:\Ivanti2017-3 (App.SaveMediaPathToExeConfig())

      2017-11-18 22:42:25 INFO: Starting Setup.exe (SetupController.CreateIProductSetupInstance())

      2017-11-18 22:42:26 INFO: Argument not expected, igored: /log (Arguments.GetArgFromString())

      2017-11-18 22:42:26 INFO: Install Action: Install (ProductController.Start())

      2017-11-18 22:42:27 INFO: Executing command CoreDBUtilDatamart (SetupController.ExecuteCurrentCommand())

      2017-11-18 22:42:27 INFO: Executing: C:\Program Files\LANDesk\ManagementSuite\CoreDbUtil.exe /buildcomponents /DDON /xml="C:\Program Files\LANDesk\ManagementSuite\datamart.xml" /logpath="C:\ProgramData\LANDESK\ManagementSuite\Install\10.1.30\Log" (Launcher.ExecuteCommandEx())

      2017-11-18 22:42:48 ERROR: Execution of CoreDBUtilDatamart completed. Return code: 1, State: Failure (SetupController.ExecuteCurrentCommand())

      Capture.PNG

      Capture1.PNG

        • 1. Re: Install ivanti2017.3 - Datamart Faild
          Rookie

          I will provide more log.

           

          C:\Program Files\LANDesk\ManagementSuite\log\CoreDBUtil.exe :

          11/19/2017 10:29:58 ERROR 1884:1     DataServices : GetExistingRow failed: Table: ClientAuthStatusEnum, Details: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CERTRESULT_ID'.

             at LANDesk.DataServices.Database.TableValue.GetExistingRow(String tableName, Boolean bUpdate, String identifierColumn, ArrayList uniqueColumnNames, IDictionary`2 columnNameValues)

             at LANDesk.DataServices.Database.TableValue.EnsureValue(TableValue tableValue, Int32 idn)

          ClientConnectionId:48df6f67-a3dd-4aeb-9eaf-694aceec41ee

          Error Number:207,State:1,Class:16

          11/19/2017 10:29:58 INFO  1884:1     CoreDBUtil : Schema exception?:  System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CERTRESULT_ID'.

             at LANDesk.DataServices.Database.TableValue.EnsureValue(TableValue tableValue, Int32 idn)

             at LANDesk.DataServices.Database.TableValue.EnsureValues(ArrayList values, String name)

             at LANDesk.DataServices.Schema.CreateTables.EnsureValues(Table table)

             at LANDesk.DataServices.Schema.CreateTables.ExecuteCreateTable(Table table)

             at LANDesk.DataServices.Schema.CreateTables.End()

             at LANDesk.DataServices.Schema.Schema.CreateDatabase(IOleDbHelper oleDbHelper, XmlDocument document)

             at LANDesk.DataServices.Schema.Schema.CreateDatabase(String file, String connectionString)

             at LANDesk.ManagementSuite.CoreDbUtil.CoreDbUtil.CreateDatabaseFromXml(DbConnection dbConn, String xmlFile, Boolean dropFirst, Boolean showDialog)

          ClientConnectionId:48df6f67-a3dd-4aeb-9eaf-694aceec41ee

          Error Number:207,State:1,Class:16

          11/19/2017 10:29:58 INFO  1884:1     RollingLog : Exception in RunSilent: Invalid column name 'CERTRESULT_ID'.

          11/19/2017 10:29:58 INFO  1884:1     RollingLog : CoreDBUtil returned the following exit code: 1

           

          C:\ProgramData\LANDesk\ManagementSuite\Install\10.1.30\Log\LANDesk.Install.LDMS_2017-11-19 10_07_57

          2017-11-19 10:29:55 INFO: Executing: C:\Program Files\LANDesk\ManagementSuite\CoreDbUtil.exe /buildcomponents /DDON /xml="C:\Program Files\LANDesk\ManagementSuite\datamart.xml" /logpath="C:\ProgramData\LANDESK\ManagementSuite\Install\10.1.30\Log" (Launcher.ExecuteCommandEx())

          2017-11-19 10:29:59 ERROR: Execution of CoreDBUtilDatamart completed. Return code: 1, State: Failure (SetupController.ExecuteCurrentCommand())

          • 3. Re: Install ivanti2017.3 - Datamart Faild
            fabraus Rookie

            It worked for me too.

            In a fresh new installation of Ivanti 2017.3, I got the following error during the "Configuring Datamart" setup step:

            Exception! Value cannot be null.

            Parameter name: userID.

            Since I had attempted a "windows" account for connecting to the SQL DB, I changed the registry key HKLM\Software\LANDESK\ManagementSuite\Core\Connections\Local\isNTLM from True to False; then, pressing "Try again", the "Configuring Datamart" step was completed successfully.

            • 4. Re: Install ivanti2017.3 - Datamart Faild
              JoeDrwiega SupportEmployee

              Also be sure you ran streams.exe on your LANDESK directories and subdirectories and that includes where you extracted the install as well: Streams; and why you should remove them.