Current Position:Home > Oracle BI Server crashed?

Oracle BI Server crashed?

Update:11-30Source: network consolidation
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
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
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

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 Application Server crashes due to Socket Write Error Update:11-30

    I am using Oracle Application Server 9.0.3. Simple JSP application is running on it. We are using the application server connection pooling functionality. Following errors are occuring on it frequently and it causes the application server crash. Firs

  • Oracle Fulfillment Server crashing Update:11-30

    Hello Friends, I have EBS-12 installed on a Windows machine(Win2003 EE). Few days back the setup was working fine. Now when i fire the EBS URL the Oracle Fulfillment Server is crashing. Even if i start it from the services, it crashes for the very fi

  • 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

  • Weblogic 81sp5 Oracle 10G server crash windows xp Update:11-30

    I was using weblogic 81sp5 hibernate 3 and Oracle 9i and everythign was fine. I upgraded to Oracle 10G, and now with the execution of the second SQL statement my server is crashing with the following error. Any help would be appreciated. An unexpecte

  • Oracle 8i client with oracle 9i server Update:11-30

    hi friends.. i have oracle 8i server and oracle 8i server crashed. so i am planning to install oracle 9i server. will i be able to connect oracle 8i clients on to oracle 9i server? is there any procedure for getting this connection.? Plea

  • CSS keepalives for Oracle forms server Update:11-30

    I'm trying to set up load balancing for oracle forms server and having issues with finding working keepalive method. If I use uri keepalive, Oracle forms server crashes within a couple of minuites. TCP doesn't work either service Ora-forms:9000 ip ad

  • 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