[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