java.sql.SQLException: ORA-13226: interface not supported without a spatial index ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 8 ORA-06512: at "MDSYS.SDO_3GL", line 1217

Oracle Community | chakra | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Mapviewer throwing ORA-13226: interface not supported ... intermittently

    Oracle Community | 6 years ago | chakra
    java.sql.SQLException: ORA-13226: interface not supported without a spatial index ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 8 ORA-06512: at "MDSYS.SDO_3GL", line 1217
  2. 0

    When converting legacy permissions algorithm in 5.2.3 in the Control Panel in the environments listed, you get errors in the console. # Navigate to Control Panel > Server Administration # Click on the Data Migration tab # Click 'Execute' to convert legacy permissions algorithm # You get the following errors in the console *DB2 9.7* {code}18:38:27,595 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data 18:38:27,647 FATAL [ConvertPermissionAlgorithm:131] com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-119, SQLSTATE=42803, SQLERRMC=CODEID, DRIVER=3.52.95 com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-119, SQLSTATE=42803, SQLERRMC=CODEID, DRIVER=3.52.95 at com.ibm.db2.jcc.a.ad.a(ad.java:666) at com.ibm.db2.jcc.a.ad.a(ad.java:60) at com.ibm.db2.jcc.a.ad.a(ad.java:127) at com.ibm.db2.jcc.a.rl.c(rl.java:2424) at com.ibm.db2.jcc.a.rl.d(rl.java:2401) at com.ibm.db2.jcc.a.rl.a(rl.java:1902) at com.ibm.db2.jcc.t4.db.g(db.java:138) at com.ibm.db2.jcc.t4.db.a(db.java:38) at com.ibm.db2.jcc.t4.t.a(t.java:32) at com.ibm.db2.jcc.t4.sb.h(sb.java:141) at com.ibm.db2.jcc.a.rl.Y(rl.java:1873) at com.ibm.db2.jcc.a.sl.bc(sl.java:2526) at com.ibm.db2.jcc.a.sl.gc(sl.java:2632) at com.ibm.db2.jcc.a.sl.a(sl.java:443) at com.ibm.db2.jcc.a.ib.a(ib.java:2016) at com.ibm.db2.jcc.a.ib.prepareStatement(ib.java:639) at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213) at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:364) at $Proxy0.prepareStatement(Unknown Source) at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:369) at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157) at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124) at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44) at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70) at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 18:38:27,650 INFO [ConvertProcess:43] Conversion complete{code} *Oracle 10.2* {code}20:25:19,058 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data 20:25:19,064 FATAL [ConvertPermissionAlgorithm:131] java.sql.SQLException: ORA-00979: not a GROUP BY expression java.sql.SQLException: ORA-00979: not a GROUP BY expression at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371) at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157) at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124) at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44) at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70) at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 20:25:19,066 INFO [ConvertProcess:43] Conversion complete{code} *PostgreSQL 9* {code}20:47:21,380 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data 20:47:21,403 FATAL [ConvertPermissionAlgorithm:131] org.postgresql.util.PSQLException: ERROR: column "resourcecode.codeid" must appear in the GROUP BY clause or be used in an aggregate function org.postgresql.util.PSQLException: ERROR: column "resourcecode.codeid" must appear in the GROUP BY clause or be used in an aggregate function at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371) at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157) at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124) at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44) at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70) at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 20:47:21,407 INFO [ConvertProcess:43] Conversion complete{code} *SQL Server 2008* {code}20:57:35,783 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data 20:57:35,792 FATAL [ConvertPermissionAlgorithm:131] java.sql.SQLException: Column 'ResourceCode.codeId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. java.sql.SQLException: Column 'ResourceCode.codeId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371) at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157) at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124) at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44) at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70) at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 20:57:35,794 INFO [ConvertProcess:43] Conversion complete{code} *Sybase 15.02* {code}19:40:04,928 DEBUG [MaintenanceUtil:75] Generating ResourceAction and ResourcePermission data 19:40:05,019 FATAL [ConvertPermissionAlgorithm:131] java.sql.SQLException: Invalid column name '100'. java.sql.SQLException: Invalid column name '100'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371) at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertResourcePermission(ConvertPermissionAlgorithm.java:365) at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:181) at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124) at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44) at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70) at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 19:40:05,021 INFO [ConvertProcess:43] Conversion complete{code}

    Liferay Issues | 5 years ago | Albert Lee
    java.sql.SQLException: ORA-00979: not a GROUP BY expression
  3. 0

    Import of database objects / metadata from MySQL fails

    Oracle Community | 7 years ago | 691757
    java.sql.SQLException: ORA-02019: connection description for remote database not found
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Passing complete sql query as a parameter to dataset in report

    Stack Overflow | 4 years ago | Bhaskar
    java.sql.SQLException: SQL string is not Query
  6. 0

    JBO-26080 error during commit

    Oracle Community | 9 years ago | 67175
    java.sql.SQLException: ORA-00936: missing expression
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-13226: interface not supported without a spatial index ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 8 ORA-06512: at "MDSYS.SDO_3GL", line 1217

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
    13 frames
  3. oracle.sdovis.theme
    PredGeomThemeProducer.prepareData
    1. oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:769)
    2. oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:280)
    2 frames
  4. oracle.sdovis
    MapMaker.renderMap
    1. oracle.sdovis.Theme.prepareData(Theme.java:189)
    2. oracle.sdovis.LoadThemeData2.run(LoadThemeData2.java:88)
    3. oracle.sdovis.DBMapMaker.prepareThemes2(DBMapMaker.java:2230)
    4. oracle.sdovis.DBMapMaker.prepareThemes(DBMapMaker.java:2164)
    5. oracle.sdovis.DBMapMaker.renderEm(DBMapMaker.java:1708)
    6. oracle.sdovis.MapMaker.renderMap(MapMaker.java:1673)
    6 frames
  5. oracle.mapviewer.builder
    DrawPanel$MapperThread.run
    1. oracle.mapviewer.builder.control.DrawPanel$MapperThread.mapRun(DrawPanel.java:3063)
    2. oracle.mapviewer.builder.control.DrawPanel$MapperThread.run(DrawPanel.java:2852)
    2 frames