org.apache.openjpa.persistence.PersistenceException: Protocol violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone, t0.time_out FROM COORD_JOBS t0 WHERE t0.bean_type = ? ORDER BY t0.created_time DESC) WHERE ROWNUM <= ? [params=(String) CoordinatorJobBean, (long) 50]} [code=17401, state=99999]

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.

  • Re: ReportingSQLException: Protocol violation
    via by Angelo K. Huang,
  • OpenJPA in JBoss EAP 6.1 | JBoss Developer
    via by Unknown author,
  • weblogic server failed to start
    via Stack Overflow by kharesoft
    ,
    • org.apache.openjpa.persistence.PersistenceException: Protocol violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone, t0.time_out FROM COORD_JOBS t0 WHERE t0.bean_type = ? ORDER BY t0.created_time DESC) WHERE ROWNUM <= ? [params=(String) CoordinatorJobBean, (long) 50]} [code=17401, state=99999] at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232) at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64) at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155) at org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:64) at org.apache.openjpa.jdbc.kernel.JDBCFetchConfigurationImpl.newResultList(JDBCFetchConfigurationImpl.java:234) at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:771) at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517) at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:255) at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:294) at org.apache.oozie.store.CoordinatorStore$15.call(CoordinatorStore.java:609) at org.apache.oozie.store.CoordinatorStore$15.call(CoordinatorStore.java:567) at org.apache.oozie.store.CoordinatorStore.doOperation(CoordinatorStore.java:425) Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Protocol violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone, t0.time_out FROM COORD_JOBS t0 WHERE t0.bean_type = ? ORDER BY t0.created_time DESC) WHERE ROWNUM <= ? [params=(String) CoordinatorJobBean, (long) 50]} [code=17401, state=99999] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1595) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252) at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:496) at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384) at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:325) at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:331) at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94) at org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:57) ... 19 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    WoodenDoors
    WoodenDoors60 times, last one,
    Unknown visitor1 times, last one,
    3 more bugmates