Portal runtime error while accessing BI Report as URL iView

[Former Member]

Hi All,

I created an URL Iview with the URL of BI report, when i am trying to access it then getting portal runtime error.

I had check the log it is showing the following details about the error, could you please help me out what is the root cause based on the log details...??

Thanks in advance.

Logfile Details

1)

08:48_14/09/10_0049_139354050*
 
*[EXCEPTION]*
 *com.sapportals.portal.prt.runtime.PortalRuntimeException: Exception in SAP Application Integrator occured: Unable to parse template '<System.ConnectionString>'; the problem occured at position 0. Cannot process expression <System.ConnectionString> because Invalid System Attribute:*
 *System:    'SAP_LocalSystem',*
 
*Attribute: 'ConnectionString'.*
 
*at com.sapportals.portal.appintegrator.AbstractIntegratorComponent.doContentPass(AbstractIntegratorComponent.java:125)*
*at com.sapportals.portal.appintegrator.AbstractIntegratorComponent.doContent(AbstractIntegratorComponent.java:98)*
*at com.sapportals.portal.prt.component.AbstractPortalComponent.serviceDeprecated(AbstractPortalComponent.java:209)*
*at com.sapportals.portal.prt.component.AbstractPortalComponent.service(AbstractPortalComponent.java:114)*
*at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328)*
*at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136)*
*at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189)*
*at com.sapportals.portal.prt.component.PortalComponentResponse.include(PortalComponentResponse.java:215)*
*at com.sapportals.portal.prt.pom.PortalNode.service(PortalNode.java:645)*
*at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328)*
*at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136)*
*at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189)*
*at com.sapportals.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:753)*
*at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:235)*
*at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:541)*
*at java.security.AccessController.doPrivileged(AccessController.java:246)*
*at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:430)*
*at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)*
*at com.sap.engine.services.servlets_jsp.server.servlet.InvokerServlet.service(InvokerServlet.java:156)*
*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(AccessController.java:219)*
*at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)*
*at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)

2)

Full Message Text*
 
 
*Content pass of Application Integrator failed.*
 *Component Name:       'com.sap.portal.appintegrator.sap.Transaction',*
 
*Context Name (iView): 'pcd:portal_content/net.ea.epson.BI_ROLES/com.epson.financeuser/ZB(3a)FINANCE_USER/com.Epson.UnitandGrossProfit',*
 
*Top Layer:            'Transaction/DragAndRelateLayer',*
 
*Producer ID (FPN):    'null',*
 
*System Alias:         'BIDCLNT100',

Thanks,

Kalki Reddy.

[dao_ha · Accepted solution]

Hi Kalki,

>

>

> [EXCEPTION]

> com.sapportals.portal.prt.runtime.PortalRuntimeException: Exception in SAP Application Integrator occured: Unable to parse template '<System.ConnectionString>'; the problem occured at position 0. Cannot process expression <System.ConnectionString> because Invalid System Attribute:

> System: 'SAP_LocalSystem',

>

> Attribute: 'ConnectionString'.

>

Your iView seems to be looking for system SAP_LocalSystem, which is strange. Please check your floating aliases to see which system the alias BIDCLNT100 is pointing to.

Hope it helps.

Regards,

Dao

[Former Member]

This message was moderated.

[Former Member]

Are you sure its a URL iview? the error says:

*Context Name (iView): 'pcd:portal_content/net.ea.epson.BI_ROLES/com.epson.financeuser/ZB(3a)FINANCE_USER/com.Epson.UnitandGrossProfit',*
 
*Top Layer:            'Transaction/DragAndRelateLayer',*
 
*Producer ID (FPN):    'null',*
 
*System Alias:         'BIDCLNT100',

probably this iview is appintegrator/transaction iview..check the property 'system' in your iview.. Its pointing to 'BIDCLNT100' as per the error....

Check that system with alias 'BIDCLNT100' is present in portal. then check it's WAS/Connector properties..you should be able to test them successfully.

cheers~

avadh

[Former Member]

Hi Avadh,

Thanks for your reply.

I tested thru connection test of the system , it was tested successflly without any issues. all are into tick mark only.

but when i am trying to use the system alias name while creating Trasaction iview also i am not able to get the system alias name in the dropdown for selecting the system alias.

but system alias what ever it is "BIDCLNT100" is in active and connection test is done correctly without any issues.

Please let me know the problem why i am not able to get the same system alias name "BIDCLNT100" not able to get in the drop down list while creating the transaction IView??

Please reply , Thanks in advance

Thanks,

Kalki Reddy

[Former Member]

Hi Kalki ,

Have you tried using Bex 3.X or 7.0 iview templates for creating these BI reports . You would need the query string of the report's URL . I am not sure how these reports will behave if you try creating url iviews out of them .

Regards

Mayank