Dashboard Error Request processing failed. (xls 000009) failed to connect to the olap source

[former_member210043]

Hi  All

Dashboard Error:

Request processing failed. (xls 000009) failed to connect to the olap source.

Thanks

Nikil..

[former_member182541]

Check credential part, also please check the below thread & Note.

Cannot connect to OLAP Source | SCN

2138401 - Error: Request Processing Failed (XLS 000009) Cannot Connect to OLAP Source

Symptom

• When connecting to BEx query from Dashboard through OLAP Connection, an error occurs - "Request processing failed. (XLS 000009) Cannot connect to the OLAP source"
• BW entitlement account in CMC > authentication > SAP becomes locked out if you attempt multiple refreshes
• Fiddler log show error message -Caused by: com.businessobjects.mds.olap.protocol.sap.jco.JCOException: com.sap.conn.jco.JCoException: (103) JCO_ERROR_LOGON_FAILURE: Name or password is incorrect (repeat logon) on <IP or Servername> sysnr 01
• When creating new query below error is displayed

Environment

• SAP BusinessObjects Business Intelligence Platform 4.1 (issue could also affect 4.0 and multiple SP's)
• Dashboard 4.1
• Dashboard 4.0

Reproducing the IssueThere are multiple workflows that could reproduce similar results

• the bug in SAP note 2062091
• If you have changed your entitlement username and password in CMC > authentication > SAP and have not restarted the Dashboard Processing and Cache Servers

Cause

The issue is caused due to special character in the Password for BW Entitlement Account.

Resolution

• If you have the bug in SAP note 2062091 then use a non special character password (and restart the Dashboard Processing and Cache Servers after changing it)
• If you have made recent changes to the BW entitlement account or password then restart the Dashboard Processing and Cache Servers so it uses the most current info.
• If restarting the Dashboard Processing and Cache Servers does not resolve you may find it necessary to recreate the Dashboard Processing and Cache Servers.

[former_member210043]

Hi Suman ..

I hav fone through the thread  Cannot connect to OLAP Source | SCN.

it is  saying we neeed to synchronise the clocks of BOserver n ABAP server..at os level,

if i want to do that   i need take the help odf other vender to to restart the os.

so any other  solution  ......plz

Regards

NIkil

[former_member182541]

Have you checked the credentials in bw side, then check in the CMC for olap connection.

[Former Member]

Hi Nikil,

Have you tried the below Notes:

1905673 - "Request processing failed. (XLS 000009 )" while adding a BICS connection in Dashboard Que...

Symptom

• "Request processing failed. (XLS 000009 )" happened while adding a BICS connection in Dashboard Query Browser
• Error detail: [[error.openSapBwBrowsingSessionFailed] 0] &lt;com.sap.sl.olap.impl.ConnectionSpecificationImpl@xxx, networkLayerType: SAP_BW_BICS, providerType: SAP_BWxx, server: null, catalogName: null, cubeName: null, language: en_US)&gt;,&lt;Unsupported AuthenticationMode: CredentialsPrompt&gt;

Environment

• Business Intelligence Platform 4.0 Support Package 04 or above (BI4 SP4)
• Dashboard Designer 4.0 SP4 or above

Reproducing the Issue

1. Logon CMC.
2. Navigate to OLAP Connections.
3. Click on the New Connection icon, enter the required information, set authentication type toPrompt and save the connection.
4. Quit CMC.
5. Open Dashboard Designer.
6. Click Query Browser.
7. Select the connection create in step3.

Cause

• This behaviour is by-design. OLAP connection created via the CMC with Prompt authentication mode is not supported.
• And a query must be selected in the OLAP Connection.

Resolution

• Set the Authentication type to Predifined and enter logon information, or set it to SSO. And select a query into the connection.

2138401 - Error: Request Processing Failed (XLS 000009) Cannot Connect to OLAP SourceSymptom

• When connecting to BEx query from Dashboard through OLAP Connection, an error occurs - "Request processing failed. (XLS 000009) Cannot connect to the OLAP source"
• BW entitlement account in CMC > authentication > SAP becomes locked out if you attempt multiple refreshes
• Fiddler log show error message -Caused by: com.businessobjects.mds.olap.protocol.sap.jco.JCOException: com.sap.conn.jco.JCoException: (103) JCO_ERROR_LOGON_FAILURE: Name or password is incorrect (repeat logon) on <IP or Servername> sysnr 01
• When creating new query below error is displayed

Environment

• SAP BusinessObjects Business Intelligence Platform 4.1 (issue could also affect 4.0 and multiple SP's)
• Dashboard 4.1
• Dashboard 4.0

Reproducing the IssueThere are multiple workflows that could reproduce similar results

• the bug in SAP note 2062091
• If you have changed your entitlement username and password in CMC > authentication > SAP and have not restarted the Dashboard Processing and Cache Servers

CauseThe issue is caused due to special character in the Password for BW Entitlement Account.Resolution

• If you have the bug in SAP note 2062091 then use a non special character password (and restart the Dashboard Processing and Cache Servers after changing it)
• If you have made recent changes to the BW entitlement account or password then restart the Dashboard Processing and Cache Servers so it uses the most current info.
• If restarting the Dashboard Processing and Cache Servers does not resolve you may find it necessary to recreate the Dashboard Processing and Cache Servers.

Thanks,

Urmil.

[former_member210043]

Hi  Urmil .

Thanks for the response ..

I am not getting  wt i need to do exaactly ..

help me

regards

nikil..

[Former Member]

Hi Nikil,

Are you manitaining userid and password of olap connection in CMC?

Regards

Urmil.

[former_member210043]

Hi Urmil..

yes we r mainiaining..

Regards

Nikil

[former_member182541]

Check the connection is working fine with the credentials.

[Former Member]

Hi nikil.

Please look at the figure.

Go to CMC->olap connection->select connection->right click->edit.

Try this.

Thanks,

Urmil.