Hi,
I am using APEX20.1, DB, Oracle DB 19
I have a simple Faceted Search Page with 4 facets (all checkbox).
The CR runs correctly displaying all records correctly. However, the facets region fails with error "Error : SyntaxError: Unexpected end of JSON input". The numbers are not calculated for the facets. I get the below error in debug
Exception in "Faceted Search":
Error Stack: ORA-00905: missing keyword
ORA-06512: at "APEX_200100.WWV_FLOW_FACETED_SEARCH", line 1211
ORA-06512: at "APEX_200100.WWV_FLOW_EXEC", line 2684
ORA-06512: at "SYS.DBMS_SQL", line 2144
ORA-06512: at "APEX_200100.WWV_FLOW_EXEC_LOCAL", line 216
ORA-06512: at "APEX_200100.WWV_FLOW_EXEC_LOCAL", line 1345
ORA-06512: at "APEX_200100.WWV_FLOW_EXEC", line 2675
ORA-06512: at "APEX_200100.WWV_FLOW_FACETED_SEARCH", line 1105
ORA-06512: at "APEX_200100.WWV_FLOW_FACETED_SEARCH", line 2818
ORA-06512: at "APEX_200100.WWV_FLOW_REGION_NATIVE", line 2576
ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 2317
ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 3193
Backtrace: ORA-06512: at "APEX_200100.WWV_FLOW_FACETED_SEARCH", line 1211
ORA-06512: at "APEX_200100.WWV_FLOW_EXEC", line 2684
ORA-06512: at "SYS.DBMS_SQL", line 2144
ORA-06512: at "APEX_200100.WWV_FLOW_EXEC_LOCAL", line 216
ORA-06512: at "APEX_200100.WWV_FLOW_EXEC_LOCAL", line 1345
ORA-06512: at "APEX_200100.WWV_FLOW_EXEC", line 2675
ORA-06512: at "APEX_200100.WWV_FLOW_FACETED_SEARCH", line 1105
ORA-06512: at "APEX_200100.WWV_FLOW_FACETED_SEARCH", line 2818
ORA-06512: at "APEX_200100.WWV_FLOW_REGION_NATIVE", line 2576
ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 2317
ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 3193
ORA-06512: at "APEX_200100.WWV_FLOW", line 2922
If I have only 1 facets, the calculations are done correctly, more than 1 facets it throws error.
When I click on any facets , the data gets refreshed correctly. Just that the totals for the facets are not calculated and I get the JSON error
I am not able to recreate the same on apex.oracle.com.
Any ideas how to solve this please? - (I know its tough to debug without example. :( )
Edit - I created the same example on apex.oracle.com. With the same data and query, it WORKS fine there. :(
ws - vpagmws
user - testuser
pwd - ABCabc@123
app - 21281 - (VP202)
page - 3 - Test Faceted Search
Thanks,
Veerendra.