Hi there,
I have an application which I can't install anymore, neither in production nor in dev environment.
When I try to install the app I just get "GET_BLOCK Error".
So I activated debugging via "Monitor Activity" -> "Active Sessions" and tried it again.
Now I have a debug output, but unfortunately it doesn't help me and that's why I need your help :(
The first error entry says "Could not parse info:" followed by the first part of the .sql file.
A bit later it says "DBMS_SYS_SQL found" and "Error: GET_BLOCK Error."
And than it goes with this:
Exception in "begin for c1 in (select 1 from wwv_flow_company_schemas
where upper(schema) = upper(:P49_PARSE_AS)
and security_group_id = :flow_security_group_id) loop
wwv_flow_imp_parser.parse (
p_file_id => :P49_FILE_ID,
p_parse_as_schema => :P49_PARSE_AS,
p_install_as_flow => :P49_NEW_FLOW_ID,
p_original_flow_id => wwv_flow_imp_parser.get_flow_id(:P49_FILE_ID),
p_adjust_offset => :P49_IMP_FLOW_ID != :P49_NEW_FLOW_ID,
p_new_build_status => :P49_BUILD_STATUS );
end loop;
wwv_flow_data_upload.fix_pre42(p_flow_id => :P49_NEW_FLOW_ID );
:FB_FLOW_ID := :P49_NEW_FLOW_ID;
:FB_FLOW_PAGE_ID := '1';
:F4000_P1_FLOW := :P49_NEW_FLOW_ID;
:F4000_P1_PAGE := '1';
end;":
Error Stack: ORA-20987: APEX - GET_BLOCK Error. - Contact your application administrator.
Details about this incident are available via debug id "1047383".
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2961
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1053
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1420
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 1424
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2914
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2860
ORA-06512: at line 4
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
Backtrace: ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2961
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1053
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1420
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 1424
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2914
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2860
ORA-06512: at line 4
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2961
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1053
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1420
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 1424
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2914
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2860
ORA-06512: at line 4
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
Exception in "plsql process":
Error Stack: ORA-20987: APEX - GET_BLOCK Error. - Contact your application administrator.
Details about this incident are available via debug id "1047383".
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2387
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2961
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1053
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1420
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 1424
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2914
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2860
ORA-06512: at line 4
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 330
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC", line 394
ORA~
Backtrace: ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2961
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1053
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1420
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 1424
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2914
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2860
ORA-06512: at line 4
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2387
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2961
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1053
ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1420
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 1424
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2914
ORA-06512: at "APEX_210100.WWV_FLOW_IMP_PARSER", line 2860
ORA-06512: at line 4
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 330
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC", line 394
ORA-06512: at "APEX_210100.WWV_FLOW_EXEC_LOCAL", line 2880
ORA-06512: at "APEX_210100.WWV_FLOW_EXEC", line 4423
ORA-06512: at "APEX_210100.WWV_FLOW~
Could the experts help me out here please? :(
Thank you so much!
PS:
Apex Version is 21.1.1
DB Version is 19.0.0.0.0