Announcement

**chrisplough** · December 31, 2007, 02:38

Re: OTM to BPEL connection error

Hello,

I've seen this before in OTM installations CU3 or later. Basically, it appears the the BPEL integration no longer functions (I believe it's deprecated, anyways) and web services has been deemed the appropriate replacement. The later EBS/OTM integration guides also cover this newer way of integrating the applications.

Instead of configuring the integration to work via BPEL, you'll want to configure it to work via web services instead. This involves:

Downloading the appropriate WSDL files from BPEL for each OTM to BPEL flow
Uploading these as WSDL documents in OTM
Creating web service definitions in OTM and associating them with the previously created WSDL documents
Linking the appropriate External Systems in OTM with the respective web service definition.
Updating your agents to send transmissions via "service" rather than "bpel"

Thanks,
Chris

**baji** · December 31, 2007, 11:45

Re: OTM to BPEL connection error

Hi,

Thanks for you help,When am using Web service instead of BPEL am getting folloing error saying that "you must enter either URL,hostname,Queuename or BPEL Provider" when i click on FINISH button in external system creation page.I have attached the error.jpg file with this message.

Thanks
Baji

Attached Files

Error.jpg (83.8 KB, 32 views)

**chrisplough** · January 2, 2008, 17:40

Re: OTM to BPEL connection error

This is due to a slight bug in the field verification code for this screen. To get past this error, just enter a URL (for instance, http://www.mavenwire.com) within the HTTP > URL text box on the screen - this will allow you to save the entry. This URL won't be used, so no worries on where it points.

Thanks,
Chris

**jeff.depaul** · January 3, 2008, 04:26

Re: OTM to BPEL connection error

One other noteworthy comment which you might find helpful since I noticed you are using BPEL/Fusion integration.

While the endpoint for the Fusion webservice is embedded in the WSDL file you upload - it can be changed dynamically in the external system definition in OTM. This proves extremely useful (not having to perform all previous setup steps above) in the Fusion development environment where endpoints change fairly frequently due to base code/point release versions changing. Updating the endpoint definition only (in OTM) allows repointing of the webservice fairly easily and does not require a new WSDL file upload each time. I only wish it were that easy on the EBS side! +1 point for OTM.

Changing on the EBS side involves recoding a Java SoapBPELInvoker class file. Hope this helps.
-Jeff

**baji** · January 7, 2008, 04:08

Re: OTM to BPEL connection error

Hi

Now am facing following error

CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSMISSION OUTBOUND: OTM failed to send SERVICE transmission 1,989 from hschbscgn25037.hclt-guindy.co.in to ServiceName null, operation null, url null with the following Exception: No integration service operation found for external system TESTSYSTEM at sun.reflect.GeneratedConstructorAccessor67.newInst ance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Construc tor.java:274) at glog.util.exception.GLException.factory(GLExceptio n.java:413) at glog.util.exception.GLException.factory(GLExceptio n.java:390) at glog.util.exception.GLException.factory(GLExceptio n.java:386) at glog.server.webservice.WebServiceCall.readCall(Web ServiceCall.java:241) at glog.server.webservice.WebServiceCall.find(WebServ iceCall.java:37) at glog.server.workflow.webservice.ServiceTransmissio n.retrieveInfo(ServiceTransmission.java:44) at glog.server.workflow.webservice.ServiceTransmissio n.(ServiceTransmission.java:27) at glog.server.workflow.notify.ServiceTransport.execu te(ServiceTransport.java:59) at glog.server.workflow.SimpleWorkflow.execute(Simple Workflow.java:23) at glog.server.workflow.WorkflowSessionBean.execute(W orkflowSessionBean.java:64) at glog.server.workflow.WorkflowSessionServerSideEJBW rapper.execute(WorkflowSessionServerSideEJBWrapper .java:32) at sun.reflect.GeneratedMethodAccessor27.invoke(Unkno wn Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.evermind.server.ejb.interceptor.joinpoint.EJBJ oinPointImpl.invoke(EJBJoinPointImpl.java:35) at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:69) at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52) at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:69) at com.evermind.server.ejb.interceptor.system.TxRequi redInterceptor.invoke(TxRequiredInterceptor.java:5 5) at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:69) at com.evermind.server.ejb.interceptor.system.Securit yRoleInterceptor.invoke(SecurityRoleInterceptor.ja va:4

at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:69) at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52) at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:69) at com.evermind.server.ejb.StatelessSessionEJBObject. OC4J_invokeMethod(StatelessSessionEJBObject.java:8 6) at WorkflowSession_StatelessSessionBeanWrapper218.exe cute(WorkflowSession_StatelessSessionBeanWrapper21 8.java:35) at glog.server.workflow.WorkflowManager.execute(Workf lowManager.java:341) at glog.server.workflow.Trigger.trigger(Trigger.java: 111) at glog.util.event.MemoryEventQueueRunnable.processEv ent(MemoryEventQueueRunnable.java:111) at glog.util.event.MemoryEventQueueRunnable.run(Memor yEventQueueRunnable.java:70) at glog.util.event.EventThread.run(EventThread.java:7 9) at java.lang.Thread.run(Thread.java:534)

