oracle.jbo.JboException: JBO-29000: JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT EOUsuario.U_ID, EOUsuario.U_NOMBRE_USUARIO, EOUsuario.U_EMAIL, EOUsuario.U_ADMIN_SEGURIDAD, EOUsuario.U_ADMIN_SISTEMA, EOUsuario.U_PASSWORD, EOUsuario.U_TOKEN, EOUsuario.U_REPORTE FROM USUARIOS EOUsuario WHERE (U_ID LIKE :Id OR :Id IS NULL) AND (UPPER(U_NOMBRE_USUARIO) LIKE CONCAT(CONCAT('%',UPPER(:Nombre)),'%') OR :Nombre IS NULL) AND (U_EMAIL LIKE CONCAT(CONCAT('%',UPPER(:Email)),'%') OR :Email IS NULL ) AND (U_ADMIN_SISTEMA LIKE :AdmSis OR :AdmSis IS NULL ) AND (U_ADMIN_SEGURIDAD LIKE CONCAT(CONCAT('%',UPPER(:AdmSeg)),'%') OR :AdmSeg IS NULL ) AND (U_REPORTE LIKE CONCAT(CONCAT('%',UPPER(:URep)),'%') OR :URep IS NULL ) ORDER BY EOUsuario.U_ID

Oracle Community | 771205 | 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

    ORA-01866

    Oracle Community | 7 years ago | 771205
    oracle.jbo.JboException: JBO-29000: JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT EOUsuario.U_ID, EOUsuario.U_NOMBRE_USUARIO, EOUsuario.U_EMAIL, EOUsuario.U_ADMIN_SEGURIDAD, EOUsuario.U_ADMIN_SISTEMA, EOUsuario.U_PASSWORD, EOUsuario.U_TOKEN, EOUsuario.U_REPORTE FROM USUARIOS EOUsuario WHERE (U_ID LIKE :Id OR :Id IS NULL) AND (UPPER(U_NOMBRE_USUARIO) LIKE CONCAT(CONCAT('%',UPPER(:Nombre)),'%') OR :Nombre IS NULL) AND (U_EMAIL LIKE CONCAT(CONCAT('%',UPPER(:Email)),'%') OR :Email IS NULL ) AND (U_ADMIN_SISTEMA LIKE :AdmSis OR :AdmSis IS NULL ) AND (U_ADMIN_SEGURIDAD LIKE CONCAT(CONCAT('%',UPPER(:AdmSeg)),'%') OR :AdmSeg IS NULL ) AND (U_REPORTE LIKE CONCAT(CONCAT('%',UPPER(:URep)),'%') OR :URep IS NULL ) ORDER BY EOUsuario.U_ID
  2. 0

    ORA-01866

    Oracle Community | 7 years ago | 771205
    oracle.jbo.JboException: JBO-29000: JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT EOUsuario.U_ID, EOUsuario.U_NOMBRE_USUARIO, EOUsuario.U_EMAIL, EOUsuario.U_ADMIN_SEGURIDAD, EOUsuario.U_ADMIN_SISTEMA, EOUsuario.U_PASSWORD, EOUsuario.U_TOKEN, EOUsuario.U_REPORTE FROM USUARIOS EOUsuario WHERE (U_ID LIKE :Id OR :Id IS NULL) AND (UPPER(U_NOMBRE_USUARIO) LIKE CONCAT(CONCAT('%',UPPER(:Nombre)),'%') OR :Nombre IS NULL) AND (U_EMAIL LIKE CONCAT(CONCAT('%',UPPER(:Email)),'%') OR :Email IS NULL ) AND (U_ADMIN_SISTEMA LIKE :AdmSis OR :AdmSis IS NULL ) AND (U_ADMIN_SEGURIDAD LIKE CONCAT(CONCAT('%',UPPER(:AdmSeg)),'%') OR :AdmSeg IS NULL ) AND (U_REPORTE LIKE CONCAT(CONCAT('%',UPPER(:URep)),'%') OR :URep IS NULL ) ORDER BY EOUsuario.U_ID
  3. 0

    Error while running the SRLIST page

    cla5h.com | 11 months ago
    oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: oracle.jbo.NameClashException, msg=JBO-25001: Name Products of object type Attribute already exists
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JBO-25005: Object name 1 for type Variable is invalid

    Oracle Community | 9 years ago | 592928
    oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.InvalidObjNameException, msg=JBO-25005: Object name 1 for type Variable is invalid
  6. 0

    JBO-27102 after JHeadstart migration

    Oracle Community | 7 years ago | 583527
    oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.DeadViewRowAccessException, msg=JBO-27102: Attempt to access dead view row of persistent id 5,345

    3 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.jbo.JboException

      JBO-29000: JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT EOUsuario.U_ID, EOUsuario.U_NOMBRE_USUARIO, EOUsuario.U_EMAIL, EOUsuario.U_ADMIN_SEGURIDAD, EOUsuario.U_ADMIN_SISTEMA, EOUsuario.U_PASSWORD, EOUsuario.U_TOKEN, EOUsuario.U_REPORTE FROM USUARIOS EOUsuario WHERE (U_ID LIKE :Id OR :Id IS NULL) AND (UPPER(U_NOMBRE_USUARIO) LIKE CONCAT(CONCAT('%',UPPER(:Nombre)),'%') OR :Nombre IS NULL) AND (U_EMAIL LIKE CONCAT(CONCAT('%',UPPER(:Email)),'%') OR :Email IS NULL ) AND (U_ADMIN_SISTEMA LIKE :AdmSis OR :AdmSis IS NULL ) AND (U_ADMIN_SEGURIDAD LIKE CONCAT(CONCAT('%',UPPER(:AdmSeg)),'%') OR :AdmSeg IS NULL ) AND (U_REPORTE LIKE CONCAT(CONCAT('%',UPPER(:URep)),'%') OR :URep IS NULL ) ORDER BY EOUsuario.U_ID

      at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout()
    2. oracle.jbo.common
      SessionCookieImpl.useApplicationModule
      1. oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2002)
      2. oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2793)
      3. oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:453)
      3 frames
    3. oracle.jbo.http
      HttpSessionCookieImpl.useApplicationModule
      1. oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:233)
      1 frame
    4. oracle.jbo.common
      SessionCookieImpl.useApplicationModule
      1. oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:424)
      2. oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:419)
      2 frames
    5. oracle.adf.model
      DCJboDataControl.beginRequest
      1. oracle.adf.model.bc4j.DCJboDataControl.rebuildApplicationModule(DCJboDataControl.java:1517)
      2. oracle.adf.model.bc4j.DCJboDataControl.beginRequest(DCJboDataControl.java:1381)
      2 frames
    6. private.sag.gui
      SAGJboDataControl.beginRequest
      1. private.sag.gui.jsf.common.binding.SAGJboDataControl.beginRequest(SAGJboDataControl.java:86)
      1 frame
    7. oracle.adf.model
      BindingContext.get
      1. oracle.adf.model.binding.DCDataControlReference.getDataControl(DCDataControlReference.java:99)
      2. oracle.adf.model.BindingContext.get(BindingContext.java:457)
      2 frames
    8. JSF
      PropertyResolverImpl.getValue
      1. com.sun.faces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:79)
      1 frame
    9. oracle.adfinternal.view
      FacesPropertyResolver.getValue
      1. oracle.adfinternal.view.faces.model.FacesPropertyResolver.getValue(FacesPropertyResolver.java:92)
      1 frame
    10. com.sun.faces
      ExpressionEvaluatorImpl.evaluate
      1. com.sun.faces.el.impl.ArraySuffix.evaluate(ArraySuffix.java:187)
      2. com.sun.faces.el.impl.ComplexValue.evaluate(ComplexValue.java:171)
      3. com.sun.faces.el.impl.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:263)
      3 frames
    11. JSF
      ValueBindingImpl.getValue
      1. com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:160)
      2. com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:143)
      2 frames
    12. private.sag.extensiones
      ADFUtils.getApplicationModuleForDataControl
      1. private.sag.extensiones.gui.util.JSFUtils.resolveExpression(JSFUtils.java:55)
      2. private.sag.extensiones.gui.util.ADFUtils.getApplicationModuleForDataControl(ADFUtils.java:55)
      2 frames
    13. private.sag.gui
      InfoSeguridadUsuario.<init>
      1. private.sag.gui.jsf.common.binding.SAGAppModuleFactory.getSeguridadService(SAGAppModuleFactory.java:44)
      2. private.sag.gui.jsf.seguridad.backing.InfoSeguridadUsuario.<init>(InfoSeguridadUsuario.java:62)
      2 frames
    14. Java RT
      Beans.instantiate
      1. sun.reflect.GeneratedConstructorAccessor546.newInstance(Unknown Source)
      2. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      3. java.lang.reflect.Constructor.newInstance(Constructor.java:494)
      4. java.lang.Class.newInstance0(Class.java:350)
      5. java.lang.Class.newInstance(Class.java:303)
      6. java.beans.Beans.instantiate(Beans.java:204)
      7. java.beans.Beans.instantiate(Beans.java:48)
      7 frames
    15. JSF
      ManagedBeanFactory.newInstance
      1. com.sun.faces.config.ManagedBeanFactory.newInstance(ManagedBeanFactory.java:223)
      1 frame