Issues and Solutions - Part II

Issue: Error during BPEL process deployment, BPEL Process is not deployed completely and the process shows in warning state. Unable to redeploy the process again.

Solution: Using below SQL script, remove the failed process entry from orabpel schema.

delete from process where process_id='CreateAccountBalanceAdjustmentBRMCommsProvABCSImpl';

delete from process_descriptor where process_id='CreateAccountBalanceAdjustmentBRMCommsProvABCSImpl';

delete from process_log where process_id='CreateAccountBalanceAdjustmentBRMCommsProvABCSImpl';

delete from process_default where process_id='CreateAccountBalanceAdjustmentBRMCommsProvABCSImpl';



----------------------------------------------------------------------------------------------------------------



Issue: Error while registering ESB, unable to register or says Integration server is down


Solution: Find the failed esb service in the server @ location $ORACLE_HOME/integration/esb/oraesb/artifacts/store and $ORACLE_HOME/integration/esb/oraesb/artifacts/store/metadata and remove it.

Also remove the esb service entry from 'ESB_Projects.def.xml' @ location $ORACLE_HOME/integration/esb/oraesb/artifacts/store/metadata/files and save it.