Question Re: Bi Query Designer executing error in Technology Q&A

Bi Query Designer executing error

Former Member — Thu, 12 Nov 2009 14:43:33 GMT

Hi experts,

i am facing a problem in executing the BI Query Designer in portal

please find the below error and let me know what needs to be done

#1.#00306E0C2A52006A0000030A000005F10004782CC51CFD21#1258033587813#com.sap.ip.bi.webapplications.runtime.jsp.portal.services.BIRuntimeService#sap.com/irj#com.sap.ip.bi.webapplications.runtime.jsp.portal.services.BIRuntimeService#AVAKEDAY#440##n/a##c34a7d60cf9111dec1c100306e0c2a52#SAPEngine_Application_Thread[impl:3]_26##0#0#Debug#1#/Applications/BI#Plain###

BEx Web Application Debug Info: ControllerCollector.removeController() exiting Thu Nov 12 05:46:27 PST 2009

Controllers in session: 0

Controllers in VM: 0

Controllers with error: 3

ESID: s_RYKGHoSWJy*aJ5noW8ww~~Auh3WUSt0YPwv5K_W5lNgQ~~

ESID: vMRfxte7MYLmvPDM8su4KA~~FlO8XmTQErw6WQlTbt1BPA~~

ESID: vMRfxte7MYLmvPDM8su4KA~~uTWEZzOVns3Em_bZ8TpIoQ~~

Controllers with timeout: 3

ESID: s_RYKGHoSWJy*aJ5noW8ww~~Auh3WUSt0YPwv5K_W5lNgQ~~

ESID: vMRfxte7MYLmvPDM8su4KA~~FlO8XmTQErw6WQlTbt1BPA~~

ESID: vMRfxte7MYLmvPDM8su4KA~~uTWEZzOVns3Em_bZ8TpIoQ~~

#1.#00306E0C2A52006A0000030B000005F10004782CC51D26D0#1258033587824#com.sap.ip.bi.webapplications.runtime.controller.impl.Controller#sap.com/irj#com.sap.ip.bi.webapplications.runtime.controller.impl.Controller#AVAKEDAY#440##n/a##c34a7d60cf9111dec1c100306e0c2a52#SAPEngine_Application_Thread[impl:3]_26##0#0#Info#1#/Applications/BI#Plain###End of release of a controller for the user "USER.R3_DATASOURCE.AVAKEDAY", generated "11/12/09 5:46 AM"#

#1.#00306E0C2A52006A0000030D000005F10004782CC51D5468#1258033587836#com.sap.ip.bi.webapplications.runtime.controller.impl.Controller#sap.com/irj#com.sap.ip.bi.webapplications.runtime.controller.impl.Controller#AVAKEDAY#440##n/a##c34a7d60cf9111dec1c100306e0c2a52#SAPEngine_Application_Thread[impl:3]_26##0#0#Debug#1#/Applications/BI#Plain###

BEx Web Application Debug Info: Controller.destroy() exiting Thu Nov 12 05:46:27 PST 2009

Controller

+- DESTROYED

+- Created at: Thu Nov 12 05:46:26 PST 2009

+- User: USER.R3_DATASOURCE.AVAKEDAY

+- Locale: en_US

+- Client IP: 10.133.74.186

+- User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; MS-RTC EA 2; MS-RTC LM 😎

+- ESID: vMRfxte7MYLmvPDM8su4KA~~FlO8XmTQErw6WQlTbt1BPA~~

No pages

#1.#00306E0C2A52006A0000030E000005F10004782CC51D60EF#1258033587839#com.sap.ip.bi.webapplications.runtime.controller.impl.Controller#sap.com/irj#com.sap.ip.bi.webapplications.runtime.controller.impl.Controller#AVAKEDAY#440##n/a##c34a7d60cf9111dec1c100306e0c2a52#SAPEngine_Application_Thread[impl:3]_26##0#0#Debug#1#/Applications/BI#Plain###

BEx Web Application Debug Info: Controller.processRequest() exiting Thu Nov 12 05:46:27 PST 2009

Controller

+- DESTROYED

+- Created at: Thu Nov 12 05:46:26 PST 2009

