4 Replies Latest reply: Aug 3, 2012 4:46 AM by Krunoslav Pap RSS

    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

        • Re: Error in Reload
          Krunoslav Pap

          Hi Glory,

          was that select command performed on sql or resident tables?

           

          regards

            • Re: Error in Reload

              It was performed in SQL query

                • Re: Error in Reload
                  Sunil Chauhan

                  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
                    Krunoslav Pap

                    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