9 Replies Latest reply on May 10, 2010 4:16 PM by user7182953

    Error in a report after enabling case insensitive search in conn pool prop

    700663
      Hi All,

      I put the below code in connection pool's connection string to enable case insensitive search.
      alter session set NLS_SORT=BINARY_CI
      alter session set NLS_COMP=LINGUISTIC

      After putting this code one of my report started giving the below error which was working fine otherwise.

      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
      State: HY000. Code: 10058. NQODBC SQL_STATE: HY000 nQSError: 10058 A general error has occurred. nQSError: 16001 ODBC error state: S1000 code: 1791 message: OracleODBCOraORA-01791: not a SELECTed expression. nQSError: 16001 ODBC error state: S1000 code: 1791 message: OracleODBCOraORA-01791: not a SELECTed expression. nQSError: 16015 SQL statement execution failed. (HY000)

      The report gives error for the below divide condition when I select a column from a different dimension (eg: region)
      COUNT(DISTINCT RMA.RMA)/COUNT(DISTINCT User."User Name")

      Can anyone please throw a light why this is happening.