oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read t

Content

Hi Experts,

I have Anniversary BI Report using OTBI analysis. Which has following filter criteria 

CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Real Time"."Person"."Person Start Date") AS CHAR)   ,'-'), 

cast(DAYOFMONTH("Workforce Management - Person Real Time"."Person"."Person Start Date")AS cHAR))  

= 

CONCAT(CONCAT(CAST(MONTHNAME(TIMESTAMPADD(SQL_TSI_DAY, +1, TIMESTAMPADD(SQL_TSI_YEAR, -1, 

  CAST(TIMESTAMPADD(SQL_TSI_HOUR, cast(substring('@{session.timeZone}' from 5 for 3) as int), CURRENT_TIMESTAMP) as DATE))) )AS CHAR),'-'),

CAST(DAYOFMONTH(TIMESTAMPADD(SQL_TSI_DAY, +1, TIMESTAMPADD(SQL_TSI_YEAR, -1, CAST(TIMESTAMPADD(SQL_TSI_HOUR, cast(substring('@{session.timeZone}' from 5 for 3) as int), CURRENT_TIMESTAMP) as DATE))) )AS CHAR))