Thursday, October 25, 2012

RedPrairie WM New Features (Technical)

This is a list of technical enhancements over the last few releases. This list is not complete and if I am wrong on exact versions, please let me know.
  1. Groovy
      2. 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:
      • Calling external web services
      • Calling 3rd party java applications, e.g. sftp, svn etc.
      • Represent complex logic
      Groovy should be a key component of your overall solution. If you are not seeing any groovy in your code, make sure you have the right folks in your team. If you are doing in-house development, then invest in some training.
  2. RF Forms in Java
      3. 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.
  3. Jasper Reports
      4. 2011.2
      It is part of 2011.2 and it looks promising.
  4. HTTP Protocol used by MOCA
      5. 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.
  5. Query level hooks in MOCA
      6. 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
  6. Clustering enhancements
      7. 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.
  7. Active X completely removed
      8. 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.
Also see RedPrairie Functional Enhancements
Posted by at
Labels:

33 comments:

  1. RameshNovember 3, 2012 at 7:20 PM

    Hi Saad,

    Excellent 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.

    ReplyDelete
  2. AnonymousJanuary 31, 2013 at 6:56 AM

    Hi Saad,

    I 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

    ReplyDelete
    Replies
    1. Saad AhmadFebruary 4, 2013 at 10:01 AM

      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

      Delete
  3. AnonymousFebruary 5, 2013 at 9:05 AM

    Hi Saad,

    Thanks 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.




    ReplyDelete
    Replies
    1. Saad AhmadFebruary 5, 2013 at 10:25 AM

      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.

      See 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.

      Delete
    2. AnonymousFebruary 5, 2013 at 11:15 AM

      Thanks a lot for this information.

      Can you please let me know your thoughts about the second option,i.e. about the Java Moca Web service component?

      Delete
  4. AnonymousNovember 26, 2013 at 12:48 AM

    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

    ReplyDelete
  5. UnknownFebruary 21, 2014 at 2:58 AM

    Hello Saad,

    I'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/

    ReplyDelete
    Replies
    1. Saad AhmadFebruary 23, 2014 at 2:32 AM

      Jasper is not supported until 2011.2 version.

      I 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.

      Delete
  6. AnonymousMay 5, 2015 at 6:49 AM

    Hello Saad,

    I 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

    ReplyDelete
  7. IraOctober 7, 2015 at 10:28 AM

    Hello Saad,
    Here is what I need from red prairie. I want to scan a UPC and have it sent to a designated location?

    ReplyDelete
  8. UnknownApril 15, 2016 at 3:11 AM

    Hello Saad,

    I am review JDA 9.1 version, could you share how create a connection from client to Moca Server? Thank you!

    ReplyDelete
  9. NelsonApril 23, 2016 at 5:27 PM

    Hi Saad,

    I 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

    ReplyDelete
  10. Akash MaxMunusJanuary 31, 2017 at 7:10 AM

    hi , Informations shared is impressive , if anyone want to learn redprairie online course check http://www.maxmunus.com/

    ReplyDelete
  11. AnonymousMarch 25, 2017 at 2:05 PM

    Hi

    Is there any tutorial for MoCA and Rp

    ReplyDelete
  12. UnknownApril 12, 2017 at 2:56 AM

    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
    MaxMunus 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



    ReplyDelete
  13. AnonymousMay 9, 2017 at 5:01 AM

    This comment has been removed by the author.

    ReplyDelete
  14. AnonymousJune 5, 2017 at 10:05 PM

    Hello Saad,

    I 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

    ReplyDelete
  15. MaryJune 8, 2017 at 9:40 AM

    Anyone knows how to convert RPwriter reports into Jasper OR how to run RPwriter reports in WMS versions 9.1 -> 2017.1

    ReplyDelete
  16. AnonymousAugust 4, 2017 at 1:05 AM

    All / Saad - I am a WMS consultant and planning to learn RedPrairie.. Are there any documentaion available .. Please let me know

    ReplyDelete
  17. UnknownFebruary 12, 2018 at 11:48 AM

    Saad,

    I 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

    ReplyDelete
    Replies
    1. Saad AhmadMarch 13, 2018 at 4:49 PM

      Please see MOCA folder and then lib subfolder. You will see files like moca-core.jar there

      Delete
  18. VeronicaApril 20, 2018 at 8:44 PM

    Where can i found documention of red praire

    ReplyDelete
    Replies
    1. Saad AhmadApril 30, 2018 at 4:48 PM

      The help that is available with the client application is fairly decent.

      Delete
  19. UnknownOctober 22, 2018 at 8:27 AM

    Hello Saad,

    I am unable to connect the MOCA plugging in Jasepr studio could you please guide me with the document.

    ReplyDelete
  20. computergeek99April 3, 2019 at 1:28 PM

    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!

    ReplyDelete
  21. UnknownApril 4, 2019 at 6:27 AM

    Hi Saad,

    We 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?

    ReplyDelete
  22. computergeek99February 11, 2020 at 10:34 PM

    Query level hooks. How do they work?

    ReplyDelete
    Replies
    1. Saad AhmadFebruary 25, 2020 at 3:17 PM

      It 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)

      Delete
    2. computergeek99May 10, 2020 at 1:44 PM

      Hey Saad, I just wanted to say thanks for the information and the reply... I was able to successfully implement a QueryHook!

      Delete
  23. mahereJune 28, 2021 at 4:55 AM

    Hi Saad,

    Can 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

    ReplyDelete
  24. MARGARET MAGOTHEOctober 29, 2021 at 10:51 AM

    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 )
    Email: tdameritrade077@gmail.com

    ReplyDelete

Subscribe to: Post Comments (Atom)