Comments (6)
that looks like the Spatial Index appears to be broken on your database. From here, I cannot see the cause for this. You might try:
- navigate to Supporting Objects
- Deinstall Supporting Objects
- Install Supporting Objects again (this should recreate all the Spatial Indexes)
Verify that you get no errors during Supporting objects reinstallation. If you get errors, please share them here.
After that, try to load the "full dataset" again and let us know.
from apex.
While I could not find the option "Deinstall Supporting Objects", I selected the "Remove All Supporting Objects" on the right hand pane. Afterwards, I selected "Install Supporting Objects" also in right hand pane. I received all green confirmation of successes.
In re-trying the Load Full Dataset, I still received an error, similar to previous one.
is_internal_error: false
ora_sqlcode: -29861
ora_sqlerrm: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 56 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2491 ORA-06512: at "ABBREV_BACK.EBA_SAMPLE_MAP_LOAD_DATA", line 38 ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856 ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 330 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC", line 414 ORA-06512: at "APEX_220100.WWV_FLOW_EXEC_LOCAL", line 2901 ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2618 ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2654 ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 35 ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 1279 ORA-06512: at "APEX_220100.WWV_FLOW_PLUGIN", line 3093
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 1591063652815334462
component.name: Load Full Dataset
error_backtrace:
ORA-06512: at "ABBREV_BACK.EBA_SAMPLE_MAP_LOAD_DATA", line 38
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 56
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2491
ORA-06512: at "ABBREV_BACK.EBA_SAMPLE_MAP_LOAD_DATA", line 38
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 330
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC", line 414
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC_LOCAL", line 2901
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2618
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2654
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 35
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 1279
ORA-06512: at "APEX_220100.WWV_FLOW_PLUGIN", line 3093
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS", line 170
error_statement:
begin begin
eba_sample_map_load_data(
p_load_from => :P501_SOURCE,
p_states_file_name => :P501_STATES_FILE,
p_airports_file_name => :P501_AIRPORTS_FILE,
p_proxy_override => :P501_PROXY_OVERRIDE );
end;
end;
from apex.
hmmm ... this is odd - did not see that ever before.
- Is Spatial (SDO_GEOMETRY type) available in your database?
- You might try the following:
- Go to SQL Commands and drop the Spatial Indexes
drop index eba_sample_map_airports_sx;
drop index eba_sample_map_simplestates_sx;
create index eba_sample_map_states_sx;
- Then load the data
- Then recreate the Spatial Indexes in SQL Commands again
create index eba_sample_map_airports_sx on eba_sample_map_airports(geometry)
indextype is mdsys.spatial_index_v2
parameters( 'layer_gtype=POINT')
/
create index eba_sample_map_simplestates_sx on eba_sample_map_simple_states(geometry)
indextype is mdsys.spatial_index_v2
/
create index eba_sample_map_states_sx on eba_sample_map_states(geometry)
indextype is mdsys.spatial_index_v2
/
Again - so far I have no idea where this comes from. Any specifics about your database environment? Version? Spatial available or not?
regards
-Carsten
from apex.
Possibly there are limitations in the DBMS environment which is outside of my ownership or management. I can confirm that I have used SDO_GEOMETRY
in this database for a fully functioning map in a different APEX application with placemarkers using Lat/Lon coordinates stored in a database table.
SELECT * FROM V$VERSION
From a Burleson post, "Detect Spatial Used and Installed":
select decode(count(*), 0, 'No', 'Yes') c1 from (select 1 from all_sdo_geom_metadata where rownum = 1);
Regarding your specific instructions, your last CREATE INDEX
command in first code block does not work:
But after running the first two commands to drop the indexes, I get same error in loading the dataset.
is_internal_error: false
ora_sqlcode: -29861
ora_sqlerrm: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 56 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2491 ORA-06512: at "ABBREV_BACK.EBA_SAMPLE_MAP_LOAD_DATA", line 38 ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856 ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 330 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC", line 414 ORA-06512: at "APEX_220100.WWV_FLOW_EXEC_LOCAL", line 2901 ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2618 ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2654 ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 35 ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 1279 ORA-06512: at "APEX_220100.WWV_FLOW_PLUGIN", line 3093
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 1591063652815334462
component.name: Load Full Dataset
error_backtrace:
ORA-06512: at "ABBREV_BACK.EBA_SAMPLE_MAP_LOAD_DATA", line 38
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 56
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2491
ORA-06512: at "ABBREV_BACK.EBA_SAMPLE_MAP_LOAD_DATA", line 38
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 330
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC", line 414
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC_LOCAL", line 2901
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2618
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2654
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 35
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 1279
ORA-06512: at "APEX_220100.WWV_FLOW_PLUGIN", line 3093
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS", line 170
error_statement:
begin begin
eba_sample_map_load_data(
p_load_from => :P501_SOURCE,
p_states_file_name => :P501_STATES_FILE,
p_airports_file_name => :P501_AIRPORTS_FILE,
p_proxy_override => :P501_PROXY_OVERRIDE );
end;
end;
from apex.
ah - now I see that. In my previous comment the first three statements were intended as DROP INDEX statements. The idea is:
- drop all the spatial indexes
- then do the "full dataset loading"
- recreate all the indexes.
Thus it should be three times DROP INDEX above. Can you try that, please?
from apex.
Yes, that worked! With dropping the spatial indexes, I was able to successfully run "full dataset loading" without any error and then I was able to successfully recreate the three indexes. I can now see all state polygons in the US States (flat) page.
If I am not an unusual case, consider adding same above instructions in a README or in APEX application loading data page for future users. Thank you for your patience and help!
from apex.
Related Issues (20)
- Does not install in APEX 21.1.3 environment HOT 1
- Floating label
- How to setup a minimum and maximun automatic zoom for entire app? HOT 1
- Universal Theme 23.1 Reference Error exporting flow 207372. ORA-01403: no data found (when export YAML/JSON)
- Improve Poll: Add conditions to questions
- Improve Poll: add others text for pick one questions
- Error creating Opportunities on app Opportunities HOT 1
- Sugestão de palpites HOT 1
- Sumário de prêmio (card)
- Ranking da rodada
- Autorest wrongly generating url
- Grap Visualization (Preview)
- Custom Attributes and CSS Class UX Improvment
- There was an error with <sample-application-search>
- "Sample Workflow, Approvals, and Tasks" Example: The example has an error in renewing the task after expiration.
- Missing Arrow Icons on Marker Ends in Dynamic Graph Layouts
- 'on create' action for task definitions doesn't work
- First error code [4035] First error message: [RR_4035 SQL Error [ ORA-01840: input value not long enough for date format Database driver error... Function Name : Execute SQL Stmt : SELECT COUNT(1) AS CANTIDAD FROM LECTURAS.CM_CLECT_CICLO A WHERE A.UPLOADED = '1' AND TRUNC(UPDATED_AT) = TO_DATE(TO_CHAR(0.000000000000000),'YYYYMMDD')
- APEX crack tools
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from apex.