com.solarmetric.jdbc.ReportingSQLException

ORA-00942: table or view does not exist {prepstmnt 7569347 SELECT SEQUENCEX FROM MARY.JDO_SEQUENCEX WHERE PKX = ? FOR UPDATE [reused=0]} [code=942, state=42000]

Solutions on the web49

  • via Oracle Community by 3004, 1 year ago
    ORA-00942: table or view does not exist {prepstmnt 7569347 SELECT SEQUENCEX FROM MARY.JDO_SEQUENCEX WHERE PKX = ? FOR UPDATE [reused=0]} [code=942, state=42000]
  • via Oracle Community by 3004, 1 year ago
    ERROR: relation "kodo_sequence_table" does not exist {prepstmnt 31538514 SELECT SEQUENCE_VALUE FROM KODO_SEQUENCE_TABLE WHERE ID = ? FOR UPDATE [reused=0]} [code=0, state=42P01]
  • ERROR: syntax error at or near "WHERE" {prepstmnt 16398807 SELECT AVG(t0.lengthinminutes) FROM WHERE t1.jdoclass = ? [reused=0]} [code=0, state=42601]
  • Stack trace

    • com.solarmetric.jdbc.ReportingSQLException: ORA-00942: table or view does not exist {prepstmnt 7569347 SELECT SEQUENCEX FROM MARY.JDO_SEQUENCEX WHERE PKX = ? FOR UPDATE [reused=0]} [code=942, state=42000] at kodo.jdbc.schema.DBSequenceFactory.getNext(DBSequenceFactory.java:227)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.