Problem

 Since moving to 4400 the Payment Run form is taking a long time to run (longer than 15 minutes) evenh when only small number of orders affected.
The screen just hangs... no error message and no payment run report is being produced.
If we check the data (after say 15mins) all appropriate works order lines are updated with PAID, but the session running the Payment Run is still frozen with no Payment Run reports being produced.
This process took a couple of minutes under 4.3

Solution

Solution to this issue was due to stats not being done on migration - overcome by running:

create_stats.sql
-----------------------------------------------------------------------------
--
--   SCCS IDENTIFIERS :-
--
-- sccsid : @(#)create_stats.sql 1.1 12/05/06
-- Module Name : create_stats.sql
-- Date into SCCS : 06/12/05 15:33:33
-- Date fetched Out : 07/06/13 17:07:17
-- SCCS Version : 1.1
--
-----------------------------------------------------------------------------
-- Copyright (C) Exor Corporation Ltd, 2004
-----------------------------------------------------------------------------
--
begin
dbms_stats.gather_schema_stats(USER);
swr_utility.delete_table_stats;
end;
/

followed by

analyse.sql

--
set feedback off
set lines 132
set pages 0
--
spool temp.ana
SELECT 'ANALYZE '||object_type||' '||object_name||' COMPUTE STATISTICS;'
from user_objects
where object_type IN ('TABLE','INDEX')
ORDER BY DECODE(object_type
               ,'TABLE',1
               ,'INDEX',2
               ,3
               )
        ,object_name;
spool off
--
prompt .
prompt Doing the analyse statements, this may take some time
prompt .
--
@temp.ana
--
host del temp.ana
--
set pages 50
set feedback on
--

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!