18 Replies Latest reply on Feb 4, 2009 1:51 PM by jflewis1021

    Report Writer - Invalid filter

    JohnW

       Where can I find the filter that I need to fix for the following report?

       


      Invalid Filter.
      Selected fields are unrelated, cannot generate a valid query.

      You need to fix the Filter first.
        • Re: Report Writer - Invalid filter
          mark wiggans

           Could you elaborate on what you are trying to filter on for this report?

            • Re: Report Writer - Invalid filter
              JohnW

              Thank you for helping me out. 

              What we ran into is a report that does not seem to work.  From our "Home" screen we click reports, expand "Historical Traffic Reports" and select the report "Total Bytes Transferred by Node - Last 7 Days".  we get a page that indicates  the following:

              Invalid Filter.
              Selected fields are unrelated, cannot generate a valid query.

              You need to fix the Filter first.
                • Re: Report Writer - Invalid filter
                  mark wiggans

                   It is a bug. What you will need to do is add the interface ID from the select Fields Tab- and make sure that it is above the Total Bytes Received field.

                    • Re: Report Writer - Invalid filter
                      JohnW

                      That worked for that report and I fixed the report for 7 days, last month and this month.  However there is yet another report that I need your help to fix.  Average and Peak Traffic Rates - WAN Interfaces Last 7 Days does not show any info.

                       

                       

                        • Re: Report Writer - Invalid filter
                          mark wiggans
                          so after pressing the Execute SQL Query you get no data? is there a timeout error?
                            • Re: Report Writer - Invalid filter
                              JohnW

                              I was running it from a web interface.

                              I just went into  Report Writer from Net Perf Mon and hit the execute button.  The window is now stuck with an Hour glass, the box indicates "formatting data..."  It began counting down and is now stuck at 3000 records. 

                                • Re: Report Writer - Invalid filter
                                  mark wiggans

                                   Well it sounds like one of two possibilities:
                                   
                                  The SQL Server is responding slowly and can't write the report query fast enough.
                                   
                                  Check the event logs of both the Orion and SQL Servers and see if there are any events such as "Main Task Data Reader" or "Connection Timeout". Also watch the CPU utilization on the servers when you pull a report - SQL can be a resource hog and perhaps the server just can't keep up with it.
                                   
                                  The other possibility is that there is just too much data to be sorted through in a reasonable amount of time. What are your settings as far as keeping old data? You can find these by going to File -> Orion Network Performance Monitor Settings in the System Manager. The Database tab should have this information on it.

                                  You could also try to change the query a bit. Keep in mind that how you order the query has a big impact on the DB response time. Make sure you have the most specific query first. You can also try to incresae the DB timeout varibales.

                                  The timeout settings for SolarWinds that can be adjusted as follows:
                                   
                                  Go to C:\Program Files\SolarWinds\Orion and find the file SWNetperfmon.db
                                   
                                  Open the file with Notepad.
                                   
                                  At the very bottom, there are two timeout values - Connection, and Database Command.

                                  Increase those to 1200 each, save and close the file.
                                   

                                    • Re: Report Writer - Invalid filter
                                      JohnW

                                      Thanks again!  It was the timers that fixed it for me.  I set Connection to 60 and Database to 120 and the report runs fine.

                                       

                                      I goofed something else up while i was working on this. I was in the Customize Menu Bar screen trying to edit the Top 10 list for one of our logins.  I deleted the Top 10 when I wanted to edit it.  Now it is gone form all of our Menu Bars.  How can I get it back? 

                                        • Re: Report Writer - Invalid filter
                                          mark wiggans


                                          Thanks again!  It was the timers that fixed it for me.  I set Connection to 60 and Database to 120 and the report runs fine.

                                           

                                          I goofed something else up while i was working on this. I was in the Customize Menu Bar screen trying to edit the Top 10 list for one of our logins.  I deleted the Top 10 when I wanted to edit it.  Now it is gone form all of our Menu Bars.  How can I get it back? 

                                          Just click the plus sign to add it back-
                                            • Re: Report Writer - Invalid filter

                                              Mark,

                                              We are having problems with our monthly utilisation reports post upgrade to the latest version of Orion. 

                                               Adding the interfaceID to the report does indeed resurrect the report, but it now forces the listing of every interface, not just one value for the whole node. What we need is the original format back.

                                               
                                              Is there any other workaround - or any update when the bug will be fixed.

                                               

                                              Thanks,

                                               

                                              Julian
                                               

                                                • Re: Report Writer - Invalid filter

                                                   Opened support case for this one - and got a workaround :-

                                                   If reports containing interfaces stats dont work :-


                                                  Add interfaceID to each report form, move it to 3rd position, change field to be SUM of interfaceID and then hide it.

                                                   
                                                  Adding the interfaceID allows the report to be viewed (although it has to be moved up to 3rd position????? in the field list)

                                                  Changing the field to Sum of InterfaceID is necessary - otherwise the report generates a line per interface rather than one per node

                                                  Finally hide it.
                                                   

                                                    • Re: Report Writer - Invalid filter

                                                      With all due respect, "its a bug" is an extremly lame response.  What seems to happen is, after upgrading to 9.0, the report writer losing its ability to filter on Custom Properties.  This SUCKS for a million reasons!  We have about 50 or so reports that are dependant on custom properties.  Now none of them work.  Invalid Filter.


                                                      For instance, I had a report that listed all enviromentals for our Cisco Routers.  Ofcourse, I was filtering the resluts off of a custom node property that I had created; "Router".


                                                      Every Node added to Orion over the past 3 years has been added with a custom property.  Every report we have ever created was filtered off of these custom properties.  Now the report writer suddenly has no idea about all of the custom properties. 

                                                        • Re: Report Writer - Invalid filter
                                                          mark wiggans

                                                          Have you tried to update the report schema to add the custom properties?

                                                           

                                                          -open the custom property editor

                                                          right click on an empty part of the toolbar and select customize.

                                                          select the commands tab.

                                                          scroll down through the list of commands until you see update report schemas.

                                                          drag the update report schemas item up to an empty space on the toolbar

                                                          close the customize dialog box.

                                                          click the new icon you just created on the toolbar to update the schema.

                                                            • Re: Report Writer - Invalid filter

                                                              Thanks Mark.  Worked perfect!  I did not see anything related to this in any of the product documentation.  I cannnot be the only one who relies on custom properties to filter thier reports. Perhaps a readme should be put out?  Or even better, perhaps this process should be automated during the upgrade. Thanks agani Mark, you really saved the day for us!!

                                                                • Re: Report Writer - Invalid filter

                                                                   Thanks to this post, I'm no longer hitting my head against my desk in frustration. (well, about this one issue anyway)

                                                                   I second that this could be better documented.

                                                                    • Re: Report Writer - Invalid filter
                                                                      BakerD


                                                                       Thanks to this post, I'm no longer hitting my head against my desk in frustration. (well, about this one issue anyway)

                                                                       I second that this could be better documented.

                                                                       

                                                                       

                                                                       

                                                                      I agree too that it should be noted in the documentation under upgrades.  I ran into this a few years back and it needs to be done after every upgrade that I have experienced.  It would be really nice if the upgrade process just did it.  Sometimes I forget and it wont be until a week or more later that someone runs or gets a report that is messed up.