Error in Reload

[#1]

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

[#2]

Hi Glory,

was that select command performed on sql or resident tables?

regards

[#3]

It was performed in SQL query

[SunilChauhan]

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

[#5]

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