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 | 5 years ago
  1. 0

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

    Oracle Community | 5 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 | 4 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

    JBO-26080 error during commit

    Oracle Community | 9 years ago | 67175
    java.sql.SQLException: ORA-00936: missing expression
  6. 0

    Oracle Apps DBA stuff: R12 : Setup Purchasing Options Gives Error JBO-27122 You Have Encountered An Error

    blogspot.com | 5 months ago
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1

  1. qavid 1 times, last 5 months ago
18 unregistered visitors
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