[Met_help] [rt.rap.ucar.edu #90303] History for 8 May change to NCEP METviewer server's /usr1/metviewer/metviewer/bin/mv_batch.sh

[Tatiana Burek via RT]

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

Hello.  I see that on the (non-AWS) NCEP METviewer server, 
/usr1/metviewer/metviewer/bin/mv_batch.sh was updated on 8 May. Since 
then my batch scripts stopped working.  For example, in the attached 
plt_rgl_ets.xml, I'm getting this error message:

  /usr1/metviewer/metviewer/bin/mv_batch.sh 
/metviewer/staging/wd22yl/sudo.scripts/plt_rgl_ets.xml
----  MVBatch  ----

input file: /metviewer/staging/wd22yl/sudo.scripts/plt_rgl_ets.xml

   **  ERROR:  String BETWEEN '2019-04-19 12:00:00' AND '2019-05-19 
12:00:00' includes SQL unsafe word AND or BETWEEN
----  MVBatch Done  ----

In the plt_rgl_ets.xml I have this:

     <date_range name="vtimes">
       <start>2019-04-19 12:00:00</start>
       <end>2019-05-19 12:00:00</end>
       <inc>86400</inc>
       <format>yyyy-MM-dd HH:mm:ss</format>
     </date_range>

Where is the unsafe word AND or BETWEEN, and how I might fix this?

Thank you -

Ying

-- 
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov




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

Subject: 8 May change to NCEP METviewer server's /usr1/metviewer/metviewer/bin/mv_batch.sh
From: Tatiana Burek
Time: Tue May 21 15:27:18 2019

Hi Ying,
I deployed the patch that should fix this problem.
I rerun you r XML and it did work.

Tatiana

On Tue May 21 14:58:11 2019, ying.lin at noaa.gov wrote:
> Hello.  I see that on the (non-AWS) NCEP METviewer server,
> /usr1/metviewer/metviewer/bin/mv_batch.sh was updated on 8 May.
Since
> then my batch scripts stopped working.  For example, in the attached
> plt_rgl_ets.xml, I'm getting this error message:
>
>   /usr1/metviewer/metviewer/bin/mv_batch.sh
> /metviewer/staging/wd22yl/sudo.scripts/plt_rgl_ets.xml
> ----  MVBatch  ----
>
> input file: /metviewer/staging/wd22yl/sudo.scripts/plt_rgl_ets.xml
>
>    **  ERROR:  String BETWEEN '2019-04-19 12:00:00' AND '2019-05-19
> 12:00:00' includes SQL unsafe word AND or BETWEEN
> ----  MVBatch Done  ----
>
> In the plt_rgl_ets.xml I have this:
>
>      <date_range name="vtimes">
>        <start>2019-04-19 12:00:00</start>
>        <end>2019-05-19 12:00:00</end>
>        <inc>86400</inc>
>        <format>yyyy-MM-dd HH:mm:ss</format>
>      </date_range>
>
> Where is the unsafe word AND or BETWEEN, and how I might fix this?
>
> Thank you -
>
> Ying
>



------------------------------------------------
Subject: Re: [rt.rap.ucar.edu #90303] 8 May change to NCEP METviewer server's /usr1/metviewer/metviewer/bin/mv_batch.sh
From: Ying Lin
Time: Tue May 21 16:27:25 2019

Hi Tatiana,

     Thank you very much for the quick fix!  I tried the script again
and it did work now.

Ying

On 5/21/19 5:27 PM, Tatiana Burek via RT wrote:
> Hi Ying,
> I deployed the patch that should fix this problem.
> I rerun you r XML and it did work.
>
> Tatiana
>
> On Tue May 21 14:58:11 2019, ying.lin at noaa.gov wrote:
>> Hello.  I see that on the (non-AWS) NCEP METviewer server,
>> /usr1/metviewer/metviewer/bin/mv_batch.sh was updated on 8 May.
Since
>> then my batch scripts stopped working.  For example, in the
attached
>> plt_rgl_ets.xml, I'm getting this error message:
>>
>>    /usr1/metviewer/metviewer/bin/mv_batch.sh
>> /metviewer/staging/wd22yl/sudo.scripts/plt_rgl_ets.xml
>> ----  MVBatch  ----
>>
>> input file: /metviewer/staging/wd22yl/sudo.scripts/plt_rgl_ets.xml
>>
>>     **  ERROR:  String BETWEEN '2019-04-19 12:00:00' AND '2019-05-
19
>> 12:00:00' includes SQL unsafe word AND or BETWEEN
>> ----  MVBatch Done  ----
>>
>> In the plt_rgl_ets.xml I have this:
>>
>>       <date_range name="vtimes">
>>         <start>2019-04-19 12:00:00</start>
>>         <end>2019-05-19 12:00:00</end>
>>         <inc>86400</inc>
>>         <format>yyyy-MM-dd HH:mm:ss</format>
>>       </date_range>
>>
>> Where is the unsafe word AND or BETWEEN, and how I might fix this?
>>
>> Thank you -
>>
>> Ying
>>
>
>

--
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov



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