BPC for NW to BW system connection failure

[Former Member]

Hello

I am trying to install SAP BPC 7.0 for NW but I am getting errors. First I installed it on our BW server machine.

I did create another SQL instance for it, I did create Message Queue as mentioned in installation guide. ".\private$\BPCStatusMessageQueue", I installed with SP9 (both server and BW ABAP SPs). I did create BPC_SYSADMIN, BPC_ADMIN and BPC_USER ABAP users with proper roles and adding SAP_ALL and SAP_NEW profiles into them. I changed them into system users (also tried communication and service user types) but I could not able to connect it. Every time I open BPC Server executable it says Cannot connect to ABAP server, check your server settings. I am able to login via SAP GUI and with those created users. I am also installing SAP BPC with Domain Administrator account and also tried to install it via local SID Adm user (which is also local administrator).

After days of failure I decided to install it on another server. I installed Windows 2003 R2 with latest updates, installed SQL Server 2005 SP3, installed IIS 6.0, I created another domain administrator account and did all installations with it (xxxx\SAPADM) I even added it to Local Administrators group on new server. I did install message queue, I checked SQL settings and gave SysAdmin roles on SQL Surface Area Configuration. I checked both BW and BPC server firewall settings, all offline. I added their IP numbers to their hosts file. Checked BPC ABAP users and made sure they are not locked. I installed other necessary programs like .NET 1.1 (and enabled 32bit applications), ADOMD.NET 8 and MSXML 4 SP2, .NET Connector 1.1. I checked my password lots of times, I pinged both servers, did telnet check too but it still says cannot connect.

==============[BPC Exception Logging]==============

[Message Type] : ERROR

[Job Name] : Log initialization

[DateTime] : 11/1/2010 8:43:33 PM

[UserId] :

[Exception]

DetailMsg : {Name or password is incorrect (repeat logon)}

==============[BPC Exception Logging End ]==============

==============[BPC Exception Logging]==============

[Message Type] : TRACE

[Job Name] : Log initialization

[DateTime] : 11/1/2010 8:43:33 PM

[UserId] :

[Exception]

[Context] :

<Context>

<AppSet>

</AppSet>

<UserID><![CDATA[-----]]></UserID>

<App><![CDATA[]]></App>

<Language><![CDATA[]]></Language>

<Session>

<SessionID><![CDATA[]]></SessionID>

<Machine><![CDATA[]]></Machine>

<ModuleName><![CDATA[]]></ModuleName>

</Session>

<CurrentView>

<Dim>

<Name></Name>

<Value></Value>

</Dim>

</CurrentView>

</Context>

[Parameter] :

[Security] :

DetailMsg : {Name or password is incorrect (repeat logon)}

[Stack Trace] :

at OSoft.Services.Common.ApplicationServiceProxy.GetUserLanguageProxy.getABAPUserLanguage()

at OSoft.Services.Common.ApplicationServiceProxy.ContextUser.init(Hashtable htContext)

at OSoft.Services.Common.ApplicationServiceProxy.ContextUser..ctor(String contextXML)

at OSoft.Services.Platform.Logging.Logger.getLoggingLevelConfig(String strContext)

at OSoft.Services.Platform.Logging.Logger.initialize(String strContext)

==============[BPC Exception Logging End ]==============

==============[BPC Exception Logging]==============

[Message Type] : ERROR

[Job Name] : TestConnection

[DateTime] : 11/1/2010 8:43:33 PM

[UserId] : -

---

[Exception]

DetailMsg : {Exception of type OSoft.Services.Common.ApplicationServiceProxy.ApplicationServiceException was thrown.}

==============[BPC Exception Logging End ]==============

I even tried without patches but no, it keeps insisting to not connect to my BW server.

Edit2: I did check Basic Authentication and Integrated Windows Authentication on ISS settings and also gave Full Control to Everyone but still no go.

Edit3: I did check UJA3_WRITE_SYS_USERS from SE38 and confirmed that proper domain\SAPADM user is there. (I created a local BPC user machinename\BPCUSER as BPC User and put it there too.)

Edit4: I tried adding ABAP users too but no go.

Edited by: Kaan Turkes on Nov 1, 2010 8:30 PM

[Former Member · Accepted solution]

Hi ,

Just try once by giving all SAP password in CAPS and maintained same .

I am not sure it will help , but this isue was there in JCO connector earlier , just try this .

Regards,

[Former Member · Accepted solution]

Hello

It finally connected after changing all passwords to uppercase but now I cannot see any application set.

Edit: I was connecting via another domain admin, I tried to connect registered SysAdmin user and now it works.

Edited by: Kaan Turkes on Nov 2, 2010 9:40 AM