Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-13591

FireFly Filter syntax exposes internal error messages

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Story Points:
      0
    • Epic Link:
    • Sprint:
      SUIT Sprint 2018-03
    • Team:
      Science User Interface

      Description

      Syntax error in filter specifiction, e.g. "Observed Passband" > U results in internal message display to user:

      Failed to load table. Error: BadSqlGrammarException:StatementCallback; bad SQL grammar [CREATE TABLE data_cdef2ea665d681650c55ca43c18264db AS (select b.*, (ROWNUM-1) as ROW_NUM from (select "No.", "Observed Passband", "Photometry Measurement", "Uncertainty", "Units", "Frequency", "NED Photometry Measurement", "NED Uncertainty", "NED Units", "Refcode", "Significance", "Published frequency", "Frequency Mode", "Coordinates Targeted", "Spatial Mode", "Qualifiers", "Comments", ROW_IDX from data where ("No." < 4) and ("Observed Passband" > U) ) as b) WITH DATA]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: U from:null

        Attachments

          Issue Links

            Activity

            xiuqin Xiuqin Wu [X] (Inactive) created issue -
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Field Original Value New Value
            Labels NED
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Team Science User Interface [ 10303 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Link This issue relates to DM-13420 [ DM-13420 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Assignee Loi Ly [ loi ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Sprint SUIT Sprint 2018-03 [ 663 ]
            loi Loi Ly made changes -
            Resolution Done [ 10000 ]
            Status To Do [ 10001 ] Done [ 10002 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Epic Link DM-12091 [ 34780 ]
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Story Points 0

              People

              Assignee:
              loi Loi Ly
              Reporter:
              xiuqin Xiuqin Wu [X] (Inactive)
              Watchers:
              Loi Ly, Xiuqin Wu [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.