Friday, 24 July 2009

ESB CONTROL TAKES LONG

Recently I have experienced that esb control taking to long to display services. Oracle has confirmed this as a bug when you have got a lot of BPEL process and you can get around this by adding a LazyLoad parameter to esb_config.ini file.

This has been reported by oracle as a bug 7720420

Adding the esb.console.services.lazyLoad.Allowed=true property to $OARCLE_HOME/integration/esb/config/esb_config.ini and restarting the services fixed the issue.

Friday, 10 July 2009

Oracle fusion middleware components and architecture

Oracle fusion middleware architecture overview

Oracle fusion middleware components

Singleton adapters issues in HA

Recently I  faced with the issue of Singleton (non-concurrent) adapters in HA (clustered environment). Two instances were created for a single file that resulted in a file will be processed twice.

Singleton adapters can not run in active-active configuration. For this type of adapters you must make sure there is only one adapter instance active at runtime independent of the number of clusters you have. This effectively means you will only have one non-concurrent adapter at runtime. If this active adapter fails, one of the passive adapter becomes active.

There are a lot resources in metalink that you will be able to use. I have listed some of them below.

  • How to Enable a Singleton Adapter in an ESB Cluster Environment
  • How to Enable a Singleton Adapter in BPEL Cluster Environment
  • How to Setup FileAdapter in Cluster for High Availability
    and more can be found on metalink.
  • Wednesday, 8 July 2009

    Oracle Fusion Middleware 11gR1 Software Downloads

    All Oracle Fusion Middleware 11gR1 Software Downloads can be found at Oracle Fusion Middleware 11gR1

    Tuesday, 7 July 2009

    Delete single or multiple esb instance

    From time to time you may need to delete stale esb instances. I had difficulty in finding a script that does it. But actually you can use oracle provided purge scripts and modify to be used only for single or multiple instance deletion. See scripts below it will delete single esb instance

    DELETE FROM ESB_ACTIVITY
    WHERE ID IN
    (SELECT ID
    FROM ESB_ACTIVITY A
    WHERE EXISTS
    (SELECT FLOW_ID
    FROM ESB_ACTIVITY B
    WHERE Flow_id = 'instance Id'
    AND A.FLOW_ID = B.FLOW_ID));



    DELETE ESB_TRACKING_FIELD_VALUE
    WHERE ACTIVITY_ID IN
    (SELECT ID
    FROM ESB_ACTIVITY A
    WHERE EXISTS
    (SELECT FLOW_ID
    FROM ESB_ACTIVITY B
    WHERE Flow_id = 'instance Id'
    AND A.FLOW_ID = B.FLOW_ID));

    --

    DELETE FROM ESB_FAULTED_INSTANCE
    WHERE ACTIVITY_ID IN
    (SELECT ID
    FROM ESB_ACTIVITY A
    WHERE EXISTS
    (SELECT FLOW_ID
    FROM ESB_ACTIVITY B
    WHERE Flow_id = 'instance Id'
    AND A.FLOW_ID = B.FLOW_ID));

    --

    DELETE FROM ESB_TRANSACTION_STATUS
    where Flow_id = 'instance Id'

    --

    DELETE FROM ESB_INSTANCE_RELATION_XML
    WHERE FLOW_ID IN
    (SELECT FLOW_ID
    FROM ESB_ACTIVITY A
    WHERE EXISTS
    (SELECT FLOW_ID
    FROM ESB_ACTIVITY B
    WHERE Flow_id = 'instance Id'
    AND A.FLOW_ID = B.FLOW_ID));

    --

    DELETE FROM ESB_RELATION_XML A
    WHERE NOT EXISTS
    (SELECT RELATION_XML_ID
    FROM ESB_INSTANCE_RELATION_XML);

    --

    DELETE ESB_SERVICE_RELATION
    WHERE RELATION_XML_ID IN
    (SELECT ID
    FROM ESB_RELATION_XML
    WHERE NOT EXISTS
    (SELECT RELATION_XML_ID
    FROM ESB_INSTANCE_RELATION_XML
    WHERE ID = RELATION_XML_ID));

    commit;