Please let me know your suggestions

Thanks
Baji

**baji** · January 7, 2008, 04:31

Re: OTM to BPEL connection error

Hi

When tried to send xml data to FTP server am getting following error .

CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSMISSION OUTBOUND: OTM failed to send FTP transmission 2,043 from hschbscgn25037.hclt-guindy.co.in to 10.103.106.6 with the following Exception: oracle.classloader.util.AnnotatedClassNotFoundExce ption: Missing class: org.finj.FTPClient Dependent class: glog.util.ftp.client.FTPClientWrapper2 Loader: init.libraries:0.0.0 Code-Source: /data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar Configuration: in /data/otmv55/oas/j2ee/home/config/server.xml This load was initiated at init.libraries:0.0.0 using the Class.forName() method. The missing class is not available from any code-source or loader in the system. oracle.classloader.util.AnnotatedClassNotFoundExce ption: Missing class: org.finj.FTPClient Dependent class: glog.util.ftp.client.FTPClientWrapper2 Loader: init.libraries:0.0.0 Code-Source: /data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar Configuration: in /data/otmv55/oas/j2ee/home/config/server.xml This load was initiated at init.libraries:0.0.0 using the Class.forName() method. The missing class is not available from any code-source or loader in the system. at oracle.classloader.PolicyClassLoader.handleClassNo tFound (PolicyClassLoader.java:2051) [/data/otmv55/oas/j2ee/home/lib/pcl.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@9516880] at oracle.classloader.PolicyClassLoader.internalLoadC lass (PolicyClassLoader.java:1665) [/data/otmv55/oas/j2ee/home/lib/pcl.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@9516880] at oracle.classloader.PolicyClassLoader.loadClass (PolicyClassLoader.java:1621) [/data/otmv55/oas/j2ee/home/lib/pcl.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@9516880] at oracle.classloader.PolicyClassLoader.loadClass (PolicyClassLoader.java:1606) [/data/otmv55/oas/j2ee/home/lib/pcl.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@9516880] at java.lang.ClassLoader.loadClassInternal (ClassLoader.java:302) [jre bootstrap, by jre.bootstrap] at java.lang.Class.forName0 (Native method) [unknown, by unknown] at java.lang.Class.forName (Class.java:141) [jre bootstrap, by jre.bootstrap] at glog.util.ftp.client.FTPClientWrapper2.setupBaseFi elds (FTPClientWrapper2.java:5

[/data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar (from in /data/otmv55/oas/j2ee/home/config/server.xml), by init.libraries:0.0.0] at glog.util.ftp.client.FTPClientWrapper2. (FTPClientWrapper2.java:47) [/data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar (from in /data/otmv55/oas/j2ee/home/config/server.xml), by init.libraries:0.0.0] at glog.util.ftp.client.FTPClientFactory.getNewInstan ce (FTPClientFactory.java:42) [/data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar (from in /data/otmv55/oas/j2ee/home/config/server.xml), by init.libraries:0.0.0] at glog.util.ftp.FTPEvent$Listener.doPost (FTPEvent.java:189) [/data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar (from in /data/otmv55/oas/j2ee/home/config/server.xml), by init.libraries:0.0.0] at glog.util.ftp.FTPEvent$Listener.trigger (FTPEvent.java:163) [/data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar (from in /data/otmv55/oas/j2ee/home/config/server.xml), by init.libraries:0.0.0] at glog.util.event.MemoryEventQueueRunnable.processEv ent (MemoryEventQueueRunnable.java:111) [/data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar (from in /data/otmv55/oas/j2ee/home/config/server.xml), by init.libraries:0.0.0] at glog.util.event.MemoryEventQueueRunnable.run (MemoryEventQueueRunnable.java:70) [/data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar (from in /data/otmv55/oas/j2ee/home/config/server.xml), by init.libraries:0.0.0] at glog.util.event.EventThread.run (EventThread.java:79) [/data/otmv55/glog/gc3webapp/WEB-INF/lib/glogserver.jar (from in /data/otmv55/oas/j2ee/home/config/server.xml), by init.libraries:0.0.0] at java.lang.Thread.run (Thread.java:534) [jre bootstrap, by jre.bootstrap]

Do you have any doument that talk about how configure FTP service in External system

Thanks
Baji

**chrisplough** · January 7, 2008, 15:54

Re: OTM to BPEL connection error

Baji,

The key portion of the error is:

Code:

CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSMISSION OUTBOUND: OTM failed to send FTP transmission 2,043 from hschbscgn25037.hclt-guindy.co.in to 10.103.106.6 with the following Exception: oracle.classloader.util.AnnotatedClassNotFoundExce ption: Missing class: org.finj.FTPClient Dependent class: glog.util.ftp.client.FTPClientWrapper2

You are encountering this error when trying to FTP, because you haven't installed the required 3rd party library files, as noted by the OTM installer. These are libraries that Oracle doesn't distribute, but which are required for full OTM functionality. In this case, it's referring to the finj library files.

Rather than downloading all of these library files manually, you can download and install the package noted in the following post, which includes the correct versions of all of the required libraries.

otmfaq.com�-�This website is for sale!�-�otmfaq Resources and Information.

http://www.otmfaq.com/forums/f23/otm-v5-5-extra-jars-required-installation-415/

This website is for sale! otmfaq.com is your first and best source for all of the information you’re looking for. From general topics to more of what you would expect to find here, otmfaq.com has it all. We hope you find what you are searching for!

Afterwards, restart OTM and test again.

--Chris

**baji** · January 7, 2008, 16:21

Re: OTM to BPEL connection error

Hi,

Thanks for your suggestion,can let me know why am getting following error when am using web service to send otm data to bpel

CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSMISSION OUTBOUND: OTM failed to send SERVICE transmission 1,989 from hschbscgn25037.hclt-guindy.co.in to ServiceName null, operation null, url null with the following Exception: No integration service operation found for external system TESTSYSTEM at sun.reflect.GeneratedConstructorAccessor67.newInst ance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl

Thanks
Baji

**chrisplough** · January 7, 2008, 19:49

Re: OTM to BPEL connection error

Baji,

That error indicates that you haven't configured or associated a web service definition to the OTM External System. Have you done each of the following, as noted above?

Instead of configuring the integration to work via BPEL, you'll want to configure it to work via web services instead. This involves:

Downloading the appropriate WSDL files from BPEL for each OTM to BPEL flow
Uploading these as WSDL documents in OTM
Creating web service definitions in OTM and associating them with the previously created WSDL documents
Linking the appropriate External Systems in OTM with the respective web service definition.
Updating your agents to send transmissions via "service" rather than "bpel"

If so, please publish a screenshot of your External Service screen, specifically the "Services" definition section and I'll try to help you out.

Hope this helps.

--Chris

**baji** · January 8, 2008, 08:29

Re: OTM to BPEL connection error

Hi Chris,

Thanks alot for your help.Am attaching screen shots of my external system and web service.But i have following doubt

1) when we are Uploading the WSDL document in OTM should the WSDL document file extension should be .xml or .wsdl ,Since when tried with .wsdl am getting error,but when tried with .xml extension its accepting it.

