JADE Environment Development Ideas

What's new in the upcoming JADE release?


The JADE 2022 release meets tomorrow’s business demands.

Start your update to JADE's latest release

RPS - ability to skip transaction on SQL where SQL operation fails

Currently, the data pump halts and prevents the system from continuing if the SQL operation has failed. In some cases, this may be due to a bad virtual mapping (exceed the string limit). This would require a code fix on primary and rebuild to move past this. It would be good to have an option to skip a certain transaction (apply transaction in Jade DB, but ignore the SQL operation) and provide a log of what was skipped, for manual intervention.

  • Thaban Segaran
  • Dec 4 2019
  • Needs review
  • Attach files
  • Ty Baen-Price commented
    20 Dec, 2019 01:30am

    No, it doesn't involve INSERTs at all. There is an emergency bypass mechanism for failing transactions, but it is intended for emergencies only. 

    I think we would be unlikely to make a GUI friendly way to do this because it's something you should never have to do in the first place. You should rarely, if ever, have to manually intervene in the operation of an rps node.

  • Thaban Segaran commented
    5 Dec, 2019 03:07pm

    Hi Ty,


    I think I may know the unpublished way (involves doing an INSERT command), but is there a way we can get a more GUI friendly way to do this on the RPS Manager. Especially with logs, when you have to continuously skip them.



  • Ty Baen-Price commented
    5 Dec, 2019 02:59am

    This exists but is unpublished for historical reasons. Please contact JADE Support.