4 Replies Latest reply on Mar 27, 2010 10:21 AM by egarlepp

    nvarchar value ' daily isssue. please perminatly fix.

    Apprentice

       

       

      Funning the SQL queery each day and sometime 2 tiems a day is absolutly annoying.. so are the calls telling me the LANDesk web console is broken every singl day. This is not looking good for me as its been ongoing and not resolved. Please someone tell me how to disable licensing checks for the web console. Or at least keep the error from showing like do a redirection to the frameset.asp.. please fix perminantly cause this is absoluty visible in my environment. I run that SQL statement to temporartly resolve but its at least 2 times a day..

       

       

      Exception: Conversion failed when converting the nvarchar value '

      Source: Microsoft OLE DB Provider for SQL Server

       

      Stack trace:
      at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)
      at System.Data.OleDb.OleDbDataReader.GetRowHandles()
      at System.Data.OleDb.OleDbDataReader.ReadRowset()
      at System.Data.OleDb.OleDbDataReader.Read()
      at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
      at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
      at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
      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.LocalExecuteDataTable(OleDbCommand cmd, Boolean SchemaOnly, Int32 retry)
      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.DataServices.Database.Database.ExecuteDataTable(String sql, Object[] parameters)
      at LANDesk.Licensing.UI.LicenseCheck.getDontRemind()
      at LANDesk.Licensing.UI.LicenseCheck.OnRequest()
      at LANDesk.WebConsole.Common.WebConsolePage.OnLoad(EventArgs e)
      at System.Web.UI.Control.LoadRecursive()
      at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)