MSS Reports not working

[Former Member]

We are having problems with MSS reports. When I try to execute the reports from portal side , its throwing the following error.

Portal runtime error.

An exception occurred while processing your request. Send the exception ID to your portal administrator.

Exception ID: 04:26_22/02/10_0452_103948150

Refer to the log file for details about this exception.

Please advice

[Former Member · Accepted solution]

Hi Revti,

Please post the detailed log file related to exception to findout root cause of issue.

Regards,

Koti Reddy

[Former Member · Accepted solution]

please find the error log below. Please let me know if you need anything else.

500 Internal Server Error

java.lang.NullPointerException

at com.sap.mss.rpt.blcreporting.FcReporting.getSelectedReportFromSessionData(FcReporting.java:1478)

at com.sap.mss.rpt.blcreporting.FcReporting.initialization(FcReporting.java:862)

at com.sap.mss.rpt.blcreporting.wdp.InternalFcReporting.initialization(InternalFcReporting.java:366)

at com.sap.mss.rpt.blcreporting.FcReportingInterface.initialization(FcReportingInterface.java:269)

at com.sap.mss.rpt.blcreporting.wdp.InternalFcReportingInterface.initialization(InternalFcReportingInterface.java:212)

at com.sap.mss.rpt.blcreporting.wdp.InternalFcReportingInterface$External.initialization(InternalFcReportingInterface.java:340)

at com.sap.mss.rpt.vacparameter.VcParameter.onInit(VcParameter.java:209)

at com.sap.mss.rpt.vacparameter.wdp.InternalVcParameter.onInit(InternalVcParameter.java:153)

at com.sap.mss.rpt.vacparameter.VcParameterInterface.onInit(VcParameterInterface.java:161)

at com.sap.mss.rpt.vacparameter.wdp.InternalVcParameterInterface.onInit(InternalVcParameterInterface.java:144)

at com.sap.mss.rpt.vacparameter.wdp.InternalVcParameterInterface$External.onInit(InternalVcParameterInterface.java:220)

at com.sap.pcuigp.xssfpm.wd.FPMComponent.doProcessEvent(FPMComponent.java:564)

at com.sap.pcuigp.xssfpm.wd.FPMComponent.doEventLoop(FPMComponent.java:438)

at com.sap.pcuigp.xssfpm.wd.FPMComponent.wdDoInit(FPMComponent.java:196)

at com.sap.pcuigp.xssfpm.wd.wdp.InternalFPMComponent.wdDoInit(InternalFPMComponent.java:110)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent.doInit(DelegatingComponent.java:108)

at com.sap.tc.webdynpro.progmodel.controller.Controller.initController(Controller.java:215)

at com.sap.tc.webdynpro.progmodel.controller.Controller.init(Controller.java:200)

at com.sap.tc.webdynpro.clientserver.cal.ClientComponent.init(ClientComponent.java:430)

at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.init(ClientApplication.java:362)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.initApplication(ApplicationSession.java:782)

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

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingPortal(ClientSession.java:761)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:696)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:253)

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

at com.sap.tc.webdynpro.clientserver.session.core.ApplicationHandle.doProcessing(ApplicationHandle.java:73)

at com.sap.tc.webdynpro.portal.pb.impl.AbstractApplicationProxy.sendDataAndProcessActionInternal(AbstractApplicationProxy.java:869)

at com.sap.tc.webdynpro.portal.pb.impl.AbstractApplicationProxy.create(AbstractApplicationProxy.java:229)

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

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

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

at com.sap.portal.pb.PageBuilder.wdDoInit(PageBuilder.java:193)

at com.sap.portal.pb.wdp.InternalPageBuilder.wdDoInit(InternalPageBuilder.java:150)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent.doInit(DelegatingComponent.java:108)

at com.sap.tc.webdynpro.progmodel.controller.Controller.initController(Controller.java:215)

at com.sap.tc.webdynpro.progmodel.controller.Controller.init(Controller.java:200)

