Preventing Office Apps from Hanging on Connection by Disabling AppData WebView2 Folder Sharing

Configure perAppFolders in either the Windows Registry or the properties.xml file in order to disable WebView folder sharing between Office apps, avoiding Office app hangs when connecting to a data source in Smart View.

In Windows, the %AppData%/Oracle/SmartView/WebView folder is shared by default between Office applications. Oracle Smart View for Office uses the WebView folder to track connections to data sources made from different Office apps. In some cases, an organization may set restrictive policies that don’t allow the WebView folder to share the connection information between different Office apps. Because of this, it may happen that when users are connected to a data source in one Office app, such as Excel, and then attempt to launch a subsequent Office app, such as Word, the second app hangs and users are unable to connect.

Use one of the following methods to configure the perAppFolders setting to resolve this connection issue:

Windows Registry Method

In the Windows Registry, create and set the DWORD registry flag, perAppFolders, to ensure that login is required for each connection made in each subsequent Office app.

To create and configure the perAppFolders DWORD registry flag:

  1. Close all Office apps.

  2. Navigate to this Windows Registry key:

    HKCU\Software\Hyperion Solutions\HyperionSmartView\Options\

  3. Add these key values:

    • Name: perAppFolders

    • Value: 1

    • Type: REG_DWORD

    When perAppFolders is set to 1, then sharing the WebView folder between Office apps is not allowed, forcing user login when connecting to data sources in each Office app launched. For example, launching Excel and connecting, then launching Word, and connecting.

  4. Save the setting, restart an Office app, such as Excel, and connect to a data source in Smart View, providing your login credentials; then start another Office app, such as Word, and connect to the same data source.

    You should be prompted for login when attempting to connect to the data source in the second Office app.

properties.xml Method

In the properties.xml file, create and set the perAppFolder parameter, to ensure that login is required for each connection made in each subsequent Office app.

To enable the perAppFolders parameter in properties.xml:

  1. Close all Office apps.

  2. Open the properties.xml file in a text editor.

  3. Add a blank line after this parameter:

    <sendStatisticsRefreshAll>10</sendStatisticsRefreshAll>

  4. In the blank line you created after the sendstatisticsRefreshAll parameter, add the following line:

    <perAppFolders>1</perAppFolders>

  5. Save properties.xml and close it.

  6. Restart an Office app, such as Excel, and connect to a data source in Smart View, providing your login credentials; then start another Office app, such as Word, and connect to the same data source.

    You should be prompted for login when attempting to connect to the data source in the second Office app.