tablespace ORA-01654 issue with Oracle SOA BPM

Recently encountered an issue with Tablespace.
Error :
oracle.fabric.common.FabricDeploymentException: oracle.mds.transfer.TransferException:

ORA-01654: unable to extend index DEV_MDS.MDS_ATTRIBUTES_U2 by 1024 in tablespace DEV_MDS

I was unable to deploy because of the Tablespace issue. Purged all the older instances in EM as well as MDS schema unsused files / versions/ projects. I had executed all the techniques provided by Oracle documentation to purge. Finally - increased the tablespace.

SQL command:
Connect SQL with Admin user and execute the below command

alter tablespace <<MDS Schema name>> add datafile 'datafile_name' size 500m
autoextend on;
 

For example,my MDS scema is "DEV_MDS"

  alter tablespace DEV_MDS add datafile 'datafile_name' size 500m
  autoextend on;

So Friends !! .. read the Oracle documentation first. There are other techniques to clear off the tablespace issue.

How to refresh / update ADF Data Controls When the BPM Human Task payload is changed

At times, Oracle BPM Human Task payload changes and this reflects on ADF UI as well.


When BPM Human Task Payload changes  like adding of new attribute the Human Task ... If you dont update  ADF Data controls then some times ADF Task page may fails or some times displays blank page or weird behavior. Simple way to update the ADF Data control.

1. Open ADF Data Control and click right click on the Data Control that needs to be changed

2. Below popup appears when you click on the Edit Definition

3. Select the Human task associated with the Data Control and click ok. Now your payload reflects accordingly with the payload.. :)

Add files to MDS through Oracle SOA EM

Import / Add / upload files to Oracle MDS through Weblogic -EM

 

Recently encountered an issue with Jdeveloper while migrating the files to MDS. Finally, Below is the quickest and easy way to upload artifacts to  MDS.

Below are the steps to upload artifacts to MDS like wsdls, schemas, xsls etc through the EM console.

Steps:

 1. Create a zip which should have all the files and folders you would like to use - like apps.zip and make sure that you have correct folder structure.

 

  2. Login to em console using http://<hostname>:<portname>/em and navigate to soa_infra > Administration > MDS Configuration

3. Import the zip onto the server by clicking the import button

4. Finally verify the same through MDS - IDE connection

Delete Files from MDS Oracle SOA BPM 11G

When you create files in Composite and deploy to MDS, those files would be available in MDS and later if you change your thoughts and those files are no longer required for the project. So if you delete those files and re-deploy Composite, you will get Resource exception / File not found exception /.



There are various ways to remove files from MDS. How ever following is the simple and easy to remove..

Approach 1:
-----------------

1. Check whether the server is UP and Running or not. It should be Up and Running.

2. Go to the File directory in DOS / where the Oracle Home recited.
as an example, C:\Oracle\SOA\Oracle_SOA1\common\bin

3. If you are in DOS/ Windows then type  wlst.cmd
if Unix machine then   ./wlst.sh

 Prompt will get changed to wls:/offline>

4. connect to the SOA Server with the below command

connect('username', 'password', 't3://Host :port')

Example:
connect('weblogic', 'welcome1', 't3://localhost:7001')

5. execute the below command
 deleteMetadata(application='Application-Name', server='Soa Server-Name', docs='absolutePath')

Example:
deleteMetadata(application='XYZ_rev1.0',server='BPM1_domain',docs='/deployed-composites/xsl/*')

deleteMetadata(application='soa-infra',server='AAAServer',docs='/deployed-composites/default/XYZ_rev1.0/businessCatalog/ABCModule/**')

Once operation executed, you will see the prompt below:

Note: The asterisk (*) represents all documents under the current directory. The double asterisk (**) represents all documents under the current directory and also recursively includes all documents in subdirectories

Approach 2:
---------------

1. Follow steps from 1 to 3 from the above.

2. execute below command:
sca_removeSharedData('http:// SOA Host:Port', 'directory', 'User Name', 'password')

 Example:sca_removeSharedData(‘http://localhost:7001’, ‘interfaces’, ‘weblogic’, ‘welcome1’)


Hope these approaches helps you! 

Feel happy for the Issues. You are the Master tomorrow :)