at com.sap.tc.webdynpro.clientserver.cal.ClientComponent.init(ClientComponent.java:430)

at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.init(ClientApplication.java:362)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.initApplication(ApplicationSession.java:782)

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

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:741)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:694)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:253)

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

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doPost(DispatcherServlet.java:53)

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

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

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

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

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

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

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)

[p330068 · Accepted solution]

Hi Revti,

Please check the mss service started or not in the content admin>>web dynpro>>check the required service here for mss report.

thanks

Arun

[Former Member · Accepted solution]

Its connected. Everything is green. Please advice, what shall i check next.

Thanks

[former_member227283 · Accepted solution]

Hi Reviti,

Generate the exception and goto default trace and search with exception id and post the log in forum again pls.

Thanks

Anil

[p330068 · Accepted solution]

Hi Revti

If you are refering to the team viewer which is on the left side table. Then you need to cross verify the Org view assiciated with that. There should be some issue with that only. Please get in touch with the Funcitonal and Backend techincal and recitify it

Thanks

Arun

[Former Member · Accepted solution]

Check the reports in BW first...

For example

0PA_C01_Q012

0PA_C01_Q005

0PAOS_C01_Q011

The one with the problems....

And see if the problem is on the BW side.

[Former Member · Accepted solution]

These are the HR Reports we are having problems with. But let me check the things which you experts have suggested and i will get back to you.

Anil:

How do we see the log.,Plase explain step by step.

I will appreciate your help.

Thanks

Edited by: Revti Saini on Feb 24, 2010 5:12 PM

[p330068 · Accepted solution]

Hi Revti,

Please check here :

Location of Trace File

A single trace file is created with the default setting of the J2EE Engine. All trace information is written to file defaultTrace.trc in directory \usr\sap\<SID>\JC<InstNo>\j2ee\cluster\server<n>\log on the J2EE Server.

The portal trace information is stored in file portal.trc in directory \usr\sap\<SID>\JC<InstNo>\j2ee\cluster\server<n>\log\applications\portal\.

You can also check in NWA.

Please for more details He[Help|http://help.sap.com/saphelp_nwce10/Helpdata/EN/ac/e9d8a51c732e42bd0e7de54b9ff4e2/content.htm]

Thanks

Arun

[Former Member · Accepted solution]

Thanks Arun

Please find below the error log.

Message:

java.util.zip.ZipException: error in opening zip file

at java.util.zip.ZipFile.open(Native Method)

at java.util.zip.ZipFile.<init>(ZipFile.java:111)... [see details]

Category:

/System/Server

Location:

com.sapmarkets.bam.jmxadapter.AbstractLog

Thanks

[p330068 · Accepted solution]

Hi Revti,

Check the thread for the same exception :

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/sap-j2ee-engine-version-700-patchleve...

Thanks

Arun

[Former Member · Accepted solution]

The log file shows the following error.

com.sapportals.portal.prt.runtime.PortalRuntimeException: Exception in SAP Application Integrator occured: Unable to parse template &#39;&lt;System.Access.WAS.protocol&gt;://&lt;System.Access.WAS.hostname&gt;/sap/bw/BEx?sap-client=&lt;System.client&gt;&amp;sap-language=&lt;Request.Language&gt;&amp;accessibility=&lt;User.Accessibility[SAP_BOOL]&gt;&amp;..

Please help me to resolve this issue

Thanks

[Former Member · Accepted solution]

Resolved,

System Alias was missing for ITS (SAP_ITS_XSS). We assign the system alias and then we ran SIAC_PUBLISH_ALL_INTERNAL. Everythign is working fine now.

Thanks for all your suggestions and help. I really appreciate it.

Thanks

[former_member526843 · Accepted solution]

Hi Revti,

We have a multi customer environment and need to launch separate Launchpads for each customer from the same portal. These launchpads needs to

Can you tell me if I can create multiple SAP_ITS_XSS equivalents. If yes, then where do I set it so that Launchpad applications referrs to the respective SAP_ITS_XSS alias.

Rgds

GP