wMUsers

wMUsers http://www.wmusers.com/forum/ wMUsers is the independent webMethods User Community en Tue, 07 Sep 2010 05:53:05 GMT vBulletin 60 http://www.wmusers.com/forum/images/misc/rss.jpg wMUsers http://www.wmusers.com/forum/ DynamicSQL service exception http://www.wmusers.com/forum/showthread.php?t=19861&goto=newpost Mon, 06 Sep 2010 15:04:22 GMT Hi , I have created DynamicSQL service,when service create time I fill up all fields in that. Ex:- in SQL place written query i.e select * from... Hi ,
I have created DynamicSQL service,when service create time I fill up all fields in that.
Ex:- in SQL place written query i.e select * from ${name}
input JDBC Type input field Type input Type
VARCHAR java.long.string name

output JDBC Type output field Type outputType
VARCHAR java.lang.String ename

after this I pass table name[emp_salary] through input field "name",but it rose exception is

Could not run 'dynamicservice'.

com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service jdbcservice.dynamicSql:dynamicAdapter.
[ADA.1.316] Cannot execute the SQL statement "select * from emp_salary". "
(72000/1006) ORA-01006: bind variable does not exist
"
ORA-01006: bind variable does not exist

please say any one,how to execute DynamicSQL. ]]> JDBC Adapter vannur http://www.wmusers.com/forum/showthread.php?t=19861 Configurtaions to be done after the CAF Deployment. http://www.wmusers.com/forum/showthread.php?t=19860&goto=newpost Mon, 06 Sep 2010 13:14:48 GMT Hi All, I deployed the CAF code on to the MWS.But i came to know that only deploying the CAF onto MWS is not the only thing to be done and we had... Hi All,

I deployed the CAF code on to the MWS.But i came to know that only deploying the CAF onto MWS is not the only thing to be done and we had to make some other configurations.

Could any one please let me know what else had to be done after deploying the CAF build and why shld it to done.

Thanks,
Vishnu Charan.T ]]> Managing webMethods Integration Server wisnu http://www.wmusers.com/forum/showthread.php?t=19860 Retrying trigger service http://www.wmusers.com/forum/showthread.php?t=19859&goto=newpost Mon, 06 Sep 2010 12:23:19 GMT Hi All, In our flow we are using a trigger service which needs to be retried on any transient failure mainly database connection not available... Hi All,

In our flow we are using a trigger service which needs to be retried on any transient failure mainly database connection not available .Could you please let me know how to handle this logic in catch block of the service and how to set the variable on which the throwing IS Runtime exception for retry depends?

Thanks and Regards,
Nithin Dindigala. ]]> Broker nithin.dindigala http://www.wmusers.com/forum/showthread.php?t=19859 Managing Users in webMethods http://www.wmusers.com/forum/showthread.php?t=19858&goto=newpost Mon, 06 Sep 2010 09:50:46 GMT Hi ,

Can anyone let me know whether i can give a read only access for a user in webMethods Integration Server so that he can't modify any element in the Is and he can only be able to view the logs and the configurations done with his user account.

Apart from giving ACL as Anonymous,Default is there a way to achieve this.

I think we can't do this.....If there is a way to achieve this then please help me.

Thanks,
Vishnu Charan.T ]]> Managing webMethods Integration Server wisnu http://www.wmusers.com/forum/showthread.php?t=19858 Process Large Volume XML File http://www.wmusers.com/forum/showthread.php?t=19857&goto=newpost Mon, 06 Sep 2010 05:57:47 GMT Hi All , I want to process very high volume xml file say 2 GB in flow service/java service . The requirement is :- Fetch the input file from... Hi All , I want to process very high volume xml file say 2 GB in flow service/java service . The requirement is :-

Fetch the input file from location , transform it and sftp to target system .

Now the problem is even though if we use NodeIterator to iterate over the nodes 1 by 1 , if we get say 10000 child tag list in it ..then flow service takes a long time to loop over 10000 child tag and many time fail...

Can you please help me better solution to handle large volume of xml ??

