Wednesday, November 27, 2013

Oracle Webcenter Content App for Android and iphone

With the release of webcenter content 11.1.1.8.0, Oracle also releases the webcenter content app for Apple and Android devices.
Installing the Oracle WebCenter Content Mobile app is just like installing other apps. Search for Oracle WebCenter Content in the App Store to find the app, then install it.
After that open the application you are asked for user name and password. The address for the host computer is the url address where the Oracle WebCenter Content server is running. Just supply all the necessary information and you are ready to manage the content on your devices.

for android : https://play.google.com/store/apps/details?id=com.oracle.webcenter.content.android


Oracle WebCenter Content App Demonstration for iOS by TEAM Informatics

Tuesday, November 19, 2013

Internal error: Failed to make composite state update: Composite "" does not exist.

Sometimes when you are working on the BPEL Processes then your process goes into the faulted state and in that case you can't do anything(shutdown, startup, retired etc.) and when you click on any action following error is thrown:




Internal error: Failed to make composite state update: Composite "Default/HelloWorld!1.0*soa_cad506cc-72bd-4b2c-9990-5c84ea3861c7" does not exist.

Error Symptoms

In my case this error comes when my Main Process is dependent on other composites and when I restart the Server before loading of the dependent composites my Main Process loads first and goes into the faulted state(as stated above).

Solution

  1. To resolve this issue you can localize the artifacts of the dependent composite so that after restarting the server the dependent artifacts are available to the Main Process.
  2. Or you can put dependent artifacts on the Oracle MDS Repository and give the reference of dependent artifacts from the MDS to the Main Process.
Well I followed the Step 1.

After these steps, I remove the composites which already in the faulted state from the MDS. Just follow this blog post : http://codeconfuse.blogspot.in/2013/11/delete-bpel-composites-which-are-in.html

Delete BPEL Composites which are in unknown state : Failed to make composite state update: Composite "" does not exist.

When your BPEL Processes goes into the unknown state and in that case you can't do anything(shutdown, startup, retired etc.) and when you click on any action following error is thrown:

 
Internal error: Failed to make composite state update: Composite "Default/HelloWorld!1.0*soa_cad506cc-72bd-4b2c-9990-5c84ea3861c7" does not exist.
In that case you can delete composite entry from the MDS and after restarting the server unknown composites are not visible in em console.

How to remove composite entry from MDS
  1. Run wlst.sh ( /app1/Oracle/Middleware/Oracle_SOA1/common/bin/wlst.sh)
  2. Connect to SOA Server Instance i.e. connect('weblogic', 'weblogic123', 't3://10.3.15.102:8001')
  3. Export the metadata. By running the command  exportMetadata(application='soa-infra', server='soa_server1', toLocation='/home/oracle/mds', docs='/**'), here "/home/oracle/mds"  is the location on the machine where all the MDS data exported.
  4. After Exporting the MDS, two folder are created in "/home/oracle/mds" i.e. deployed-composites and soa.
  5. Now  go to deployed-composites folder there is deployed-composite.xml, open that file in an editor and remove all the faulted composite entry.
  6. After saving the file, Import the MDS by running the command importMetadata(application='soa-infra',server='soa_server1', fromLocation='/home/oracle/mds',docs='/**')
  7. Restart the SOA Server.

Monday, November 18, 2013

ORA-00904: "ORA_ROWSCN": invalid identifier

Sometimes when you look the database tables in SQL Developer or in Jdeveloper Database Navigator you are facing the following issue:
ORA-00904: "ORA_ROWSCN": invalid identifier
and you are not able to see the data in the table.

In that case you can do following step
Go to  preference -> database -> object viewer and uncheck the check-box  "Use ORA_ROWSCN for DataEditor insert and update statements." and then data is visible.

Sunday, November 17, 2013

Large Event Payload Causes: ORA-19011: Character string buffer too small ORA-06512: at "SYS.XMLTYPE"

I am using oracle EDN in SOA 11.1.1.6, while testing the process i am getting the large event payload error:

faultName: {{http://schemas.oracle.com/bpel/extension}runtimeFault} messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{ summary=<summary>Error enqueing event:  ORA-06512: at "SYS.XMLTYPE", line 169 ORA-06512: at "DEV_SOAINFRA.EDN_ENQUEUE_
BUSINESS_EVENT", line 13 ORA-06512: at "DEV_SOAINFRA.EDN_INTERNAL_PUBLISH_EVENT", line 4 </summary> ,detail=<detail>oracle.fabric.common.FabricException: Error enqueing event: ORA-19011: Character string buffer too small ORA-06512: at "SYS.XMLTYPE", line 169 ORA-06512: at "DEV_SOAINFRA.EDN_ENQUEUE_BUSINESS_EVENT", line 13 ORA-06512: at "DEV_SOAINFRA.EDN_INTERNAL_PUBLISH_EVENT",
Well according to the oracle support when you publish an event to EDN with a large payload in a BPEL process, this error occurs and  it is reported as a unpublished bug 13801175.
To resolve this issue you need to install the patch 13801175 (you can get it from metalink).
Note: This issue has been fixed in SOA 11.1.1.7.0.