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, 24 July 2009
Friday, 10 July 2009
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.
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.
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;
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;
Subscribe to:
Posts (Atom)