thanks in advance
Rohit Gupta
rohitgupta.it@gmail.com ]]> Flow and Java services rohitgupta2476 http://www.wmusers.com/forum/showthread.php?t=19857 MWS error while accessing Integration-services http://www.wmusers.com/forum/showthread.php?t=19856&goto=newpost Mon, 06 Sep 2010 05:01:20 GMT I faced following error while accesing Monitoring-Integration-Services in MWS 7.1 Error executing search. Have a System Administrator verify... I faced following error while accesing Monitoring-Integration-Services in MWS 7.1

Error executing search. Have a System Administrator verify the Integration Server settings at Administration -> My webMethods -> System Settings.

Guys can you please advise me on below error.
Thanks a lot in advance.

2010-09-06 10:07:29 IST (wsclient : FATAL) [RID:59] - com.webmethods.caf.wsclient.proxy.impl.WSClientDynamicProxy: [ISS.0088.9134] Exception occurred while processing the body of the message
SOAPException( Client: [ISS.0088.9134] Exception occurred while processing the body of the message )
at electric.soap.SOAPMessage.getSOAPException(SOAPMessage.java:691)
at electric.soap.java.reference.JavaToSOAP.invoke(JavaToSOAP.java:256)
at electric.soap.java.reference.JavaToSOAP.invoke(JavaToSOAP.java:165)
at electric.proxy.handler.Proxy.invoke(Proxy.java:126)
at $Proxy9.getList(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.webmethods.caf.wsclient.proxy.impl.WSClientDynamicProxy.invokeMethod(WSClientDynamicProxy.java:89)
at com.webmethods.caf.wsclient.proxy.impl.WSClientDynamicProxy.invoke(WSClientDynamicProxy.java:134)
at $Proxy8.getList(Unknown Source)
at com.webmethods.bpo.portlet.wm_mon_service_list.Mon_service_list.getList_getList(Mon_service_list.java:923)
at com.webmethods.bpo.portlet.wm_mon_service_list.Mon_service_list.search(Mon_service_list.java:520)
at com.webmethods.portal.portlet.wm_commonsearchresults.mechanics.CommonsearchresultsMechanics.getSearchResults(CommonsearchresultsMechanics.java:89)
at com.webmethods.bpo.portlet.wm_mon_service_list.Mon_service_list.getSearchResults(Mon_service_list.java:570)
a
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2010-09-06 10:07:29 IST (Framework : INFO) [RID:59] - Error executing search. Have a System Administrator verify the Integration Server settings at Administration -> My webMethods -> System Settings.
com.webmethods.portal.PortalException: Error executing search. Have a System Administrator verify the Integration Server settings at Administration -> My webMethods -> System Settings.
at com.webmethods.bpo.portlet.wm_mon_service_list.Mon_service_list.getList_getList(Mon_service_list.java:935)
at com.webmethods.bpo.portlet.wm_mon_service_list.Mon_service_list.search(Mon_service_list.java:520)
at com.webmethods.portal.portlet.wm_commonsearchresults.mechanics.CommonsearchresultsMechanics.getSearchResults(CommonsearchresultsMechanics.java:89) ]]> Portal / My webMethods Server (MwS) maddy http://www.wmusers.com/forum/showthread.php?t=19856 Problem in getting stored procedure resultset in Order http://www.wmusers.com/forum/showthread.php?t=19855&goto=newpost Sun, 05 Sep 2010 19:24:58 GMT Hi All, I m getting a strange problem. I have a JDBC adapter for calling a stored procedure which returns nearly 32 fields in resultset. The order... Hi All,
I m getting a strange problem. I have a JDBC adapter for calling a stored procedure which returns nearly 32 fields in resultset. The order of the output parameters of the Adapter service is not same as the order in which the store procedure returns the values. Is it a problem? Do we need to maintain the order of the parameters when we are giving the names of the parameters same as declared in the Stored procedure?

My problem is even if the order is different, i m getting correct values in output in one server. While in another server same adapter service is not giving values in proper order. e.g. Expected is
Name = Sush
Age = 27
country = India

Actual is
Name = 27
Age = India
Country = Sush

Both the server runs WM 7.1.2

What I traced is, in the second server, some fixes are not there, those are present in the 1st server.

