Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Error in Reload

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

4 Replies
Not applicable

Re: Error in Reload

Hi Glory,

was that select command performed on sql or resident tables?

regards

Not applicable

Re: Error in Reload

It was performed in SQL query

SunilChauhan
Esteemed Contributor

Re: Error in Reload

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

Not applicable

Re: Error in Reload

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