Home » Developer & Programmer » Reports & Discoverer » No timeout in BI Excel Add-In or D4O
No timeout in BI Excel Add-In or D4O [message #434370] Wed, 09 December 2009 00:35
varshagoel
Messages: 1
Registered: December 2009
Junior Member
Session time out feature is not available in Excel Add-In or D4O .But is available in Discoverer Relational.
When contacted Oracle, it was suggested to have the time out at the database session level.

When session level time out is implemented through database profiles, the error messages thrown are neither consistent nor meaningful.

Error message from Excel Add-In
-----------------------------------------------------------
The OracleBI Spreadsheet Add-In failed to load and/or refresh a query.

Error message from D4O
-----------------------------------------------------------------
BIB-9527 Could not preprae OLAP transaction.
oracle.express.idl.util.OlapiException:
java.sql.SQLException:ORA-01012:not logged on.

The error messages does not inform the user that the error occurred due to time-out.
Did anyone encounter this issue ? If yes, how was it resolved?

Regards,
Varsha
Previous Topic: Schema for Oracle Report Developer 10G Course
Next Topic: need help
Goto Forum:
  


Current Time: Fri Mar 29 00:23:44 CDT 2024