Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
read timeout mistake with Oracle BI Analysis source for data set

Summary
read timeout mistake with Oracle BI Analysis source for data set
Content
I'm making bi publisher data model, using Oracle BI Analysis as source for data set.
This analysis needs about an hour to complete. And bi publisher report stops to work in 6 minutes.
In the incedent report I found the problem is "Root cause of ServletException. java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at ...."
I have the same problem when I am trying to view data sample in data model.
Does anybody know where am I need to set timeout value to solve the problem?
I've set timout values both in data set options and in data model options with no result.
I've set ClientSessionExpireMinutes, DefaultTimeoutMinutes, LogonExpireMinutes, UnaccessedRunningTimeoutMinutes in instanceconfig.xml file with no result too.
There is no problem with long queries for data set from other sources (including sql query from oracle bi data model).
There is no problem with this analysis when I open it in OBIEE too.
Answers
-
Also you don't say anything about what version you're on or what the actual error is.
0 -
Hi
First off, Id strongly recommend NOT using BI Analyses as the data source for the BIP report. The performance is terrible and the feature was put in to meet a requirement for very small and fast running reports. When the BIP report is run, it calls OBIEE to run the analysis. The query i the analysis is executed and the results returned to the the presentation services when then render the data as XML output and that is passed back to the BIP data model engine. Its slow and fraught with issues. Im not sure of the linkage btw BIP and the presentation services (PS) in terms of whether, BIP checks with PS to see if the report is complete or if PS nudges BIP when it is complete. I think is the former.
Either way, you are getting a disconnect between the two and the report is failing to render, I would recommend just grabbing the query out of the Analysis and pasting it into the BIP data model and use the BI Server connection. You get the security of the BIEE rpd model without the overhead of the report having to be formatted and rendered to XML and passed back to the BIP data model.
If you want to pursue the issue. Id log an SR with support to get some help. Make sure you include a trace 32 log of the report run with the SR - https://docs.oracle.com/cd/E17904_01/bi.1111/e13880/T526682T542464.htm
Cheers
Tim
0 -
-
Ok not sure what you exactly mean with "And I told about patching not about upgrade" but if your question is answered then can you please close this thread?
0 -
I've never ever seen that. What bug is that?
Normally what I've seen is that most RPD issues where tied to invalid config in the source version. Not the destination version.
0 -
So additional to everything told you, there's this:
user10657994 wrote:My version is 12.2.1.0.0
Ref MOS Doc ID 2070465.1: "Error Correction for 12.2.1.0 ended: June 2017"
So
a) rethink how that data model sources its data
b) rethink if the analysis makes sense to begin with (like pulling in millions of rows across hundreds of columns just to show 12 months with 2 measures)
c) upgrade
(not necessarily in that order)
0 -
My first question is not answered. I asked about setting timeout for solving the problem and recieved answer only about workaround and recomendations about upgrade
I still hope sombody knows about timeout I need to set (if it exists)
0 -
I can't find it now on oracle support.
And I told about patching not about upgrade. I learnt a lot about upgrading from your link. I need to think much about.
Thank you
0 -
Thank you for the advice, but I tried to upgrade twice. And after upgrade new admin tool changed the levels order in hierarchies in rep during saving, created warnings and even errors (I found this as registered bug with no decision). So I was forced to rollback first and second bundle putches.
0 -
Tim, thank you for so detailed answer
It's really good advise about copying sql query from analisys and paste to dataset.
I've tried it befire. It works, but it's not convenient to make changes in future.
Logging SR will help me probably
0