[Met_help] [rt.rap.ucar.edu #84590] History for two metviewer VSDB load errors
John Halley Gotway via RT
met_help at ucar.edu
Wed Jul 10 16:43:16 MDT 2019
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
Hello. I'm loading VSDB files to the NCEP metviewer server and run into
two error messages, hope you can help:
1. DROP INDEX mtd_header_fcst_init_idx ON mtd_header ;
** ERROR: caught class java.lang.Exception applying index
mtd_header_fcst_init_idx: caught SQLException calling executeUpdate:
Can't DROP 'mtd_header_fcst_init_idx'; check that column/key exists
2. (when loading an HREF VSDB file):
/metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
** ERROR: caught class java.lang.Exception in processFile()
caught SQLException calling executeBatch: Column count doesn't match
value count at row 1
** WARNING: error(s) encountered loading file
/metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb - skipping file
java.lang.Exception: caught SQLException calling executeBatch:
Column count doesn't match value count at row 1
The load script is at /metviewer/staging/wd22yl/mv_load.sh and the load
output is at /metviewer/staging/wd22yl/out.load/loadlog.20180329_mv_ylin_pcp
The VSDB file in question for No. 2 above is at
/metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
[cc'ing Binbin for #2 above since I don't know enough about HREF]
Thanks -
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: two metviewer VSDB load errors
From: Tatiana Burek
Time: Thu Mar 29 15:32:01 2018
Ying,
I fixed the issue that caused the 'Column count doesn't match' error.
Could you rerun your script to see if it works.
Tatiana
On Thu Mar 29 13:17:43 2018, ying.lin at noaa.gov wrote:
> Hello. I'm loading VSDB files to the NCEP metviewer server and run
into
> two error messages, hope you can help:
>
> 1. DROP INDEX mtd_header_fcst_init_idx ON mtd_header ;
> ** ERROR: caught class java.lang.Exception applying index
> mtd_header_fcst_init_idx: caught SQLException calling
executeUpdate:
> Can't DROP 'mtd_header_fcst_init_idx'; check that column/key
exists
> 2. (when loading an HREF VSDB file):
> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
> ** ERROR: caught class java.lang.Exception in processFile()
> caught SQLException calling executeBatch: Column count doesn't
match
> value count at row 1
> ** WARNING: error(s) encountered loading file
> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb -
skipping file
> java.lang.Exception: caught SQLException calling executeBatch:
> Column count doesn't match value count at row 1
>
> The load script is at /metviewer/staging/wd22yl/mv_load.sh and the
load
> output is at
/metviewer/staging/wd22yl/out.load/loadlog.20180329_mv_ylin_pcp
>
> The VSDB file in question for No. 2 above is at
> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
>
> [cc'ing Binbin for #2 above since I don't know enough about HREF]
>
> Thanks -
>
> Ying
>
------------------------------------------------
Subject: Re: [rt.rap.ucar.edu #84590] two metviewer VSDB load errors
From: Ying Lin
Time: Thu Mar 29 17:43:48 2018
Thanks Tatiana. I tried loading the same vsdb file to the database
(thinking that "skipping file" meant it didn't get loaded at all) and
got a "** WARNING: file already present in table data_file" and the
same err msg as below. Loading that single file took 56 minutes ...
I'll load a fresh HREF vsdb tomorrow to verify that it works.
Ying
On 03/29/2018 05:32 PM, Tatiana Burek via RT wrote:
> Ying,
> I fixed the issue that caused the 'Column count doesn't match'
error.
> Could you rerun your script to see if it works.
>
> Tatiana
>
> On Thu Mar 29 13:17:43 2018, ying.lin at noaa.gov wrote:
>> Hello. I'm loading VSDB files to the NCEP metviewer server and run
into
>> two error messages, hope you can help:
>>
>> 1. DROP INDEX mtd_header_fcst_init_idx ON mtd_header ;
>> ** ERROR: caught class java.lang.Exception applying index
>> mtd_header_fcst_init_idx: caught SQLException calling
executeUpdate:
>> Can't DROP 'mtd_header_fcst_init_idx'; check that column/key
exists
>> 2. (when loading an HREF VSDB file):
>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
>> ** ERROR: caught class java.lang.Exception in
processFile()
>> caught SQLException calling executeBatch: Column count doesn't
match
>> value count at row 1
>> ** WARNING: error(s) encountered loading file
>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb -
skipping file
>> java.lang.Exception: caught SQLException calling executeBatch:
>> Column count doesn't match value count at row 1
>>
>> The load script is at /metviewer/staging/wd22yl/mv_load.sh and the
load
>> output is at
/metviewer/staging/wd22yl/out.load/loadlog.20180329_mv_ylin_pcp
>>
>> The VSDB file in question for No. 2 above is at
>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
>>
>> [cc'ing Binbin for #2 above since I don't know enough about HREF]
>>
>> Thanks -
>>
>> Ying
>>
>
>
--
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov
------------------------------------------------
Subject: two metviewer VSDB load errors
From: Ying Lin
Time: Fri Mar 30 11:04:55 2018
Hi Tatiana,
I tried loading a new vsdb file
(/metviewer/staging/wd22yl/vsdb/href/href_20180321.vsdb) to the
existing
database, mv_ylin_pcp, and still got the same error message.
Load script: /metviewer/staging/wd22yl/load_late.xml (I gave the
wrong file name in the initial email inquiry)
Load output:
/metviewer/staging/wd22yl/out.load/loadlog.20180330_mv_ylin_pcp
In addition to the above, and error #1 as in my initial inquiry,
I'm also getting an additional err msg this time round:
DROP INDEX line_data_nbrcnt_fcst_lead_idx ON line_data_nbrcnt ;
** ERROR: caught class java.lang.Exception applying index
line_data_nbrcnt_fcst_lead_idx: caught SQLException calling
executeUpdate: Communications link failure
Next tried loading the same href_20180321.vsdb to a brand new
database mv_ylin_test, and still got the same error message (#2 in the
initial email inquiry).
Load script for this:
/metviewer/staging/wd22yl/load_test_new_database_test.xml
Load output:
/metviewer/staging/wd22yl/out.load/loadlog.20180330.test
Thanks again,
Ying
On 03/29/2018 07:43 PM, Ying Lin wrote:
> Thanks Tatiana. I tried loading the same vsdb file to the database
> (thinking that "skipping file" meant it didn't get loaded at all)
and
> got a "** WARNING: file already present in table data_file" and
the
> same err msg as below. Loading that single file took 56 minutes ...
> I'll load a fresh HREF vsdb tomorrow to verify that it works.
>
> Ying
>
> On 03/29/2018 05:32 PM, Tatiana Burek via RT wrote:
>> Ying,
>> I fixed the issue that caused the 'Column count doesn't match'
error.
>> Could you rerun your script to see if it works.
>>
>> Tatiana
>>
>> On Thu Mar 29 13:17:43 2018, ying.lin at noaa.gov wrote:
>>> Hello. I'm loading VSDB files to the NCEP metviewer server and
run
>>> into
>>> two error messages, hope you can help:
>>>
>>> 1. DROP INDEX mtd_header_fcst_init_idx ON mtd_header ;
>>> ** ERROR: caught class java.lang.Exception applying index
>>> mtd_header_fcst_init_idx: caught SQLException calling
>>> executeUpdate:
>>> Can't DROP 'mtd_header_fcst_init_idx'; check that column/key
>>> exists
>>> 2. (when loading an HREF VSDB file):
>>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
>>> ** ERROR: caught class java.lang.Exception in
processFile()
>>> caught SQLException calling executeBatch: Column count
doesn't
>>> match
>>> value count at row 1
>>> ** WARNING: error(s) encountered loading file
>>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb -
>>> skipping file
>>> java.lang.Exception: caught SQLException calling
executeBatch:
>>> Column count doesn't match value count at row 1
>>>
>>> The load script is at /metviewer/staging/wd22yl/mv_load.sh and the
load
>>> output is at
>>> /metviewer/staging/wd22yl/out.load/loadlog.20180329_mv_ylin_pcp
>>>
>>> The VSDB file in question for No. 2 above is at
>>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
>>>
>>> [cc'ing Binbin for #2 above since I don't know enough about HREF]
>>>
>>> Thanks -
>>>
>>> Ying
>>>
>>
>>
>
--
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov
------------------------------------------------
Subject: two metviewer VSDB load errors
From: Tatiana Burek
Time: Fri Mar 30 12:36:23 2018
Ying,
I changed <drop_indexes> value from false to true and rerun your
load_test_new_database_test.xml. It finished without errors and loaded
data
from
/metviewer/staging/wd22yl/vsdb/href/href_20180321.vsdb
to the database.
I started loading with /metviewer/staging/wd22yl/load_late.xml and
logging in
/usr1/metviewer/test_load.log.
It finished successfully with some indexing errors that should not be
a
concern for your data.
This database is large so indexing takes a long time.
Tatiana
On Fri, Mar 30, 2018 at 11:04 AM, Ying Lin via RT <met_help at ucar.edu>
wrote:
>
> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=84590 >
>
> Hi Tatiana,
>
> I tried loading a new vsdb file
> (/metviewer/staging/wd22yl/vsdb/href/href_20180321.vsdb) to the
existing
> database, mv_ylin_pcp, and still got the same error message.
> Load script: /metviewer/staging/wd22yl/load_late.xml (I gave
the
> wrong file name in the initial email inquiry)
> Load output:
> /metviewer/staging/wd22yl/out.load/loadlog.20180330_mv_ylin_pcp
> In addition to the above, and error #1 as in my initial
inquiry,
> I'm also getting an additional err msg this time round:
> DROP INDEX line_data_nbrcnt_fcst_lead_idx ON line_data_nbrcnt ;
> ** ERROR: caught class java.lang.Exception applying index
> line_data_nbrcnt_fcst_lead_idx: caught SQLException calling
> executeUpdate: Communications link failure
>
>
> Next tried loading the same href_20180321.vsdb to a brand new
> database mv_ylin_test, and still got the same error message (#2 in
the
> initial email inquiry).
> Load script for this:
> /metviewer/staging/wd22yl/load_test_new_database_test.xml
> Load output:
/metviewer/staging/wd22yl/out.load/loadlog.20180330.test
>
> Thanks again,
>
> Ying
>
> On 03/29/2018 07:43 PM, Ying Lin wrote:
> > Thanks Tatiana. I tried loading the same vsdb file to the
database
> > (thinking that "skipping file" meant it didn't get loaded at all)
and
> > got a "** WARNING: file already present in table data_file" and
the
> > same err msg as below. Loading that single file took 56 minutes
...
> > I'll load a fresh HREF vsdb tomorrow to verify that it works.
> >
> > Ying
> >
> > On 03/29/2018 05:32 PM, Tatiana Burek via RT wrote:
> >> Ying,
> >> I fixed the issue that caused the 'Column count doesn't match'
error.
> >> Could you rerun your script to see if it works.
> >>
> >> Tatiana
> >>
> >> On Thu Mar 29 13:17:43 2018, ying.lin at noaa.gov wrote:
> >>> Hello. I'm loading VSDB files to the NCEP metviewer server and
run
> >>> into
> >>> two error messages, hope you can help:
> >>>
> >>> 1. DROP INDEX mtd_header_fcst_init_idx ON mtd_header ;
> >>> ** ERROR: caught class java.lang.Exception applying
index
> >>> mtd_header_fcst_init_idx: caught SQLException calling
> >>> executeUpdate:
> >>> Can't DROP 'mtd_header_fcst_init_idx'; check that
column/key
> >>> exists
> >>> 2. (when loading an HREF VSDB file):
> >>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
> >>> ** ERROR: caught class java.lang.Exception in
processFile()
> >>> caught SQLException calling executeBatch: Column count
doesn't
> >>> match
> >>> value count at row 1
> >>> ** WARNING: error(s) encountered loading file
> >>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb -
> >>> skipping file
> >>> java.lang.Exception: caught SQLException calling
executeBatch:
> >>> Column count doesn't match value count at row 1
> >>>
> >>> The load script is at /metviewer/staging/wd22yl/mv_load.sh and
the
> load
> >>> output is at
> >>> /metviewer/staging/wd22yl/out.load/loadlog.20180329_mv_ylin_pcp
> >>>
> >>> The VSDB file in question for No. 2 above is at
> >>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
> >>>
> >>> [cc'ing Binbin for #2 above since I don't know enough about
HREF]
> >>>
> >>> Thanks -
> >>>
> >>> Ying
> >>>
> >>
> >>
> >
>
> --
> Ying Lin
> NCEP/EMC/Verification, Post-processing and Product Generation Branch
> NCWCP Cubicle No. 2015
> Ying.Lin at noaa.gov
>
>
>
>
------------------------------------------------
Subject: Re: [rt.rap.ucar.edu #84590] two metviewer VSDB load errors
From: Ying Lin
Time: Fri Mar 30 19:28:55 2018
Thanks Tatiana. I rerun the load to mv_ylin_test using
load_test_new_database_test.xml and did not see the "Column count
doesn't match" error for HREF, as you said. Thinking that it might
have something to do with href_20180321.vsdb being already present in
table data file, I loaded a fresh new href vsdb file to mv_ylin_test,
that also went in fine.
This is still puzzling. Next week I'll load a few new href vsdbs to
the
larger mv_ylin_pcp to see if the "Column count doesn't match" is no
longer a problem.
Thanks again. Have a great weekend.
Ying
On 03/30/2018 02:36 PM, Tatiana Burek via RT wrote:
> Ying,
> I changed <drop_indexes> value from false to true and rerun your
> load_test_new_database_test.xml. It finished without errors and
loaded data
> from
>
> /metviewer/staging/wd22yl/vsdb/href/href_20180321.vsdb
> to the database.
>
> I started loading with /metviewer/staging/wd22yl/load_late.xml and
> logging in
>
> /usr1/metviewer/test_load.log.
>
> It finished successfully with some indexing errors that should not
be a
> concern for your data.
>
> This database is large so indexing takes a long time.
>
> Tatiana
>
>
>
> On Fri, Mar 30, 2018 at 11:04 AM, Ying Lin via RT
<met_help at ucar.edu> wrote:
>
>> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=84590 >
>>
>> Hi Tatiana,
>>
>> I tried loading a new vsdb file
>> (/metviewer/staging/wd22yl/vsdb/href/href_20180321.vsdb) to the
existing
>> database, mv_ylin_pcp, and still got the same error message.
>> Load script: /metviewer/staging/wd22yl/load_late.xml (I gave
the
>> wrong file name in the initial email inquiry)
>> Load output:
>> /metviewer/staging/wd22yl/out.load/loadlog.20180330_mv_ylin_pcp
>> In addition to the above, and error #1 as in my initial
inquiry,
>> I'm also getting an additional err msg this time round:
>> DROP INDEX line_data_nbrcnt_fcst_lead_idx ON line_data_nbrcnt
;
>> ** ERROR: caught class java.lang.Exception applying index
>> line_data_nbrcnt_fcst_lead_idx: caught SQLException calling
>> executeUpdate: Communications link failure
>>
>>
>> Next tried loading the same href_20180321.vsdb to a brand new
>> database mv_ylin_test, and still got the same error message (#2 in
the
>> initial email inquiry).
>> Load script for this:
>> /metviewer/staging/wd22yl/load_test_new_database_test.xml
>> Load output:
/metviewer/staging/wd22yl/out.load/loadlog.20180330.test
>>
>> Thanks again,
>>
>> Ying
>>
>> On 03/29/2018 07:43 PM, Ying Lin wrote:
>>> Thanks Tatiana. I tried loading the same vsdb file to the
database
>>> (thinking that "skipping file" meant it didn't get loaded at all)
and
>>> got a "** WARNING: file already present in table data_file" and
the
>>> same err msg as below. Loading that single file took 56 minutes
...
>>> I'll load a fresh HREF vsdb tomorrow to verify that it works.
>>>
>>> Ying
>>>
>>> On 03/29/2018 05:32 PM, Tatiana Burek via RT wrote:
>>>> Ying,
>>>> I fixed the issue that caused the 'Column count doesn't match'
error.
>>>> Could you rerun your script to see if it works.
>>>>
>>>> Tatiana
>>>>
>>>> On Thu Mar 29 13:17:43 2018, ying.lin at noaa.gov wrote:
>>>>> Hello. I'm loading VSDB files to the NCEP metviewer server and
run
>>>>> into
>>>>> two error messages, hope you can help:
>>>>>
>>>>> 1. DROP INDEX mtd_header_fcst_init_idx ON mtd_header ;
>>>>> ** ERROR: caught class java.lang.Exception applying
index
>>>>> mtd_header_fcst_init_idx: caught SQLException calling
>>>>> executeUpdate:
>>>>> Can't DROP 'mtd_header_fcst_init_idx'; check that
column/key
>>>>> exists
>>>>> 2. (when loading an HREF VSDB file):
>>>>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
>>>>> ** ERROR: caught class java.lang.Exception in
processFile()
>>>>> caught SQLException calling executeBatch: Column count
doesn't
>>>>> match
>>>>> value count at row 1
>>>>> ** WARNING: error(s) encountered loading file
>>>>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb -
>>>>> skipping file
>>>>> java.lang.Exception: caught SQLException calling
executeBatch:
>>>>> Column count doesn't match value count at row 1
>>>>>
>>>>> The load script is at /metviewer/staging/wd22yl/mv_load.sh and
the
>> load
>>>>> output is at
>>>>> /metviewer/staging/wd22yl/out.load/loadlog.20180329_mv_ylin_pcp
>>>>>
>>>>> The VSDB file in question for No. 2 above is at
>>>>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
>>>>>
>>>>> [cc'ing Binbin for #2 above since I don't know enough about
HREF]
>>>>>
>>>>> Thanks -
>>>>>
>>>>> Ying
>>>>>
>>>>
>> --
>> Ying Lin
>> NCEP/EMC/Verification, Post-processing and Product Generation
Branch
>> NCWCP Cubicle No. 2015
>> Ying.Lin at noaa.gov
>>
>>
>>
>>
--
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov
------------------------------------------------
Subject: Re: [rt.rap.ucar.edu #84590] two metviewer VSDB load errors
From: Ying Lin
Time: Mon Apr 02 12:40:58 2018
Hi Tatiana,
Following up on this: I loaded some new VSDBs, including that for
HREF, to mv_ylin_pcp. There are some index errors no more "Column
count
doesn't match" error for HREF. Thanks!
Ying
On 03/30/2018 09:28 PM, Ying Lin wrote:
> Thanks Tatiana. I rerun the load to mv_ylin_test using
> load_test_new_database_test.xml and did not see the "Column count
> doesn't match" error for HREF, as you said. Thinking that it
might
> have something to do with href_20180321.vsdb being already present
in
> table data file, I loaded a fresh new href vsdb file to
mv_ylin_test,
> that also went in fine.
>
> This is still puzzling. Next week I'll load a few new href vsdbs to
> the larger mv_ylin_pcp to see if the "Column count doesn't match" is
> no longer a problem.
>
> Thanks again. Have a great weekend.
>
> Ying
>
> On 03/30/2018 02:36 PM, Tatiana Burek via RT wrote:
>> Ying,
>> I changed <drop_indexes> value from false to true and rerun your
>> load_test_new_database_test.xml. It finished without errors and
>> loaded data
>> from
>>
>> /metviewer/staging/wd22yl/vsdb/href/href_20180321.vsdb
>> to the database.
>>
>> I started loading with /metviewer/staging/wd22yl/load_late.xml
and
>> logging in
>>
>> /usr1/metviewer/test_load.log.
>>
>> It finished successfully with some indexing errors that should not
be a
>> concern for your data.
>>
>> This database is large so indexing takes a long time.
>>
>> Tatiana
>>
>>
>>
>> On Fri, Mar 30, 2018 at 11:04 AM, Ying Lin via RT
<met_help at ucar.edu>
>> wrote:
>>
>>> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=84590 >
>>>
>>> Hi Tatiana,
>>>
>>> I tried loading a new vsdb file
>>> (/metviewer/staging/wd22yl/vsdb/href/href_20180321.vsdb) to the
>>> existing
>>> database, mv_ylin_pcp, and still got the same error message.
>>> Load script: /metviewer/staging/wd22yl/load_late.xml (I gave
the
>>> wrong file name in the initial email inquiry)
>>> Load output:
>>> /metviewer/staging/wd22yl/out.load/loadlog.20180330_mv_ylin_pcp
>>> In addition to the above, and error #1 as in my initial
inquiry,
>>> I'm also getting an additional err msg this time round:
>>> DROP INDEX line_data_nbrcnt_fcst_lead_idx ON
line_data_nbrcnt ;
>>> ** ERROR: caught class java.lang.Exception applying index
>>> line_data_nbrcnt_fcst_lead_idx: caught SQLException calling
>>> executeUpdate: Communications link failure
>>>
>>>
>>> Next tried loading the same href_20180321.vsdb to a brand
new
>>> database mv_ylin_test, and still got the same error message (#2 in
the
>>> initial email inquiry).
>>> Load script for this:
>>> /metviewer/staging/wd22yl/load_test_new_database_test.xml
>>> Load output:
>>> /metviewer/staging/wd22yl/out.load/loadlog.20180330.test
>>>
>>> Thanks again,
>>>
>>> Ying
>>>
>>> On 03/29/2018 07:43 PM, Ying Lin wrote:
>>>> Thanks Tatiana. I tried loading the same vsdb file to the
database
>>>> (thinking that "skipping file" meant it didn't get loaded at all)
and
>>>> got a "** WARNING: file already present in table data_file" and
the
>>>> same err msg as below. Loading that single file took 56 minutes
...
>>>> I'll load a fresh HREF vsdb tomorrow to verify that it works.
>>>>
>>>> Ying
>>>>
>>>> On 03/29/2018 05:32 PM, Tatiana Burek via RT wrote:
>>>>> Ying,
>>>>> I fixed the issue that caused the 'Column count doesn't
match'
>>>>> error.
>>>>> Could you rerun your script to see if it works.
>>>>>
>>>>> Tatiana
>>>>>
>>>>> On Thu Mar 29 13:17:43 2018, ying.lin at noaa.gov wrote:
>>>>>> Hello. I'm loading VSDB files to the NCEP metviewer server and
run
>>>>>> into
>>>>>> two error messages, hope you can help:
>>>>>>
>>>>>> 1. DROP INDEX mtd_header_fcst_init_idx ON mtd_header ;
>>>>>> ** ERROR: caught class java.lang.Exception applying
index
>>>>>> mtd_header_fcst_init_idx: caught SQLException calling
>>>>>> executeUpdate:
>>>>>> Can't DROP 'mtd_header_fcst_init_idx'; check that
column/key
>>>>>> exists
>>>>>> 2. (when loading an HREF VSDB file):
>>>>>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
>>>>>> ** ERROR: caught class java.lang.Exception in
>>>>>> processFile()
>>>>>> caught SQLException calling executeBatch: Column count
doesn't
>>>>>> match
>>>>>> value count at row 1
>>>>>> ** WARNING: error(s) encountered loading file
>>>>>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb -
>>>>>> skipping file
>>>>>> java.lang.Exception: caught SQLException calling
executeBatch:
>>>>>> Column count doesn't match value count at row 1
>>>>>>
>>>>>> The load script is at /metviewer/staging/wd22yl/mv_load.sh and
the
>>> load
>>>>>> output is at
>>>>>> /metviewer/staging/wd22yl/out.load/loadlog.20180329_mv_ylin_pcp
>>>>>>
>>>>>> The VSDB file in question for No. 2 above is at
>>>>>> /metviewer/staging/wd22yl/vsdb/href/href_20180320.vsdb
>>>>>>
>>>>>> [cc'ing Binbin for #2 above since I don't know enough about
HREF]
>>>>>>
>>>>>> Thanks -
>>>>>>
>>>>>> Ying
>>>>>>
>>>>>
>>> --
>>> Ying Lin
>>> NCEP/EMC/Verification, Post-processing and Product Generation
Branch
>>> NCWCP Cubicle No. 2015
>>> Ying.Lin at noaa.gov
>>>
>>>
>>>
>>>
>
--
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov
------------------------------------------------
More information about the Met_help
mailing list