APEX Using SQL With Json Table Is Returning An "Internal Server Error" - 7445 (Doc ID 2262789.1)

Last updated on MAY 11, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0.4.00.12 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT:
********************
Apex 5.0.4.00.12
Linux x86-64
DB 12.1.0.2


ISSUE:
*********
When attempting to create a report region on APEX using SQL with json table is returning an "Internal Server Error" 7445


ERROR:
*****************
ORA-07445 [qknExpRegIni_int()+100]

Changes

Using APEX SQL query on JSON table and getting "Internal Server Error". 

The error occurs:

 when validating SQL in the "SQL Query" edit box
 when saving the page containing the "Classic Report"
 when opening the "Classic Report" page for editing.

Same test work with SQL Developer and SQL Plus but not with the Apex
interface

Here was the query reproducable:

SELECT id,
url,
business_key,
suspended,
ended,
process_definition_id,
process_definition_url,
process_definition_key,
activity_id,
tenant_id
FROM
JSON_TABLE (
'{"data":[{"id":"170001","url":"http://vmsebd01.tse.jus.br:8080/dactiviti-rest/service/runtime/process-instances/170001","businessKey":null,"suspended":false,"ended":false,"processDefinitionId":"procAvaliacaoRA:1:167504","processDefinitionUrl":"http://vmsebd01.tse.jus.br:8080/dactiviti-rest/service/repository/process-definitions/procAvaliacaoRA:1:167504","processDefinitionKey":"procAvaliacaoRA","activityId":"atribuirRA","variables":[],"tenantId":"","name":null,"completed":false},{"id":"170036","url":"http://vmsebd01.tse.jus.br:8080/dactiviti-rest/service/runtime/process-instances/170036","businessKey":null,"suspended":false,"ended":false,"processDefinitionId":"procAvaliacaoRA:1:167504","processDefinitionUrl":"http://vmsebd01.tse.jus.br:8080/dactiviti-rest/service/repository/process-definitions/procAvaliacaoRA:1:167504","processDefinitionKey":"procAvaliacaoRA","activityId":"atribuirRA","variables":[],"tenantId":"","name":null,"completed":false}],"total":2,"start":0,"sort":"id","order":"asc","size":2}'
, '$.data[*]'
COLUMNS (
id VARCHAR2 ( 50 CHAR ) PATH '$.id',
url VARCHAR2 ( 500 CHAR ) PATH '$.url',
business_key VARCHAR2 ( 100 CHAR ) PATH '$.businessKey',
suspended VARCHAR2 ( 5 CHAR ) PATH '$.suspended',
ended VARCHAR2 ( 5 CHAR ) PATH '$.ended',
process_definition_id VARCHAR2 ( 100 CHAR ) PATH
'$.processDefinitionId',
process_definition_url VARCHAR2 ( 500 CHAR ) PATH
'$.processDefinitionUrl',
process_definition_key VARCHAR2 ( 100 CHAR ) PATH
'$.processDefinitionKey',
activity_id VARCHAR2 ( 100 CHAR ) PATH '$.activityId',
tenant_id VARCHAR2 (3000 CHAR ) FORMAT JSON PATH
'$.tenantId'
)
)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms