[MCOL-3338] Sporadic Internal error: TreeNode::getDecimalVal: decimal overflow is returned when execute query consecutively several times - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Won't Do
Affects Version/s: 1.2.4
Fix Version/s: Icebox
Component/s: ExeMgr
Labels:
None
Environment:
1UM-1PM ; mcs deployed on CentOS7

Description

Sporadic Internal error: TreeNode::getDecimalVal: decimal overflow is returned when execute query consecutively several times

note : that error was not observed before

Repeat several times
the query below against 1TB loaded tpc-ds schema .
It's returned Sporadically Internal error: TreeNode::getDecimalVal: decimal overflow

select i_item_id

      ,i_item_desc

      ,i_category

      ,i_class

      ,i_current_price

      ,sum(ss_ext_sales_price) as itemrevenue

      ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over

          (partition by i_class) as revenueratio

from

        store_sales

        ,item

        ,date_dim

where

        ss_item_sk = i_item_sk

        and i_category in ('Sports', 'Books', 'Home')

        and ss_sold_date_sk = d_date_sk

        and (d_date between cast('1999-02-22' as date)

                                and ADDDATE(cast('1999-02-22' as date),30))

group by

        i_item_id

        ,i_item_desc

        ,i_category

        ,i_class

        ,i_current_price

order by

        i_category

        ,i_class

        ,i_item_id

        ,i_item_desc

        ,revenueratio;

May 29 20:12:51 um1 ExeMgr[26289]: 51.513860 |450|0|0| D 16 CAL0042: End SQL statement

May 29 20:12:51 um1 ExeMgr[26289]: 51.626946 |2147484099|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:12:51 um1 ExeMgr[26289]: 51.646476 |2147484099|0|0| D 16 CAL0042: End SQL statement

May 29 20:12:51 um1 ExeMgr[26289]: 51.647466 |2147484099|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:12:51 um1 ExeMgr[26289]: 51.663927 |2147484099|0|0| D 16 CAL0042: End SQL statement

May 29 20:12:51 um1 ExeMgr[26289]: 51.665530 |2147484099|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:12:51 um1 ExeMgr[26289]: 51.683973 |2147484099|0|0| D 16 CAL0042: End SQL statement

May 29 20:12:51 um1 ExeMgr[26289]: 51.726845 |451|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:14:10 um1 joblist[26289]: 10.407905 |451|0|0| C 05 CAL0000: TreeNode::getDecimalVal: decimal overflow.

May 29 20:14:10 um1 ExeMgr[26289]: 10.410256 |451|0|0| D 16 CAL0042: End SQL statement

May 29 20:14:10 um1 ExeMgr[26289]: 10.430170 |2147484100|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:14:10 um1 ExeMgr[26289]: 10.449719 |2147484100|0|0| D 16 CAL0042: End SQL statement

May 29 20:14:10 um1 ExeMgr[26289]: 10.450637 |2147484100|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:14:10 um1 ExeMgr[26289]: 10.469135 |2147484100|0|0| D 16 CAL0042: End SQL statement

May 29 20:14:10 um1 ExeMgr[26289]: 10.470357 |2147484100|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:14:10 um1 ExeMgr[26289]: 10.488802 |2147484100|0|0| D 16 CAL0042: End SQL statement

May 29 20:14:10 um1 ExeMgr[26289]: 10.530894 |452|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:15:29 um1 joblist[26289]: 29.247175 |452|0|0| C 05 CAL0000: TreeNode::getDecimalVal: decimal overflow.

May 29 20:15:29 um1 ExeMgr[26289]: 29.248608 |452|0|0| D 16 CAL0042: End SQL statement

May 29 20:15:29 um1 ExeMgr[26289]: 29.269247 |2147484101|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:15:29 um1 ExeMgr[26289]: 29.289813 |2147484101|0|0| D 16 CAL0042: End SQL statement

May 29 20:15:29 um1 ExeMgr[26289]: 29.291432 |2147484101|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:15:29 um1 ExeMgr[26289]: 29.307878 |2147484101|0|0| D 16 CAL0042: End SQL statement

May 29 20:15:29 um1 ExeMgr[26289]: 29.308646 |2147484101|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:15:29 um1 ExeMgr[26289]: 29.325046 |2147484101|0|0| D 16 CAL0042: End SQL statement

May 29 20:15:29 um1 ExeMgr[26289]: 29.364723 |453|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:16:48 um1 ExeMgr[26289]: 48.793878 |453|0|0| D 16 CAL0042: End SQL statement

May 29 20:16:48 um1 ExeMgr[26289]: 48.921942 |2147484102|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:16:48 um1 ExeMgr[26289]: 48.942661 |2147484102|0|0| D 16 CAL0042: End SQL statement

May 29 20:16:48 um1 ExeMgr[26289]: 48.943526 |2147484102|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:16:48 um1 ExeMgr[26289]: 48.959742 |2147484102|0|0| D 16 CAL0042: End SQL statement

