[Geoserver-devel] [jira] (GEOS-6424) Importer fails to import into Oracle data in geographic coordinates

GeoServer GeoServer Developer
1

Andrea Aime created an issue

GeoServer / BugGEOS-6424

Importer fails to import into Oracle data in geographic coordinates

Issue Type:

BugBug

Assignee:

Justin Deoliveira

Components:

Importer

Created:

30/Mar/14 10:15 AM

Priority:

MajorMajor

Reporter:

Andrea Aime

 
30 mar 15:14:34 ERROR [geoserver.importer] - Error occured during import
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.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-13249: Only alphanumeric characters and "_" are allowed in SDO_DIMNAME
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.CHK_SDO_DIMNAME", line 11
ORA-04088: error during execution of trigger 'MDSYS.CHK_SDO_DIMNAME'
ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", 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

Add Comment

Add Comment

This message was sent by Atlassian JIRA (v6.1.6#6162-sha1:7af547c)

Atlassian logo