[Met_help] [rt.rap.ucar.edu #94383] History for METviewer- upload FBIAS=1 .stat issue
John Halley Gotway via RT
met_help at ucar.edu
Thu Mar 5 14:56:51 MST 2020
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
Hi again,
I wanted to bring up an issue I encountered while running METviewer version 2.11. I have output for grid_stat-generated data that specifies a forecast threshold of “FBIAS=1” and wanted to plot some of the statistics with that data. However, when uploading the .stat files to our local mariadb database, I’ll get the following error message:
2020-03-02 edu.ucar.metviewer.db.mysql.MysqlLoadDatabaseManager.executeBatch(Unknown Source) -1 executeBatch - Could not set parameter at position 13 (values was '-9999.0')
Query - conn:336(M) - "INSERT INTO line_data_perc VALUES (?,?,?,?,?,?,?,?,?,?,?,?)"
2020-03-02 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main - ** ERROR: caught class edu.ucar.metviewer.DatabaseException in processFile()
caught SQLException calling executeBatch: Could not set parameter at position 13 (values was '-9999.0’)
So then I tried to process the grid_stat data with the stat_analysis tool and create .stat files from there. I then received the following message when uploading the stat_analysis-created .stat files:
** WARNING: unexpected line type: NA the line will be ignored
Both of these attempts yielded zero lines being read into the database. Is there a workaround that I should try so that I can get the .stat files uploaded successfully? Please let me know if you need a copy of the .stat output for both instances and I’ll be happy to provide them.
Many thanks!
-Brian
—————————————————————
Brian Matilla
Research Fellow— Warn-on-Forecast Team
Cooperative Institute for Mesoscale Meteorological Studies — The University of Oklahoma
NOAA National Severe Storms Laboratory
----------------------------------------------------------------
Complete Ticket History
----------------------------------------------------------------
Subject: METviewer- upload FBIAS=1 .stat issue
From: John Halley Gotway
Time: Tue Mar 03 09:45:41 2020
Brian,
Could you please send me one of those .stat files that resulted in an
error
from stat_analysis when trying to read it? The first thing I want to
check
is whether the column alignment is messed up. The columns are
separated by
whitespace. So even though they may be lined up nicely for a human to
read, an empty string (too few columns) or embedded whitespace (too
many
columns) would cause a parsing error.
We have several checks in MET to prevent embedded whitespace and empty
strings, but perhaps we missed one? If so, I'd like to figure out
where
and add it for the next release.
Of course, the problem could be something else entirely.
Thanks,
John Halley Gotway
On Tue, Mar 3, 2020 at 7:53 AM Brian Matilla - NOAA Affiliate via RT <
met_help at ucar.edu> wrote:
>
> Tue Mar 03 07:53:24 2020: Request 94383 was acted upon.
> Transaction: Ticket created by brian.matilla at noaa.gov
> Queue: met_help
> Subject: METviewer- upload FBIAS=1 .stat issue
> Owner: Nobody
> Requestors: brian.matilla at noaa.gov
> Status: new
> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=94383 >
>
>
> Hi again,
>
> I wanted to bring up an issue I encountered while running METviewer
> version 2.11. I have output for grid_stat-generated data that
specifies a
> forecast threshold of “FBIAS=1” and wanted to plot some of the
statistics
> with that data. However, when uploading the .stat files to our local
> mariadb database, I’ll get the following error message:
>
> 2020-03-02
>
edu.ucar.metviewer.db.mysql.MysqlLoadDatabaseManager.executeBatch(Unknown
> Source) -1 executeBatch - Could not set parameter at position 13
(values
> was '-9999.0')
> Query - conn:336(M) - "INSERT INTO line_data_perc VALUES
> (?,?,?,?,?,?,?,?,?,?,?,?)"
> 2020-03-02 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main -
**
> ERROR: caught class edu.ucar.metviewer.DatabaseException in
processFile()
> caught SQLException calling executeBatch: Could not set parameter at
> position 13 (values was '-9999.0’)
>
> So then I tried to process the grid_stat data with the stat_analysis
tool
> and create .stat files from there. I then received the following
message
> when uploading the stat_analysis-created .stat files:
>
> ** WARNING: unexpected line type: NA the line will be ignored
>
> Both of these attempts yielded zero lines being read into the
database. Is
> there a workaround that I should try so that I can get the .stat
files
> uploaded successfully? Please let me know if you need a copy of the
.stat
> output for both instances and I’ll be happy to provide them.
>
> Many thanks!
>
> -Brian
> —————————————————————
> Brian Matilla
> Research Fellow— Warn-on-Forecast Team
> Cooperative Institute for Mesoscale Meteorological Studies — The
> University of Oklahoma
> NOAA National Severe Storms Laboratory
>
>
>
------------------------------------------------
Subject: METviewer- upload FBIAS=1 .stat issue
From: Brian Matilla - NOAA Affiliate
Time: Tue Mar 03 10:08:08 2020
Hi John,
Sure thing. I’ve attached a grid_stat file and a stat_analysis file so
that you can try both if you need them.
-Brian
> On Mar 3, 2020, at 10:45 AM, John Halley Gotway via RT
<met_help at ucar.edu> wrote:
>
> Brian,
>
> Could you please send me one of those .stat files that resulted in
an error
> from stat_analysis when trying to read it? The first thing I want
to check
> is whether the column alignment is messed up. The columns are
separated by
> whitespace. So even though they may be lined up nicely for a human
to
> read, an empty string (too few columns) or embedded whitespace (too
many
> columns) would cause a parsing error.
>
> We have several checks in MET to prevent embedded whitespace and
empty
> strings, but perhaps we missed one? If so, I'd like to figure out
where
> and add it for the next release.
>
> Of course, the problem could be something else entirely.
>
> Thanks,
> John Halley Gotway
>
> On Tue, Mar 3, 2020 at 7:53 AM Brian Matilla - NOAA Affiliate via RT
<
> met_help at ucar.edu> wrote:
>
>>
>> Tue Mar 03 07:53:24 2020: Request 94383 was acted upon.
>> Transaction: Ticket created by brian.matilla at noaa.gov
>> Queue: met_help
>> Subject: METviewer- upload FBIAS=1 .stat issue
>> Owner: Nobody
>> Requestors: brian.matilla at noaa.gov
>> Status: new
>> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=94383 >
>>
>>
>> Hi again,
>>
>> I wanted to bring up an issue I encountered while running METviewer
>> version 2.11. I have output for grid_stat-generated data that
specifies a
>> forecast threshold of “FBIAS=1” and wanted to plot some of the
statistics
>> with that data. However, when uploading the .stat files to our
local
>> mariadb database, I’ll get the following error message:
>>
>> 2020-03-02
>>
edu.ucar.metviewer.db.mysql.MysqlLoadDatabaseManager.executeBatch(Unknown
>> Source) -1 executeBatch - Could not set parameter at position 13
(values
>> was '-9999.0')
>> Query - conn:336(M) - "INSERT INTO line_data_perc VALUES
>> (?,?,?,?,?,?,?,?,?,?,?,?)"
>> 2020-03-02 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main -
**
>> ERROR: caught class edu.ucar.metviewer.DatabaseException in
processFile()
>> caught SQLException calling executeBatch: Could not set parameter
at
>> position 13 (values was '-9999.0’)
>>
>> So then I tried to process the grid_stat data with the
stat_analysis tool
>> and create .stat files from there. I then received the following
message
>> when uploading the stat_analysis-created .stat files:
>>
>> ** WARNING: unexpected line type: NA the line will be ignored
>>
>> Both of these attempts yielded zero lines being read into the
database. Is
>> there a workaround that I should try so that I can get the .stat
files
>> uploaded successfully? Please let me know if you need a copy of the
.stat
>> output for both instances and I’ll be happy to provide them.
>>
>> Many thanks!
>>
>> -Brian
>> —————————————————————
>> Brian Matilla
>> Research Fellow— Warn-on-Forecast Team
>> Cooperative Institute for Mesoscale Meteorological Studies — The
>> University of Oklahoma
>> NOAA National Severe Storms Laboratory
>>
>>
>>
>
------------------------------------------------
Subject: METviewer- upload FBIAS=1 .stat issue
From: John Halley Gotway
Time: Tue Mar 03 12:24:30 2020
Brian,
Thanks for sending the sample data. I don't see any issues in these
output
files. I ran the following stat_analysis job on the grid_stat data
you
sent. I suspect there's just a little confusion about the output
options
from grid_stat.
*met-8.1.1/bin/stat_analysis \*
*-lookin grid_stat_FV3_PCP_010000L_20190520_190000V.stat \*
*-job aggregate -line_type CTC -by obs_thresh \*
*-out_stat agg_CTC.stat -out agg_CTC.out*
So this jobs reads all the lines from the input .stat file. For the
CTC
lines it finds, it aggregates them together, but separately for each
value
found in the OBS_THRESH column.
You'll notice that I'm using two output options:
*-out_stat* writes full .stat output lines to a file named
*agg_CTC.stat*.
This data can be loaded into METviewer.
*-out* writes more concise, human-readable output to a file named
*agg_CTC.out.* This data CANNOT be loaded into METviewer.
If that doesn't explain this behavior, please send me the
stat_analysis job
that is problematic.
Thanks,
John
On Tue, Mar 3, 2020 at 10:08 AM Brian Matilla - NOAA Affiliate via RT
<
met_help at ucar.edu> wrote:
>
> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=94383 >
>
> Hi John,
>
> Sure thing. I’ve attached a grid_stat file and a stat_analysis file
so
> that you can try both if you need them.
>
> -Brian
>
>
>
> > On Mar 3, 2020, at 10:45 AM, John Halley Gotway via RT <
> met_help at ucar.edu> wrote:
> >
> > Brian,
> >
> > Could you please send me one of those .stat files that resulted in
an
> error
> > from stat_analysis when trying to read it? The first thing I want
to
> check
> > is whether the column alignment is messed up. The columns are
separated
> by
> > whitespace. So even though they may be lined up nicely for a
human to
> > read, an empty string (too few columns) or embedded whitespace
(too many
> > columns) would cause a parsing error.
> >
> > We have several checks in MET to prevent embedded whitespace and
empty
> > strings, but perhaps we missed one? If so, I'd like to figure out
where
> > and add it for the next release.
> >
> > Of course, the problem could be something else entirely.
> >
> > Thanks,
> > John Halley Gotway
> >
> > On Tue, Mar 3, 2020 at 7:53 AM Brian Matilla - NOAA Affiliate via
RT <
> > met_help at ucar.edu> wrote:
> >
> >>
> >> Tue Mar 03 07:53:24 2020: Request 94383 was acted upon.
> >> Transaction: Ticket created by brian.matilla at noaa.gov
> >> Queue: met_help
> >> Subject: METviewer- upload FBIAS=1 .stat issue
> >> Owner: Nobody
> >> Requestors: brian.matilla at noaa.gov
> >> Status: new
> >> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=94383 >
> >>
> >>
> >> Hi again,
> >>
> >> I wanted to bring up an issue I encountered while running
METviewer
> >> version 2.11. I have output for grid_stat-generated data that
specifies
> a
> >> forecast threshold of “FBIAS=1” and wanted to plot some of the
> statistics
> >> with that data. However, when uploading the .stat files to our
local
> >> mariadb database, I’ll get the following error message:
> >>
> >> 2020-03-02
> >>
>
edu.ucar.metviewer.db.mysql.MysqlLoadDatabaseManager.executeBatch(Unknown
> >> Source) -1 executeBatch - Could not set parameter at position 13
(values
> >> was '-9999.0')
> >> Query - conn:336(M) - "INSERT INTO line_data_perc VALUES
> >> (?,?,?,?,?,?,?,?,?,?,?,?)"
> >> 2020-03-02 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main
- **
> >> ERROR: caught class edu.ucar.metviewer.DatabaseException in
> processFile()
> >> caught SQLException calling executeBatch: Could not set parameter
at
> >> position 13 (values was '-9999.0’)
> >>
> >> So then I tried to process the grid_stat data with the
stat_analysis
> tool
> >> and create .stat files from there. I then received the following
message
> >> when uploading the stat_analysis-created .stat files:
> >>
> >> ** WARNING: unexpected line type: NA the line will be ignored
> >>
> >> Both of these attempts yielded zero lines being read into the
database.
> Is
> >> there a workaround that I should try so that I can get the .stat
files
> >> uploaded successfully? Please let me know if you need a copy of
the
> .stat
> >> output for both instances and I’ll be happy to provide them.
> >>
> >> Many thanks!
> >>
> >> -Brian
> >> —————————————————————
> >> Brian Matilla
> >> Research Fellow— Warn-on-Forecast Team
> >> Cooperative Institute for Mesoscale Meteorological Studies — The
> >> University of Oklahoma
> >> NOAA National Severe Storms Laboratory
> >>
> >>
> >>
> >
>
>
> Hi John,
>
> Sure thing. I’ve attached a grid_stat file and a stat_analysis file
so
> that you can try both if you need them.
>
> -Brian
>
>
>
> On Mar 3, 2020, at 10:45 AM, John Halley Gotway via RT
<met_help at ucar.edu>
> wrote:
>
> Brian,
>
> Could you please send me one of those .stat files that resulted in
an error
> from stat_analysis when trying to read it? The first thing I want
to check
> is whether the column alignment is messed up. The columns are
separated by
> whitespace. So even though they may be lined up nicely for a human
to
> read, an empty string (too few columns) or embedded whitespace (too
many
> columns) would cause a parsing error.
>
> We have several checks in MET to prevent embedded whitespace and
empty
> strings, but perhaps we missed one? If so, I'd like to figure out
where
> and add it for the next release.
>
> Of course, the problem could be something else entirely.
>
> Thanks,
> John Halley Gotway
>
> On Tue, Mar 3, 2020 at 7:53 AM Brian Matilla - NOAA Affiliate via RT
<
> met_help at ucar.edu> wrote:
>
>
> Tue Mar 03 07:53:24 2020: Request 94383 was acted upon.
> Transaction: Ticket created by brian.matilla at noaa.gov
> Queue: met_help
> Subject: METviewer- upload FBIAS=1 .stat issue
> Owner: Nobody
> Requestors: brian.matilla at noaa.gov
> Status: new
> Ticket <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=94383
>
>
>
> Hi again,
>
> I wanted to bring up an issue I encountered while running METviewer
> version 2.11. I have output for grid_stat-generated data that
specifies a
> forecast threshold of “FBIAS=1” and wanted to plot some of the
statistics
> with that data. However, when uploading the .stat files to our local
> mariadb database, I’ll get the following error message:
>
> 2020-03-02
>
edu.ucar.metviewer.db.mysql.MysqlLoadDatabaseManager.executeBatch(Unknown
> Source) -1 executeBatch - Could not set parameter at position 13
(values
> was '-9999.0')
> Query - conn:336(M) - "INSERT INTO line_data_perc VALUES
> (?,?,?,?,?,?,?,?,?,?,?,?)"
> 2020-03-02 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main -
**
> ERROR: caught class edu.ucar.metviewer.DatabaseException in
processFile()
> caught SQLException calling executeBatch: Could not set parameter at
> position 13 (values was '-9999.0’)
>
> So then I tried to process the grid_stat data with the stat_analysis
tool
> and create .stat files from there. I then received the following
message
> when uploading the stat_analysis-created .stat files:
>
> ** WARNING: unexpected line type: NA the line will be ignored
>
> Both of these attempts yielded zero lines being read into the
database. Is
> there a workaround that I should try so that I can get the .stat
files
> uploaded successfully? Please let me know if you need a copy of the
.stat
> output for both instances and I’ll be happy to provide them.
>
> Many thanks!
>
> -Brian
> —————————————————————
> Brian Matilla
> Research Fellow— Warn-on-Forecast Team
> Cooperative Institute for Mesoscale Meteorological Studies — The
> University of Oklahoma
> NOAA National Severe Storms Laboratory
>
>
>
>
>
>
------------------------------------------------
Subject: METviewer- upload FBIAS=1 .stat issue
From: Brian Matilla - NOAA Affiliate
Time: Thu Mar 05 11:31:31 2020
Hi John,
Looks like your advice with the stat_analysis command worked. I
originally set my command to contain the “-out” flag instead of the “-
out_stat” flag which explains why the problem was occurring. I can now
feed the data through to METviewer and obtain plots without an issue.
I took a bit more time to write back just to make sure things were
working correctly and catch if something else happened that I should
bring up but that looks to be resolved. Thanks very much for looking
into this!
There’s another unrelated question I have regarding MET 9.0 beta 3 but
I’ll raise that in a separate ticket to keep topics aligned...
-Brian
—————————————————————
Brian Matilla
Research Fellow— Warn-on-Forecast Team
Cooperative Institute for Mesoscale Meteorological Studies — The
University of Oklahoma
NOAA National Severe Storms Laboratory
Phone: (405) 325-1688
> On Mar 3, 2020, at 1:24 PM, John Halley Gotway via RT
<met_help at ucar.edu> wrote:
>
> Brian,
>
> Thanks for sending the sample data. I don't see any issues in these
output
> files. I ran the following stat_analysis job on the grid_stat data
you
> sent. I suspect there's just a little confusion about the output
options
> from grid_stat.
>
> *met-8.1.1/bin/stat_analysis \*
>
> *-lookin grid_stat_FV3_PCP_010000L_20190520_190000V.stat \*
>
> *-job aggregate -line_type CTC -by obs_thresh \*
>
> *-out_stat agg_CTC.stat -out agg_CTC.out*
>
>
> So this jobs reads all the lines from the input .stat file. For the
CTC
> lines it finds, it aggregates them together, but separately for each
value
> found in the OBS_THRESH column.
>
>
> You'll notice that I'm using two output options:
> *-out_stat* writes full .stat output lines to a file named
*agg_CTC.stat*.
> This data can be loaded into METviewer.
> *-out* writes more concise, human-readable output to a file named
> *agg_CTC.out.* This data CANNOT be loaded into METviewer.
>
> If that doesn't explain this behavior, please send me the
stat_analysis job
> that is problematic.
>
> Thanks,
> John
>
> On Tue, Mar 3, 2020 at 10:08 AM Brian Matilla - NOAA Affiliate via
RT <
> met_help at ucar.edu> wrote:
>
>>
>> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=94383 >
>>
>> Hi John,
>>
>> Sure thing. I’ve attached a grid_stat file and a stat_analysis file
so
>> that you can try both if you need them.
>>
>> -Brian
>>
>>
>>
>>> On Mar 3, 2020, at 10:45 AM, John Halley Gotway via RT <
>> met_help at ucar.edu> wrote:
>>>
>>> Brian,
>>>
>>> Could you please send me one of those .stat files that resulted in
an
>> error
>>> from stat_analysis when trying to read it? The first thing I want
to
>> check
>>> is whether the column alignment is messed up. The columns are
separated
>> by
>>> whitespace. So even though they may be lined up nicely for a
human to
>>> read, an empty string (too few columns) or embedded whitespace
(too many
>>> columns) would cause a parsing error.
>>>
>>> We have several checks in MET to prevent embedded whitespace and
empty
>>> strings, but perhaps we missed one? If so, I'd like to figure out
where
>>> and add it for the next release.
>>>
>>> Of course, the problem could be something else entirely.
>>>
>>> Thanks,
>>> John Halley Gotway
>>>
>>> On Tue, Mar 3, 2020 at 7:53 AM Brian Matilla - NOAA Affiliate via
RT <
>>> met_help at ucar.edu> wrote:
>>>
>>>>
>>>> Tue Mar 03 07:53:24 2020: Request 94383 was acted upon.
>>>> Transaction: Ticket created by brian.matilla at noaa.gov
>>>> Queue: met_help
>>>> Subject: METviewer- upload FBIAS=1 .stat issue
>>>> Owner: Nobody
>>>> Requestors: brian.matilla at noaa.gov
>>>> Status: new
>>>> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=94383 >
>>>>
>>>>
>>>> Hi again,
>>>>
>>>> I wanted to bring up an issue I encountered while running
METviewer
>>>> version 2.11. I have output for grid_stat-generated data that
specifies
>> a
>>>> forecast threshold of “FBIAS=1” and wanted to plot some of the
>> statistics
>>>> with that data. However, when uploading the .stat files to our
local
>>>> mariadb database, I’ll get the following error message:
>>>>
>>>> 2020-03-02
>>>>
>>
edu.ucar.metviewer.db.mysql.MysqlLoadDatabaseManager.executeBatch(Unknown
>>>> Source) -1 executeBatch - Could not set parameter at position 13
(values
>>>> was '-9999.0')
>>>> Query - conn:336(M) - "INSERT INTO line_data_perc VALUES
>>>> (?,?,?,?,?,?,?,?,?,?,?,?)"
>>>> 2020-03-02 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main
- **
>>>> ERROR: caught class edu.ucar.metviewer.DatabaseException in
>> processFile()
>>>> caught SQLException calling executeBatch: Could not set parameter
at
>>>> position 13 (values was '-9999.0’)
>>>>
>>>> So then I tried to process the grid_stat data with the
stat_analysis
>> tool
>>>> and create .stat files from there. I then received the following
message
>>>> when uploading the stat_analysis-created .stat files:
>>>>
>>>> ** WARNING: unexpected line type: NA the line will be ignored
>>>>
>>>> Both of these attempts yielded zero lines being read into the
database.
>> Is
>>>> there a workaround that I should try so that I can get the .stat
files
>>>> uploaded successfully? Please let me know if you need a copy of
the
>> .stat
>>>> output for both instances and I’ll be happy to provide them.
>>>>
>>>> Many thanks!
>>>>
>>>> -Brian
>>>> —————————————————————
>>>> Brian Matilla
>>>> Research Fellow— Warn-on-Forecast Team
>>>> Cooperative Institute for Mesoscale Meteorological Studies — The
>>>> University of Oklahoma
>>>> NOAA National Severe Storms Laboratory
>>>>
>>>>
>>>>
>>>
>>
>>
>> Hi John,
>>
>> Sure thing. I’ve attached a grid_stat file and a stat_analysis file
so
>> that you can try both if you need them.
>>
>> -Brian
>>
>>
>>
>> On Mar 3, 2020, at 10:45 AM, John Halley Gotway via RT
<met_help at ucar.edu>
>> wrote:
>>
>> Brian,
>>
>> Could you please send me one of those .stat files that resulted in
an error
>> from stat_analysis when trying to read it? The first thing I want
to check
>> is whether the column alignment is messed up. The columns are
separated by
>> whitespace. So even though they may be lined up nicely for a human
to
>> read, an empty string (too few columns) or embedded whitespace (too
many
>> columns) would cause a parsing error.
>>
>> We have several checks in MET to prevent embedded whitespace and
empty
>> strings, but perhaps we missed one? If so, I'd like to figure out
where
>> and add it for the next release.
>>
>> Of course, the problem could be something else entirely.
>>
>> Thanks,
>> John Halley Gotway
>>
>> On Tue, Mar 3, 2020 at 7:53 AM Brian Matilla - NOAA Affiliate via
RT <
>> met_help at ucar.edu> wrote:
>>
>>
>> Tue Mar 03 07:53:24 2020: Request 94383 was acted upon.
>> Transaction: Ticket created by brian.matilla at noaa.gov
>> Queue: met_help
>> Subject: METviewer- upload FBIAS=1 .stat issue
>> Owner: Nobody
>> Requestors: brian.matilla at noaa.gov
>> Status: new
>> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=94383 >
>>
>>
>> Hi again,
>>
>> I wanted to bring up an issue I encountered while running METviewer
>> version 2.11. I have output for grid_stat-generated data that
specifies a
>> forecast threshold of “FBIAS=1” and wanted to plot some of the
statistics
>> with that data. However, when uploading the .stat files to our
local
>> mariadb database, I’ll get the following error message:
>>
>> 2020-03-02
>>
edu.ucar.metviewer.db.mysql.MysqlLoadDatabaseManager.executeBatch(Unknown
>> Source) -1 executeBatch - Could not set parameter at position 13
(values
>> was '-9999.0')
>> Query - conn:336(M) - "INSERT INTO line_data_perc VALUES
>> (?,?,?,?,?,?,?,?,?,?,?,?)"
>> 2020-03-02 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main -
**
>> ERROR: caught class edu.ucar.metviewer.DatabaseException in
processFile()
>> caught SQLException calling executeBatch: Could not set parameter
at
>> position 13 (values was '-9999.0’)
>>
>> So then I tried to process the grid_stat data with the
stat_analysis tool
>> and create .stat files from there. I then received the following
message
>> when uploading the stat_analysis-created .stat files:
>>
>> ** WARNING: unexpected line type: NA the line will be ignored
>>
>> Both of these attempts yielded zero lines being read into the
database. Is
>> there a workaround that I should try so that I can get the .stat
files
>> uploaded successfully? Please let me know if you need a copy of the
.stat
>> output for both instances and I’ll be happy to provide them.
>>
>> Many thanks!
>>
>> -Brian
>> —————————————————————
>> Brian Matilla
>> Research Fellow— Warn-on-Forecast Team
>> Cooperative Institute for Mesoscale Meteorological Studies — The
>> University of Oklahoma
>> NOAA National Severe Storms Laboratory
>>
>>
>>
>>
>>
>>
>
------------------------------------------------
More information about the Met_help
mailing list