Does it matter or I am missing something else.
Below are the list of fixes in both the servers.

Server 1 :

IS_7-1-2_XA_Fix3
IS_7.1.2_Core_Fix24
IS_7.1.2_FlatFile_Fix5
IS_7.1.2_Flow_Fix7
IS_7.1.2_PubSub_Fix7
IS_7.1.2_SrvPrtcl_Fix19
IS_7.1.2_WebSvcsXML_Fix18
IS_7.1.2_PkgMgmt_Fix4

Server 2 :

IS_7.1.2_Core_Fix24
IS_7.1.2_FlatFile_Fix5
IS_7.1.2_PubSub_Fix7
IS_7.1.2_SrvPrtcl_Fix12
IS_7.1.2_WebSvcsXML_Fix11
IS_7.1.2_PkgMgmt_Fix4

Please help....:sad: ]]> JDBC Adapter sushree http://www.wmusers.com/forum/showthread.php?t=19855 Finding Documents type in Dead letter Queue using Webmthods 7.1 Integration Server http://www.wmusers.com/forum/showthread.php?t=19854&goto=newpost Sat, 04 Sep 2010 21:46:58 GMT Hi i am working on webemethods 7.1 .Can u please tell me that is there any way to find the document type in the Dead letter Queue using the... Hi
i am working on webemethods 7.1 .Can u please tell me that is there any way to find the document type in the Dead letter Queue using the Integration server console . ]]> Managing webMethods Broker Saurabh Agrahari http://www.wmusers.com/forum/showthread.php?t=19854 SOAP Error http://www.wmusers.com/forum/showthread.php?t=19853&goto=newpost Fri, 03 Sep 2010 20:09:20 GMT hello all I am receiving the follow error when doing a webservice call. _An error occurred while tracing.... hello all I am receiving the follow error when doing a webservice call.

An error occurred while tracing.
com.wm.app.b2b.server.ServiceException: [ISS.0088.9139] Output parameters do not conform to targetOutputSignature:
errorCode=VV-002
pathName=/tns:TrackPackagesByPinResponse/tns:TrackingInformationList/tns:TrackingInformation[0]/tns:Scans/tns:Scan[1]/tns:ScanDetails
errorMessage=[ISC.0082.9026] Undefined Object found
errorCode=VV-002
pathName=/tns:TrackPackagesByPinResponse/tns:TrackingInformationList/tns:TrackingInformation[0]/tns:Scans/tns:Scan[2]/tns:ScanDetails
errorMessage=[ISC.0082.9026] Undefined Object found
errorCode=VV-002
pathName=/tns:TrackPackagesByPinResponse/tns:TrackingInformationList/tns:TrackingInformation[0]/tns:Scans/tns:Scan[3]/tns:ScanDetails
errorMessage=[ISC.0082.9026] Undefined Object found

IDEAS?
]]> Flow and Java services MarlonRea http://www.wmusers.com/forum/showthread.php?t=19853 AS2 profile import error. Null Key http://www.wmusers.com/forum/showthread.php?t=19852&goto=newpost Fri, 03 Sep 2010 16:03:52 GMT Hi, I am fairly new to wM. I was asked to setup the AS2 profile for a new partner. I have never done an AS2 profile before. It was exported from... Hi,

I am fairly new to wM. I was asked to setup the AS2 profile for a new partner. I have never done an AS2 profile before. It was exported from DEV TN and is then imported into Production TN. The error message was BAC.0001.0060 RuntimeException: Cannot insert null key. I have attached the full text of the error message. Do I need to remove the Partners test certs before iimporting? Or is it something else? Thanks in advance!

Attached Files

TN Error.txt (8.0 KB)

]]> Trading Networks Baughmanj http://www.wmusers.com/forum/showthread.php?t=19852 Import/Export Users http://www.wmusers.com/forum/showthread.php?t=19851&goto=newpost Fri, 03 Sep 2010 12:43:23 GMT Hi. I am trying to export user/groups/roles from one MWS to another environment. Anyone can help me out? I have read the documentation but I... Hi.

I am trying to export user/groups/roles from one MWS to another environment.

Anyone can help me out?

