java.sql.SQLException: Got error 157 'Unknown error code' from NDBCLUSTER Error Code: 1296 Call: SELECT id, owner, progress_detail, version, endtime, jobdata, type, pool_id, starttime, resource_lock, progress, keepalive, visibility, submitter, status FROM t_job WHERE (id = ?) bind => [1579] Query: ReadObjectQuery(referenceClass=PersistentJob sql="SELECT id, owner, progress_detail, version, endtime, jobdata, type, pool_id, starttime, resource_lock, progress, keepalive, visibility, submitter, status FROM t_job WHERE (id = ?)")

Oracle Community | 807578 | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    VDI 3.1 demo setup - zfs/vbox/mysql errors !!

    Oracle Community | 7 years ago | 807578
    java.sql.SQLException: Got error 157 'Unknown error code' from NDBCLUSTER Error Code: 1296 Call: SELECT id, owner, progress_detail, version, endtime, jobdata, type, pool_id, starttime, resource_lock, progress, keepalive, visibility, submitter, status FROM t_job WHERE (id = ?) bind => [1579] Query: ReadObjectQuery(referenceClass=PersistentJob sql="SELECT id, owner, progress_detail, version, endtime, jobdata, type, pool_id, starttime, resource_lock, progress, keepalive, visibility, submitter, status FROM t_job WHERE (id = ?)")
  2. 0

    JPA - "java.sql.SQLException: Data truncated" when trying to persist Date field

    Stack Overflow | 2 years ago
    java.sql.SQLException: Data truncated for column 'enlisted' at row 1 Error Code: 1265 Call: INSERT INTO stud_group (cd, enlisted) VALUES (?, ?) bind => [2 parameters bound] Query: InsertObjectQuery(courses.StudGroup[ id=null ])
  3. 0

    UpdateAllQuery Rollback Problem

    Oracle Community | 6 years ago | 422827
    java.sql.SQLException: Statement has already been closed Error Code: 0 Call: UPDATE PCIT_OWN.ORG_BALANCE SET BALANCE = (BALANCE + ?), VERSION = (VERSION + ?), UPDATE_USER = ?, UPDATE_DATE = ? WHERE (AFFILIATION_ORG_ID = ?) bind => [50.0, 1, khenry, 2011-07-19 01:26:08.144, 10226] Query: UpdateAllQuery(referenceClass=OrgBalance sql="UPDATE PCIT_OWN.ORG_BALANCE SET BALANCE = (BALANCE + ?), VERSION = (VERSION + ?), UPDATE_USER = ?, UPDATE_DATE = ? WHERE (AFFILIATION_ORG_ID = ?)")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HPCM stops generating calcs

    Oracle Community | 5 years ago | RMarques
    java.sql.SQLException: ORA-01427: single-row subquery returns more than one row Error Code: 1427 Call: select distinct COALESCE(COALESCE((select y.id from hpm_driver_association y, hpm_mdl_src_nd_ctx dactx, hpm_model_context ctx where y.hpm_mdl_src_nd_ctx_id=dactx.id and dactx.hpm_mdl_Ctx_id=ctx.id and ctx.hpm_stage_id=? and dactx.hpm_dim_mem_grp_id=? and ctx.hpm_pov_dim_mem_grp_id =? and ctx.hpm_layer_id=?),(select (select a.id from hpm_driver_association a, hpm_mdl_src_nd_ctx dactx2, hpm_model_context ctx2 where a.hpm_mdl_src_nd_ctx_id=dactx2.id and dactx2.hpm_mdl_Ctx_id=ctx2.id and ctx2.hpm_stage_id=? and ctx2.hpm_pov_dim_mem_grp_id =? and ctx2.hpm_layer_id=? and dactx2.hpm_dim_mem_grp_id =(SELECT d.hpm_dim_mem_grp_id FROM (SELECT b.hpm_dim_mem_grp_id, b.hpm_dim_mem_id FROM hpm_dim_mem_grp_mem b ) d, hpm_dim_mem_grp_mem e WHERE d.hpm_dim_mem_grp_id=e.hpm_dim_mem_grp_id and d.hpm_dim_mem_id=f.hpm_dim_mem_id GROUP BY d.hpm_dim_mem_grp_id HAVING COUNT(1)=1)) from hpm_dim_mem_gen_lev f where f.hpm_dimension_id = ( select g.hpm_dimension_id from hpm_dim_mem_grp b, hpm_dim_mem_grp_mem c, hpm_dimension_member d, hpm_dimension e, hpm_stage_dimension f, hpm_dim_mem_gen_lev g where b.id = ? and b.id=c.hpm_dim_mem_grp_id and c.hpm_dim_mem_id= d.id and d.hpm_dimension_id=e.id and e.id =f.hpm_dimension_id and f.hpm_stage_id=? and f.is_driver=1 and d.id=g.hpm_dim_mem_id ) and f.branch_number = ( select g.branch_number from hpm_dim_mem_grp b, hpm_dim_mem_grp_mem c, hpm_dimension_member d, hpm_dimension e, hpm_stage_dimension f, hpm_dim_mem_gen_lev g where b.id =? and b.id=c.hpm_dim_mem_grp_id and c.hpm_dim_mem_id= d.id and d.hpm_dimension_id=e.id and e.id =f.hpm_dimension_id and f.hpm_stage_id =? and f.is_driver=1 and d.id=g.hpm_dim_mem_id ) and f.generation_number =(select max(generation_number) from hpm_dim_mem_gen_lev g where g.branch_number = ( select g.branch_number from hpm_dim_mem_grp b, hpm_dim_mem_grp_mem c, hpm_dimension_member d, hpm_dimension e, hpm_stage_dimension f, hpm_dim_mem_gen_lev g where b.id = ? and b.id=c.hpm_dim_mem_grp_id and c.hpm_dim_mem_id= d.id and d.hpm_dimension_id=e.id and e.id =f.hpm_dimension_id and f.hpm_stage_id =? and f.is_driver=1 and d.id=g.hpm_dim_mem_id ) and g.hpm_dimension_id = ( select g.hpm_dimension_id from hpm_dim_mem_grp b, hpm_dim_mem_grp_mem c, hpm_dimension_member d, hpm_dimension e, hpm_stage_dimension f, hpm_dim_mem_gen_lev g where b.id = ? and b.id=c.hpm_dim_mem_grp_id and c.hpm_dim_mem_id= d.id and d.hpm_dimension_id=e.id and e.id =f.hpm_dimension_id and f.hpm_stage_id=? and f.is_driver=1 and d.id=g.hpm_dim_mem_id ) and exists (select 'x' from hpm_driver_association a,hpm_mdl_src_nd_ctx dactx3,hpm_model_context ctx3 where a.hpm_mdl_src_nd_ctx_id=dactx3.id and dactx3.hpm_mdl_Ctx_id=ctx3.id and ctx3.hpm_stage_id=? and ctx3.hpm_pov_dim_mem_grp_id =? and ctx3.hpm_layer_id=? and dactx3.hpm_dim_mem_grp_id=(SELECT d.hpm_dim_mem_grp_id FROM (SELECT b.hpm_dim_mem_grp_id, b.hpm_dim_mem_id FROM hpm_dim_mem_grp_mem b) d, hpm_dim_mem_grp_mem e WHERE d.hpm_dim_mem_grp_id=e.hpm_dim_mem_grp_id and d.hpm_dim_mem_id=g.hpm_dim_mem_id GROUP BY d.hpm_dim_mem_grp_id HAVING COUNT(1)=1) )))),0) as driverAssoc from hpm_driver + bind => [833145, 4266283, 1068009, 1, 833145, 1068009, 1, 4266283, 833145, 4266283, 833145, 4266283, 833145, 4266283, 833145, 833145, 1068009, 1]+ Query: DataReadQuery(sql="select distinct COALESCE(COALESCE((select y.id from hpm_driver_association y, hpm_mdl_src_nd_ctx dactx, hpm_model_context ctx where y.hpm_mdl_src_nd_ctx_id=dactx.id and dactx.hpm_mdl_Ctx_id=ctx.id and ctx.hpm_stage_id=? and dactx.hpm_dim_mem_grp_id=? and ctx.hpm_pov_dim_mem_grp_id =? and ctx.hpm_layer_id=?),(select (select a.id from hpm_driver_association a, hpm_mdl_src_nd_ctx dactx2, hpm_model_context ctx2 where a.hpm_mdl_src_nd_ctx_id=dactx2.id and dactx2.hpm_mdl_Ctx_id=ctx2.id and ctx2.hpm_stage_id=? and ctx2.hpm_pov_dim_mem_grp_id =? and ctx2.hpm_layer_id=? and dactx2.hpm_dim_mem_grp_id =(SELECT d.hpm_dim_mem_grp_id FROM (SELECT b.hpm_dim_mem_grp_id, b.hpm_dim_mem_id FROM hpm_dim_mem_grp_mem b ) d, hpm_dim_mem_grp_mem e WHERE d.hpm_dim_mem_grp_id=e.hpm_dim_mem_grp_id and d.hpm_dim_mem_id=f.hpm_dim_mem_id GROUP BY d.hpm_dim_mem_grp_id HAVING COUNT(1)=1)) from hpm_dim_mem_gen_lev f where f.hpm_dimension_id = ( select g.hpm_dimension_id from hpm_dim_mem_grp b, hpm_dim_mem_grp_mem c, hpm_dimension_member d, hpm_dimension e, hpm_stage_dimension f, hpm_dim_mem_gen_lev g where b.id = ? and b.id=c.hpm_dim_mem_grp_id and c.hpm_dim_mem_id= d.id and d.hpm_dimension_id=e.id and e.id =f.hpm_dimension_id and f.hpm_stage_id=? and f.is_driver=1 and d.id=g.hpm_dim_mem_id ) and f.branch_number = ( select g.branch_number from hpm_dim_mem_grp b, hpm_dim_mem_grp_mem c, hpm_dimension_member d, hpm_dimension e, hpm_stage_dimension f, hpm_dim_mem_gen_lev g where b.id =? and b.id=c.hpm_dim_mem_grp_id and c.hpm_dim_mem_id= d.id and d.hpm_dimension_id=e.id and e.id =f.hpm_dimension_id and f.hpm_stage_id =? and f.is_driver=1 and d.id=g.hpm_dim_mem_id ) and f.generation_number =(select max(generation_number) from hpm_dim_mem_gen_lev g where g.branch_number = ( select g.branch_number from hpm_dim_mem_grp b, hpm_dim_mem_grp_mem c, hpm_dimension_member d, hpm_dimension e, hpm_stage_dimension f, hpm_dim_mem_gen_lev g where b.id = ? and b.id=c.hpm_dim_mem_grp_id and c.hpm_dim_mem_id= d.id and d.hpm_dimension_id=e.id and e.id =f.hpm_dimension_id and f.hpm_stage_id =? and f.is_driver=1 and d.id=g.hpm_dim_mem_id ) and g.hpm_dimension_id = ( select g.hpm_dimension_id from hpm_dim_mem_grp b, hpm_dim_mem_grp_mem c, hpm_dimension_member d, hpm_dimension e, hpm_stage_dimension f, hpm_dim_mem_gen_lev g where b.id = ? and b.id=c.hpm_dim_mem_grp_id and c.hpm_dim_mem_id= d.id and d.hpm_dimension_id=e.id and e.id =f.hpm_dimension_id and f.hpm_stage_id=? and f.is_driver=1 and d.id=g.hpm_dim_mem_id ) and exists (select 'x' from hpm_driver_association a,hpm_mdl_src_nd_ctx dactx3,hpm_model_context ctx3 where a.hpm_mdl_src_nd_ctx_id=dactx3.id and dactx3.hpm_mdl_Ctx_id=ctx3.id and ctx3.hpm_stage_id=? and ctx3.hpm_pov_dim_mem_grp_id =? and ctx3.hpm_layer_id=? and dactx3.hpm_dim_mem_grp_id=(SELECT d.hpm_dim_mem_grp_id FROM (SELECT b.hpm_dim_mem_grp_id, b.hpm_dim_mem_id FROM hpm_dim_mem_grp_mem b) d, hpm_dim_mem_grp_mem e WHERE d.hpm_dim_mem_grp_id=e.hpm_dim_mem_grp_id and d.hpm_dim_mem_id=g.hpm_dim_mem_id GROUP BY d.hpm_dim_mem_grp_id HAVING COUNT(1)=1) )))),0) as driverAssoc from hpm_driver") + at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)

    1 unregistered visitors

    Root Cause Analysis

    1. java.sql.SQLException

      Got error 157 'Unknown error code' from NDBCLUSTER Error Code: 1296 Call: SELECT id, owner, progress_detail, version, endtime, jobdata, type, pool_id, starttime, resource_lock, progress, keepalive, visibility, submitter, status FROM t_job WHERE (id = ?) bind => [1579] Query: ReadObjectQuery(referenceClass=PersistentJob sql="SELECT id, owner, progress_detail, version, endtime, jobdata, type, pool_id, starttime, resource_lock, progress, keepalive, visibility, submitter, status FROM t_job WHERE (id = ?)")

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException()
    2. EclipseLink (non-OSGi)
      DatabaseAccessor.basicExecuteCall
      1. org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:332)
      2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:656)
      2 frames