Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-7252

"ORA-00942: table or view does not exist" when starting the server with Oracle cache store

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.0.0.Final
    • 9.0.0.Final
    • Loaders and Stores
    • None

      Exception thrown during start. The tables are created successfully on Oracle, but during the index check it throws:

      Caused by: org.infinispan.persistence.spi.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.timestampIndexExists(AbstractTableManager.java:151)
	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.createTimestampIndex(AbstractTableManager.java:127)
	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.start(AbstractTableManager.java:61)
	at org.infinispan.persistence.jdbc.common.AbstractJdbcStore.initializeConnectionFactory(AbstractJdbcStore.java:163)
	at org.infinispan.persistence.jdbc.common.AbstractJdbcStore.start(AbstractJdbcStore.java:55)
	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.start(JdbcStringBasedStore.java:95)
	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$start$0(PersistenceManagerImpl.java:156)
	at java.util.ArrayList.forEach(ArrayList.java:1249)
	at org.infinispan.persistence.manager.PersistenceManagerImpl.start(PersistenceManagerImpl.java:172)

              gfernand@redhat.com Gustavo Fernandes (Inactive)
              gfernand@redhat.com Gustavo Fernandes (Inactive)
              Archiver:
              rhn-support-adongare Amol Dongare

                Created:
                Updated:
                Resolved:
                Archived: