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

Discussions related to custom development with Select.
Post Reply
BobRichards
Posts: 917
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

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

Post by BobRichards » Fri May 01, 2020 5:19 pm

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"
Bob Richards, Software Developer, SoftPro

Post Reply