Importer fails to import into Oracle data in geographic coordinates

Description

30 mar 15:14:34 ERROR [geoserver.importer] - Error occured during
java.io.IOException: Error occurred creating table
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:707)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:142)
at org.geoserver.importer.Importer.loadIntoDataStore(Importer.java:989)
at org.geoserver.importer.Importer.doIndirectImport(Importer.java:859)
at org.geoserver.importer.Importer.run(Importer.java:731)
at org.geoserver.importer.Importer.run(Importer.java:681)
at org.geoserver.importer.Importer$4.call(Importer.java:757)
at org.geoserver.importer.Importer$4.call(Importer.java:1)
at org.geoserver.importer.job.Job.call(Job.java:15)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang..java:662)
Caused by: java.sql.SQLException: ORA-13249: Only alphanumeric characters and are allowed in SDO_DIMNAME
ORA-06512: at , line 1723
ORA-06512: at , line 17
ORA-06512: at , line 11
ORA-04088: error during execution of trigger 'MDSYS.CHK_SDO_DIMNAME'
ORA-06512: at , line 43
ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1688)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1654)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.geotools.data.oracle.OracleDialect.postCreateTable(OracleDialect.java:963)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:704)
... 13 more

Environment

None

Activity

Show:
codehaus
April 10, 2015, 4:48 PM

CodeHaus Comment From: aaime - Time: Sun, 30 Mar 2014 14:27:18 -0500
---------------------
<p>Fixed back in GeoTools</p>

Andrea Aime
February 15, 2017, 11:48 AM

Mass closing all resolved issues not modified in the last 4 weeks

Assignee

Unassigned

Reporter

codehaus

Triage

None

Fix versions

Affects versions

None

Components

Priority

Medium
Configure