BPEL Process Manager Server connection :Failed

Hi all,

In the SOA Suite 10.1.3.4 and using Jdev 10.1.3.4,when trying to create the integration server connection.
The BPEL Process Manager Server fails when you check the details,the error is on the Identiy service says
"java.io.FileNotFoundException:http://:80/integration/services/testconnection/BPELConnection ".
The workaround for this is:
Login to EM console goto the oc4j instance Stop and start the hw_services
And goback to Jdev and create the connection again,it succeeds this time.

Happy learning
Regards
Ashwini

FTP Adapter File Archive

Hi,
The FTP adapter reads the file but does not archive the file in the specied location.
Especially when reading from a remote location.

There is a Property UseRemoteArchive.This property needs to be set to true in the jca:operation of the WSDL and redeploy your process.
The Process starts archiving the file.

Happy learning

OraBPEL-10902 Compilation Failed

Hi,
Orabpel-10902: Compilation failed
Description :in "bpel.xml", XML parsing failed because "undefined part element.In WSDL at "http://localhost:9700/orabpel/default/RapidDistributors/RapidDistributors?wsdl", message part element "{http://schemas.xmlsoap.org/ws/2003/03/addressing}ReplyTo" is not defined in any of the schemas.Please make sure the spelling of the element QName is correct and the WSDL import is complete.".Potential fix: n/a.

This is one of the errors during compilation.

In my case what happened was:
1)All the processes were created in 10.1.3.3 and then we migrated to 10.1.3.4,suddenly all processes which were running on 10.1.3.3 started throwing this error.

After checking all the properties in the Jdev i found this thing.

There is a Property Use Http Proxy,which is in the Tools->Preferences->Web Browser and Proxy
This needs to be uncehcked.
After unchecking this compile the processes again,error gone.
The Http was not able to fetch the WSDL which was causing this error.

Happy Learning

Creating AQ JMS Queue

Hi,
In this post i shall give information on creating AQ JMS Queues.
These JMS queues are database persisitant and can be accessed from the JMS Adapter.
Creating a AQ JMS queue has 3 steps:
1)Create a user in the DB: jmsuser/jmsuser
2)Create a queue table
3)Create the queue inside the queue table.

1)Creating the jmsuser :
Log on to Sql from command promt or SQl*plus and Create a user

CREATE USER jmsuser IDENTIFIED BY jmsuser;
GRANT CONNECT, RESOURCE, AQ_ADMINISTRATOR_ROLE, AQ_USER_ROLE to jmsuser;
GRANT EXECUTE ON DBMS_AQADM TO jmsuser;
GRANT EXECUTE ON DBMS_AQ TO jmsuser;
GRANT EXECUTE ON DBMS_LOB TO jmsuser;
GRANT EXECUTE ON DBMS_JMS_PLSQL TO jmsuser;

2)Creating Queue table
Login to SQL as jmsuser and run the below command

DBMS_AQADM.CREATE_QUEUE_TABLE(Queue_table => 'AQJMSQueueTab',Queue_payload_type => 'SYS.AQ$_JMS_MESSAGE');

3)Creating the AQ JMS queue
Now create a JMS queue inside the above created table and start the queue

DBMS_AQADM.CREATE_QUEUE( 'AQJMSQueue', 'AQJMSQueueTab');
DBMS_AQADM.START_QUEUE('AQJMSQueue');

Now this queue can be accessed from the JMS adapter.

To create a JMS topic create a Queue table with a propetry "multiple_consumer" set to true.
And then create a queue inside this table.

Happy Learning

Regards
Ashwini

Clone for each in XSLT

Hi All,
We all know we use for each when we want to read a array.
We also have another function called as clone for each in XSLT.
Suppose u have a scenario like u want to repeat a bunch of data,with only one of the field changing.
In my scenario i have a employee information,address of the employee for both permanent and present is the same,but i want to set the flag to true for permanent and flag set to false for present.
When i get the input i get the address only once,i am mapping it twice in the XSLT.
For this i used Clone for each,and set the flag to T for Permanent addr,and F for present.

Happy learning.

Jdeveloper Extension

A very good document which gives information on Jdeveloper extensions.
http://www.oracle.com/technology/products/jdev/howtos/1013/extension/extension.html

Happy Learning

ora:get-Content-as-string

Hi,
In my previous post i wrote about a custom xpath function to convert a string representation of XML to a XML.
In this post lets see a function which the reverse of this.
This function can be used to convert a XML to a string.
for ex:
xsl:value-of select ="orcl:get-content-as-string(/nso:Booklist/nso:Bookdesc:desc")

Happy Learning

ora:parseEscapedXML

Hi,
Oracle provides a custom xpath function,which can be used to convert a string representation of a XML input to a XML ,i.e the input which you are getting is a proper XML input but has been represented as a string.
The function is ora:parseEscapedXML(String).
One workaround is when we directly use this function in the XSLT,by default it does value-of,so the value of the XML input is selected.
Ex:
When we call this function and give the output of this function to a out variable the source looks like
xsl:value-of select="orcl:parseEscapedXML(/ns0:Message/ns0:msgData)"/

So the value of the variable msgData is passed instead of the XML.

This can be overcome by
1)Create a local XSLT variable pass the output of your function to this variable.
2)Use Copy-of and copy the variable to the required output variable
For Ex:
Replace the whole of
xsl:value-of select="orcl:parseEscapedXML(/ns0:Message/ns0:msgData)"/
with
xsl:variable name="parsedMsgData" select="orcl:parseEscapedXML(/ns0:Message/ns0:msgData)"/>
xsl:copy-of select="$parsedMsgData"/


Happy Learning