You are currently reviewing an older revision of this page.
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 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-------------------------------------------------------------------------------begindbms_stats.gather_schema_stats(USER);swr_utility.delete_table_stats;end;/
followed by
analyse.sql
--set feedback offset lines 132set pages 0--spool temp.anaSELECT 'ANALYZE '||object_type||' '||object_name||' COMPUTE STATISTICS;'from user_objectswhere 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 timeprompt .--@temp.ana--host del temp.ana--set pages 50set feedback on--
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
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!