[Met_help] [rt.rap.ucar.edu #83285] History for MetViewer loading error messages

[Tatiana Burek via RT]

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

Hello.  I'm getting some error messages when loading VSDBs into an 
existing database on MetViewer:

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

18:03:25 ERROR DROP INDEX line_data_grad_fcst_lead_idx ON line_data_grad ;
18:03:25 ERROR   **  ERROR: caught class java.lang.Exception applying 
index line
_data_grad_fcst_lead_idx: caught SQLException calling executeUpdate: 
Can't DROP
'line_data_grad_fcst_lead_idx'; check that column/key exists

     ....

18:12:21 ERROR CREATE INDEX line_data_ctc_fcst_valid_beg_idx ON 
line_data_ctc (f
cst_valid_beg);
18:12:21 ERROR   **  ERROR: caught class java.lang.Exception applying 
index line
_data_ctc_fcst_valid_beg_idx: caught SQLException calling executeUpdate: 
Communi
cations link failure

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

This is what I did to load the data:

cd /metviewer/staging/wd22yl/
  /usr1/metviewer/metviewer/bin/mv_load.sh load_late.xml > 
out.load/loadlog.20171212_mv_ylin_pcp

Should I have done this differently?   Does the load script 
(/metviewer/staging/wd22yl/load_late.xml) need updating?

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: MetViewer loading error messages
From: Tatiana Burek
Time: Tue Dec 12 14:41:02 2017

Ying,

These messages are warning messages.
You data should be loaded successfully and ready to use.

Tatiana
On Tue Dec 12 12:25:40 2017, ying.lin at noaa.gov wrote:
> Hello.  I'm getting some error messages when loading VSDBs into an
> existing database on MetViewer:
>
>
----------------------------------------------------------------------------------------
>
> 18:03:25 ERROR DROP INDEX line_data_grad_fcst_lead_idx ON
> line_data_grad ;
>  18:03:25 ERROR   **  ERROR: caught class java.lang.Exception
applying
> index line
>  _data_grad_fcst_lead_idx: caught SQLException calling
executeUpdate:
> Can't DROP
> 'line_data_grad_fcst_lead_idx'; check that column/key exists
>
>     ....
>
> 18:12:21 ERROR CREATE INDEX line_data_ctc_fcst_valid_beg_idx ON
> line_data_ctc (f
> cst_valid_beg);
> 18:12:21 ERROR   **  ERROR: caught class java.lang.Exception
applying
> index line
> _data_ctc_fcst_valid_beg_idx: caught SQLException calling
> executeUpdate:
> Communi
> cations link failure
>
>
----------------------------------------------------------------------------------------
>
> This is what I did to load the data:
>
> cd /metviewer/staging/wd22yl/
>    /usr1/metviewer/metviewer/bin/mv_load.sh load_late.xml >
> out.load/loadlog.20171212_mv_ylin_pcp
>
> Should I have done this differently?   Does the load script
> (/metviewer/staging/wd22yl/load_late.xml) need updating?
>
> Ying



------------------------------------------------
Subject: Re: [rt.rap.ucar.edu #83285] MetViewer loading error messages
From: Ying Lin
Time: Tue Dec 12 16:50:31 2017

Hi Tatiana,

Good to know.  Thank you very much -

Ying

On 12/12/2017 04:41 PM, Tatiana Burek via RT wrote:
> Ying,
>
> These messages are warning messages.
> You data should be loaded successfully and ready to use.
>
> Tatiana
> On Tue Dec 12 12:25:40 2017, ying.lin at noaa.gov wrote:
>> Hello.  I'm getting some error messages when loading VSDBs into an
>> existing database on MetViewer:
>>
>>
----------------------------------------------------------------------------------------
>>
>> 18:03:25 ERROR DROP INDEX line_data_grad_fcst_lead_idx ON
>> line_data_grad ;
>>   18:03:25 ERROR   **  ERROR: caught class java.lang.Exception
applying
>> index line
>>   _data_grad_fcst_lead_idx: caught SQLException calling
executeUpdate:
>> Can't DROP
>> 'line_data_grad_fcst_lead_idx'; check that column/key exists
>>
>>      ....
>>
>> 18:12:21 ERROR CREATE INDEX line_data_ctc_fcst_valid_beg_idx ON
>> line_data_ctc (f
>> cst_valid_beg);
>> 18:12:21 ERROR   **  ERROR: caught class java.lang.Exception
applying
>> index line
>> _data_ctc_fcst_valid_beg_idx: caught SQLException calling
>> executeUpdate:
>> Communi
>> cations link failure
>>
>>
----------------------------------------------------------------------------------------
>>
>> This is what I did to load the data:
>>
>> cd /metviewer/staging/wd22yl/
>>     /usr1/metviewer/metviewer/bin/mv_load.sh load_late.xml >
>> out.load/loadlog.20171212_mv_ylin_pcp
>>
>> Should I have done this differently?   Does the load script
>> (/metviewer/staging/wd22yl/load_late.xml) need updating?
>>
>> Ying
>
>

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



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