Bi Query Designer executing error

[Former Member]

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*aJ5noW8wwAuh3WUSt0YPwv5K_W5lNgQ

ESID: vMRfxte7MYLmvPDM8su4KAFlO8XmTQErw6WQlTbt1BPA

ESID: vMRfxte7MYLmvPDM8su4KAuTWEZzOVns3Em_bZ8TpIoQ

Controllers with timeout: 3

ESID: s_RYKGHoSWJy*aJ5noW8wwAuh3WUSt0YPwv5K_W5lNgQ

ESID: vMRfxte7MYLmvPDM8su4KAFlO8XmTQErw6WQlTbt1BPA

ESID: vMRfxte7MYLmvPDM8su4KAuTWEZzOVns3Em_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: vMRfxte7MYLmvPDM8su4KAFlO8XmTQErw6WQlTbt1BPA

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: vMRfxte7MYLmvPDM8su4KAFlO8XmTQErw6WQlTbt1BPA

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.integr...

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=vMRfxte7MYLmvPDM8su4KAFlO8XmTQErw6WQlTbt1BPA

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

[Former Member]

Hi,

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

Regards,

Vamshi.

[Former Member]

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

[Former Member]

Hi,

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

Regards

Imran