Oracle Analytics Server Reports Run 1hour end process Failed

Tiang

Product: Oracle Analytics Server 7.6

OS: Linux 7.9

After upgrading from Oracle Analytics Server 5.5 to 7.6, we started encountering a 'Socket read timed out' error for reports that consistently finish in exactly 1 hour. Interestingly, reports running for more than 1 hour do not face this issue. This problem did not exist in the previous version. Has anyone else experienced this, and are there any suggestions or solutions?

Thanks.

Mallikarjuna Kuppauru-Oracle

Hi @Tiang

Are you running using scheduler ? you can override the limit refer below -

Fusion Applications BI Publisher : How to control BI Publisher Data Model time out (Doc ID 1921393.1)

Regards,

Arjun

Tiang

https://community.oracle.com/products/oracleanalytics/discussion/comment/63070#Comment_63070

Hi, Recently happen again even though i follow the Doc link you share and configure the query timeout but when one hour it still failure.

Emil_M_

Hello Guys. The same exact problem in my OAS upgrade. Did you solve this problem? Doc ID is useless. Not working.

Tiang

https://community.oracle.com/products/oracleanalytics/discussion/comment/69758#Comment_69758

Hi @Emil_M_

The issued had been solved.
Go to WebLogic Console > DataSource > Your Custom DataSource

Custom Data Source > Connection Pool > Properties
set these 2 parameters
oracle.jdbc.ReadTimeout=28800000
oracle.net.CONNECT_TIMEOUT=7000000
the value to set is ms, so totally set 8hour for read timeout and 2hour for connection timeout. you can try set lower from begin and test out

Thanks.

Emil_M_

Hi Tiang. Thank You very much. It's working.