After upgrading to APEX 5.1, refreshing the Theme (42) and setting the compatibility to 5.1, I get an error "Error: parsererror - SyntaxError: Unexpected end of JSON input" when using a Dynamic Action that does a "Set Value" using a SQL Statement (returning two columns). The "Affected Elements" is set to two Page Items.
The Dynamic Action fires on change of a Page Item. That Page Item is referred in the SQL Statement and thus defined in the "Items to Submit".
Running in debug mode shows no errors on the console - just that it's trying to use the first "Set Value" Action (of two). In the PLSQL Debug output i see:
Exception in "":
Sqlerrm: ORA-01403: no data found
Backtrace: ORA-06512: at "APEX_050100.WWV_FLOW_PLUGIN", line 1096
ORA-06512: at "APEX_050100.WWV_FLOW_PLUGIN", line 2303
ORA-06512: at "APEX_050100.WWV_FLOW_PLUGIN", line 3010
ORA-06512: at "APEX_050100.WWV_FLOW", line 4533
The original application - before upgrading the theme - works flawless in APEX 5.1 (same instance / workspace, just another app-id).
Switching the Compatibility Mode back to 5.0 has no effect. Setting the Compatibility Mode to 5.1 in the original app does not result in any error.
So it seems it has something to do with Refreshing the UT....