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

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.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
  2. 0

    ORA-01866

    Oracle Community | 7 years ago | 771205
    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
  3. 0

    Design Gererator issue

    Oracle Community | 1 decade ago | 437234
    oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. State ment: select tab.name tabName , tab.irid tabIrid , tab.table_type tab leType , tab.ivid tabIvid , mti.alias mtiAlias , mde.name mdeName , decode ( ov.state , 'O' , jr_version.get_vlabe l(ov.irid, jr_version.get_original_of_checkout( ov.irid,ov.ivid))||'CO' , 'I' , ov.vlabel , 'N' , '' , '0.0' ) versionLabel from ci_general_modules mde , ci relation definitions tab , ci_module_detail_table_usages mti , ci_m odule_component_inclusions mcn , sdd_object_versions ov where mde.ivid = .ivid and mti.module_unit_reference = mcn.module_component_reference and mti.table_reference = tab.irid and ov.ivid = tab.ivid UNION select tab.na me tabName , tab.irid tabIrid , tab.table_type tableType , tab.iv id tabIvid , mti.alias mtiAlias , mde.name mdeName , decode ( ov.state , 'O' , jr_version.get_vlabel(ov.irid, jr_versio n.get_original_of_checkout( ov.irid,ov.ivid))||'CO' , 'I' , ov.vlabel , 'N' , '' , '0.0' ) versionLabel from ci_general_modules mde , ci_relation_definition s tab , ci_module_detail_table_usages mti , ci_lov_inclusions lvi , sdd_object_versions ov where mde.ivid = :1 and lvi.general_module_ref erence = mde.irid and lvi.parent_ivid = mde.ivid and mti.module_unit_ref erence = lvi.list_of_values_reference and mti.table_reference = tab.irid a nd ov.ivid = tab.ivid order by 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid column index :RTE after adding eo/vo attributes

    Oracle Community | 10 years ago | 593191
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ContactEO.ROW_ID, ContactEO.FST_NAME, ContactEO.LAST_NAME, ContactEO.CELL_PH_NUM, ContactEO.EMAIL_ADDR, ContactEO.FAX_PH_NUM, ContactEO.HOME_PH_NUM, ContactEO.JOB_TITLE, ContactEO.MID_NAME, ContactEO.OWNER_PER_ID, ContactEO.PER_TITLE, ContactEO.WORK_PH_NUM, ContactEO.MODIFICATION_NUM, ContactEO.CREDIT_SCORE, OrgExtEO.NAME, OrgExtEO.ROW_ID AS ROW_ID11, OrgExtEO.MODIFICATION_NUM AS MODIFICATION_NUM1, OrgExtEO.LOC FROM S_PARTY PartyEO, S_CONTACT ContactEO, S_ORG_EXT OrgExtEO, S_PARTY_PER PartyPerEO WHERE (PartyEO.ROW_ID = ContactEO.PAR_ROW_ID) AND ((ContactEO.ROW_ID = PartyPerEO.PERSON_ID(+)) AND (PartyPerEO.PARTY_ID = OrgExtEO.ROW_ID(+)))
  6. 0

    JBO-27122 SQL error during Statement preparation

    Google Groups | 1 decade ago | Jeff
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Product.APPNAME, Product.PRODID, Product.DESCRIPTION, Product.PRICE, Product.THUMBNAIL, Product.DESCRIPTION_ES, Product.DESCRIPTION_FR FROM ETC.ECOM_PRODUCT Product WHERE (SPECIALCHARGE <> 'Y' OR SPECIALCHARGE IS NULL) AND APPNAME = ? AND ((DISABLED <> 'Y' OR DISABLED IS NULL)) ORDER BY PRODID

    1 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.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()
    2. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3383)
      2. oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:3977)
      3. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:961)
      4. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
      5. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3751)
      6. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
      7. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
      8. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
      9. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
      10. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3671)
      10 frames
    3. private.sag.extensiones
      CustomViewObjectImpl.executeQuery
      1. private.sag.extensiones.modelo.view.CustomViewObjectImpl.executeQuery(CustomViewObjectImpl.java:89)
      1 frame
    4. private.sag.modelo
      VOUsuariosImpl.recuperarInfoUsuarioAutenticado
      1. private.sag.modelo.core.view.seguridad.VOUsuariosImpl.recuperarInfoUsuarioAutenticado(VOUsuariosImpl.java:49)
      1 frame