Solved: Visusla Composer with BI Query error .

Former Member · ‎10-03-2013

Hi Expert,

Hope all are doing well..

Actually i have an issue in Visual composer application which is connected to BI data using as model passing Employee Number and execute to get all info from BI side.

while user clicking on VC application through portal that time user will get some error like as given below.

My question is -

1- how it is connected ...? I want to see the Query from NWDS or BW system how? as i have only below info as syste

2-how to find it out how its connected ...as i am giving some info...while clicking on BI Query model in Studio ----Configure ---

System Name - BI_Referal_ 1289796967967

Technical name-BI_Referal_ 1289796967967

System type-BICSQUERYGET .

System Alias--No Connectivity required

Please advise me its urgent to resolve it as its production issue..

java.lang.NullPointerException: while trying to invoke the method com.sap.ip.bi.bics.dataaccess.consumer.queryview.IQueryView.getVariableProcessor() of an object loaded from local variable 'bicsQueryView'

at com.sap.ip.bi.wd4vc.infoactors.classes.BICSQueryGetInfoactor.executeService(BICSQueryGetInfoactor.java:110)

at com.sap.tc.wd4vc.core.std.infoactors.GenericInfoactor.execute(GenericInfoactor.java:286)

at com.sap.tc.wd4vc.core.std.infoactors.wdp.InternalGenericInfoactor.execute(InternalGenericInfoactor.java:144)

at com.sap.tc.wd4vc.core.std.infoactors.GenericInfoactorInterface.execute(GenericInfoactorInterface.java:134)

at com.sap.tc.wd4vc.core.std.infoactors.wdp.InternalGenericInfoactorInterface.wdInvokeMethod(InternalGenericInfoactorInterface.java:175)

... 119 more

See full exception chain for details.

Failed to process request. Please contact your system administrator.

While processing the current request, an exception occured which could not be handled by the application or the framework.

If the information contained on this page doesn't help you to find and correct the cause of the problem, please contact your system administrator. To facilitate analysis of the problem, keep a copy of this error page. Hint: Most browsers allow to select all content, copy it and then paste it into an empty document (e.g. email or simple text file).

For further information about the Web Dynpro error page, error analysis and a description of well-known error situations, see SAP note 1113811.

Correction Hints

Exception could be caused by the development component: bluefinsolutions.com/myreferrals_impl

Note: The above hints are only a guess. They are automatically derived from the exception that occurred and therefore can't be guaranteed to address the original problem in all cases.

System Environment

Client

Web Dynpro Client Type AJAX Client

User agent Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; WOW64; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)

Client Type msie7

Client Type Profile ie6

ActiveX enabled

Java Applets enabled

Accessibility mode disabled

Inline CSS false

Validate by rendering true

Server

Web Dynpro Runtime vendor: 'sap.com', name: 'tc/wd/webdynpro', scV: 'sap.com', scN: 'WD-RUNTIME', location: 'SAP AG', counter: '7.2002.20100122170810.0000', R: '7.20', SP: '2', PL: '0', change number: '87076', codeline: NW720_02_REL

J2EE Engine 7.20.3710.78620.20100309171304

System ID (SID) CEP

Java VM SAP Java Server VM, version:6.1.010, vendor: SAP AG

Operating system SunOS, version: 5.10, architecture: sparcv9

Application

Java EE Application (deployable object) bluefinsolutions.com/myreferrals_impl

Web Dynpro Application My_Referrals

Request URI /webdynpro/resources/sap.com/pb/PageBuilder

Version vendor: 'bluefinsolutions.com', name: 'myreferrals_impl', scV: 'bluefinsolutions.com', scN: 'CAM', location: 'CED_FLEXDEV_D', counter: '20110118231839', R: 'null', SP: 'null', PL: '0', change number: 'null'

Session & Other

Session Locale en_GB

Session Timezone Greenwich Mean Time

Time of Failure Thu Oct 03 16:14:02 BST 2013 (Java Time: 1380813242802)

Session User ClientUser(id=USER.R3_DATASOURCE.GSIMS, name=GSIMS)

Http Session Id (J2EE403202100)ID0398406351DB21172375675576884536End

Client Window Id WID1380812212658

Application Session Id 3Etvmsb4Bq3MOAr*cuiZlw--XcebuzneZRxpd3e8GEt8nQ--/fpn:EPP/pcd:portal_content/com.aw.cam/com.aw.ro...

Web Dynpro Code Generation Infos

bluefinsolutions.com/myreferrals_impl

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapDictionaryGenerationCore 7.1000.20060405193334.0000

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapDictionaryGenerationTemplates (unknown)

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapGenerationFrameworkCore 7.1000.20060405123111.0000

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapIdeWebDynproCheckLayer 7.1000.20060405193334.0000

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapMetamodelCommon 7.1000.20060405193334.0000

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapMetamodelCore 7.1000.20060405193334.0000

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapMetamodelDictionary 7.1000.20060405193334.0000 (release=dev, buildtime=2006-04-05:18:54:50[UTC], changelist=34653, host=pwdfm074)

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapMetamodelWebDynpro 7.1000.20060405193334.0000

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapWebDynproGenerationCore 7.1000.20060405193334.0000

WD web module webdynpro/resources/bluefinsolutions.com/myreferrals_impl: SapWebDynproGenerationTemplates 7.1000.20060405193334.0000