May 29 20:16:48 um1 ExeMgr[26289]: 48.960964 |2147484102|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:16:48 um1 ExeMgr[26289]: 48.977554 |2147484102|0|0| D 16 CAL0042: End SQL statement

May 29 20:16:49 um1 ExeMgr[26289]: 49.020009 |454|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:18:07 um1 ExeMgr[26289]: 07.763479 |454|0|0| D 16 CAL0042: End SQL statement

May 29 20:18:07 um1 ExeMgr[26289]: 07.893421 |2147484103|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:18:07 um1 ExeMgr[26289]: 07.913936 |2147484103|0|0| D 16 CAL0042: End SQL statement

May 29 20:18:07 um1 ExeMgr[26289]: 07.915448 |2147484103|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:18:07 um1 ExeMgr[26289]: 07.933593 |2147484103|0|0| D 16 CAL0042: End SQL statement

May 29 20:18:07 um1 ExeMgr[26289]: 07.934678 |2147484103|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:18:07 um1 ExeMgr[26289]: 07.953227 |2147484103|0|0| D 16 CAL0042: End SQL statement

May 29 20:18:07 um1 ExeMgr[26289]: 07.996806 |455|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:19:26 um1 ExeMgr[26289]: 26.846870 |455|0|0| D 16 CAL0042: End SQL statement

May 29 20:19:26 um1 ExeMgr[26289]: 26.976437 |2147484104|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:19:26 um1 ExeMgr[26289]: 26.993869 |2147484104|0|0| D 16 CAL0042: End SQL statement

May 29 20:19:26 um1 ExeMgr[26289]: 26.994749 |2147484104|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:19:27 um1 ExeMgr[26289]: 27.011223 |2147484104|0|0| D 16 CAL0042: End SQL statement

May 29 20:19:27 um1 ExeMgr[26289]: 27.012249 |2147484104|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:19:27 um1 ExeMgr[26289]: 27.028430 |2147484104|0|0| D 16 CAL0042: End SQL statement

May 29 20:19:27 um1 ExeMgr[26289]: 27.068939 |456|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:20:45 um1 joblist[26289]: 45.631282 |456|0|0| C 05 CAL0000: TreeNode::getDecimalVal: decimal overflow.

May 29 20:20:45 um1 ExeMgr[26289]: 45.633407 |456|0|0| D 16 CAL0042: End SQL statement

May 29 20:20:45 um1 ExeMgr[26289]: 45.653294 |2147484105|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:20:45 um1 ExeMgr[26289]: 45.673191 |2147484105|0|0| D 16 CAL0042: End SQL statement

May 29 20:20:45 um1 ExeMgr[26289]: 45.674150 |2147484105|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:20:45 um1 ExeMgr[26289]: 45.693596 |2147484105|0|0| D 16 CAL0042: End SQL statement

May 29 20:20:45 um1 ExeMgr[26289]: 45.694679 |2147484105|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:20:45 um1 ExeMgr[26289]: 45.710976 |2147484105|0|0| D 16 CAL0042: End SQL statement

May 29 20:20:45 um1 ExeMgr[26289]: 45.752904 |457|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:22:05 um1 ExeMgr[26289]: 05.094629 |457|0|0| D 16 CAL0042: End SQL statement

May 29 20:22:05 um1 ExeMgr[26289]: 05.225847 |2147484106|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:22:05 um1 ExeMgr[26289]: 05.245745 |2147484106|0|0| D 16 CAL0042: End SQL statement

May 29 20:22:05 um1 ExeMgr[26289]: 05.246811 |2147484106|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:22:05 um1 ExeMgr[26289]: 05.265204 |2147484106|0|0| D 16 CAL0042: End SQL statement

May 29 20:22:05 um1 ExeMgr[26289]: 05.266676 |2147484106|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:22:05 um1 ExeMgr[26289]: 05.285188 |2147484106|0|0| D 16 CAL0042: End SQL statement

May 29 20:22:05 um1 ExeMgr[26289]: 05.328757 |458|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:23:24 um1 ExeMgr[26289]: 24.036184 |458|0|0| D 16 CAL0042: End SQL statement

May 29 20:23:24 um1 ExeMgr[26289]: 24.158223 |2147484107|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:23:24 um1 ExeMgr[26289]: 24.179274 |2147484107|0|0| D 16 CAL0042: End SQL statement

May 29 20:23:24 um1 ExeMgr[26289]: 24.181141 |2147484107|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:23:24 um1 ExeMgr[26289]: 24.199670 |2147484107|0|0| D 16 CAL0042: End SQL statement

May 29 20:23:24 um1 ExeMgr[26289]: 24.200682 |2147484107|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:23:24 um1 ExeMgr[26289]: 24.218214 |2147484107|0|0| D 16 CAL0042: End SQL statement

