on 2013 Jun 18 2:08 PM
Hi All,
We have a MII application runs on version 12.1.10 Build(64). Application connect with SQL and Historian database.
While accessing Home page (Home button on the top right hand side, after logged into MII) in MII, we received an error as "503 Service Unavailable", whereas at the NWE logs file we have "Response timed out, request terminated" error. We were able to access other pages in MII (mapped through navigation services) but applets like dropdown, iGrid shows "No Data Available".
NWE Error Details
Message : Response timed out, request terminated
Category : com.sap.xmii.common.threading.CachedThreadRequestor
Location : com.sap.xmii.common.threading.CachedThreadRequestor
Application : sap.com/xapps~xmii~ear
We check with both SAP Basis and SQL DBA team, both of them ensured that all services are up and running from their end.
Aforesaid issue is not repetitive. Issue was there for almost 3 hours, then application works fine.
Within MII, database connections, Xacute connector, scheduled jobs everything works fine.
We would like to know the reason for this error and under what circumstances it will occur. Kindly share your thoughts on this.
Thanks
S.Rajesh
Request clarification before answering.
Hi Rajesh,
May be in your case, the data fetching is taking a longer time thus the applets show "No Data Available" as the underlying query fetching data times out.
There are settings for increasing the Read Timeout and Connection Timeout in the BLS workbench.
Go to Help-->Settings in the menu of BLS Workbench.
You can increase them or set to 0 so that there are no timeouts.
Regards,
Rohit Negi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rohit,
Thanks for your reply.
In our application, we have both simple and complex queries to fetch data from database. For complex queries we have increased the read time out option at Netweaver level. We already tested this scenario.
This issue occurs even for simple queries that returns just 12 items. (Ex: Location as drop down, it shows 12 items by default).
Thanks
S.Rajesh
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.