Current Position:Home > Oracle BI Server crashed?

Oracle BI Server crashed?

Update:11-30Source: network consolidation
Advertisement
Hi all,
I've had a really disturbing issue with OBISE1 today which i hope you guys can shed some light on.
During an OBI demonstration the performance went down the drain after about 30 minutes. While i was logged in and demonstrated dashboards/reports, 22 other users in the same room were also logged in and followed my steps through the dashboards. After those 30 minutes dashboards and reports just stopped loading and errors started popping out on all screens. At the end even logging off took a minute.
At the location there was a fast internet line, so im ruling that out as an issue. After
Afterwards when i checked the server i noticed Oracle BI Server stopped.
I checked eventviewer and found the following from the VsJITDebugger that occured at 2:26:30 PM :
An unhandled win32 exception occurred in NQSServer.exe [1948]. Just-In-Time debugging this exception failed with the following error: Debugger could not be started because no user is logged on.
Check the documentation index for 'Just-in-time debugging, errors' for more information.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Another thing that I found from the Service Control Manager that occured at 2:26:39 PM :
The Oracle BI Server service terminated unexpectedly.  It has done this 1 time(s).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
This sounds like an OBISE1 issue. So I digged some deeper and found the following.
The NQSServer log doesn't show anything that happened during this time period.
The NQSQuery log only shows -------------------- Cache Purge of query: records.
The sawlog0.log did show a lot of errors, covering about 500 MS Word pages :
1. Exception in handler thread. An error occurred during execution of "send". An unknown error occurred in the sockets library. [Socket:4848]
This happened 16 times
2. Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 27004] Unresolved table: "QPO". (HY000)
This happened 225 times for this and another table
3. SQLFetchScroll returned code SQL_NO_DATA_FOUND
This happened 118 times
I still don't clearly see what happened that made OBI crash, why i received the errors in sawlog0.log and where i can find more information about this.
Can anyone advise me what to do, because I do need an answer to the question what caused this??

The Best Answer

Advertisement
If given info helps pls mark.
Appreciate if you update your issue and the bug details
Edited by: Srini VEERAVALLI on Jan 8, 2013 8:14 AM
  • Oracle HTTP Server Crash Update:12-10

    Hi all, i have an application deployed in OC4J, this application, due to dabase locks, its started to respond very slowly (i had some JSP with 102 seconds response time) about 12:50 i had 175 active connection in that OC4J container, some moments aft

  • Oracle BI Server crashed? Update:11-30

    Hi all, I've had a really disturbing issue with OBISE1 today which i hope you guys can shed some light on. During an OBI demonstration the performance went down the drain after about 30 minutes. While i was logged in and demonstrated dashboards/repor

  • Bea 7.0 sp2 oracle 8i server crashes with Update:11-30

    hi there ... we are running into strange problems with the following setup bea 7.0 sp2 on a sun solaris oralce 8.1.7 + bea jdbc driver CMP 2.0 our application consists of approx. 30 tables. after a certain amount of time the server prompts: An unexpe

  • Oracle VM server crashes with disk corruption using SATA 2 Update:11-30

    Created OEL 5 x86_64 on a HVM and occassionally the VM server crashes with the following messages on the console: ata1.0.0 tag 0 cmd 0x25 Emask 0x4 stat 0x40 err 0x0 timeout (frozen) failed to recover some devices retrying in 5 seconds comreset faile

  • Oracle 9iAS Orion Server Crashes on Running RWSERVLET Update:10-11

    We are developing a product with JSP as front end,EJB as middle tier and Oracle as DB.Oracle 9iAS is the deployment environment.We are using the RWSERVLET configuration. We have configured Orion to communicate with RWSERVLET.Rwservlet copied to web-i