May 29 20:23:24 um1 ExeMgr[26289]: 24.266591 |459|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:24:42 um1 ExeMgr[26289]: 42.969892 |459|0|0| D 16 CAL0042: End SQL statement

May 29 20:24:43 um1 ExeMgr[26289]: 43.091080 |2147484108|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:24:43 um1 ExeMgr[26289]: 43.109631 |2147484108|0|0| D 16 CAL0042: End SQL statement

May 29 20:24:43 um1 ExeMgr[26289]: 43.110467 |2147484108|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:24:43 um1 ExeMgr[26289]: 43.130503 |2147484108|0|0| D 16 CAL0042: End SQL statement

May 29 20:24:43 um1 ExeMgr[26289]: 43.131545 |2147484108|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:24:43 um1 ExeMgr[26289]: 43.148413 |2147484108|0|0| D 16 CAL0042: End SQL statement

May 29 20:24:43 um1 ExeMgr[26289]: 43.189728 |460|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:26:02 um1 ExeMgr[26289]: 02.236975 |460|0|0| D 16 CAL0042: End SQL statement

May 29 20:26:02 um1 ExeMgr[26289]: 02.369458 |2147484109|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:26:02 um1 ExeMgr[26289]: 02.389062 |2147484109|0|0| D 16 CAL0042: End SQL statement

May 29 20:26:02 um1 ExeMgr[26289]: 02.390131 |2147484109|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:26:02 um1 ExeMgr[26289]: 02.408854 |2147484109|0|0| D 16 CAL0042: End SQL statement

May 29 20:26:02 um1 ExeMgr[26289]: 02.409731 |2147484109|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:26:02 um1 ExeMgr[26289]: 02.428261 |2147484109|0|0| D 16 CAL0042: End SQL statement

May 29 20:26:02 um1 ExeMgr[26289]: 02.472087 |461|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:27:21 um1 ExeMgr[26289]: 21.515018 |461|0|0| D 16 CAL0042: End SQL statement

May 29 20:27:21 um1 ExeMgr[26289]: 21.636896 |2147484110|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:27:21 um1 ExeMgr[26289]: 21.656428 |2147484110|0|0| D 16 CAL0042: End SQL statement

May 29 20:27:21 um1 ExeMgr[26289]: 21.657549 |2147484110|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:27:21 um1 ExeMgr[26289]: 21.675852 |2147484110|0|0| D 16 CAL0042: End SQL statement

May 29 20:27:21 um1 ExeMgr[26289]: 21.676847 |2147484110|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:27:21 um1 ExeMgr[26289]: 21.695481 |2147484110|0|0| D 16 CAL0042: End SQL statement

May 29 20:27:21 um1 ExeMgr[26289]: 21.739996 |462|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:28:40 um1 ExeMgr[26289]: 40.494806 |462|0|0| D 16 CAL0042: End SQL statement

May 29 20:28:40 um1 ExeMgr[26289]: 40.617971 |2147484111|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; ||

May 29 20:28:40 um1 ExeMgr[26289]: 40.639483 |2147484111|0|0| D 16 CAL0042: End SQL statement

May 29 20:28:40 um1 ExeMgr[26289]: 40.640626 |2147484111|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; ||

May 29 20:28:40 um1 ExeMgr[26289]: 40.659087 |2147484111|0|0| D 16 CAL0042: End SQL statement

May 29 20:28:40 um1 ExeMgr[26289]: 40.660126 |2147484111|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; ||

May 29 20:28:40 um1 ExeMgr[26289]: 40.676683 |2147484111|0|0| D 16 CAL0042: End SQL statement

May 29 20:28:40 um1 ExeMgr[26289]: 40.717700 |463|0|0| D 16 CAL0041: Start SQL statement: select i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(ss_ext_sales_price) as itemrevenue        ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over           (partition by i_class) as revenueratio from   store_sales      ,item       ,date_dim where   ss_item_sk = i_item_sk     and i_category in ('Sports', 'Books', 'Home')    and ss_sold_date_sk = d_date_sk  and (d_date between cast('1999-02-22' as date)      and ADDDATE(cast('1999-02-22' as date),30)) group by   i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by   i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratio; |tpcds_1000|

May 29 20:29:59 um1 joblist[26289]: 59.775084 |463|0|0| C 05 CAL0000: TreeNode::getDecimalVal: decimal overflow.

May 29 20:29:59 um1 ExeMgr[26289]: 59.776352 |463|0|0| D 16 CAL0042: End SQL statement

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

sopradic overflow error.txt
42 kB
2019-05-29 18:11

Issue Links

duplicates

MCOL-3343 Window Functions don't work with arithmetic operators or other functions

Closed

relates to

MCOL-3343 Window Functions don't work with arithmetic operators or other functions

Closed

Activity

People

Assignee:: Unassigned

Reporter:: Zdravelina Sokolovska (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2019-05-29 17:55

Updated:: 2023-03-06 06:11

Resolved:: 2023-03-06 06:11

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.