+- User: USER.R3_DATASOURCE.AVAKEDAY

+- Locale: en_US

+- Client IP: 10.133.74.186

+- User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; MS-RTC EA 2; MS-RTC LM 😎

+- ESID: vMRfxte7MYLmvPDM8su4KA~~FlO8XmTQErw6WQlTbt1BPA~~

No pages

#1.#00306E0C2A52006A0000030F000005F10004782CC51DD0B3#1258033587867#com.sap.ip.bi.webapplications.runtime.jsp.portal.services.BIRuntimeService#sap.com/irj#com.sap.ip.bi.webapplications.runtime.jsp.portal.services.BIRuntimeService#AVAKEDAY#440##n/a##c34a7d60cf9111dec1c100306e0c2a52#SAPEngine_Application_Thread[impl:3]_26##0#0#Debug#1#/Applications/BI#Plain###

BEx Web Application Debug Info: BIRuntimeService.handleRequest() exiting Thu Nov 12 05:46:27 PST 2009

Request URL: http://ttcsap04.tycothermal.com:52000/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.web.portal.integration.launcher

Parameters:

DUMMY=2

QUERY=ZPSAGEDBALANCE2

VARIABLE_SCREEN=X

sap-bw-iViewID=pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex

sap-ext-sid=vMRfxte7MYLmvPDM8su4KA~~FlO8XmTQErw6WQlTbt1BPA~~

Headers:

Accept=image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, /

Accept-Encoding=gzip, deflate

Accept-Language=en-us

Cache-Control=no-cache

Connection=Keep-Alive

Content-Length=222

Content-Type=application/x-www-form-urlencoded

Cookie=JSESSIONID=(ttcsap05_TBI_03)ID1846259550DB11763987245312943257End;

Thanks & Regards,

Arun

Re: Bi Query Designer executing error

Former Member — Thu, 12 Nov 2009 15:01:05 GMT

Hi,

Have you activated the content in your BI system, If not first activate the content(RSA1).

Regards,

Vamshi.

Re: Bi Query Designer executing error

Former Member — Fri, 13 Nov 2009 12:40:28 GMT

Hi,

Could you plese know me which content and how to active it in RSA1.

When i exectute the query designer then the error i get is

500 Internal Server Error

BEx Web Application

Failed to process request; contact your system administrator

Error Summary

Exception occured while processing the current request; this exception cannot be handled by the application or framework

If the information on this page does not help you locate and correct the cause of the problem, contact your system administrator

To facilitate analysis of the problem, keep a copy of this error page Hint: Most Web browsers allow you to select all content, and copy and paste it into an empty document (such as in an email or simple text file)

Root Cause

The initial exception that caused the request to fail was:

java.lang.NullPointerException

Log ID 00306E0C2A52007300000EAE00006BAC0004783F9F6943D6

Application log :-

Caused by: java.lang.NullPointerException

at com.sap.ip.bi.base.application.impl.Application.getProperty(Application.java:720)

at com.sap.ip.bi.base.application.impl.Application.startApplicationStep(Application.java:286)

at com.sap.ip.bi.base.application.impl.Application.initialization(Application.java:266)

at com.sap.ip.bi.base.application.ApplicationFactory.createApplication(ApplicationFactory.java:172)

at com.sap.ip.bi.base.application.ApplicationFactory.createApplication(ApplicationFactory.java:65)

at com.sap.ip.bi.webapplications.runtime.impl.Page.createApplication(Page.java:1117)

at com.sap.ip.bi.webapplications.runtime.impl.Page.constructPage(Page.java:955)

at com.sap.ip.bi.webapplications.runtime.impl.Page.<init>(Page.java:776)

at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller._createPage(Controller.java:567)

at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.createPage(Controller.java:524)

at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.doProcessRequest(Controller.java:990)

at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller._processRequest(Controller.java:883)

... 36 more

Thanks & Regards,

Arun

Re: Bi Query Designer executing error

Former Member — Sun, 15 Nov 2009 12:42:56 GMT

Hi,

Please check the integration configuration between your BI & EP system.

Regards

Imran