I have read the documentation but I am not able to do this....:eek: ]]> Portal / My webMethods Server (MwS) lcgs13 http://www.wmusers.com/forum/showthread.php?t=19851 Storing system properties with TN ? http://www.wmusers.com/forum/showthread.php?t=19850&goto=newpost Fri, 03 Sep 2010 11:45:23 GMT Hello, This is my first and probably not last post on this forum. I started using webMethods a couple of weeks ago, and got pushed into a project... Hello,

This is my first and probably not last post on this forum. I started using webMethods a couple of weeks ago, and got pushed into a project right away where nobody has a big experience about webMethods and TN.

I have a question concerning trading networks. I understand that basically you can send documents to it, that will be processed, and from it you can get another document in response.

But what we want here is to use TN as a way to store some configuration properties. That is, store a file ONCE, and later on we can ask to access the file and get the configuration.

Is this a correct use of TN? Or a misusage of it?

What I want is to request for the file information, and automatically have a document filled in Developer, the document containing all the fields present in the XML file I would have stored in TN.

Thank you in advance ]]> Trading Networks Francoyy http://www.wmusers.com/forum/showthread.php?t=19850 Migration of flow services between environments http://www.wmusers.com/forum/showthread.php?t=19849&goto=newpost Fri, 03 Sep 2010 08:10:55 GMT We are currently using the publish and subscribing of releases method to migrate code between different environments. I would like to know if we... We are currently using the publish and subscribing of releases method to migrate code between different environments.
I would like to know if we can use deployer to perform these tasks and also let me know which is the better and preferred method.

Also i would like to reveal that we rarely migrate a lot of packages and most of the time it will be just a flow service or a folder in the package. ]]> Managing webMethods Integration Server murali.thangavelu http://www.wmusers.com/forum/showthread.php?t=19849 Document/Literal Coder: decoding error; cant convert SOAP Message to IS Docume http://www.wmusers.com/forum/showthread.php?t=19848&goto=newpost Thu, 02 Sep 2010 15:16:59 GMT Hello, once again I am asking for help and all that is given is greatly appriacted. I am receiving the following error when trying to create a SOAP... Hello, once again I am asking for help and all that is given is greatly appriacted. I am receiving the following error when trying to create a SOAP message from a webservice call into a IS document.

com.wm.app.b2b.server.ServiceException: com.wm.soap.coder.SoapCoderRuntimeException: [ISC.0076.9222] Document/Literal Coder: decoding error; cant convert SOAP Message to IS Document
at pub.clientimpl.soapClient(clientimpl.java:1903)
at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:631)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:189)
at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324)
at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:581)
at com.wm.lang.flow.FlowState.stepIncremental(FlowState.java:491)
at com.wm.lang.flow.FlowState.invoke(FlowState.java:379)
at wm.server.flowimpl.stepFlow(flowimpl.java:183)
at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:413)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:631)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119)
at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:151)
at com.wm.app.b2b.server.HTTPDispatch.handleRequest(HTTPDispatch.java:186)
at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:329)
at com.wm.util.pool.PooledThread.run(PooledThread.java:118)
at java.lang.Thread.run(Thread.java:595) ]]> Flow and Java services MarlonRea http://www.wmusers.com/forum/showthread.php?t=19848 How should i proceed? http://www.wmusers.com/forum/showthread.php?t=19847&goto=newpost Thu, 02 Sep 2010 12:05:19 GMT Hi forum guys, Please guide me here Am presently working as a Project coordinator in a firm which works on web methods 2.5(very old version)... Hi forum guys,

Please guide me here

Am presently working as a Project coordinator in a firm which works on web methods 2.5(very old version)
we normaly harvest data from web site(Documents or datas for the clients)and store it in the form of WIDL(web interface definition language)and send it to the clients

am looking for a job change, and has undergone trainign in web methods 7.x

Kindly tell me, how can i apply for jobs with my project management exp(total wrk exp abpve 5 years)

should i be applying for development side or project mamangemt/TL side?

should i learn about Project depolyment also?

if neede,please help me to get the materials necessery for all those

Thanks,
Ji.. ]]> jithugj http://www.wmusers.com/forum/showthread.php?t=19847