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