- Groovy
- Calling external web services
- Calling 3rd party java applications, e.g. sftp, svn etc.
- Represent complex logic
- RF Forms in Java
- Jasper Reports
- HTTP Protocol used by MOCA
- Query level hooks in MOCA
- Clustering enhancements
- Active X completely removed
-
2007
This has been around for a while but it needs to be emphasized. Please use it when appropriate - it will make your life much easier. It allows you to create high quality solutions with much less effort, for example:
-
2009
Definitely a good direction to obsolete the old style RF forms in favor of Java. Now you have options to extend base forms rather than old way of copying code and changing it.
I would like to see something like DDA to work on RF so that people can develop simple forms without writing any code, but we are not there yet. But overall a good feature.
-
2011.2
It is part of 2011.2 and it looks promising.
-
2010+
Previously MOCA used a proprietary protocol for traffic between clients and servers. Now MOCA users http protocol. This is definitely a good direction. The connections are backwards compatible where new versions can open a Classic Port where older clients can connect to. New Clients can connect to older servers by using "host:port" syntax.
-
2011
So you find a badly written query that is deep within the standard code which is in C or Java. Previously the only option you had was to override the whole component; now it is possible to install a hook that would rewrite that query.
The performance is impressive. I ran a simple "select * from dual" 10,000 times where the hook scanned an array in Java to find the mapped rewritten query. The net overhead was about 2 seconds over the 10,000 executions. Exact times will be variable but it is an option in such cases.
Do not consider this as an option for enhancements, only use it when bug is a bad query deep within standard code which is in Java or C
-
2011
Earlier versions of MOCA were not cluster-aware. If you are using an active-active cluster, you needed to actively manage what runs on each node. Now you have setup that will be controlled by MOCA.
If you are using active-passive configuration, then you can probably keep using the OS level options but for active-active this will be very helpful.
-
2008
All Active X components are removed from the GUI and integrator explorer is no longer supported. There are ways to get older Integrator Explorer to work with newer versions but don't go there. Use the new screens that part of the Dlx Client.
Hi Saad,
ReplyDeleteExcellent Job of summarizing important features, keep it up.
Could you write-up few articles on Integrator?, would like to hear more from architect of Integrator. Some topics to suggest, undocumented features of RP Integrator, Integrator Performance Tuning Tips & Tricks, etc.
Really love to hear from you.
Investing online has been a main source of income, that's why knowledge plays a very important role in humanity, you don't need to over work yourself for money.All you need is the right information, and you could build your own wealth from the comfort of your home! Binary trading is dependent on timely signals, assets or controlled strategies which when mastered increases chance of winning up to 90%-100% with trading. It’s possible to earn $10,000 to $20,000 trading weekly-monthly in cryptocurrency(bitcoin) investment, just get in contact with Mr Bernie Doran my broker. I had almost given up on everything about binary trading and never getting my lost funds back, till i met with him, with his help and guidance now i have my lost funds back to my bank account, gained more profit and I can now trade successfully with his profitable strategies and signals! Reach out to him on Gmail ( BERNIEDORANSIGNALS@GMAIL.COM ) , or his WhatsApp : +1(424)285-0682 for inquiries
DeleteI lost my job few months back and there was no way to get income for my family, things was so tough and I couldn’t get anything for my children, not until a met a recommendation of an expert broker/trader Mr Bernie Doran////
Hi Saad,
ReplyDeleteI would like to know what are the different options to retrieve information from RP database(for example i need to check if a record exist in RP table from my java application and based on it do some operation) using an external java application.
Can i connect to the RP database using an sql driver and then execute the query or do i need to write a web service to send http request to the Moca server and then create a Java Moca component which will receive this request and perform a database query within the Java moca component to get the information
You should use the moca.jar available under $MOCADIR. The documentation for that is available under $MOCADIR as well. Our MOCA Client referenced in some of our blogs and downloadable at http://autoupdate.oracular.com/mocaclient is a java application
DeleteHi Saad,
ReplyDeleteThanks a lot for the reply.Let me give more details on what exactly i am looking for.
I am trying to write a java application for my client (which is using RedPrairie as the WMS).I have a scenario where i need to lookup some information in the RP table(for example i need to check if an order has reached the RP order table i.e. a record exist in RP order table).What are the different options available to lookup the RP database from an external java application.
I was thinking of two options:
1.Can i connect to the RP database using the database driver(with their connection details) and then start executing the sql query within my java application(like the same way how we connect to any database using a java application)?
Does RP allow external application to connect to their database?
2.Reading through the Moca tutorials i could see that we could develop a Moca Java Web service component and deploy the same to the Moca server.
Inside web service component i could write a service method to lookup the RP database by getting a connection using ConnectionUtils java class and call executeCommand() to execute the sql query against the database and get the result.
From my java application i could make a web service call to the Moca web service and call the service method to get the result.
These are just approaches i could derive reading through documents.
Just wanted to get your thought on the approaches.
Can you share me your view on these approaches.
You can use JDBC to connect to the database if you know connection details but I would recommend that you instead use moca.jar (moca-core.jar) in newer versions.
DeleteSee the moca documentation in $MOCADIR/docs. The DirectConnection will let you connect to host:port. Then ConnectionUtils will let you login and then from DirectConnection you can execute a MOCA Command.
This gives you ability to run MOCA Commands and SQLs - SQLS are just within square brackets.
Thanks a lot for this information.
DeleteCan you please let me know your thoughts about the second option,i.e. about the Java Moca Web service component?
heyy thanks for lot of information. Can you provide me the use of active perl,java,PHP,dot net as a third party for RP?? I am a fresher.. it will help me a lot
ReplyDeleteHello Saad,
ReplyDeleteI've been following your blog and explanations recently, I found it very useful.
I wonder if you have more information about integrating Jasper Reports inside RedPrairie/JDA Discrete. I've been trying to search a Jasper plugin for MOCA connection, but I couldn't find anything (although I'm connecting to 2010.2.8 version).
Also I have to design a sets of label with NiceLabel and Redpraire Discrete product.
I've been looking some Redprairie documentation regarding Nicelabel (using a CMD='moca command' to get the data for the label) and how to add the label to the application.
I'm a developer that comes from Redprairie Dispacher application that use iReports for the reports and labels.
My question is easy:
It is possible to run the label (from NiceLabel) to retrieve the data to fill the label's fields, and see how the data is visualize?
As an example of what I would like to see is like a preview in Report Designer or iReports.
As far as I know or learn, I have to do the export to POF, added to RP application and then execute it to see how it is printed.
Thank you very much and best regards.
Ruben Muñoz.
es.linkedin.com/pub/ruben-munoz-palomino/1b/692/3a0/
Jasper is not supported until 2011.2 version.
DeleteI assume you know how to get nice label to print and you are simply wanting to see how it looks like. That is not possible with standard Nice label integration that is available.
If this is something that you need - then an enhancement can be created.
Hello Saad,
ReplyDeleteI am Ganga Pradhan from Pune working for KPIT technology I need some help regarding the Redprarie 2013 installation.
We are facing the below issue while executing the db create scripts to created a database structure.
Database - sql server 2008 r2
Error is showing that we can not load the dll that is 32 bit compactible under the 64 bit machine. Our virtual machine is 64 bit.
Is there anyway we can resolved this issue without changing the machine to 32 bit.
Thanks in advance.
Regards
Ganga Pradhan
Hello Saad,
ReplyDeleteHere is what I need from red prairie. I want to scan a UPC and have it sent to a designated location?
That is done via storage configuration maint.
DeleteHello Saad,
ReplyDeleteI am review JDA 9.1 version, could you share how create a connection from client to Moca Server? Thank you!
Hi Saad,
ReplyDeleteI have installed WMS 9.1 and every time I start the MOCA Service (manually) it stops with error:
2016-04-23 12:20:51 Commons Daemon procrun stderr initialized
com.redprairie.moca.server.service.ServiceManagerException: Command exited with status 1
at com.redprairie.moca.server.service.ServiceTools.executeCommand(ServiceTools.java:124)
at com.redprairie.moca.server.service.JavaStartStopInfo.exec(JavaStartStopInfo.java:131)
at com.redprairie.moca.server.service.Service.start(Service.java:79)
at com.redprairie.moca.server.service.ServiceManagerWedge.startService(ServiceManagerWedge.java:81)
I can connect to the database, but I cannot understand where its going wrong.
Thank you for your time.
Regards,
Nelson
hi , Informations shared is impressive , if anyone want to learn redprairie online course check http://www.maxmunus.com/
ReplyDeleteHi
ReplyDeleteIs there any tutorial for MoCA and Rp
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in RedPrairie, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on RedPrairie. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us:
Name : Arunkumar U
Email : arun@maxmunus.com
Skype id: training_maxmunus
Contact No.-+91-9738507310
Company Website –http://www.maxmunus.com
This comment has been removed by the author.
ReplyDeleteHello Saad,
ReplyDeleteI am have installed the 9.1.x version, we are going to build some reports, whereby we need to deploy the MOCA Plugin for reporting tools.
Could you please suggest, where to locate the required plugin? Would be very much appreciate if can provide the path and/or filename from the installed MOCA package.
Thank you.
Kok
Anyone knows how to convert RPwriter reports into Jasper OR how to run RPwriter reports in WMS versions 9.1 -> 2017.1
ReplyDeleteAll / Saad - I am a WMS consultant and planning to learn RedPrairie.. Are there any documentaion available .. Please let me know
ReplyDeleteSaad,
ReplyDeleteI am trying to get Jasper Reports Designer working to compile reports for RedPrairie (mainly 2014.1). I see in previous posts you mention pulling down the MOCA.jar or MOCACORE.jar files, but I can't seem to find them in 2014 MOCADIR. Is it different for 2014. Also what is required to adding the connection file/info in Jasper Reports report designer?
Thanks!
Jeff
Please see MOCA folder and then lib subfolder. You will see files like moca-core.jar there
DeleteWhere can i found documention of red praire
ReplyDeleteThe help that is available with the client application is fairly decent.
DeleteHello Saad,
ReplyDeleteI am unable to connect the MOCA plugging in Jasepr studio could you please guide me with the document.
Hey Saad. I am really interested in the 'Query Level Hooks in MOCA'. Would you be able to elaborate on implementing this? I have searched through the change documentation for 2011, but didn't find anything... your help is appreciated!
ReplyDeleteHi Saad,
ReplyDeleteWe have implemented Moca Cluser in Application level. Moca Cluster leave Implicit transaction open which causing the version store to build up in tempdb in SQL server. Has anyone face similar issue? and what is the solution?
Query level hooks. How do they work?
ReplyDeleteIt is documented in the MOCA Developer Guide. Basically you end up creating code in java that would execute for every SQL that is executed. We, for example, utilized this concept to create a simple file where we put "from" and "to" SQLs to easily execute alternate SQLs. Note that SQLs are parameterized at this time so they would look the same even if the bind variable values are different (which is what we want)
DeleteHey Saad, I just wanted to say thanks for the information and the reply... I was able to successfully implement a QueryHook!
DeleteHi Saad,
ReplyDeleteCan you let me know if there is an option to create a drop down field on Page builders, having 4-5 options which user could select and execute require action using it?
Thanks,
maherep
All thanks to Mr Anderson for helping with my profits and making my fifth withdrawal possible. I'm here to share an amazing life changing opportunity with you. its called Bitcoin / Forex trading options. it is a highly lucrative business which can earn you as much as $2,570 in a week from an initial investment of just $200. I am living proof of this great business opportunity. If anyone is interested in trading on bitcoin or any cryptocurrency and want a successful trade without losing notify Mr Anderson now.Whatsapp: (+447883246472 )
ReplyDeleteEmail: tdameritrade077@gmail.com