Wednesday, September 15, 2010

SOA BPEL (10.1.3.x) Identity service: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection timed out

The reason for this error:
"java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection timed out:"
was that an proxy server was configured on the oc4j_soa container in opmn.xml

BPEL Console gave this error:
The following exception occured while processing this request:
Io exception: The Network Adapter could not establish the connection

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Wednesday, September 1, 2010

Delete of bpel domain on SOA 10.1.3.4 is not complete

When a BPEL domain is delete from the BPELAdmin there are still records left in de dehydration database. These entries can be deleted:

Logon on the dehydration store database as ORABPEL

Check which domains are active:
select domain_ref from domain;

Delete all other domains:

delete suitcase_bin where domain_ref not in (select domain_ref from domain);
delete audit_details where domain_ref not in (select domain_ref from domain);
delete audit_trail where domain_ref not in (select domain_ref from domain);
delete cube_instance where domain_ref not in (select domain_ref from domain);
delete cube_scope where domain_ref not in (select domain_ref from domain);
delete dlv_message where domain_ref not in (select domain_ref from domain);
delete dlv_subscription where domain_ref not in (select domain_ref from domain);
delete document_ci_ref where domain_ref not in (select domain_ref from domain);
delete document_dlv_msg_ref where domain_ref not in (select domain_ref from domain);
delete domain_properties where domain_ref not in (select domain_ref from domain);
delete invoke_message where domain_ref not in (select domain_ref from domain);
delete process where domain_ref not in (select domain_ref from domain);
delete process_default where domain_ref not in (select domain_ref from domain);
delete process_descriptor where domain_ref not in (select domain_ref from domain);
delete process_log where domain_ref not in (select domain_ref from domain);
delete wi_fault where domain_ref not in (select domain_ref from domain);
delete work_item where domain_ref not in (select domain_ref from domain);
delete xml_document where domain_ref not in (select domain_ref from domain);
delete wftask where domainid='[NOT EXISTING DOMAINS]';
delete wftaskhistory where domainid='[NOT EXISTING DOMAINS]';
delete wftaskmetadata where domainid='[NOT EXISTING DOMAINS]';
delete wftask where domainid='[NOT EXISTING DOMAINS]';

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.