Support Article
Error occurs while editing data tables in Excel
SA-62788
Summary
Error occurs while editing data tables in Excel. This occurs on Windows 7 and Windows 10.
Error Messages
Failed Re-attach Server session
Steps to Reproduce
- Launch the data table list.
- Open any data table
- Click Edit In Excel
Root Cause
TLS 1.1 and TLS 1.2 have compatibility issues with Windows 7. Hence, Pega macros fail in this setup.
TLS 1.1 and TLS 1.2 work with Windows 10, however, ActiveX fails.
The Edit in Excel feature works with Windows 10 from Pega 7.2.1 onwards due to the change in the underlying application.
Resolution
Perform the following local-change:
Modify the below registry value from the below path,
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 2.0\Client
Change the DWORD value to 0 for Disable the Protocol.
For more information regarding ActiveX: https://community.pega.com/knowledgebase/articles/deprecation-microsoft-activex-controls-pega-platform
Published February 28, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.