[Met_help] [rt.rap.ucar.edu #97510] History for batch plotting not moving forward/no plots generated
John Halley Gotway via RT
met_help at ucar.edu
Fri Nov 20 11:37:56 MST 2020
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
Good afternoon,
After the machine switch from Mars to Venus, I set everything up and tested
the batch plotting capability as I had done before. When running the plot
batch script I noticed that nothing proceeds forward. It's been hung up
here for over 30 minutes:
'2020-11-14 04:00:00', '2020-11-14 05:00:00', '2020-11-14 06:00:00',
'2020-11-14 07:00:00', '2020-11-14 08:00:00', '2020-11-14 09:00:00',
'2020-11-14 10:00:00', '2020-11-14 11:00:00', '2020-11-14 12:00:00',
'2020-11-14 13:00:00', '2020-11-14 14:00:00', '2020-11-14 15:00:00',
'2020-11-14 16:00:00', '2020-11-14 17:00:00', '2020-11-14 18:00:00',
'2020-11-14 19:00:00', '2020-11-14 20:00:00', '2020-11-14 21:00:00',
'2020-11-14 22:00:00', '2020-11-14 23:00:00', '2020-11-15 00:00:00',
'2020-11-15 01:00:00', '2020-11-15 02:00:00', '2020-11-15 03:00:00',
'2020-11-15 04:00:00', '2020-11-15 05:00:00', '2020-11-15 06:00:00',
'2020-11-15 07:00:00', '2020-11-15 08:00:00', '2020-11-15 09:00:00',
'2020-11-15 10:00:00', '2020-11-15 11:00:00', '2020-11-15 12:00:00',
'2020-11-15 13:00:00', '2020-11-15 14:00:00', '2020-11-15 15:00:00',
'2020-11-15 16:00:00', '2020-11-15 17:00:00', '2020-11-15 18:00:00',
'2020-11-15 19:00:00', '2020-11-15 20:00:00', '2020-11-15 21:00:00',
'2020-11-15 22:00:00', '2020-11-15 23:00:00')
AND BINARY h.model IN ('PARA6A', 'PARA6A_BC', 'PROD', 'PROD_BC')
AND BINARY if( (select fcst_lead_offset FROM model_fcst_lead_offset
WHERE model = h.model) is NULL , ld.fcst_lead , ld.fcst_lead + (select
fcst_lead_offset FROM model_fcst_lead_offset WHERE model = h.model) ) IN
('0', '10000', '20000', '30000', '40000', '50000', '60000', '70000',
'80000', '90000', '100000', '110000', '120000', '130000', '140000',
'150000', '160000', '170000', '180000', '190000', '200000', '210000',
'220000', '230000', '240000', '250000', '260000', '270000', '280000',
'290000', '300000', '310000', '320000', '330000', '340000', '350000',
'360000', '370000', '380000', '390000', '400000', '410000', '420000',
'430000', '440000', '450000', '460000', '470000', '480000')
AND BINARY h.fcst_var = 'PMTF'
AND ld.stat_header_id = h.stat_header_id;
I did hear the MetViewer site was inaccessible earlier. I'm not sure what
happened or if this could be related to my issue.
--
Edward Strobach
EMC/NCEP/NWS/
IMSG Contractor
Cubicle#: 2029
301-683-3717
----------------------------------------------------------------
Complete Ticket History
----------------------------------------------------------------
Subject: batch plotting not moving forward/no plots generated
From: Tatiana Burek
Time: Wed Nov 18 11:02:52 2020
Ed,
I see a few batch jobs handing on AWS.
I will cancel them so you could restart your job(s).
Will this work?
Tatiana
On Wed Nov 18 10:57:01 2020, edward.strobach at noaa.gov wrote:
> Good afternoon,
>
> After the machine switch from Mars to Venus, I set everything up and
tested
> the batch plotting capability as I had done before. When running the
plot
> batch script I noticed that nothing proceeds forward. It's been
hung up
> here for over 30 minutes:
>
>
> '2020-11-14 04:00:00', '2020-11-14 05:00:00', '2020-11-14
06:00:00',
> '2020-11-14 07:00:00', '2020-11-14 08:00:00', '2020-11-14 09:00:00',
> '2020-11-14 10:00:00', '2020-11-14 11:00:00', '2020-11-14 12:00:00',
> '2020-11-14 13:00:00', '2020-11-14 14:00:00', '2020-11-14 15:00:00',
> '2020-11-14 16:00:00', '2020-11-14 17:00:00', '2020-11-14 18:00:00',
> '2020-11-14 19:00:00', '2020-11-14 20:00:00', '2020-11-14 21:00:00',
> '2020-11-14 22:00:00', '2020-11-14 23:00:00', '2020-11-15 00:00:00',
> '2020-11-15 01:00:00', '2020-11-15 02:00:00', '2020-11-15 03:00:00',
> '2020-11-15 04:00:00', '2020-11-15 05:00:00', '2020-11-15 06:00:00',
> '2020-11-15 07:00:00', '2020-11-15 08:00:00', '2020-11-15 09:00:00',
> '2020-11-15 10:00:00', '2020-11-15 11:00:00', '2020-11-15 12:00:00',
> '2020-11-15 13:00:00', '2020-11-15 14:00:00', '2020-11-15 15:00:00',
> '2020-11-15 16:00:00', '2020-11-15 17:00:00', '2020-11-15 18:00:00',
> '2020-11-15 19:00:00', '2020-11-15 20:00:00', '2020-11-15 21:00:00',
> '2020-11-15 22:00:00', '2020-11-15 23:00:00')
> AND BINARY h.model IN ('PARA6A', 'PARA6A_BC', 'PROD', 'PROD_BC')
> AND BINARY if( (select fcst_lead_offset FROM
model_fcst_lead_offset
> WHERE model = h.model) is NULL , ld.fcst_lead , ld.fcst_lead +
(select
> fcst_lead_offset FROM model_fcst_lead_offset WHERE model = h.model)
) IN
> ('0', '10000', '20000', '30000', '40000', '50000', '60000', '70000',
> '80000', '90000', '100000', '110000', '120000', '130000', '140000',
> '150000', '160000', '170000', '180000', '190000', '200000',
'210000',
> '220000', '230000', '240000', '250000', '260000', '270000',
'280000',
> '290000', '300000', '310000', '320000', '330000', '340000',
'350000',
> '360000', '370000', '380000', '390000', '400000', '410000',
'420000',
> '430000', '440000', '450000', '460000', '470000', '480000')
> AND BINARY h.fcst_var = 'PMTF'
> AND ld.stat_header_id = h.stat_header_id;
>
>
> I did hear the MetViewer site was inaccessible earlier. I'm not
sure what
> happened or if this could be related to my issue.
------------------------------------------------
Subject: batch plotting not moving forward/no plots generated
From: Edward Strobach - NOAA Affiliate
Time: Wed Nov 18 11:04:56 2020
I can try that. Thanks
On Wed, Nov 18, 2020 at 1:03 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Ed,
>
> I see a few batch jobs handing on AWS.
> I will cancel them so you could restart your job(s).
> Will this work?
>
> Tatiana
>
> On Wed Nov 18 10:57:01 2020, edward.strobach at noaa.gov wrote:
> > Good afternoon,
> >
> > After the machine switch from Mars to Venus, I set everything up
and
> tested
> > the batch plotting capability as I had done before. When running
the plot
> > batch script I noticed that nothing proceeds forward. It's been
hung up
> > here for over 30 minutes:
> >
> >
> > '2020-11-14 04:00:00', '2020-11-14 05:00:00', '2020-11-14
06:00:00',
> > '2020-11-14 07:00:00', '2020-11-14 08:00:00', '2020-11-14
09:00:00',
> > '2020-11-14 10:00:00', '2020-11-14 11:00:00', '2020-11-14
12:00:00',
> > '2020-11-14 13:00:00', '2020-11-14 14:00:00', '2020-11-14
15:00:00',
> > '2020-11-14 16:00:00', '2020-11-14 17:00:00', '2020-11-14
18:00:00',
> > '2020-11-14 19:00:00', '2020-11-14 20:00:00', '2020-11-14
21:00:00',
> > '2020-11-14 22:00:00', '2020-11-14 23:00:00', '2020-11-15
00:00:00',
> > '2020-11-15 01:00:00', '2020-11-15 02:00:00', '2020-11-15
03:00:00',
> > '2020-11-15 04:00:00', '2020-11-15 05:00:00', '2020-11-15
06:00:00',
> > '2020-11-15 07:00:00', '2020-11-15 08:00:00', '2020-11-15
09:00:00',
> > '2020-11-15 10:00:00', '2020-11-15 11:00:00', '2020-11-15
12:00:00',
> > '2020-11-15 13:00:00', '2020-11-15 14:00:00', '2020-11-15
15:00:00',
> > '2020-11-15 16:00:00', '2020-11-15 17:00:00', '2020-11-15
18:00:00',
> > '2020-11-15 19:00:00', '2020-11-15 20:00:00', '2020-11-15
21:00:00',
> > '2020-11-15 22:00:00', '2020-11-15 23:00:00')
> > AND BINARY h.model IN ('PARA6A', 'PARA6A_BC', 'PROD',
'PROD_BC')
> > AND BINARY if( (select fcst_lead_offset FROM
model_fcst_lead_offset
> > WHERE model = h.model) is NULL , ld.fcst_lead , ld.fcst_lead +
(select
> > fcst_lead_offset FROM model_fcst_lead_offset WHERE model =
h.model) ) IN
> > ('0', '10000', '20000', '30000', '40000', '50000', '60000',
'70000',
> > '80000', '90000', '100000', '110000', '120000', '130000',
'140000',
> > '150000', '160000', '170000', '180000', '190000', '200000',
'210000',
> > '220000', '230000', '240000', '250000', '260000', '270000',
'280000',
> > '290000', '300000', '310000', '320000', '330000', '340000',
'350000',
> > '360000', '370000', '380000', '390000', '400000', '410000',
'420000',
> > '430000', '440000', '450000', '460000', '470000', '480000')
> > AND BINARY h.fcst_var = 'PMTF'
> > AND ld.stat_header_id = h.stat_header_id;
> >
> >
> > I did hear the MetViewer site was inaccessible earlier. I'm not
sure
> what
> > happened or if this could be related to my issue.
>
>
>
>
--
Edward Strobach
EMC/NCEP/NWS/
IMSG Contractor
Cubicle#: 2029
301-683-3717
------------------------------------------------
Subject: batch plotting not moving forward/no plots generated
From: Edward Strobach - NOAA Affiliate
Time: Wed Nov 18 11:47:46 2020
I did try again but it still seems hung up. Should I just try later
perhaps?
On Wed, Nov 18, 2020 at 1:04 PM Edward Strobach - NOAA Affiliate <
edward.strobach at noaa.gov> wrote:
> I can try that. Thanks
>
> On Wed, Nov 18, 2020 at 1:03 PM Tatiana Burek via RT
<met_help at ucar.edu>
> wrote:
>
>> Ed,
>>
>> I see a few batch jobs handing on AWS.
>> I will cancel them so you could restart your job(s).
>> Will this work?
>>
>> Tatiana
>>
>> On Wed Nov 18 10:57:01 2020, edward.strobach at noaa.gov wrote:
>> > Good afternoon,
>> >
>> > After the machine switch from Mars to Venus, I set everything up
and
>> tested
>> > the batch plotting capability as I had done before. When running
the
>> plot
>> > batch script I noticed that nothing proceeds forward. It's been
hung up
>> > here for over 30 minutes:
>> >
>> >
>> > '2020-11-14 04:00:00', '2020-11-14 05:00:00', '2020-11-14
06:00:00',
>> > '2020-11-14 07:00:00', '2020-11-14 08:00:00', '2020-11-14
09:00:00',
>> > '2020-11-14 10:00:00', '2020-11-14 11:00:00', '2020-11-14
12:00:00',
>> > '2020-11-14 13:00:00', '2020-11-14 14:00:00', '2020-11-14
15:00:00',
>> > '2020-11-14 16:00:00', '2020-11-14 17:00:00', '2020-11-14
18:00:00',
>> > '2020-11-14 19:00:00', '2020-11-14 20:00:00', '2020-11-14
21:00:00',
>> > '2020-11-14 22:00:00', '2020-11-14 23:00:00', '2020-11-15
00:00:00',
>> > '2020-11-15 01:00:00', '2020-11-15 02:00:00', '2020-11-15
03:00:00',
>> > '2020-11-15 04:00:00', '2020-11-15 05:00:00', '2020-11-15
06:00:00',
>> > '2020-11-15 07:00:00', '2020-11-15 08:00:00', '2020-11-15
09:00:00',
>> > '2020-11-15 10:00:00', '2020-11-15 11:00:00', '2020-11-15
12:00:00',
>> > '2020-11-15 13:00:00', '2020-11-15 14:00:00', '2020-11-15
15:00:00',
>> > '2020-11-15 16:00:00', '2020-11-15 17:00:00', '2020-11-15
18:00:00',
>> > '2020-11-15 19:00:00', '2020-11-15 20:00:00', '2020-11-15
21:00:00',
>> > '2020-11-15 22:00:00', '2020-11-15 23:00:00')
>> > AND BINARY h.model IN ('PARA6A', 'PARA6A_BC', 'PROD',
'PROD_BC')
>> > AND BINARY if( (select fcst_lead_offset FROM
model_fcst_lead_offset
>> > WHERE model = h.model) is NULL , ld.fcst_lead , ld.fcst_lead +
(select
>> > fcst_lead_offset FROM model_fcst_lead_offset WHERE model =
h.model) )
>> IN
>> > ('0', '10000', '20000', '30000', '40000', '50000', '60000',
'70000',
>> > '80000', '90000', '100000', '110000', '120000', '130000',
'140000',
>> > '150000', '160000', '170000', '180000', '190000', '200000',
'210000',
>> > '220000', '230000', '240000', '250000', '260000', '270000',
'280000',
>> > '290000', '300000', '310000', '320000', '330000', '340000',
'350000',
>> > '360000', '370000', '380000', '390000', '400000', '410000',
'420000',
>> > '430000', '440000', '450000', '460000', '470000', '480000')
>> > AND BINARY h.fcst_var = 'PMTF'
>> > AND ld.stat_header_id = h.stat_header_id;
>> >
>> >
>> > I did hear the MetViewer site was inaccessible earlier. I'm not
sure
>> what
>> > happened or if this could be related to my issue.
>>
>>
>>
>>
>
> --
> Edward Strobach
> EMC/NCEP/NWS/
> IMSG Contractor
> Cubicle#: 2029
> 301-683-3717
>
--
Edward Strobach
EMC/NCEP/NWS/
IMSG Contractor
Cubicle#: 2029
301-683-3717
------------------------------------------------
Subject: batch plotting not moving forward/no plots generated
From: Tatiana Burek
Time: Wed Nov 18 12:00:38 2020
Are you starting a multiple batch jobs at the same time without
waiting until the previous one is finished?
This could overwhelm the Java Virtual Machine and the database
resources.
Tatiana
On Wed Nov 18 11:47:46 2020, edward.strobach at noaa.gov wrote:
> I did try again but it still seems hung up. Should I just try later
> perhaps?
>
> On Wed, Nov 18, 2020 at 1:04 PM Edward Strobach - NOAA Affiliate <
> edward.strobach at noaa.gov> wrote:
>
> > I can try that. Thanks
> >
> > On Wed, Nov 18, 2020 at 1:03 PM Tatiana Burek via RT
> > <met_help at ucar.edu>
> > wrote:
> >
> >> Ed,
> >>
> >> I see a few batch jobs handing on AWS.
> >> I will cancel them so you could restart your job(s).
> >> Will this work?
> >>
> >> Tatiana
> >>
> >> On Wed Nov 18 10:57:01 2020, edward.strobach at noaa.gov wrote:
> >> > Good afternoon,
> >> >
> >> > After the machine switch from Mars to Venus, I set everything
up
> >> > and
> >> tested
> >> > the batch plotting capability as I had done before. When
running
> >> > the
> >> plot
> >> > batch script I noticed that nothing proceeds forward. It's
been
> >> > hung up
> >> > here for over 30 minutes:
> >> >
> >> >
> >> > '2020-11-14 04:00:00', '2020-11-14 05:00:00', '2020-11-14
> >> > 06:00:00',
> >> > '2020-11-14 07:00:00', '2020-11-14 08:00:00', '2020-11-14
> >> > 09:00:00',
> >> > '2020-11-14 10:00:00', '2020-11-14 11:00:00', '2020-11-14
> >> > 12:00:00',
> >> > '2020-11-14 13:00:00', '2020-11-14 14:00:00', '2020-11-14
> >> > 15:00:00',
> >> > '2020-11-14 16:00:00', '2020-11-14 17:00:00', '2020-11-14
> >> > 18:00:00',
> >> > '2020-11-14 19:00:00', '2020-11-14 20:00:00', '2020-11-14
> >> > 21:00:00',
> >> > '2020-11-14 22:00:00', '2020-11-14 23:00:00', '2020-11-15
> >> > 00:00:00',
> >> > '2020-11-15 01:00:00', '2020-11-15 02:00:00', '2020-11-15
> >> > 03:00:00',
> >> > '2020-11-15 04:00:00', '2020-11-15 05:00:00', '2020-11-15
> >> > 06:00:00',
> >> > '2020-11-15 07:00:00', '2020-11-15 08:00:00', '2020-11-15
> >> > 09:00:00',
> >> > '2020-11-15 10:00:00', '2020-11-15 11:00:00', '2020-11-15
> >> > 12:00:00',
> >> > '2020-11-15 13:00:00', '2020-11-15 14:00:00', '2020-11-15
> >> > 15:00:00',
> >> > '2020-11-15 16:00:00', '2020-11-15 17:00:00', '2020-11-15
> >> > 18:00:00',
> >> > '2020-11-15 19:00:00', '2020-11-15 20:00:00', '2020-11-15
> >> > 21:00:00',
> >> > '2020-11-15 22:00:00', '2020-11-15 23:00:00')
> >> > AND BINARY h.model IN ('PARA6A', 'PARA6A_BC', 'PROD',
> >> > 'PROD_BC')
> >> > AND BINARY if( (select fcst_lead_offset FROM
> >> > model_fcst_lead_offset
> >> > WHERE model = h.model) is NULL , ld.fcst_lead , ld.fcst_lead +
> >> > (select
> >> > fcst_lead_offset FROM model_fcst_lead_offset WHERE model =
> >> > h.model) )
> >> IN
> >> > ('0', '10000', '20000', '30000', '40000', '50000', '60000',
> >> > '70000',
> >> > '80000', '90000', '100000', '110000', '120000', '130000',
> >> > '140000',
> >> > '150000', '160000', '170000', '180000', '190000', '200000',
> >> > '210000',
> >> > '220000', '230000', '240000', '250000', '260000', '270000',
> >> > '280000',
> >> > '290000', '300000', '310000', '320000', '330000', '340000',
> >> > '350000',
> >> > '360000', '370000', '380000', '390000', '400000', '410000',
> >> > '420000',
> >> > '430000', '440000', '450000', '460000', '470000', '480000')
> >> > AND BINARY h.fcst_var = 'PMTF'
> >> > AND ld.stat_header_id = h.stat_header_id;
> >> >
> >> >
> >> > I did hear the MetViewer site was inaccessible earlier. I'm
not
> >> > sure
> >> what
> >> > happened or if this could be related to my issue.
> >>
> >>
> >>
> >>
> >
> > --
> > Edward Strobach
> > EMC/NCEP/NWS/
> > IMSG Contractor
> > Cubicle#: 2029
> > 301-683-3717
> >
------------------------------------------------
Subject: batch plotting not moving forward/no plots generated
From: Edward Strobach - NOAA Affiliate
Time: Wed Nov 18 12:16:37 2020
I'm glad you brought that up. This has been an issue I have been
facing
for quite a while. Although things are now just starting to process,
I
have experienced issues of plots not being generated or stored in the
wrong
location. There's no pattern to it, and I suspect it's related to the
point you brought up. My hope is that once I get the SQL error
resolved
related to Crop_Woodland - and others; recall the conversation two
days ago
- that I can put everything under the same xml file.
On Wed, Nov 18, 2020 at 2:00 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Are you starting a multiple batch jobs at the same time without
waiting
> until the previous one is finished?
> This could overwhelm the Java Virtual Machine and the database
resources.
>
> Tatiana
>
> On Wed Nov 18 11:47:46 2020, edward.strobach at noaa.gov wrote:
> > I did try again but it still seems hung up. Should I just try
later
> > perhaps?
> >
> > On Wed, Nov 18, 2020 at 1:04 PM Edward Strobach - NOAA Affiliate <
> > edward.strobach at noaa.gov> wrote:
> >
> > > I can try that. Thanks
> > >
> > > On Wed, Nov 18, 2020 at 1:03 PM Tatiana Burek via RT
> > > <met_help at ucar.edu>
> > > wrote:
> > >
> > >> Ed,
> > >>
> > >> I see a few batch jobs handing on AWS.
> > >> I will cancel them so you could restart your job(s).
> > >> Will this work?
> > >>
> > >> Tatiana
> > >>
> > >> On Wed Nov 18 10:57:01 2020, edward.strobach at noaa.gov wrote:
> > >> > Good afternoon,
> > >> >
> > >> > After the machine switch from Mars to Venus, I set everything
up
> > >> > and
> > >> tested
> > >> > the batch plotting capability as I had done before. When
running
> > >> > the
> > >> plot
> > >> > batch script I noticed that nothing proceeds forward. It's
been
> > >> > hung up
> > >> > here for over 30 minutes:
> > >> >
> > >> >
> > >> > '2020-11-14 04:00:00', '2020-11-14 05:00:00', '2020-11-14
> > >> > 06:00:00',
> > >> > '2020-11-14 07:00:00', '2020-11-14 08:00:00', '2020-11-14
> > >> > 09:00:00',
> > >> > '2020-11-14 10:00:00', '2020-11-14 11:00:00', '2020-11-14
> > >> > 12:00:00',
> > >> > '2020-11-14 13:00:00', '2020-11-14 14:00:00', '2020-11-14
> > >> > 15:00:00',
> > >> > '2020-11-14 16:00:00', '2020-11-14 17:00:00', '2020-11-14
> > >> > 18:00:00',
> > >> > '2020-11-14 19:00:00', '2020-11-14 20:00:00', '2020-11-14
> > >> > 21:00:00',
> > >> > '2020-11-14 22:00:00', '2020-11-14 23:00:00', '2020-11-15
> > >> > 00:00:00',
> > >> > '2020-11-15 01:00:00', '2020-11-15 02:00:00', '2020-11-15
> > >> > 03:00:00',
> > >> > '2020-11-15 04:00:00', '2020-11-15 05:00:00', '2020-11-15
> > >> > 06:00:00',
> > >> > '2020-11-15 07:00:00', '2020-11-15 08:00:00', '2020-11-15
> > >> > 09:00:00',
> > >> > '2020-11-15 10:00:00', '2020-11-15 11:00:00', '2020-11-15
> > >> > 12:00:00',
> > >> > '2020-11-15 13:00:00', '2020-11-15 14:00:00', '2020-11-15
> > >> > 15:00:00',
> > >> > '2020-11-15 16:00:00', '2020-11-15 17:00:00', '2020-11-15
> > >> > 18:00:00',
> > >> > '2020-11-15 19:00:00', '2020-11-15 20:00:00', '2020-11-15
> > >> > 21:00:00',
> > >> > '2020-11-15 22:00:00', '2020-11-15 23:00:00')
> > >> > AND BINARY h.model IN ('PARA6A', 'PARA6A_BC', 'PROD',
> > >> > 'PROD_BC')
> > >> > AND BINARY if( (select fcst_lead_offset FROM
> > >> > model_fcst_lead_offset
> > >> > WHERE model = h.model) is NULL , ld.fcst_lead , ld.fcst_lead
+
> > >> > (select
> > >> > fcst_lead_offset FROM model_fcst_lead_offset WHERE model =
> > >> > h.model) )
> > >> IN
> > >> > ('0', '10000', '20000', '30000', '40000', '50000', '60000',
> > >> > '70000',
> > >> > '80000', '90000', '100000', '110000', '120000', '130000',
> > >> > '140000',
> > >> > '150000', '160000', '170000', '180000', '190000', '200000',
> > >> > '210000',
> > >> > '220000', '230000', '240000', '250000', '260000', '270000',
> > >> > '280000',
> > >> > '290000', '300000', '310000', '320000', '330000', '340000',
> > >> > '350000',
> > >> > '360000', '370000', '380000', '390000', '400000', '410000',
> > >> > '420000',
> > >> > '430000', '440000', '450000', '460000', '470000', '480000')
> > >> > AND BINARY h.fcst_var = 'PMTF'
> > >> > AND ld.stat_header_id = h.stat_header_id;
> > >> >
> > >> >
> > >> > I did hear the MetViewer site was inaccessible earlier. I'm
not
> > >> > sure
> > >> what
> > >> > happened or if this could be related to my issue.
> > >>
> > >>
> > >>
> > >>
> > >
> > > --
> > > Edward Strobach
> > > EMC/NCEP/NWS/
> > > IMSG Contractor
> > > Cubicle#: 2029
> > > 301-683-3717
> > >
>
>
>
>
--
Edward Strobach
EMC/NCEP/NWS/
IMSG Contractor
Cubicle#: 2029
301-683-3717
------------------------------------------------
Subject: batch plotting not moving forward/no plots generated
From: John Halley Gotway
Time: Fri Nov 20 11:20:28 2020
Ed,
Wondering about the status of this RT ticket. I believe that Tatiana
is
looking into the SQL issue related to the "Crop_Woodland" string.
Can I go ahead and resolve this particular RT ticket?
Thanks,
John
On Wed, Nov 18, 2020 at 12:17 PM Edward Strobach - NOAA Affiliate via
RT <
met_help at ucar.edu> wrote:
>
> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=97510 >
>
> I'm glad you brought that up. This has been an issue I have been
facing
> for quite a while. Although things are now just starting to
process, I
> have experienced issues of plots not being generated or stored in
the wrong
> location. There's no pattern to it, and I suspect it's related to
the
> point you brought up. My hope is that once I get the SQL error
resolved
> related to Crop_Woodland - and others; recall the conversation two
days ago
> - that I can put everything under the same xml file.
>
> On Wed, Nov 18, 2020 at 2:00 PM Tatiana Burek via RT
<met_help at ucar.edu>
> wrote:
>
> > Are you starting a multiple batch jobs at the same time without
waiting
> > until the previous one is finished?
> > This could overwhelm the Java Virtual Machine and the database
resources.
> >
> > Tatiana
> >
> > On Wed Nov 18 11:47:46 2020, edward.strobach at noaa.gov wrote:
> > > I did try again but it still seems hung up. Should I just try
later
> > > perhaps?
> > >
> > > On Wed, Nov 18, 2020 at 1:04 PM Edward Strobach - NOAA Affiliate
<
> > > edward.strobach at noaa.gov> wrote:
> > >
> > > > I can try that. Thanks
> > > >
> > > > On Wed, Nov 18, 2020 at 1:03 PM Tatiana Burek via RT
> > > > <met_help at ucar.edu>
> > > > wrote:
> > > >
> > > >> Ed,
> > > >>
> > > >> I see a few batch jobs handing on AWS.
> > > >> I will cancel them so you could restart your job(s).
> > > >> Will this work?
> > > >>
> > > >> Tatiana
> > > >>
> > > >> On Wed Nov 18 10:57:01 2020, edward.strobach at noaa.gov wrote:
> > > >> > Good afternoon,
> > > >> >
> > > >> > After the machine switch from Mars to Venus, I set
everything up
> > > >> > and
> > > >> tested
> > > >> > the batch plotting capability as I had done before. When
running
> > > >> > the
> > > >> plot
> > > >> > batch script I noticed that nothing proceeds forward. It's
been
> > > >> > hung up
> > > >> > here for over 30 minutes:
> > > >> >
> > > >> >
> > > >> > '2020-11-14 04:00:00', '2020-11-14 05:00:00', '2020-11-14
> > > >> > 06:00:00',
> > > >> > '2020-11-14 07:00:00', '2020-11-14 08:00:00', '2020-11-14
> > > >> > 09:00:00',
> > > >> > '2020-11-14 10:00:00', '2020-11-14 11:00:00', '2020-11-14
> > > >> > 12:00:00',
> > > >> > '2020-11-14 13:00:00', '2020-11-14 14:00:00', '2020-11-14
> > > >> > 15:00:00',
> > > >> > '2020-11-14 16:00:00', '2020-11-14 17:00:00', '2020-11-14
> > > >> > 18:00:00',
> > > >> > '2020-11-14 19:00:00', '2020-11-14 20:00:00', '2020-11-14
> > > >> > 21:00:00',
> > > >> > '2020-11-14 22:00:00', '2020-11-14 23:00:00', '2020-11-15
> > > >> > 00:00:00',
> > > >> > '2020-11-15 01:00:00', '2020-11-15 02:00:00', '2020-11-15
> > > >> > 03:00:00',
> > > >> > '2020-11-15 04:00:00', '2020-11-15 05:00:00', '2020-11-15
> > > >> > 06:00:00',
> > > >> > '2020-11-15 07:00:00', '2020-11-15 08:00:00', '2020-11-15
> > > >> > 09:00:00',
> > > >> > '2020-11-15 10:00:00', '2020-11-15 11:00:00', '2020-11-15
> > > >> > 12:00:00',
> > > >> > '2020-11-15 13:00:00', '2020-11-15 14:00:00', '2020-11-15
> > > >> > 15:00:00',
> > > >> > '2020-11-15 16:00:00', '2020-11-15 17:00:00', '2020-11-15
> > > >> > 18:00:00',
> > > >> > '2020-11-15 19:00:00', '2020-11-15 20:00:00', '2020-11-15
> > > >> > 21:00:00',
> > > >> > '2020-11-15 22:00:00', '2020-11-15 23:00:00')
> > > >> > AND BINARY h.model IN ('PARA6A', 'PARA6A_BC', 'PROD',
> > > >> > 'PROD_BC')
> > > >> > AND BINARY if( (select fcst_lead_offset FROM
> > > >> > model_fcst_lead_offset
> > > >> > WHERE model = h.model) is NULL , ld.fcst_lead ,
ld.fcst_lead +
> > > >> > (select
> > > >> > fcst_lead_offset FROM model_fcst_lead_offset WHERE model =
> > > >> > h.model) )
> > > >> IN
> > > >> > ('0', '10000', '20000', '30000', '40000', '50000', '60000',
> > > >> > '70000',
> > > >> > '80000', '90000', '100000', '110000', '120000', '130000',
> > > >> > '140000',
> > > >> > '150000', '160000', '170000', '180000', '190000', '200000',
> > > >> > '210000',
> > > >> > '220000', '230000', '240000', '250000', '260000', '270000',
> > > >> > '280000',
> > > >> > '290000', '300000', '310000', '320000', '330000', '340000',
> > > >> > '350000',
> > > >> > '360000', '370000', '380000', '390000', '400000', '410000',
> > > >> > '420000',
> > > >> > '430000', '440000', '450000', '460000', '470000', '480000')
> > > >> > AND BINARY h.fcst_var = 'PMTF'
> > > >> > AND ld.stat_header_id = h.stat_header_id;
> > > >> >
> > > >> >
> > > >> > I did hear the MetViewer site was inaccessible earlier.
I'm not
> > > >> > sure
> > > >> what
> > > >> > happened or if this could be related to my issue.
> > > >>
> > > >>
> > > >>
> > > >>
> > > >
> > > > --
> > > > Edward Strobach
> > > > EMC/NCEP/NWS/
> > > > IMSG Contractor
> > > > Cubicle#: 2029
> > > > 301-683-3717
> > > >
> >
> >
> >
> >
>
> --
> Edward Strobach
> EMC/NCEP/NWS/
> IMSG Contractor
> Cubicle#: 2029
> 301-683-3717
>
>
------------------------------------------------
Subject: batch plotting not moving forward/no plots generated
From: Edward Strobach - NOAA Affiliate
Time: Fri Nov 20 11:31:46 2020
Yeah, we're good here. Thanks
On Fri, Nov 20, 2020 at 1:20 PM John Halley Gotway via RT
<met_help at ucar.edu>
wrote:
> Ed,
>
> Wondering about the status of this RT ticket. I believe that Tatiana
is
> looking into the SQL issue related to the "Crop_Woodland" string.
>
> Can I go ahead and resolve this particular RT ticket?
>
> Thanks,
> John
>
> On Wed, Nov 18, 2020 at 12:17 PM Edward Strobach - NOAA Affiliate
via RT <
> met_help at ucar.edu> wrote:
>
> >
> > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=97510 >
> >
> > I'm glad you brought that up. This has been an issue I have been
facing
> > for quite a while. Although things are now just starting to
process, I
> > have experienced issues of plots not being generated or stored in
the
> wrong
> > location. There's no pattern to it, and I suspect it's related to
the
> > point you brought up. My hope is that once I get the SQL error
resolved
> > related to Crop_Woodland - and others; recall the conversation two
days
> ago
> > - that I can put everything under the same xml file.
> >
> > On Wed, Nov 18, 2020 at 2:00 PM Tatiana Burek via RT
<met_help at ucar.edu>
> > wrote:
> >
> > > Are you starting a multiple batch jobs at the same time without
waiting
> > > until the previous one is finished?
> > > This could overwhelm the Java Virtual Machine and the database
> resources.
> > >
> > > Tatiana
> > >
> > > On Wed Nov 18 11:47:46 2020, edward.strobach at noaa.gov wrote:
> > > > I did try again but it still seems hung up. Should I just try
later
> > > > perhaps?
> > > >
> > > > On Wed, Nov 18, 2020 at 1:04 PM Edward Strobach - NOAA
Affiliate <
> > > > edward.strobach at noaa.gov> wrote:
> > > >
> > > > > I can try that. Thanks
> > > > >
> > > > > On Wed, Nov 18, 2020 at 1:03 PM Tatiana Burek via RT
> > > > > <met_help at ucar.edu>
> > > > > wrote:
> > > > >
> > > > >> Ed,
> > > > >>
> > > > >> I see a few batch jobs handing on AWS.
> > > > >> I will cancel them so you could restart your job(s).
> > > > >> Will this work?
> > > > >>
> > > > >> Tatiana
> > > > >>
> > > > >> On Wed Nov 18 10:57:01 2020, edward.strobach at noaa.gov
wrote:
> > > > >> > Good afternoon,
> > > > >> >
> > > > >> > After the machine switch from Mars to Venus, I set
everything up
> > > > >> > and
> > > > >> tested
> > > > >> > the batch plotting capability as I had done before. When
running
> > > > >> > the
> > > > >> plot
> > > > >> > batch script I noticed that nothing proceeds forward.
It's been
> > > > >> > hung up
> > > > >> > here for over 30 minutes:
> > > > >> >
> > > > >> >
> > > > >> > '2020-11-14 04:00:00', '2020-11-14 05:00:00', '2020-11-14
> > > > >> > 06:00:00',
> > > > >> > '2020-11-14 07:00:00', '2020-11-14 08:00:00', '2020-11-14
> > > > >> > 09:00:00',
> > > > >> > '2020-11-14 10:00:00', '2020-11-14 11:00:00', '2020-11-14
> > > > >> > 12:00:00',
> > > > >> > '2020-11-14 13:00:00', '2020-11-14 14:00:00', '2020-11-14
> > > > >> > 15:00:00',
> > > > >> > '2020-11-14 16:00:00', '2020-11-14 17:00:00', '2020-11-14
> > > > >> > 18:00:00',
> > > > >> > '2020-11-14 19:00:00', '2020-11-14 20:00:00', '2020-11-14
> > > > >> > 21:00:00',
> > > > >> > '2020-11-14 22:00:00', '2020-11-14 23:00:00', '2020-11-15
> > > > >> > 00:00:00',
> > > > >> > '2020-11-15 01:00:00', '2020-11-15 02:00:00', '2020-11-15
> > > > >> > 03:00:00',
> > > > >> > '2020-11-15 04:00:00', '2020-11-15 05:00:00', '2020-11-15
> > > > >> > 06:00:00',
> > > > >> > '2020-11-15 07:00:00', '2020-11-15 08:00:00', '2020-11-15
> > > > >> > 09:00:00',
> > > > >> > '2020-11-15 10:00:00', '2020-11-15 11:00:00', '2020-11-15
> > > > >> > 12:00:00',
> > > > >> > '2020-11-15 13:00:00', '2020-11-15 14:00:00', '2020-11-15
> > > > >> > 15:00:00',
> > > > >> > '2020-11-15 16:00:00', '2020-11-15 17:00:00', '2020-11-15
> > > > >> > 18:00:00',
> > > > >> > '2020-11-15 19:00:00', '2020-11-15 20:00:00', '2020-11-15
> > > > >> > 21:00:00',
> > > > >> > '2020-11-15 22:00:00', '2020-11-15 23:00:00')
> > > > >> > AND BINARY h.model IN ('PARA6A', 'PARA6A_BC', 'PROD',
> > > > >> > 'PROD_BC')
> > > > >> > AND BINARY if( (select fcst_lead_offset FROM
> > > > >> > model_fcst_lead_offset
> > > > >> > WHERE model = h.model) is NULL , ld.fcst_lead ,
ld.fcst_lead +
> > > > >> > (select
> > > > >> > fcst_lead_offset FROM model_fcst_lead_offset WHERE model
=
> > > > >> > h.model) )
> > > > >> IN
> > > > >> > ('0', '10000', '20000', '30000', '40000', '50000',
'60000',
> > > > >> > '70000',
> > > > >> > '80000', '90000', '100000', '110000', '120000', '130000',
> > > > >> > '140000',
> > > > >> > '150000', '160000', '170000', '180000', '190000',
'200000',
> > > > >> > '210000',
> > > > >> > '220000', '230000', '240000', '250000', '260000',
'270000',
> > > > >> > '280000',
> > > > >> > '290000', '300000', '310000', '320000', '330000',
'340000',
> > > > >> > '350000',
> > > > >> > '360000', '370000', '380000', '390000', '400000',
'410000',
> > > > >> > '420000',
> > > > >> > '430000', '440000', '450000', '460000', '470000',
'480000')
> > > > >> > AND BINARY h.fcst_var = 'PMTF'
> > > > >> > AND ld.stat_header_id = h.stat_header_id;
> > > > >> >
> > > > >> >
> > > > >> > I did hear the MetViewer site was inaccessible earlier.
I'm not
> > > > >> > sure
> > > > >> what
> > > > >> > happened or if this could be related to my issue.
> > > > >>
> > > > >>
> > > > >>
> > > > >>
> > > > >
> > > > > --
> > > > > Edward Strobach
> > > > > EMC/NCEP/NWS/
> > > > > IMSG Contractor
> > > > > Cubicle#: 2029
> > > > > 301-683-3717
> > > > >
> > >
> > >
> > >
> > >
> >
> > --
> > Edward Strobach
> > EMC/NCEP/NWS/
> > IMSG Contractor
> > Cubicle#: 2029
> > 301-683-3717
> >
> >
>
>
--
Edward Strobach
EMC/NCEP/NWS/
IMSG Contractor
Cubicle#: 2029
301-683-3717
------------------------------------------------
More information about the Met_help
mailing list