Symantec Management Platform (Notification Server)

 View Only
  • 1.  Notification policies

    Posted Mar 11, 2009 04:56 AM
    I am getting this error when trying to run policy

    Unable to simulate a scheduled execution for this Notification Policy. Reason: Unable to process a scheduled execution for the Notification Policy with guid {5e2bf919-32b8-4d07-b22c-a64c29d4ef4b}. Reason: Sql error in query. Error: System.Data.SqlClient.SqlError: Conversion failed when converting from a character string to uniqueidentifier.Sql CommandText: -- MAX ROWCOUNT SET ROWCOUNT 50000 -- SELECT dm.[Domain] as 'Domain', dm.[Name] as 'Name', dm.[OS Name] as 'OS Name' FROM DiscoveredMachines dm WHERE DateDiff( dd, dm.DiscoveryDate, GetDate() ) < 1 AND dm.[Domain] LIKE '%' AND dm.[OS Name] LIKE '%'


  • 2.  RE: Notification policies

    Posted Mar 18, 2009 01:24 PM

    Can you run that SQL as a report?  Just a quick glance at that error tells me you might be having an issue witht the SQL statement itself.