Thanks Christian, its an OBI Analysis Report. We Copied Physical query from Query log of OBIEE and tried to execute it through OBIEE (using same connection pool as used by report) by Direct Database Request and we observed same behavior i.e query remained in running state. Then we replaced the one of the MV with its…

Hi Christan I had tried by server (host and port details as well) and -D but same result. for -W I will check. I guess system will prompt for RPD password so didn't use -W