1 Reply Latest reply: May 14, 2013 9:29 AM by user8950278 RSS

    Problems executing an processflow out of sqldeveloper with different user

    user8950278
      Hi everybody,

      i have problems executing an process flow out of sql developer with an different user than the workspace owner.

      Although i have executed exec owbsys.wb_workspace_management.set_workspace('OWBWORKSPACE','WORKSPACEOWNER'); before trying to start the process flow out of sql developer, i get the following error:

      ORA-20008: The workspace with name:OWBWORKSPACE and owner:EXECUTIONUSER does not exist. You can find out the existing workspace information from view ALL_IV_WORKSPACE or view WORKSPACE_ASSIGNMENT.
      ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1602
      ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1569
      ORA-06512: at "OWBSYS.WB_RT_SCRIPT_UTIL", line 1028
      ORA-06512: at "WORKSPACEOWNER.START_PROCESSES", line 31
      ORA-06512: at line 3

      We use OWB 11.2.0.3.
      One more information, in my pl/sql procedure (START_PROCESSES) i have the following line owbsys.wb_rt_script_util.set_workspace ('OWBWORKSPACE');

      I hope anybody can helo me out of this.

      Greetings