Thu Apr 25 14:54:35 BST 2019: starting extract process...Thu Apr 25 14:54:35 BST 2019: reading attribute mapping file...Thu Apr 25 14:54:35 BST 2019: extract running on: 'V_MCP_EXTRACT_DEFT' with query: 'SELECT DEFECT, ACTIVITY, TYPE, REPAIR, DETAIL, LOCATION, PRIORITY, DUE, INSPECTED, SHAPE FROM V_MCP_EXTRACT_DEFT WHERE 1=1'Thu Apr 25 14:54:37 BST 2019: found geometry column: 'SHAPE' with SRID: 27700Thu Apr 25 14:54:37 BST 2019: writing features to shapefile...Thu Apr 25 14:54:44 BST 2019: Error: Exception mainException caught...java.sql.SQLException: ORA-20001: HIG-0287: Unknown geometry type - must be a point, line or polygonORA-06512: at "HIGHWAYS.HIG", line 1464ORA-06512: at "HIGHWAYS.NM3SDO", line 4534
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1073) at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:359) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:263) at bentley.exor.gis.SDE2SHP.generateShapeFile(SDE2SHP.java:388) at bentley.exor.gis.SDE2SHP.main(SDE2SHP.java:299)
Thu Apr 25 14:54:44 BST 2019: Error: shapefile creation failed!
This happened when attempting to extract Maintenance Manager defect data for MapCapture.
Check the geometry types in the table using this query, replacing the table name and spatial column (highlighted) with the details from your defects theme (you can view these in the Themes form)
select msdo.geoloc.sdo_gtype, count(*) from mai_defects_xy_sdo msdo group by msdo.geoloc.sdo_gtype;
select msdo.geoloc.sdo_gtype, count(*)
from mai_defects_xy_sdo msdo
group by msdo.geoloc.sdo_gtype;
Contact Bentley Support if any of the geometry types are invalid.
SELECT COUNT (*)
FROM defects def
WHERE def.def_easting IS NOT NULL
AND NOT EXISTS
(SELECT 'x'
FROM mai_defects_xy_sdo mxy
WHERE mxy.def_defect_id = def.def_defect_id);