postgresql-2009-04-15_222743.log:2009-04-15 22:35:21 CEST : LOG:  process 968 still waiting for AccessShareLock on relation 39915 of database 39713 after 1000.068 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:35:21 CEST : LOG:  process 966 still waiting for AccessShareLock on relation 39915 of database 39713 after 1000.060 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:35:22 CEST : LOG:  process 990 still waiting for AccessShareLock on relation 40434 of database 39713 after 1000.065 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:35:32 CEST : LOG:  process 991 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.067 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:36:22 CEST : LOG:  process 995 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.068 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:37:12 CEST : LOG:  process 1001 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.066 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:38:02 CEST : LOG:  process 1005 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.064 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:38:52 CEST : LOG:  process 1009 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.062 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:39:42 CEST : LOG:  process 1010 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.069 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:40:32 CEST : LOG:  process 1012 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.072 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:41:22 CEST : LOG:  process 1014 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.069 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:42:12 CEST : LOG:  process 1016 still waiting for AccessShareLock on relation 40297 of database 39713 after 1004.731 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:43:02 CEST : LOG:  process 1018 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.069 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:43:52 CEST : LOG:  process 1022 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.073 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:44:42 CEST : LOG:  process 1025 still waiting for AccessShareLock on relation 40297 of database 39713 after 1002.779 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:45:32 CEST : LOG:  process 1027 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.070 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:46:22 CEST : LOG:  process 1029 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.071 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:47:12 CEST : LOG:  process 1031 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.068 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:48:02 CEST : LOG:  process 1033 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.066 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:48:52 CEST : LOG:  process 1035 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.070 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:49:42 CEST : LOG:  process 1038 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.066 ms
postgresql-2009-04-15_222743.log:2009-04-15 22:50:32 CEST : LOG:  process 1042 still waiting for AccessShareLock on relation 40297 of database 39713 after 1000.078 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 5216814.052 ms  execute <unnamed>: SELECT * FROM AD_DELETE_CLIENT(TO_NUMBER($1),NULL)
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1031 acquired AccessShareLock on relation 40297 of database 39713 after 4499177.857 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1029 acquired AccessShareLock on relation 40297 of database 39713 after 4549183.261 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1027 acquired AccessShareLock on relation 40297 of database 39713 after 4599179.174 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1025 acquired AccessShareLock on relation 40297 of database 39713 after 4649166.711 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1022 acquired AccessShareLock on relation 40297 of database 39713 after 4699187.968 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1018 acquired AccessShareLock on relation 40297 of database 39713 after 4749187.211 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1016 acquired AccessShareLock on relation 40297 of database 39713 after 4799136.640 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1014 acquired AccessShareLock on relation 40297 of database 39713 after 4849191.736 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1012 acquired AccessShareLock on relation 40297 of database 39713 after 4899196.969 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1010 acquired AccessShareLock on relation 40297 of database 39713 after 4949209.635 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1009 acquired AccessShareLock on relation 40297 of database 39713 after 4999204.136 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1005 acquired AccessShareLock on relation 40297 of database 39713 after 5049203.575 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1001 acquired AccessShareLock on relation 40297 of database 39713 after 5099214.975 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 995 acquired AccessShareLock on relation 40297 of database 39713 after 5149215.792 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 991 acquired AccessShareLock on relation 40297 of database 39713 after 5199210.486 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 990 acquired AccessShareLock on relation 40434 of database 39713 after 5209364.480 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1042 acquired AccessShareLock on relation 40297 of database 39713 after 4299186.942 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1038 acquired AccessShareLock on relation 40297 of database 39713 after 4349193.097 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1035 acquired AccessShareLock on relation 40297 of database 39713 after 4399202.561 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 1033 acquired AccessShareLock on relation 40297 of database 39713 after 4449195.599 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 968 acquired AccessShareLock on relation 39915 of database 39713 after 5210084.973 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  process 966 acquired AccessShareLock on relation 39915 of database 39713 after 5210055.061 ms
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4499217.755 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4649237.887 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4299266.699 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 5210162.450 ms  bind S_2: SELECT AD_CLIENT_ID, '' AS AD_USER_ID, '' as AD_ORG_ID      FROM AD_CLIENT WHERE ISACTIVE='Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4949316.926 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4599307.251 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 5049360.235 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4399360.689 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4549390.869 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 5149436.492 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4999430.801 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4349423.797 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 5199471.777 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 5210325.003 ms  parse <unnamed>: SELECT AD_CLIENT_ID, '' AS AD_USER_ID, '' as AD_ORG_ID      FROM AD_CLIENT WHERE ISACTIVE='Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4899481.217 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4849495.666 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 5209678.911 ms  parse <unnamed>: SELECT COUNT(*) AS TOTAL		  FROM AD_Process_Scheduling		 WHERE (Weekday IS NULL OR Weekday = TO_CHAR(NOW(), 'D'))		   AND TO_DATE(TO_CHAR(TRUNC(NOW()), 'DD-MM-YYYY') || ' ' || TO_CHAR(TimeFrom, 'HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS') <= NOW()		   AND (TimeTo IS NULL 		    OR  TO_DATE(TO_CHAR(TRUNC(NOW()), 'DD-MM-YYYY') || ' ' || TO_CHAR(TimeTo, 'HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS') > NOW())		   AND AD_Client_ID = TO_NUMBER($1) 		   AND AD_Process_ID = TO_NUMBER($2)
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4749525.159 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 5099557.982 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4799492.659 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4449601.727 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'
postgresql-2009-04-16_000000.log:2009-04-16 00:02:10 CEST : LOG:  duration: 4699614.027 ms  parse <unnamed>: SELECT MO.ACTION AS TYPE, (CASE MO.ACTION WHEN 'X' THEN MO.AD_FORM_ID                               WHEN 'P' THEN MO.AD_PROCESS_ID                               WHEN 'R' THEN MO.AD_PROCESS_ID                               WHEN 'T' THEN MO.AD_TASK_ID                               WHEN 'S' THEN MO.AD_REFERENCE_ID                              WHEN 'F' THEN MO.AD_WORKFLOW_ID                               WHEN 'C' THEN MO.AD_CALLOUT_ID                               ELSE MO.AD_TAB_ID END) AS ID,         MOM.MAPPINGNAME, COALESCE(mt.name, m.name) AS NAME        FROM AD_MODEL_OBJECT_MAPPING MOM, AD_MODEL_OBJECT MO              left join AD_Menu m on MO.ad_process_id = m.ad_process_id                                   AND MO.action in ('P', 'R')                                  AND m.action in ('P', 'R')             left join AD_Menu_TRL mt on m.ad_menu_id = mt.ad_menu_id                                     AND mt.ad_language = $1         WHERE MOM.AD_MODEL_OBJECT_ID = MO.AD_MODEL_OBJECT_ID         AND MOM.MAPPINGNAME = $2         AND MO.IsDefault = 'Y'        AND MO.IsActive = 'Y'