Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

read timeout mistake with Oracle BI Analysis source for data set

Received Response
533
Views
11
Comments

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.

Welcome!

It looks like you're new here. Sign in or register to get started.
«1

Answers

  • Rank 7 - Analytics Coach

    Also you don't say anything about what version you're on or what the actual error is.

  • Rank 6 - Analytics Lead

    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

  • Rank 7 - Analytics Coach

    Oh ok. Well since it looks like a security thingy I'd say pump up the security logging to 16 and check the detail logs again.

    This tells you how:

  • Rank 7 - Analytics Coach

    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?

  • Rank 7 - Analytics Coach

    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.

  • Rank 7 - Analytics Coach

    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)

  • Rank 2 - Community Beginner

    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)

  • Rank 2 - Community Beginner

    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

  • Rank 2 - Community Beginner

    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.

  • Rank 2 - Community Beginner

    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

Welcome!

It looks like you're new here. Sign in or register to get started.