This appendix lists the Workspace Manager error messages, including the cause and recommended user action for each.
LIVE workspaces in the workspace hierarchy or explicit savepoints in the LIVE workspace.LIVE workspace and there may be no explicit savepoints. A clean install of Workspace Manager is needed on the import platform.LATEST version of a workspace.LATEST version in the workspace by using the GotoWorkspace or GotoSavepoint procedures.WM_ADMIN system privilege can version-disable a table in another schema.WM_ADMIN system privilege can version-enable a table in another schema.WM_ADMIN system privilege or the owner of the workspace can alter workspace attributes.WM_ADMIN system privilege or the owner of the workspace can freeze a workspace.WM_ADMIN system privilege or the owner of the workspace can set the workspace lock mode.WM_ADMIN system privilege or the owner of the workspace or savepoint can alter the savepoint attributes.WM_ADMIN system privilege or the owner of the workspace or savepoint can delete the savepoint.ACCESS and MERGE privileges on the workspace on which it was invoked; or, in a multiparent workspace environment, the user does not have both ACCESS and MERGE privileges on the non-root workspaces and ACCESS privilege on the root workspace of the multiparent workspace graph.ACCESS privileges on the parent workspace of the workspace it was invoked on.ACCESS and MERGE privileges on the workspace on which it was invoked.ACCESS privileges on the workspace on which it was invoked.ACCESS privileges on the workspace on which it was invoked.ACCESS and REMOVE privileges on the workspace on which it was invoked.WM_ADMIN system privilege.LATEST version of the workspace.LATEST version in the workspace by using the GotoWorkspace or GotoSavepoint procedures.LATEST version of the workspace.LATEST version in the workspace by using the GotoWorkspace or GotoSavepoint procedures.grant_option parameter may only be YES or NO.SELECT, INSERT, UPDATE and DELETE privileges on the versioned table.SELECT, INSERT, UPDATE and DELETE privileges on the versioned table being conflict resolved.CREATE privileges on a workspace to be allowed to create a workspace off of it. Privileges can be granted using the grantWorkspacePriv or the grantSystemPriv procedures. Use the function GetPrivs to see which privileges you have on a workspace.GRANT option to be able to grant it to others.SELECT, INSERT, UPDATE and DELETE privileges on all versioned tables that were modified in the input workspace.SELECT, INSERT, UPDATE and DELETE privileges on all versioned tables that were modified in the input workspace.ACCESS_WORKSPACE, MERGE_WORKSPACE, ROLLBACK_WORKSPACE, REVOKE_WORKSPACE, and CREATE_WORKSPACE.lock_mode parameter (fifth parameter) of procedure UnlockRows.lock_mode are E, S, and ES (default is ES).all_or_user parameter (fourth parameter) of procedure UnlockRows.all_or_user. The valid values for all_or_user are ALL and USER (default is USER).LIVE workspace.LIVE. The LIVE workspace is the default workspace for any session that is connected and Workspace Manager does not monitor users in the LIVE workspace. Do not invoke this method on the LIVE workspace.LIVE workspace in NO_ACCESS mode. Workspace Manager does not support this mode for the LIVE workspace.READ_ONLY, 1WRITER, 1WRITER_SESSION, WM_ONLY) modes to freeze the LIVE workspace.ACCESS privilege.ACCESS privilege can be passed to SetMultiWorkspaces.LIVE workspaces and then version-disable the table without the FORCE option.SELECT privilege on the parent table.SELECT privilege on the parent table. Grant the required privilege before version-enabling.ACCESS and MERGE privileges on the child workspace on which it was invoked; or, in a multiparent workspace environment, the user does not have both ACCESS and MERGE privileges on the non-root workspaces and ACCESS privilege on the root workspace of the multiparent workspace graph.ACCESS privilege on the parent workspace.ACCESS privilege on the parent workspace before invoking RefreshTable or RefreshWorkspace. Privileges can be granted using the GrantWorkspacePriv or the GrantSystemPriv procedures. Use the GetPrivs function to see which privileges the current user has on a workspace.LIVE workspace.LIVE workspace. The user needs to be in the LIVE workspace before invoking CreateWorkspace for creating a continually refreshed workspace.freezemode parameter.NO_ACCESS, READ_ONLY, 1WRITER, 1WRITER_SESSION, WM_ONLY). Ensure that FreezeWorkspace is invoked with the correct parameters.freezewriter parameter.freezewriter parameter for the FreezeWorkspace procedure can be non-null only when the freezemode parameter is 1WRITER. Ensure that FreezeWorkspace is invoked with the correct parameters.keep parameter.keep parameter to the ResolveConflicts procedure is one of (CHILD,PARENT,BASE). This parameter is not case-sensitive. See the Resolving Conflicts section of the Workspace Manager documentation for details on the process of conflict resolution.LIVE workspace.LIVE workspace, use the RollbackToSP operation. To remove descendants to the LIVE workspace, use the RemoveWorkspace operation on the child workspaces.lockmode parameter.C(carry-forward), D (disregard), E (exclusive), S (Shared), VE (version exclusive), or WE (workspace exclusive). For a discussion of the differences and similarities among these modes, see the Workspace Manager documentation.WM_ADMIN_ROLE, or by a user with the WM_ADMIN system privilege using the UnfreezeWorkspace procedure.where_clause parameter as input.where_clause parameter contains only valid column names and has proper syntax. The where_clause parameter for this Workspace Manager operation can contain only columns that are part of the primary key.LATEST savepoints in the workspace. CompressWorkspace requires that all sessions in the specified workspace be on the LATEST version of the workspace.LATEST savepoint using GotoSavepoint. Privileged users can view all the sessions in a workspace using the DBA_WORKSPACE_USERS view.ACCESS privileges on the workspace.ACCESS privileges on the workspace. Invoke the UnlockRows operation only on workspaces that you have ACCESS privileges for.WM_ADMIN_ROLE role or the WM_ADMIN system privilege, or the user who initiated the BeginResolve operation on the workspace, can issue a CommitResolve or RollbackResolve call for that workspace.WM_ADMIN system privilege.WM_ADMIN system privilege.WM_ADMIN_ROLE role or WM_ADMIN system privilege or the owner of the workspace can unfreeze a frozen workspace.where_clause parameter of LockRows to specify those rows that have not already been versioned.freezewriter parameter.freezewriter parameter of the FreezeWorkspace procedure must be null whenever the session_duration parameter is TRUE. The freezewriter is implicitly assumed to be the currently connected session. Ensure that FreezeWorkspace is invoked with the correct parameters.session_duration parameter.session_duration parameter of the FreezeWorkspace must be TRUE when attempting to freeze a workspace in 1WRITER_SESSION mode. Ensure that FreezeWorkspace is invoked with the correct parameters.FREEZE_WORKSPACE privilege on the workspace, or FREEZE_ANY_WORKSPACE, the WM_ADMIN_ROLE role, or the WM_ADMIN system privilege to the user trying the operation.SQL> EXECUTE WMSYS.OWM_MIG_PKG.AllFixSentinelVersion;WM_ADMIN system privilege or WM_ADMIN_ROLE role is required to invoke this specific operation. Ensure that the current user has the required privileges to invoke this operation.ignore_last_error => TRUE' with DisableVersioning.)auto_commit value of TRUE is invalid if the current session has an open database transaction on that workspace.auto_commit value of FALSE.NONCR_WORKSPACE_MODE is set to PESSIMISTIC_LOCKING.NONCR_WORKSPACE_MODE is set to OPTIMISTIC_LOCKING. To see the current Workspace Manager system parameter settings, use the WM_INSTALLATION metadata view.CR_WORKSPACE_MODE or NONCR_WORKSPACE_MODE is set to PESSIMISTIC_LOCKING and the DML operation violates the system setting.LIVE workspaces, you can change the PESSIMISTIC_LOCKING setting to OPTIMISTIC_LOCKING. To see the current Workspace Manager system parameter settings, use the WM_INSTALLATION metadata view.LIVE workspaces.LIVE workspaces for the workspace type (continually refreshed or not continually refreshed) for which the parameter is being set.ALLOW_CAPTURE_EVENTS was set to OFF.ALLOW_CAPTURE_EVENTS to ON, and retry the operation.SetCaptureEvents('ALL_EVENTS','OFF'), and retry the operation.ALLOW_MULTI_PARENT_WORKSPACES to OFF when one or more multiparent workspaces existed in the system.ALLOW_NESTED_TABLE_COLUMNS to OFF when one or more version-enabled tables contained a nested table column.ALLOW_NESTED_TABLE_COLUMNS was set to OFF.ALLOW_NESTED_TABLE_COLUMNS to ON, and retry the operation.WM_ADMIN system privilege or WM_ADMIN_ROLE role to the executing user, or execute the procedure as the owner of the table.remove_data parameter to false, or do not execute the operation on the table for the specified workspace.instant and savepoint parameters.LIVE workspace, the savepoint_name parameter must be either 'LATEST' or 'ROOT_VERSION'. When bulk loading into any workspace other than LIVE, the savepoint_name parameter must be 'LATEST'.enforce_ric parameter to false.workspace=>'LIVE', PurgeAfter=>true, savepoint_name=>null, instant=>null.ADD_VALID_TIME option of alterVersionedTable for a version-enabled table that already has the validtime option enabled.wm_valid column was found.wm_valid column so that the validfrom column is non-null and the validtill column is not less than the validfrom column.