Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Error when trying to edit data table in Excel



When user tries to edit a data table in Excel, the launch fails. This was working until the recent upgrade to Websphere Application Server (WAS) 7.0. 

Error Messages

Failed to Re-attach server session

Steps to Reproduce

  1. Open a Data table with 'Edit Data instances' button
  2. Click on 'Edit in Excel' button

Root Cause

The root cause of this issue is HTTPONLY setting applied to the obSSOCookie security cookie.

In the process of logging into PRPC 5.5 SP1, the SSO proxy server attempts to authenticate the user. The following HTTP request captures this activity:

The response sets security obSSOCookie with HTTPONLY attribute shown in greater detail here:

HTTPONLY attribute instructs the browser to make that cookie inaccessible for any use outside of the sandbox, while the Excel process needs all cookies used by the browser in HTTP requests in order to access the same operator’s requestor on PRPC server.
Due to missing obSSOCookie cookie, the Excel macrocode fails to establish HTTP connection with the operator’s requestor, which explains the error message. 


The recommended approach is to review SSO security policy with the networking administrators and decide whether it is possible to modify the policy and turn off the HTTPONLY mode to enable Excel integration with Data Tables.

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us