sciserver/SkyServer-DR13

Imaging Query Form needs better error message

Closed this issue · 3 comments

raddick commented

From a bug report filed by a SciServer user:

Issue title: Imaging Query Form Error

From: Amanda Newmark

Category: Error message needed

Severity: Mild

Description:
I get the following error:

Exception of type 'System.Web.HttpUnhandledException' was thrown.: Input string was not in a correct format.

Steps to reproduce:

  1. no limit
  2. imaging parameters set to radec
  3. Rectangle parameters:
    RA 212.7 223.4
    DEC -2.5 2.26
raddick commented

Bug report filed by:

Amanda Newmark
Princeton University
anewmark@princeton.edu
October 15, 2016 at 1:19 PM

mtaghiza commented

Cannot reproduce the error from the user, but at least this unleashed my finding a bug in the error message shown to the user when the DEC values are off limits.

When try to reproduce the user's procedure, I actually get a valid error message:
An error occured
Invalid numerical value for maximum number of rows in LIMIT=

If I include a valid value for the limit, then I get an error message which is a little wrong:

Incorrect syntax near 'Illegal'. Incorrect syntax near 'pERROR:'.

Your SQL command was:
ERROR: Illegal rectangular search values: 212.7,223.4,-2.5,2.26.
SELECT TOP 10
cast(str(p.ra,13,8) as float) as ra,cast(str(p.[dec],13,8) as float) as dec
FROM ..PhotoObj AS pERROR: Illegal rectangular search values: 212.7,223.4,-2.5,2.26.
WHERE ( p.type = 3 OR p.type = 6)

mtaghiza commented

Fixed in 1.9.1