topic Error in Reload in QlikView

Error in Reload

Wed, 01 Aug 2012 11:19:36 GMT

Hi All

I have done Edit Script then loaded the following query

select s.SITE SITE, s.SFC SFC, s.QTY QTY, stat.STATUS SFC_STATUS,

stat.STATUS_DESCRIPTION SFC_STATUS_DESCRIPTION, i.ITEM ITEM, i.REVISION ITEM_REVISION,

ss.OPERATION_BO, ss.QTY_IN_QUEUE, ss.QTY_IN_WORK, so.SHOP_ORDER SHOP_ORDER,

sot.DESCRIPTION SHOP_ORDER_TYPE

from SFC s inner join ITEM i on

s.ITEM_BO = i.HANDLE inner join STATUS stat on s.STATUS_BO = stat.HANDLE

inner join SFC_ROUTING srg on s.HANDLE = srg.SFC_BO

inner join SFC_ROUTER sr on srg.HANDLE = sr.SFC_ROUTING_BO

inner join SFC_STEP ss on sr.HANDLE = ss.SFC_ROUTER_BO

inner join SHOP_ORDER so on s.SHOP_ORDER_BO = so.HANDLE

inner join SHOP_ORDER_TYPE sot on so.SHOP_ORDER_TYPE_BO = sot.HANDLE

where s.SITE = 'PPM' --and i.ITEM = 'ITEM_PANEL' and i.REVISION = 'A'

and sot.ORDER_TYPE = 'PRODUCTION' and stat.STATUS_DESCRIPTION = 'Scrapped'

order by SFC_BO

Then when click reload button it gives Script Execution Process not responding.

Can anyone suggest how to recover from this?

Regards

Glory

Re: Error in Reload

Fri, 03 Aug 2012 08:18:04 GMT

Hi Glory,

was that select command performed on sql or resident tables?

regards

Re: Error in Reload

Fri, 03 Aug 2012 08:33:36 GMT

It was performed in SQL query

Re: Error in Reload

SunilChauhan — Fri, 03 Aug 2012 08:45:38 GMT

use below code

select s.SITE as SITE, s.SFC as SFC, s.QTY as QTY, stat.STATUS as SFC_STATUS,

stat.STATUS_DESCRIPTION as SFC_STATUS_DESCRIPTION, i.ITEM as ITEM, i.REVISION as ITEM_REVISION,

ss.OPERATION_BO, ss.QTY_IN_QUEUE, ss.QTY_IN_WORK, so.SHOP_ORDER as SHOP_ORDER,

sot.DESCRIPTION as SHOP_ORDER_TYPE

from SFC s inner join ITEM i on

s.ITEM_BO = i.HANDLE inner join STATUS stat on s.STATUS_BO = stat.HANDLE

inner join SFC_ROUTING srg on s.HANDLE = srg.SFC_BO

inner join SFC_ROUTER sr on srg.HANDLE = sr.SFC_ROUTING_BO

inner join SFC_STEP ss on sr.HANDLE = ss.SFC_ROUTER_BO

inner join SHOP_ORDER so on s.SHOP_ORDER_BO = so.HANDLE

inner join SHOP_ORDER_TYPE sot on so.SHOP_ORDER_TYPE_BO = sot.HANDLE

where s.SITE = 'PPM' --and i.ITEM = 'ITEM_PANEL' and i.REVISION = 'A'

and sot.ORDER_TYPE = 'PRODUCTION' and stat.STATUS_DESCRIPTION = 'Scrapped'

order by SFC_BO

hope this helps

Re: Error in Reload

Fri, 03 Aug 2012 08:46:41 GMT

Try to measure how much time select execution takes when run from db tool and how many rows has final result.

One option would be to create corresponding resident tables in QV and inner joins perform on them.

regards