on 04-23-2014 4:58 AM
Hello, Experts,
I have a problem with creation of EPM Add-in connection when SAP BusinessObjects Enterprise connection type is selected.
An error message is "Error while communicating with the server. Framework message: Authorization failed."
Here are the steps that were implemented and how this issue was reproduced:
Looking forward you valuable comments and suggestions.
Thank you in advance.
Donatas Budrys
Hi Donatas,
Please check this note 1512256 - DB_SEC_E_AUTH_FAILED error appears in InfoView when
configuring PCM to a BusinessObjects Enterprise server , the troubleshooting steps are the same from EPM add-in since the security schema is relatively the same.
Best Regards,
Hamda.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, experts,
Any ideas or suggestion on this issue?
Best regards,
Donatas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I am facing the exact same issue as you. With the help of fiddler I noticed that EPM addin tries to call the Logon method in /sap/bpc/app/CommonService/CmsLogonService.asmx but it passes empty login name and password!!!! This is the problem. When I modified the call in fiddler with the correct user name and password then I got a proper response from BPC server. I suppose it is some kind of bug.
Regards
John
Hi Matthias,
I am afraid not. I have even tried EPM addin sp 20 but with the same results.
Below is the soap message epm addin creates when you select connection type 'SAP BusinessObject Enterprise' (it doesn't even give you the chance to give credentials)!!!!
<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><Logon xmlns="http://sap.com/SAP.POA.CmsLogonService/CmsLogonService"><UserName /><Password /></Logon></soap:Body></soap:Envelope>
As you can see username and password are empty!!!!!!
In our case we are using BOE authentication in BPC 10 MS.
Kind Regards
John
Hi Donatas,
verify that your user has the rights for the model you're trying to reach, see please note 1991773 - EPM Add-in: Authorization Failed when creating Local connection
Regards
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear, Roberto,
Our user has Full Access to all BPC tasks and it is administrator in BI system.
Also we can successfully connect with the same user using Connection type "Local".
We had done some investigation and in the BPC SQL Server trace log we can catch the following message when an error occurs:
==============[System Error Tracing]==============
[System Name] : BPCXMLAService [Message Type] : ErrorMessage [Job Name] : ValidateUser [DateTime] : 04/23/2014 10:58:06 [UserId] : [Exception] DetailMsg : {System.Exception: Invalid user at SAP.BPC.Services.Webservice.XMLAService.XMLAService.ValidateUser()} ==============[System Error Tracing End ]==============
It is very interesting that after the EPM workbook is launched via BI Launch Pad till an error occurs we are NOT provided with possibility to enter any username and password. So the EPM add-in should use the same user which was logged into BI Launch Pad - in our case the user with administrative rights both in BI Launch Pad and BPC systems. Am I missing anything?
Looking forward your feedback.
Thank you in advance.
Best regards,
Donatas
Hi Donatas,
if you have followed the epm installation guide I can only suggest these notes about bpc and bi?
1799540 - SAP BusinessObjects EPM Solutions Connection Manager (Plugin)
1709467 - Trouble shooting BPC ODBO / XMLA issues
1654565 - Configuring BPC XMLA web service for P&C 10 MS (Win auth) with the attached pdf file,
otherwise you should ask directly to SAP.
Regards
Roberto
User | Count |
---|---|
5 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.