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
  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 | 8 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

    2 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
      VariableResolverImpl.resolveVariable
      1. com.sun.faces.config.ManagedBeanFactory.newInstance(ManagedBeanFactory.java:223)
      2. com.sun.faces.application.ApplicationAssociate.createAndMaybeStoreManagedBeans(ApplicationAssociate.java:282)
      3. com.sun.faces.el.VariableResolverImpl.resolveVariable(VariableResolverImpl.java:97)
      3 frames
    16. oracle.adfinternal.view
      VariableResolverUtils$JspResolver.resolveVariable
      1. oracle.adfinternal.view.faces.el.AdfFacesVariableResolver.resolveVariable(AdfFacesVariableResolver.java:40)
      2. oracle.adfinternal.view.faces.model.VariableResolverUtils$JspResolver.resolveVariable(VariableResolverUtils.java:79)
      2 frames
    17. com.sun.faces
      ExpressionEvaluatorImpl.evaluate
      1. com.sun.faces.el.impl.NamedValue.evaluate(NamedValue.java:145)
      2. com.sun.faces.el.impl.ComplexValue.evaluate(ComplexValue.java:166)
      3. com.sun.faces.el.impl.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:263)
      3 frames
    18. 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
    19. oracle.adfinternal.view
      UINodeRendererBase.encodeEnd
      1. oracle.adfinternal.view.faces.uinode.ValueBindingBoundValue.getValue(ValueBindingBoundValue.java:30)
      2. oracle.adfinternal.view.faces.uinode.UIXComponentUINode.getAttributeValueImpl(UIXComponentUINode.java:392)
      3. oracle.adfinternal.view.faces.uinode.UIXComponentUINode.getAttributeValue(UIXComponentUINode.java:127)
      4. oracle.adfinternal.view.faces.ui.laf.base.xhtml.LinkDataObject.getLinkDataList(LinkDataObject.java:51)
      5. oracle.adfinternal.view.faces.ui.laf.oracle.desktop.TabBarRenderer.prerender(TabBarRenderer.java:141)
      6. oracle.adfinternal.view.faces.ui.BaseRenderer.render(BaseRenderer.java:79)
      7. oracle.adfinternal.view.faces.ui.laf.base.xhtml.XhtmlLafRenderer.render(XhtmlLafRenderer.java:69)
      8. oracle.adfinternal.view.faces.uinode.UIXComponentUINode.renderInternal(UIXComponentUINode.java:177)
      9. oracle.adfinternal.view.faces.uinode.UINodeRendererBase.encodeEnd(UINodeRendererBase.java:53)
      9 frames
    20. oracle.adf.view
      UIXCollection.encodeEnd
      1. oracle.adf.view.faces.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:624)
      2. oracle.adf.view.faces.component.UIXCollection.encodeEnd(UIXCollection.java:456)
      2 frames
    21. oracle.adfinternal.view
      UIComponentUINode.render
      1. oracle.adfinternal.view.faces.uinode.UIComponentUINode._renderComponent(UIComponentUINode.java:317)
      2. oracle.adfinternal.view.faces.uinode.UIComponentUINode._renderComponent(UIComponentUINode.java:312)
      3. oracle.adfinternal.view.faces.uinode.UIComponentUINode.render(UIComponentUINode.java:262)
      4. oracle.adfinternal.view.faces.uinode.UIComponentUINode.render(UIComponentUINode.java:239)
      4 frames