[Met_help] [rt.rap.ucar.edu #87881] History for Cannot generate scorecard because data is missing

[Tatiana Burek via RT]

----------------------------------------------------------------
  Initial Request
----------------------------------------------------------------

Hi,

I'm having difficulty generating a scorecard with the METviewer batch
engine.  I was getting a "permission denied" error but after modifying the
<plots>, <data>, and <scripts> tags to /usr1/metviewer/tmp those messages
disappeared.

Now I get the following message when I run mv_scorecard.sh
scorecard_ncarhref.xml:

MySQL query:
SELECT 'ME' stat_name, 'NA'
stat_value,fcst_var,model,fcst_valid_beg,vx_mask,fcst_lead,total,fbar,obar,fobar,ffbar,oobar,mae
FROM stat_header,line_data_sl1l2 WHERE fcst_var IN ('DPT') AND model IN
('hrefarw1','ncar1') AND fcst_valid_beg BETWEEN '2017-05-29 00:00:00' AND
'2017-09-25 00:00:00' AND HOUR(fcst_init_beg) IN (0) AND vx_mask IN
('CONUS') AND fcst_lead IN
('3','6','9','12','15','18','21','24','27','30','33','36') AND
stat_header.stat_header_id = line_data_sl1l2.stat_header_id;
No data was returned from database
  **  ERROR: Caught class edu.ucar.metviewer.EmptyResultSetException in
printFormattedTable(ResultSet res): result set contained no data

I was able to create a plot in METviewer for DPT mean error over the
specified time range as a function of forecast lead time so I am confused
why I get a "result set contained no data" error.  Maybe I'm missing
something in the xml file?  I've attached the one I am using to generate
the scorecard.

Thanks!
Ben


----------------------------------------------------------------
  Complete Ticket History
----------------------------------------------------------------

Subject: Cannot generate scorecard because data is missing
From: Tatiana Burek
Time: Tue Nov 20 12:58:57 2018

Hi Ben,

fcst_lead field in your database has values (30000, 60000, 90000,
120000...). In XML file you specify (3, 6, 9, 12...). MySQL query
can't find fcst_lead leads with these values and returns empty set.
When you use the web app you choose the correct values for this field
and get a non empty result set and a plot.

Please provide valid values for fcst_lead in XML :
<field name="fcst_lead">
          <val name="30000" label="f03"/>
          <val name="60000" label="f06"/>
.....

Tatiana

On Tue Nov 20 10:27:41 2018, benjamin.blake at noaa.gov wrote:
> Hi,
>
> I'm having difficulty generating a scorecard with the METviewer
batch
> engine.  I was getting a "permission denied" error but after
modifying
> the
> <plots>, <data>, and <scripts> tags to /usr1/metviewer/tmp those
> messages
> disappeared.
>
> Now I get the following message when I run mv_scorecard.sh
> scorecard_ncarhref.xml:
>
> MySQL query:
> SELECT 'ME' stat_name, 'NA'
>
stat_value,fcst_var,model,fcst_valid_beg,vx_mask,fcst_lead,total,fbar,obar,fobar,ffbar,oobar,mae
> FROM stat_header,line_data_sl1l2 WHERE fcst_var IN ('DPT') AND model
> IN
> ('hrefarw1','ncar1') AND fcst_valid_beg BETWEEN '2017-05-29
00:00:00'
> AND
> '2017-09-25 00:00:00' AND HOUR(fcst_init_beg) IN (0) AND vx_mask IN
> ('CONUS') AND fcst_lead IN
> ('3','6','9','12','15','18','21','24','27','30','33','36') AND
> stat_header.stat_header_id = line_data_sl1l2.stat_header_id;
> No data was returned from database
>   **  ERROR: Caught class edu.ucar.metviewer.EmptyResultSetException
> in
> printFormattedTable(ResultSet res): result set contained no data
>
> I was able to create a plot in METviewer for DPT mean error over the
> specified time range as a function of forecast lead time so I am
> confused
> why I get a "result set contained no data" error.  Maybe I'm missing
> something in the xml file?  I've attached the one I am using to
> generate
> the scorecard.
>
> Thanks!
> Ben



------------------------------------------------
Subject: Cannot generate scorecard because data is missing
From: Benjamin Blake - NOAA Affiliate
Time: Tue Nov 20 13:30:15 2018

Hi Tatiana,

You're right, I missed that when I was looking through the xml file.
I
just re-ran mv_scorecard.sh and was able to generate a scorecard.

Thanks!
Ben

On Tue, Nov 20, 2018 at 2:58 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:

> Hi Ben,
>
> fcst_lead field in your database has values (30000, 60000, 90000,
> 120000...). In XML file you specify (3, 6, 9, 12...). MySQL query
can't
> find fcst_lead leads with these values and returns empty set.
> When you use the web app you choose the correct values for this
field and
> get a non empty result set and a plot.
>
> Please provide valid values for fcst_lead in XML :
> <field name="fcst_lead">
>           <val name="30000" label="f03"/>
>           <val name="60000" label="f06"/>
> .....
>
> Tatiana
>
> On Tue Nov 20 10:27:41 2018, benjamin.blake at noaa.gov wrote:
> > Hi,
> >
> > I'm having difficulty generating a scorecard with the METviewer
batch
> > engine.  I was getting a "permission denied" error but after
modifying
> > the
> > <plots>, <data>, and <scripts> tags to /usr1/metviewer/tmp those
> > messages
> > disappeared.
> >
> > Now I get the following message when I run mv_scorecard.sh
> > scorecard_ncarhref.xml:
> >
> > MySQL query:
> > SELECT 'ME' stat_name, 'NA'
> >
>
stat_value,fcst_var,model,fcst_valid_beg,vx_mask,fcst_lead,total,fbar,obar,fobar,ffbar,oobar,mae
> > FROM stat_header,line_data_sl1l2 WHERE fcst_var IN ('DPT') AND
model
> > IN
> > ('hrefarw1','ncar1') AND fcst_valid_beg BETWEEN '2017-05-29
00:00:00'
> > AND
> > '2017-09-25 00:00:00' AND HOUR(fcst_init_beg) IN (0) AND vx_mask
IN
> > ('CONUS') AND fcst_lead IN
> > ('3','6','9','12','15','18','21','24','27','30','33','36') AND
> > stat_header.stat_header_id = line_data_sl1l2.stat_header_id;
> > No data was returned from database
> >   **  ERROR: Caught class
edu.ucar.metviewer.EmptyResultSetException
> > in
> > printFormattedTable(ResultSet res): result set contained no data
> >
> > I was able to create a plot in METviewer for DPT mean error over
the
> > specified time range as a function of forecast lead time so I am
> > confused
> > why I get a "result set contained no data" error.  Maybe I'm
missing
> > something in the xml file?  I've attached the one I am using to
> > generate
> > the scorecard.
> >
> > Thanks!
> > Ben
>
>
>
>

------------------------------------------------