1 Reply Latest reply on May 5, 2015 10:36 AM by rmoff

    BI server crashes at COUNT(DISTINCT) on a varchar column along with a filter on timestamp column

    user1116922

      Hi All,

       

      I'm facing an issue with an analysis which i'm trying to build.

      analysis.JPG

      Below is the error I'm getting.

      error1.JPG

      The error occurrence is sporadic and I'm getting results when I clear the cache and run the analysis again. Below is the query from the manage session. I'm surprised that the filter on the timestamp column is missing in the physical query.

       

      select T745597."RPTG_PRDCR_BR_NM" as c2,

           T745984."CLM_OFCNBR" as c3,

           T745984."POL_EFF_DT" as c5

      from

           "TBL_OBIEE_RPTG_RGN" T745597,

           "TBL_OBIEE_DTL" T745984

      where  ( T745597."PRDCR_BR_CD" = T745984."PRDCR_BR_CD" and T745984."CLM_OFCNBR" is not null and T745984."POL_EFF_DT" is not null )

       

      I'm getting different error at different instances for the same analysis. Below is the other kind of error I'm getting while I try to run the same analysis for different date filter.

      error2.JPG

      This causes the BI server to go unavailable for sometime. If I have RPD opened in online mode, I'm getting the below error.

      Admintool.jpg

      But I could open the RPD again in online mode immediately.

      I don't face any issue if I remove the filter on timestamp column or just have 'count' instead of 'count distinct'.

      I'm not sure what is going around this analysis.

      Kindly help. The OBIEE version we are using is 11.1.1.6.2 (Build 120605.2000 BP1 64-bit).

       

      Thanks.