Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Oracle Analytics Server Reports Run 1hour end process Failed
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.
Best Answer
-
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
0
Answers
-
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.
0 -
Hello Guys. The same exact problem in my OAS upgrade. Did you solve this problem? Doc ID is useless. Not working.
0 -
Hi @Emil_M_
The issued had been solved.
Go to WebLogic Console > DataSource > Your Custom DataSourceCustom 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 outThanks.
1 -
Hi Tiang. Thank You very much. It's working.
0
