Salesforce

How to reset a user's profile in the Database to fix possible View issues in WorldServer and in Transport

« Go Back

Information

 
Article TypeSolution Article
Scope/EnvironmentWorldServer
Symptoms/Context
Sometimes Users have View issues in WorldServer, in the Projects, Tasks, Issues or other pages. An example is the issue described in this article:

Worldserver - for a specific user, the Projects View displays only few projects and Search field is not enabled

However, sometimes the suggestions in the article do not help. Moreover, they do not apply to the Transport Projects view.
 
Resolution
If nothing else helps (for instance use a different View), you can re-set the User's profile in the Database to reset the View in WorldServer. You will need to confirm the user's username for that. The query is:
 
delete from configuration where name like 'profiles/username%'

Obviously, 'username' should be replaced with the actual username. Once all configurations have been re-set, the View issue should be solved. The user should log in again to WorldServer and repeat the action.

Note, however, that any Search filters previously created by the user will also be deleted.

For Transport: sometimes users set their view to Simple View, which might lead to long times loading the page because this view will also attempt to display all archived projects. The recommended View in Transport is the Summary by Project Status where you can expand only the lists of projects that you want to use. Usually, these are Active or Completed Projects only. 

User-added image

To reset the View of a specific user to Summary by Project Status, ask the user to log out of Transport. Then find the user's username and run this query in the Database, replacing username with the actual user's username:

update CONFIGURATION SET VALUE=1 where NAME= 'profiles/username/transport.projects/view_mode'

Ask the user to log in to Transport again and go to the Projects page. The View should now be reset to Summary by Project Status.
Root Cause
Unknown. The behavior is sporadic and could not be reproduced.
Reference
Attachment 1 
Attachment 2 
Attachment 3 
Attachment 4 
Attachment 5 

Powered by