[Met_help] [rt.rap.ucar.edu #90886] History for METviewer load data
Julie Prestopnik via RT
met_help at ucar.edu
Mon Jul 8 10:01:49 MDT 2019
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
Dear Colleagues,
I installed METviewer and tried to load a MET output file into a mysql database.
When I run the mv_load.sh command, I got the following error:
[root at 356e1fd08e0f METviewer]# bin/mv_load.sh xml/load_test.xml
---- MVLoad ----
Begin time: 2019-07-03 01:40:22
Parsing: xml/load_test.xml
/data/grid_stat_000000L_19700101_000000V.stat
data file time: 0:00:00.024
For input string: "0.81622"
** ERROR: caught class java.lang.Exception loading file /data/grid_stat_000000L_19700101_000000V.stat: caught SQLException calling executeBatch: (conn=457) Column count doesn't match value count at row 1
java.lang.Exception: caught SQLException calling executeBatch: (conn=457) Column count doesn't match value count at row 1
** WARNING: error(s) encountered loading file /data/grid_stat_000000L_19700101_000000V.stat - skipping file
==== grid_stat ====
However, it seems the data have eventually been loaded and I was able to see the loaded variables from the web page at http://localhost:8080/metviewer/metviewer1.jsp and make plots.
So I wonder if the above error message about “skipping file” is just a warning and therefore does not affect the METviewer run? Or has a part of the file has been skipped and therefore the loading is not complete?
Could you please advise? The xml file and the .stat file have been attached here.
Thanks
Shaowu
----------------------------------------------------------------
Complete Ticket History
----------------------------------------------------------------
Subject: METviewer load data
From: Julie Prestopnik
Time: Wed Jul 03 09:33:25 2019
Hi Shaowu
I see that you are having some trouble with METviewer. I have
assigned
this ticket to Tatiana, who should be able to better assist you.
Please
allow a few days for a response.
Thank you.
Julie
On Tue, Jul 2, 2019 at 7:53 PM sbao at coastal.edu via RT
<met_help at ucar.edu>
wrote:
>
> Tue Jul 02 19:53:16 2019: Request 90886 was acted upon.
> Transaction: Ticket created by sbao at coastal.edu
> Queue: met_help
> Subject: METviewer load data
> Owner: Nobody
> Requestors: sbao at coastal.edu
> Status: new
> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=90886 >
>
>
> Dear Colleagues,
>
> I installed METviewer and tried to load a MET output file into a
mysql
> database.
> When I run the mv_load.sh command, I got the following error:
>
> [root at 356e1fd08e0f METviewer]# bin/mv_load.sh xml/load_test.xml
> ---- MVLoad ----
>
> Begin time: 2019-07-03 01:40:22
> Parsing: xml/load_test.xml
>
> /data/grid_stat_000000L_19700101_000000V.stat
> data file time: 0:00:00.024
> For input string: "0.81622"
> ** ERROR: caught class java.lang.Exception loading file
> /data/grid_stat_000000L_19700101_000000V.stat: caught SQLException
calling
> executeBatch: (conn=457) Column count doesn't match value count at
row 1
> java.lang.Exception: caught SQLException calling executeBatch:
(conn=457)
> Column count doesn't match value count at row 1
> ** WARNING: error(s) encountered loading file
> /data/grid_stat_000000L_19700101_000000V.stat - skipping file
> ==== grid_stat ====
>
>
> However, it seems the data have eventually been loaded and I was
able to
> see the loaded variables from the web page at
> http://localhost:8080/metviewer/metviewer1.jsp and make plots.
>
> So I wonder if the above error message about “skipping file” is just
a
> warning and therefore does not affect the METviewer run? Or has a
part of
> the file has been skipped and therefore the loading is not complete?
>
> Could you please advise? The xml file and the .stat file have been
> attached here.
>
> Thanks
> Shaowu
>
>
------------------------------------------------
Subject: Re: [rt.rap.ucar.edu #90886] METviewer load data
From: sbao at coastal.edu
Time: Fri Jul 05 17:08:02 2019
Julie,
I would like to let you know that I have found the cause of the
problem: I am trying to load MET-v8.1 output data into METviewer2.9,
which are incompatible.
I changed to MET-v8.0 and the METviewer2.9 worked well. Problem
solved.
Thanks,
Shaowu
On 7/3/19, 11:34 AM, "Julie Prestopnik via RT" <met_help at ucar.edu>
wrote:
Hi Shaowu
I see that you are having some trouble with METviewer. I have
assigned
this ticket to Tatiana, who should be able to better assist you.
Please
allow a few days for a response.
Thank you.
Julie
On Tue, Jul 2, 2019 at 7:53 PM sbao at coastal.edu via RT
<met_help at ucar.edu>
wrote:
>
> Tue Jul 02 19:53:16 2019: Request 90886 was acted upon.
> Transaction: Ticket created by sbao at coastal.edu
> Queue: met_help
> Subject: METviewer load data
> Owner: Nobody
> Requestors: sbao at coastal.edu
> Status: new
> Ticket <URL:
https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Frt.rap.ucar.edu%2Frt%2FTicket%2FDisplay.html%3Fid%3D90886&data=02%7C01%7Csbao%40coastal.edu%7C9da35cf942aa4ccfe5c008d6ffcbe52a%7Cbf1f856b8ef84e52be9387d3c3622797%7C0%7C0%7C636977648533592657&sdata=cdutcXJyv8EUlmEb3t%2BYlqRy6GC5lr7JOEOe6QXBblc%3D&reserved=0
>
>
>
> Dear Colleagues,
>
> I installed METviewer and tried to load a MET output file into a
mysql
> database.
> When I run the mv_load.sh command, I got the following error:
>
> [root at 356e1fd08e0f METviewer]# bin/mv_load.sh xml/load_test.xml
> ---- MVLoad ----
>
> Begin time: 2019-07-03 01:40:22
> Parsing: xml/load_test.xml
>
> /data/grid_stat_000000L_19700101_000000V.stat
> data file time: 0:00:00.024
> For input string: "0.81622"
> ** ERROR: caught class java.lang.Exception loading file
> /data/grid_stat_000000L_19700101_000000V.stat: caught
SQLException calling
> executeBatch: (conn=457) Column count doesn't match value count
at row 1
> java.lang.Exception: caught SQLException calling executeBatch:
(conn=457)
> Column count doesn't match value count at row 1
> ** WARNING: error(s) encountered loading file
> /data/grid_stat_000000L_19700101_000000V.stat - skipping file
> ==== grid_stat ====
>
>
> However, it seems the data have eventually been loaded and I was
able to
> see the loaded variables from the web page at
> http://localhost:8080/metviewer/metviewer1.jsp and make plots.
>
> So I wonder if the above error message about “skipping file” is
just a
> warning and therefore does not affect the METviewer run? Or has
a part of
> the file has been skipped and therefore the loading is not
complete?
>
> Could you please advise? The xml file and the .stat file have
been
> attached here.
>
> Thanks
> Shaowu
>
>
------------------------------------------------
Subject: METviewer load data
From: Julie Prestopnik
Time: Mon Jul 08 09:29:32 2019
Thank you for resolving the problem and for letting us know. I will
close
this ticket. Please feel free to open a new ticket with any other
issues.
Julie
On Fri, Jul 5, 2019 at 5:08 PM sbao at coastal.edu via RT
<met_help at ucar.edu>
wrote:
>
> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=90886 >
>
> Julie,
>
> I would like to let you know that I have found the cause of the
problem: I
> am trying to load MET-v8.1 output data into METviewer2.9, which are
> incompatible.
> I changed to MET-v8.0 and the METviewer2.9 worked well. Problem
solved.
>
> Thanks,
> Shaowu
>
> On 7/3/19, 11:34 AM, "Julie Prestopnik via RT" <met_help at ucar.edu>
wrote:
>
> Hi Shaowu
>
> I see that you are having some trouble with METviewer. I have
assigned
> this ticket to Tatiana, who should be able to better assist you.
> Please
> allow a few days for a response.
>
> Thank you.
>
> Julie
>
> On Tue, Jul 2, 2019 at 7:53 PM sbao at coastal.edu via RT <
> met_help at ucar.edu>
> wrote:
>
> >
> > Tue Jul 02 19:53:16 2019: Request 90886 was acted upon.
> > Transaction: Ticket created by sbao at coastal.edu
> > Queue: met_help
> > Subject: METviewer load data
> > Owner: Nobody
> > Requestors: sbao at coastal.edu
> > Status: new
> > Ticket <URL:
>
https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Frt.rap.ucar.edu%2Frt%2FTicket%2FDisplay.html%3Fid%3D90886&data=02%7C01%7Csbao%40coastal.edu%7C9da35cf942aa4ccfe5c008d6ffcbe52a%7Cbf1f856b8ef84e52be9387d3c3622797%7C0%7C0%7C636977648533592657&sdata=cdutcXJyv8EUlmEb3t%2BYlqRy6GC5lr7JOEOe6QXBblc%3D&reserved=0
> >
> >
> >
> > Dear Colleagues,
> >
> > I installed METviewer and tried to load a MET output file into
a
> mysql
> > database.
> > When I run the mv_load.sh command, I got the following error:
> >
> > [root at 356e1fd08e0f METviewer]# bin/mv_load.sh
xml/load_test.xml
> > ---- MVLoad ----
> >
> > Begin time: 2019-07-03 01:40:22
> > Parsing: xml/load_test.xml
> >
> > /data/grid_stat_000000L_19700101_000000V.stat
> > data file time: 0:00:00.024
> > For input string: "0.81622"
> > ** ERROR: caught class java.lang.Exception loading file
> > /data/grid_stat_000000L_19700101_000000V.stat: caught
SQLException
> calling
> > executeBatch: (conn=457) Column count doesn't match value
count at
> row 1
> > java.lang.Exception: caught SQLException calling executeBatch:
> (conn=457)
> > Column count doesn't match value count at row 1
> > ** WARNING: error(s) encountered loading file
> > /data/grid_stat_000000L_19700101_000000V.stat - skipping file
> > ==== grid_stat ====
> >
> >
> > However, it seems the data have eventually been loaded and I
was
> able to
> > see the loaded variables from the web page at
> > http://localhost:8080/metviewer/metviewer1.jsp and make plots.
> >
> > So I wonder if the above error message about “skipping file”
is just
> a
> > warning and therefore does not affect the METviewer run? Or
has a
> part of
> > the file has been skipped and therefore the loading is not
complete?
> >
> > Could you please advise? The xml file and the .stat file have
been
> > attached here.
> >
> > Thanks
> > Shaowu
> >
> >
>
>
>
>
>
>
------------------------------------------------
More information about the Met_help
mailing list