sap.com/tc~wd4vc~launcher

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapDictionaryGenerationCore 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-09T18:16:24+0000, changelist=78360, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapDictionaryGenerationTemplates 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-09T18:16:55+0000, changelist=78360, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapGenerationFrameworkCore 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-09T17:59:34+0000, changelist=78518, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapIdeWebDynproCheckLayer 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-09T19:47:29+0000, changelist=79069, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapMetamodelCommon 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-10T17:52:41+0000, changelist=78914, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapMetamodelCore 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-10T17:51:29+0000, changelist=78914, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapMetamodelDictionary 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-10T17:54:35+0000, changelist=78362, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapMetamodelWebDynpro 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-09T18:25:44+0000, changelist=79070, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapWebDynproGenerationCore 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-09T19:47:58+0000, changelist=79069, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapWebDynproGenerationTemplates 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-09T19:47:06+0000, changelist=79069, host=pwdfm302, is-central=true)

WD web module webdynpro/resources/sap.com/tc~wd4vc~launcher: SapWebDynproRuntimeGen 7.2002.20091230100539.0000 (release=NW720_02_REL, buildtime=2010-01-09T19:41:49+0000, changelist=79073, host=pwdfm302, is-central=true)

Detailed Error Information

Detailed Exception Chain

com.sap.tc.webdynpro.services.exceptions.WDRuntimeException: Exception was thrown in preprocessing phase of application session 3Etvmsb4Bq3MOAr*cuiZlw--XcebuzneZRxpd3e8GEt8nQ--/fpn:EPP/pcd:portal_content/com.aw.cam/com.aw.roles/com.aw.r_field_employee/my_absence/f_manage_leave/com.aw.manage_leave_page_0:lmLjHAZT3SyS3%2B4vudt4mA%3D%3D:1:/com.aw.my_referrals_page/com.bluefinsolutions.myreferrals_impl.My_Referrals_base/bluefinsolutions.com/myreferrals_impl/My_Referrals/base/. The causing exception is nested. RID=6f95a0dd2c3e11e38ef40000092e73d2

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doPreprocessing(ApplicationSession.java:606)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:335)

at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:315)

at com.sap.tc.webdynpro.serverimpl.core.sessionctx.AbstractExecutionContextDispatcher.delegateToRequestManager(AbstractExecutionContextDispatcher.java:62)

at com.sap.tc.webdynpro.serverimpl.wdc.sessionctx.DispatchHandlerForRequestManager.service(DispatchHandlerForRequestManager.java:39)

at com.sap.tc.webdynpro.serverimpl.wdc.sessionctx.DispatchHandlerForRequestManager.service(DispatchHandlerForRequestManager.java:46)

at com.sap.engine.services.servlets_jsp.server.deploy.impl.module.IRequestDispatcherImpl.dispatch(IRequestDispatcherImpl.java:258)

at com.sap.tc.webdynpro.serverimpl.wdc.sessionctx.ExecutionContextDispatcher.dispatchToAppContext(ExecutionContextDispatcher.java:68)

at com.sap.tc.webdynpro.serverimpl.core.sessionctx.AbstractExecutionContextDispatcher.dispatch(AbstractExecutionContextDispatcher.java:53)

at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:244)

at com.sap.tc.webdynpro.clientserver.embedding.JavaApplicationProxy$Runner.callRequestManager(JavaApplicationProxy.java:1265)

at com.sap.tc.webdynpro.clientserver.embedding.JavaApplicationProxy$Runner.callEmbeddedApplication(JavaApplicationProxy.java:1146)

at com.sap.tc.webdynpro.clientserver.embedding.JavaApplicationProxy$StartCommand.doExecute(JavaApplicationProxy.java:1552)

at com.sap.tc.webdynpro.clientserver.embedding.JavaApplicationProxy$AbstractCommand.execute(JavaApplicationProxy.java:1465)

at com.sap.tc.webdynpro.clientserver.embedding.JavaApplicationProxy$Runner.execute(JavaApplicationProxy.java:1052)

at com.sap.tc.webdynpro.clientserver.embedding.JavaApplicationProxy.execute(JavaApplicationProxy.java:883)

at com.sap.tc.webdynpro.clientserver.embedding.JavaApplicationProxy.start1(JavaApplicationProxy.java:661)

at com.sap.tc.webdynpro.portal.pb.impl.JavaApplicationProxyAdapter.create(JavaApplicationProxyAdapter.java:166)

at com.sap.portal.pb.PageBuilder.updateApplications(PageBuilder.java:1659)

at com.sap.portal.pb.PageBuilder.createPage(PageBuilder.java:408)

at com.sap.portal.pb.PageBuilder.init(PageBuilder.java:638)

at com.sap.portal.pb.PageBuilder.wdDoRefresh(PageBuilder.java:1085)

at com.sap.portal.pb.PageBuilder$PhaseListenerImpl.doPhase(PageBuilder.java:2079)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processPhaseListener(WindowPhaseModel.java:251)

at com.sap.tc.webdynpro.clientserver.phases.PortalDispatchPhase.execute(PortalDispatchPhase.java:50)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequestPartly(WindowPhaseModel.java:162)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doProcessRequest(WindowPhaseModel.java:110)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:97)

at com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:514)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:55)

at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.doExecute(ClientApplication.java:1688)

at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.doProcessing(ClientApplication.java:1502)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doApplicationProcessing(ApplicationSession.java:870)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:343)

at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:315)

at com.sap.tc.webdynpro.serverimpl.core.AbstractDispatcherServlet.doContent(AbstractDispatcherServlet.java:87)

at com.sap.tc.webdynpro.serverimpl.wdc.DispatcherServlet.doContent(DispatcherServlet.java:76)

at com.sap.tc.webdynpro.serverimpl.core.AbstractDispatcherServlet.doPost(AbstractDispatcherServlet.java:62)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:359)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:476)

at com.sap.tc.webdynpro.serverimpl.wdc.ForwardServlet.doPost(ForwardServlet.java:63)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:38)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:400)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:203)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:438)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:427)

at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)