Tuesday, February 2, 2010

Gonna be working on SOA 11g.. Will be publishing few content on how-tos on 11g soon.

Sunday, December 20, 2009

iBizTrack.com Good Going..

Pals, great going.
Just checked your new offering on Oracle SOA Suite 11g training.
Checked the following links:

Training Content:

Training Prices:

The content looks quite interesting and prices too seem comparative.
I wish to attend one (at discounted rates though..lol..)


Sunday, September 20, 2009

It's time to pay back the old favours of the friends! [:)]
Some of my friends have started a new venture and here i m promoting it.

They are into technical consulting on oracle technologies and training on oracle products. I am sure their trainings are going to be precious for individuals who want to start working on any Oracle product.
Please check this out:

One of their most popular trainings is which i happened to attend couple of session.


Sunday, August 30, 2009

Windows Live Writer being explored…


Hello, now i m writing through Windows Live Writer..

looks like this is gonna be cool..

Saturday, October 18, 2008

Dear Readers, one more error and the potential fix:
This error has also been posted on the forum:

I have the following in place:
1) JMS Consumer BPEL Process : It Consumes messages from a JMS Queue.
2) Another BPEL Process : It does transormation and calls an ESB service.
3) An ESB Service: This is my router.

I am facing the following problem with my SOA:

exception on JaxRpc invoke: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: company: company *

I have chain of calls wherein Service1 calls Service2 and Service2 in turn calls Service3.
However, When BPEL Process 2 calls ESB Service 3, I get the above mentioned exception:

The following is the few first and last lines in the exception stack:

at com.collaxa.cube.ws.WSIFInvocationHandler.invoke(WSIFInvocationHandler.java:656)
at com.collaxa.cube.ws.WSInvocationManager.invoke2(WSInvocationManager.java:436)
at com.collaxa.cube.ws.WSInvocationManager.invoke(WSInvocationManager.java:251)


at oracle.j2ee.connector.work.WorkWrapper.doWork(WorkWrapper.java:215)
at oracle.j2ee.connector.work.WorkWrapper.run(WorkWrapper.java:190)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:819)
at java.lang.Thread.run(Thread.java:595)

Cause and Fix:
The problem arose because the WSDL for the Routing Service had a service tag which was pointing to the dummy implementation endpoint. It was of a form like : http://company/blabla/
The company you see in the exception summary, was coming from this Service tag. The URL being a dummy one is not found and the message send failed.
When you register a routing service, a new WSDL gets created which imports the abstract WSDL. But here the service and binding tags (somehow they were added and that was the issue) in the abstract WSDL was being considered and hence the error.

Removing the service and binding tags from this WSDL was a fix.

Wednesday, August 27, 2008

Error after upgrading to

Got error java.sql.SQLException: [POL-5205] column BLOCK not found.This happened immidiately after upgrading to log to investigate and found the following:

The process domain was unable to insert the current log entries for the instance "2" to the audit trail table.
The exception reported is: [POL-5205] column BLOCK not foundPlease check that the machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid.sql statement: INSERT INTO audit_trail( cikey, domain_ref, count_id, block, block_csize, block_usize, log ) VALUES( ?, ?, ?, ?, ?, ?, ? )] -> [java.sql.SQLException: [POL-5205] column BLOCK not found]

Found that:
The table definition is different for Oracle DB and Olite DB.BPEL PM uses the definition of audit_trail table for Oracle DB even if it connects to Olite. Hence, the problem.
Drop the audit_trail table first, and create anew from the Script file for Oracle DB.Make sure you have necessary backup before proceeding.

drop table audit_trail;
drop index at_fk;
create table audit_trail( cikey integer, domain_ref smallint, count_id integer, block integer, block_csize integer, block_usize integer, log raw( 2000 ));
create index at_fk on audit_trail( cikey );

It worked for me.!!

Thursday, July 17, 2008

Well, I came to Oracle for testing their new product features from a Partner company. It's a nice feeling to be back with Oracle again, the same old environment wherein I grew as an IT professional and as a consultant too.

Well, Oracle is coming up with a bunch of new features related to SOA in R12.1 that, I suppose, would make Integrator's life a lot easier.. The idea is to gradually make the entire Integration Repository service-enabled. Plus custom APIs, Service Objects etc. too could be published in the repository..

more to come...