Problem in integrating BI 7.x with Portal 7.0

[Former Member]

Hi,

I have creted system (BI_System) in portal, given the BI details in the properties, WebAS and Connector connection test is successful.

I have created Web Template using BI 7.

I am trying to created BI iView. We have two option in Template iView,

1. BI 7.x Web application iView

2. Bw 2.x/3.x Web application iView.

While i try to create iView using BI 7.x Web application iView, My system (BI_System) is not showing in the system dropdown option.

While i try to create iView using Bw 2.x/3.x Web application iView, My system (BI_System) is showing in the system dropdown option.

What is the problem here.. why it is not showing for BI 7.x template iView.. please help me regarding this.

Regards,

Art Tech

[former_member304001 · Accepted solution]

Hi,

When use BI 7.0 u will get as SAP_LOCAL SYSTEM

u need to select this for BI7.0 version reports

i don't know the exact reason why it is showing like that but SAP has suggested us to use SAP_LOCALSYSTEM for bi7 reports

Regards

Krishna.

[Former Member · Accepted solution]

ok..

I have given the BEx Web Application Query String (Web Template).

if i select SAP_LOCAL SYSTEM (I am unable to usermap this system),

I am getting the following error,

The initial exception that caused the request to fail was:

Name or password is incorrect (repeat logon)

com.sap.mw.jco.JCO$Exception: (103) RFC_ERROR_LOGON_FAILURE: Name or password is incorrect (repeat logon)

at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:455)

at com.sap.mw.jco.MiddlewareJRfc$Client.connect(MiddlewareJRfc.java:1015)

at com.sap.mw.jco.JCO$Client.connect(JCO.java:3255)

at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.connectWithJCO(SAPCFConnectorManagedConnection.java:428)

at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.establishInitialConnection(SAPCFConnectorManagedConnection.java:203)

how can i solve this.

[detlev_beutner · Accepted solution]

SAP_LocalSystem is a virtual system, pointing to the WAS of the calling portal itself. If BI is installed on a different system, you cannot use SAP_LocalSystem.

Best regards

Detlev

[former_member304001 · Accepted solution]

Hi

Check ur JCo connections as the error is showing that user id and password is wrong

so make sure that u have given correct user id and password while creating JCo

Regards

Krishna.

[Former Member · Accepted solution]

hi detlev,

Thanks for your reply.

BI is installed different system.

How can i integrated BI 7 to EP7

Thanks,

[Former Member · Accepted solution]

hi krishna,

I have checked the JCO Connection, there userid and password are correct, Ping and connection test is successful in JCO Connection..

How can we solve this issue..

Thanks and Regards,

Art Tech

[pramod_gopisetty1 · Accepted solution]

Hello Art,

For integrating BI with Portal please go through the following notes.

SAP Note: 937697

SAP Note: 917950

In the first note you have a par file download it and upload in the portal. Once done. go to 917950 note and there you will find a link

<http|https>://<j2ee_server>:<j2ee_port>/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.supportdesk.default

which will show up a screen with the configurations you have done and the corrections you need to do.

Hope this helps.

Cheers-

Pramod

Reward points if helpful!

[Former Member · Accepted solution]

Problem solved.. we need to open the server using fully qualified host name.

Regards,

Art Tech