Theme Roller not saving changes on a 5.1 ORDS standalone environment

A very quick entry so we have this written down and so that it may help anyone in the future who faces the same problem..

We were having a problem on some of our new 5.1 environments where when using the theme roller and saving changes the save process was not working. When looking in the browser console we could see “500 (Server Error)” errors:

It was eventually traced down to not starting ORDS with the JAVA_OPTIONS variable, i.e.

export JAVA_OPTIONS="-Dorg.eclipse.jetty.server.Request.maxFormContentSize=3000000"

as can be found detailed in the guide on Oracle Base for configuring Oracle REST Data Services (ORDS) in standalone mode here.

Setting this and restarting ORDS fixed it.

Author: Paul Jones

Job Title: Oracle APEX Development Consultant

Bio: Paul is a Development Consultant at DSP-Explorer. Paul has a BSc in Computing from the University of Leeds and is now building on considerable experience in development and support using Oracle PL/SQL and Oracle E-Business Suite (EBS). Paul is employing APEX to provide quality, bespoke software solutions both internally and to a range of organisations.