2 Replies Latest reply: Jul 31, 2014 6:42 AM by 947140 RSS

    Different Physical query in two different environment

    947140

      I have a dashboard and it is working fine in DEV environment but it is not working in PROD environment.

      while investigating I found some points.

      1. the two physical queries are different in the where condition

       

      in DEV

           T66755.PER_NAME_ENT_YEAR = '2014'

      and T66755.PER_NAME_ENT_PERIOD = 'FEB-14'

       

      in Prod

           T66755.PER_NAME_ENT_YEAR = '2014'

      and concat(cast(T66755.PER_NAME_ENT_YEAR as  VARCHAR ( 4 ) ), substr(concat('0', cast(T66755.ENT_PERIOD as  VARCHAR ( 2 ) )) , -(2))) = 'FEB-14'

       

      2. if i remove the Sql result from the prompt it is working

      3. if I click twice on the apply button of the prompt it is working.