oracle.jbo.SQLStmtException

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.

  • ORA-01866
    via by 771205,
  • ORA-01866
    via by 771205,
  • Design Gererator issue
    via by 437234,
  • setWhereClauseParam
    via by BabakSaraie,
  • [SOLVED]Connecting DB problem
    via by soso_xuc,
  • socket error/ where-clause
    via by 100443,
    • oracle.jbo.SQLStmtException: 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.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3383) at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:3977) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:961) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3751) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3671) at private.sag.extensiones.modelo.view.CustomViewObjectImpl.executeQuery(CustomViewObjectImpl.java:89) at private.sag.modelo.core.view.seguridad.VOUsuariosImpl.recuperarInfoUsuarioAutenticado(VOUsuariosImpl.java:49) at private.sag.modelo.core.SAGSeguridadServiceImpl.prepareSession(SAGSeguridadServiceImpl.java:43) at oracle.jbo.server.ApplicationModuleImpl.prepareSession(ApplicationModuleImpl.java:6061) at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:135) at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:7777) at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4074) at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2161) at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1961) at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2793) at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:453) at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:233) at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:424) at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:419) at oracle.adf.model.bc4j.DCJboDataControl.rebuildApplicationModule(DCJboDataControl.java:1517) at oracle.adf.model.bc4j.DCJboDataControl.beginRequest(DCJboDataControl.java:1381) at private.sag.gui.jsf.common.binding.SAGJboDataControl.beginRequest(SAGJboDataControl.java:86)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,