IBM Support

A blank page is displayed for some users who connect to Planning Analytics Workspace (duplicate user issue)



In Planning Analytics Workspace, some of the existing users are now getting a blank page just after logging in.


For reasons that are still unknown, these users have been duplicated in the Workspace databases.

Resolving The Problem

All duplicate users have to be deleted.
- On either Windows Powershell or Linux, run this command to display the list of users:
docker exec wa-proxy node tools/Tools.js
- Search for any identical "LoginId" so that to determine if these users are only duplicated or if they appear more than twice (in that case, the solution below will have to be applied several times)
- create a CSV file that contains these lines (change the dummy user informations by the actual user informations):
Login Id,First Name,Last Name,Role,Email,Status,Directive
- Connect to PAW as an admin

- Go to the "Users" folder
- Find the personal folders of these users and copy them to another safe temporary location.
- Go to the Administration page at the top-right

- Select the "Users" tab
- Click the "Upload users" link at the bottom-right
- Go find the CSV file and load it.
==> this should delete one occurrence of the duplicate users (but we do not know which occurrence will be deleted, that is why we saved the personal folders first)
- If some users have more than 2 occurrences, then run this again, until only one occurrence remains.
- Now let these users reconnect.  If this is working, then the final step is just to restore the content of their personal folders.

Document Location


[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzIzAAK","label":"Planning Analytics Workspace"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
23 December 2020