2)Since am new to OTM i would like to know "how to configure my agent to send transmissions via "service" rather than "bpel" "?

Attached Files

**baji** · January 8, 2008, 11:01

Re: OTM to BPEL connection error

Hi chris,

As you suggested earlier we have installed third party library files and we bounced our instance .after which we are facing following error

CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSMISSION OUTBOUND: OTM failed to send FTP transmission 2,084 from hschbscgn25037.hclt-guindy.co.in to 10.103.106.6 with the following Exception: java.lang.NullPointerException java.lang.NullPointerException at org.finj.FTPClient.writeLineToControlConnection(FT PClient.java:653) at org.finj.FTPClient.sendFTPCommand(FTPClient.java:5 7

at org.finj.FTPClient.processCommand(FTPClient.java:5 2

at org.finj.FTPClient.close(FTPClient.java:121

at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at glog.util.ftp.client.FTPClientWrapper2.processMeth od(FTPClientWrapper2.java:85) at glog.util.ftp.client.FTPClientWrapper2.close(FTPCl ientWrapper2.java:147) at glog.util.ftp.FTPEvent$Listener.doPost(FTPEvent.ja va:284) at glog.util.ftp.FTPEvent$Listener.trigger(FTPEvent.j ava:163) at glog.util.event.MemoryEventQueueRunnable.processEv ent(MemoryEventQueueRunnable.java:111) at glog.util.event.MemoryEventQueueRunnable.run(Memor yEventQueueRunnable.java:70) at glog.util.event.EventThread.run(EventThread.java:7 9) at java.lang.Thread.run(Thread.java:534)

Any suggestions
Thanks
Baji

**chrisplough** · January 8, 2008, 18:06

Re: OTM to BPEL connection error

Baji,

Looking at the screenshots, you should be able to blank out the "bpel" section, to prevent future issues and confusion.

As for the web service, upload the file as a ".wsdl" file, though you'll manually have to change the file Storage type to "Text" and the Mime Type to "text/xml".

Also, on the Web Service definition, I usually only define one external system, rather than the two that you have listed.

Finally, to send as "service" rather than "bpel" you have to edit the Agents that you've setup to send the transmissions. For the external system you've configured them to use, just select "service". If you're testing manually by sending interface transmissions, then you can just select "service" from the drop down to get the same results.

[Added] Just saw your error on the FTP transmission. This is one of two things -- either there is a bug in OTM that you've hit or you haven't fully populated the required information in the FTP section of the External System. Check the External System first and if it is complete, then I'd recommend opening an SR with Oracle.

--Chris

**hi.shekhu2002** · May 27, 2008, 04:58

Re: OTM to BPEL connection error

hey Chris,

Even i had same problem configuring out bound xml to external system using web service.. Hope your explanation for the screen shot will help me also.. i have one more issue, I want to parse the outbound xml with an xsl so that entire xml don't go to the external system. Could you please suggest where and how can i implement this in webservices..

**chrisplough** · May 27, 2008, 15:13

Re: OTM to BPEL connection error

I believe this is implemented the same way, regardless of the integration method (web services, http post, ftp, etc). You define an Outbound XML Profile in the OTM system and that is used to either add or remove elements from the outbound XML.

You can access the configuration screens via Business Process Automation > Power Data > Integration > Out XML Profiles.

This is explained in further detail within the OTM Integration Guide and OTM Online Help.

--Chris

Announcement

OTM to BPEL connection error

OTM to BPEL connection error

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment