4 Replies Latest reply on Jul 13, 2016 4:14 AM by kvv

    After update SU2 on LDMS2016 does not open scheduled tasks

    kvv Apprentice

      After update SU2 on LDMS2016 does not open scheduled tasks. Update finished without errors

        • 1. Re: After update SU2 on LDMS2016 does not open scheduled tasks
          masterpetz ITSMMVPGroup

          Hi kvv,

           

          can you check your console.exe.log under "...\Program Files\LANDESK\ManagementSuite\log". Maybe you get a bit more information about a task or device ID which task or device is effected by the object reference error. Maybe you can attach the console.exe.log.

           

          Kind regards

          Christian

          • 2. Re: After update SU2 on LDMS2016 does not open scheduled tasks
            kvv Apprentice

            Hi Christian

            here log console.exe, something broke in sql tables or views

            ===========

            ClientConnectionId:b5aaa6d2-d5d3-4b7d-85d9-5a60dbcf198a

            07/13/2016 10:40:34 ERROR 11216:Charts.BackgroundThread DataServices : Database.ExecuteDataTable: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'TargetAllUsers'.

               at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

               at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

               at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

               at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

               at System.Data.SqlClient.SqlDataReader.get_MetaData()

               at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

               at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

               at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

               at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

               at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

               at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

               at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

               at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

               at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

               at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

               at LANDesk.DataServices.OleDbHelper. (DbCommand  , Boolean  , Int32  )

               at LANDesk.DataServices.OleDbHelper.ExecuteDataTable(CommandType commandType, Boolean SchemaOnly, String commandText, Object[] commandParameters)

               at LANDesk.DataServices.Database.Database.ExecuteDataTable(String sql, Boolean schemaOnly, Object[] parameters)

               at LANDesk.ManagementSuite.Database.Database.ExecuteDataTableP(String sql, Boolean schemaOnly, Object[] parameters)

               at LANDesk.ManagementSuite.Database.Database.ExecuteDataTable(String sql, Boolean schemaOnly)

            ClientConnectionId:b5aaa6d2-d5d3-4b7d-85d9-5a60dbcf198a

            07/13/2016 10:40:34 ERROR 11216:Charts.BackgroundThread DataServices : Sql statement SELECT e.TASK_STATUS,e.TASK_WAKE_MACHINES,e.TASK_REBOOT_MACHINES,e.TIMEZONE_AWARE,e.INITIAL_START,e.NEXT_START,e.LAST_MODIFIED,e.LAST_START,e.LAST_END,e.LAST_STATUS,e.DAY_WEEK_FLAGS,e.DAY_MONTH_FLAGS,e.MAX_RETRIES,e.TIMES_TRIED,e.ALWAYS_RUN,e.GroupTag,s.ScriptType,e.PACKAGE_IDN,s.Script_Idn,p.Name as PackageName,ab.Name as MethodName,ab.BehaviorType as MethodType,e.DELIVERYMETHOD_IDN,e.RESCHEDULE_TYPE,e.RESCHEDULE_TYPE_GUI,e.USER_CUSTOMGROUP_IDN,e.COMMON_CUSTOMGROUP_IDN,e.QUERY_IDN,e.QUERY_TYPE,e.ISPUBLIC,e.REMOTE_OBJECT_HASH,e.REMOTE_OBJECT_NAME,e.LAST_RESCHEDULE_TIMET,e.ScopeUser_Idn,e.AutoStart,e.SourceCore,cu.UserType,e.LD_TASK_CONFIG_IDN,cu2.UserName as ScopeUser,e.TASK_NAME,e.TaskType,e.Overrides,e.TargetAllUsers,e.Revision,e.SyncEnabled,e.LastSavedBy,e.LastSavedDate,e.Notes,e.ConsoleUser_Idn,cu.UserName as Owner,e.Guid,e.LD_TASK_Idn, x.LD_SCHEDULE_EXE_IDN, x.EXE_NAME, x.EXE_UNC, x.EXE_CLSID, x.IGSCLIENT_ASSEMBLY, x.IGSCLIENT_CLASS, x.IGSSERVER_ASSEMBLY, x.IGSSERVER_CLASS, x.STHClientAssembly, x.STHClientClass, x.STHServerClassId, c.LD_TASK_CONFIG_IDN, c.LD_SCHEDULE_EXE_IDN, c.CFG_NAME, c.CFG_PARAMS, cu.UserName as Owner FROM LD_TASK e LEFT OUTER JOIN ConsoleUser cu on e.ConsoleUser_Idn = cu.ConsoleUser_Idn LEFT OUTER JOIN ConsoleUser cu2 on e.ScopeUser_Idn = cu2.ConsoleUser_Idn left outer join AgentBehavior ab ON ab.AgentBehavior_Idn = e.DeliveryMethod_Idn left outer join Package p ON p.Package_Idn = e.Package_Idn left outer join LD_TASK_CONFIG c on c.LD_TASK_CONFIG_IDN = e.LD_TASK_CONFIG_IDN left outer join SCRIPT S ON c.CFG_NAME = S.FILENAME left outer join LD_SCHEDULE_EXE x on x.LD_SCHEDULE_EXE_IDN = c.LD_SCHEDULE_EXE_IDN

            07/13/2016 10:40:34 INFO  11216:Charts.BackgroundThread RollingLog : GetTasksByComponents: Got an exception trying to get tasks by component, exception was: [Object reference not set to an instance of an object.]

            ===================

            • 3. Re: After update SU2 on LDMS2016 does not open scheduled tasks
              masterpetz ITSMMVPGroup

              Hi kvv,

               

              I copied the SQL select from your log to my SQL server and let it run against the database and get a successful result. Can you do the same against your database? Simple copy the following is to a query window and see what returns:

               

              SELECT e.TASK_STATUS,e.TASK_WAKE_MACHINES,e.TASK_REBOOT_MACHINES,e.TIMEZONE_AWARE,e.INITIAL_START,e.NEXT_START,e.LAST_MODIFIED,e.LAST_START,e.LAST_END,e.LAST_STATUS,e.DAY_WEEK_FLAGS,e.DAY_MONTH_FLAGS,e.MAX_RETRIES,e.TIMES_TRIED,e.ALWAYS_RUN,e.GroupTag,s.ScriptType,e.PACKAGE_IDN,s.Script_Idn,p.Name as PackageName,ab.Name as MethodName,ab.BehaviorType as MethodType,e.DELIVERYMETHOD_IDN,e.RESCHEDULE_TYPE,e.RESCHEDULE_TYPE_GUI,e.USER_CUSTOMGROUP_IDN,e.COMMON_CUSTOMGROUP_IDN,e.QUERY_IDN,e.QUERY_TYPE,e.ISPUBLIC,e.REMOTE_OBJECT_HASH,e.REMOTE_OBJECT_NAME,e.LAST_RESCHEDULE_TIMET,e.ScopeUser_Idn,e.AutoStart,e.SourceCore,cu.UserType,e.LD_TASK_CONFIG_IDN,cu2.UserName as ScopeUser,e.TASK_NAME,e.TaskType,e.Overrides,e.TargetAllUsers,e.Revision,e.SyncEnabled,e.LastSavedBy,e.LastSavedDate,e.Notes,e.ConsoleUser_Idn,cu.UserName as Owner,e.Guid,e.LD_TASK_Idn, x.LD_SCHEDULE_EXE_IDN, x.EXE_NAME, x.EXE_UNC, x.EXE_CLSID, x.IGSCLIENT_ASSEMBLY, x.IGSCLIENT_CLASS, x.IGSSERVER_ASSEMBLY, x.IGSSERVER_CLASS, x.STHClientAssembly, x.STHClientClass, x.STHServerClassId, c.LD_TASK_CONFIG_IDN, c.LD_SCHEDULE_EXE_IDN, c.CFG_NAME, c.CFG_PARAMS, cu.UserName as Owner FROM LD_TASK e LEFT OUTER JOIN ConsoleUser cu on e.ConsoleUser_Idn = cu.ConsoleUser_Idn LEFT OUTER JOIN ConsoleUser cu2 on e.ScopeUser_Idn = cu2.ConsoleUser_Idn left outer join AgentBehavior ab ON ab.AgentBehavior_Idn = e.DeliveryMethod_Idn left outer join Package p ON p.Package_Idn = e.Package_Idn left outer join LD_TASK_CONFIG c on c.LD_TASK_CONFIG_IDN = e.LD_TASK_CONFIG_IDN left outer join SCRIPT S ON c.CFG_NAME = S.FILENAME left outer join LD_SCHEDULE_EXE x on x.LD_SCHEDULE_EXE_IDN = c.LD_SCHEDULE_EXE_IDN

               

              From your log it seems like the column "TargetAllUsers" from the LD_Task table is missing. Can you check this in your database too? If the column is really missing, I would try to do a CoreDBUtil à Built Components. You can find the tool under “C:\Program Files\LANDesk\ManagementSuite”. Just to be on the safe side, take a database copy before running the tool.

               

              Waiting eagerly for your results…

               

              Kind regards

              Christian

               

              • 4. Re: After update SU2 on LDMS2016 does not open scheduled tasks
                kvv Apprentice

                I start CoreDButil.exe, and fix this problem. Thank you very much!