java.sql.SQLException

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.

  • 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: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:969) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2387) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2660) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:777) at oracle.sdovis.theme.DynGeomThemeProducer.prepareData(DynGeomThemeProducer.java:241) at oracle.sdovis.Theme.prepareData(Theme.java:174) at oracle.sdovis.DBMapMaker$LoadThemeData.run(DBMapMaker.java:1740)

    Users with the same issue

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