Solid Edge SEWHD: Steps to fix 'Unable to edit style-set'

In SEWHD, users are not able to edit stylesets even with full Admin permissions.

When users attempt to edit stylesets, they are given the popup message:

Cannot edit style set, open read-only?
You do not have sufficient privileges to edit style sets.
Either open in read-only or cancel. 

Solution

Steps to fix 'Unable to edit style-set' in SEWHD:


1. Download FixStyleSetPermissions.sql & VerifyStyleSetPermissions.sql.
Please get in touch with the Support team to get these files.

 Note: The commands below assume the sql files are located in your user downloads folder. If you move them after download, please revise the commands to reflect the new location.
 
2. Open a command line shell
 
3. Connect to the SEWHD database and run 'FixStyleSetPermissions.sql'. (See below in Notes/References section for command window example)

For example:
 
C:\Program Files\Siemens\Solid Edge Wiring and Harness Design 2021\embeddeddb\bin\psql.exe -U electrical2021 -p 5472 -f C:\Users\username\Downloads\FixStyleSetPermissions.sql
 
 -u – SEWHD database username (typically electricalXXXX where XXXX=your version. e.g: electrical2021)
  
-p – Port on which the postgres database is running
  
-f – Path to SQL script to run
 
4. After running the FixStylePermissions sql, verify the result of the script by running VerifyStyleSetPermissions.sql. 

For example:
 
C:\Program Files\Siemens\Solid Edge Wiring and Harness Design 2021\embeddeddb\bin\psql.exe -U electrical2021 -p 5472 -f C:\Users\username\Downloads\VerifyStyleSetPermissions.sql
 
We expect a count 1 to be returned for both the queries run in VerifyStyleSetPermissions.sql
 
5. Relaunch SEWHD application and verify that the user is able to edit style-sets.

Notes and References

Default Port number for SEWHD is 5472

                    https://www.postgresql.org/docs/9.6/backup.html

Example of the command window activity to execute the sql fix:

SEWHD = Solid Edge Wiring and Harness Design

Hardware/Software Configuration

Platform: all
OS: n/a
OS Version: n/a
Product: SOLID_EDGE
Application: SE_ELECTRICAL
Function: OTHER

Ref: 002-8564678