Page 1 of 1

Error attempting to get event notification subscriptions on command line with "sps.exe events"

Posted: Fri May 01, 2020 5:19 pm
by BobRichards
The SoftPro Select Server Utility (sps.exe) can be used to display the current list of events that are registered with the server on the command line. There is a potential bug in the code that may cause the utility to throw an exception.

Code: Select all

Unhandled Exception: System.NullReferenceException: Object reference not set to an instance of an object.
   at SoftPro.Select.CommandLine.StringUtil.FormatColumnOutput(String[] headers, String[,] contents, 
      String indent, Int32 lineWidth, Encoding encoding)
This can occur if any row in the [core].[EventSubscription] table has a null in the "Filter" column. Until this is fixed, if you are having this problem, set the "Filter" value to an empty string. Below is an command line example (use your server URL and your username/password) you can use if sps.exe is in your current folder.

Code: Select all

.\sps.exe events /s:"http://localhost:8080" /user:"admin,Passw0rd"