java.sql.SQLException: ORA-00600: Interner Fehlercode, Argumente: [ttcgcshnd-1], [0], [], [], [], [], [], []

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Oracle JDBC Problem
    via by 843797,
  • Like is done in RDBMServices, I think this SQL should have had "{ts " added to the beginning and "}" added to the end of the timestamp when the database supports it to allow it to work with our Oracle setup. I think the query should have looked like this: SELECT ENTITY_TYPE_ID, ENTITY_KEY, INVALIDATION_TIME FROM UP_ENTITY_CACHE_INVALIDATION WHERE 1 = 1 AND ENTITY_TYPE_ID = 5 AND INVALIDATION_TIME > '{ts 2003-01-15 08:29:45.638}' Here is the exception and other messages from the log: ============================== DEBUG [Thread-54] root.[] Jan/15 10:30:45 - RDBMInvalidCacheableEntityStore.primSelect(): SELECT ENTITY_TYPE_ID, ENTITY_KEY, INVALIDATION_TIME FROM UP_ENTITY_CACHE_INVALIDATION WHERE 1 = 1 AND ENTITY_TYPE_ID = 5 AND INVALIDATION_TIME > '2003-01-15 08:29:45.638' ERROR [Thread-54] root.[] Jan/15 10:30:45 - EXCEPTION: java.sql.SQLException: ORA-01861: literal does not match format string java.sql.SQLException: ORA-01861: literal does not match format string at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:943) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2119) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2324) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:627) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:162) at org.jasig.portal.concurrency.caching.RDBMCachedEntityInvalidationStore.primSelect(RDBMCachedEntityInvalidationStore.java:393) at org.jasig.portal.concurrency.caching.RDBMCachedEntityInvalidationStore.selectAfter(RDBMCachedEntityInvalidationStore.java:528) at org.jasig.portal.concurrency.caching.RDBMCachedEntityInvalidationStore.findAfter(RDBMCachedEntityInvalidationStore.java:196) at org.jasig.portal.concurrency.caching.ReferenceInvalidatingEntityCache.removeInvalidEntities(ReferenceInvalidatingEntityCache.java:205) at org.jasig.portal.concurrency.caching.ReferenceInvalidatingEntityCache.cleanupCache(ReferenceInvalidatingEntityCache.java:121) at org.jasig.portal.concurrency.caching.ReferenceEntityCache$CacheSweeper.run(ReferenceEntityCache.java:75) at java.lang.Thread.run(Thread.java:536) ERROR [Thread-54] root.[] Jan/15 10:30:45 - ReferenceInvalidatingEntityCache.removeInvalidEntries(): Problem retrieving Invalid Entities ORA-01861: literal does not match format string ==============================
    via by Brad Johnson,
    • java.sql.SQLException: ORA-00600: Interner Fehlercode, Argumente: [ttcgcshnd-1], [0], [], [], [], [], [], [] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:538) at oracle.sdovis.util.DBTable.query(DBTable.java:110) at oracle.eLocation.console.VisMetaImpl.getStyles(VisMetaImpl.java:308) at oracle.eLocation.console.VisMetaImpl.getAllStyles(VisMetaImpl.java:287) at oracle.eLocation.console.JTableStyleModel.reloadStyleData(JTableStyleModel.java:124) at oracle.eLocation.console.StyleColorPanel$18.componentShown(StyleColorPanel.java:320) at java.awt.Component.processComponentEvent(Component.java:3599)

    Users with the same issue

    Unknown visitor1 times, last one,
    rp
    rp1 times, last one,
    Unknown visitor2 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    28 more bugmates