APAR status
Closed as program error.
Error description
Attempts to delete workspace from an encyclopedia in SAEM, results in timeout error which reads 'An error occured while deleting a workspace, Description: Timeout expired'. The workaround to delete these workspaces is to run the following queries in SQL Server Management Studio - Do not use SAEM because SAEM uses whatever timeout value it is coded to use not what SQL Mgmt Studio is setup to use exec SASP_WorkspacesDelete 7, 0 (where 7 is the Workspace ID found by running the query: select * from Workspaces) The timeout setting should already be set by default to 0, but you should check if possible in SQL Server Management Studio: Tools \ Options Under Query Execution \ SQL Server \ General Execution time-out: 0 Note it can still take a while for the workspace(s) to be deleted.
Local fix
Problem summary
Attempts to delete workspace from an encyclopedia in SAEM, results in timeout error which reads "An error occured while deleting a workspace, Description: Timeout expired".
Problem conclusion
The timeout value for the delete command needs to be increased. Actually, now the timeout value for the delete command has been set to 0, meaning never timeout.
Temporary fix
The workaround to delete these workspaces is to run the following queries in SQL Server Management Studio - Do not use SAEM because SAEM uses whatever timeout value it is coded to use not what SQL Mgmt Studio is setup to use exec SASP_WorkspacesDelete 7, 0 (where 7 is the Workspace ID found by running the query: select * from Workspaces) The timeout setting should already be set by default to 0, but you should check if possible in SQL Server Management Studio: Tools \ Options Under Query Execution \ SQL Server \ General Execution time-out: 0 Note it can still take a while for the workspace(s) to be deleted.
Comments
APAR Information
APAR number
PM89962
Reported component name
TLOGIC SYS ARCH
Reported component ID
5724V68SA
Reported release
B41
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-05-29
Closed date
2013-10-09
Last modified date
2013-10-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TLOGIC SYS ARCH
Fixed component ID
5724V68SA
Applicable component levels
RB42 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS6RBX","label":"Rational System Architect"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.4.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
09 October 2013