Designer 6i Install error message
Date: 2000/07/15
Message-ID: <396fdfac.9591953_at_news.giganews.com>
I got the following error after trying to install the default repository , Could someone help me past this section?
Message
ORA-04068: existing state of packages has been discarded
Cause
One of errors 4060 - 4067 when attempt to execute a stored procedure.
Action
Try again after proper re-initialization of any application's state.
Message
ORA-04063: package body "REP_USER.JR_WORKAREA" has errors
Cause
Attempt to execute a stored procedure or use a view that has errors. For stored procedures, the problem could be syntax errors or references to other, non-existent procedures. For views, the problem could be a reference in the view's defining query to a non-existent table.
Action
Fix the errors and/or create referenced objects as necessary.
Message
ORA-06508: PL/SQL: could not find program unit being called
Cause
Action
Message
ORA-06512: at line 93
Cause
Backtrace message as the stack is unwound by unhandled exceptions.
Action
Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.
Message
ORA-06512: at line 93
Cause
Backtrace message as the stack is unwound by unhandled exceptions.
Action
Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.
Message
RME-02124: Failed to execute SQL statement: DECLARE
wkarea_irid number; rtn_id number; comment varchar2(100); l_SUPPORTS_DESIGNER varchar2(1); l_SUPPORTS_JDEVEE varchar2(1);
BEGIN
dbms_output.enable(1000000);
select SUPPORTS_JDEVEE
, SUPPORTS_DESIGNER
into l_SUPPORTS_JDEVEE
, l_SUPPORTS_DESIGNER
from rm$repositories;
- Create a Shared WorkArea called GLOBAL SHARED WORKAREA dbms_output.put_line('* Creating Shared WorkArea named GLOBAL SHARED WORKAREA' );
wkarea_irid := jr_workarea.create_workarea( user,
'GLOBAL SHARED
WORKAREA',
comment,
'SHARED');
- Added to Fix 1132361 need to grant access on WA to PUBLIC so that subordinates can connect to it rtn_id := jr_acc_rights.ins( wkarea_irid , 'WA' , sdd_acc_priv_list('Y', -- 'Delete' 'N', -- 'Administrate' 'Y', -- 'Insert' 'Y', -- 'Select' 'Y', -- 'Update' 'N', -- 'Version' 'N', -- 'Compile' 'N') -- 'Update Spec' , 'PUBLIC');
- Revoke access rights from workarea dbms_output.put_line('* Revoking Configuration Management and Version Control access rights from GLOBAL SHARED WORKAREA');
update sdw_access_rights
set access_privs = sdd_acc_priv_list('Y', -- 'Delete'
'Y', --
'Administrate'
'Y', -- 'Insert'
'Y', -- 'Select'
'Y', -- 'Update'
'N', -- 'Version'
'N', -- 'Compile'
'N') -- 'Update Spec'
where object_type = 'WA'
and object_reference = wkarea_irid;
- Revoke system privileges from repository owner dbms_output.put_line('* Revoking Configuration Management and Version Control system privileges');
update sdw_users
set system_privs = sdd_sys_priv_list('N', -- 'Manage Workarea'
'N', -- 'Manage
Configuration'
'Y', -- 'Manage Container' 'Y', -- 'Manage User' 'N', -- 'Manage Branch Label' 'Y', -- 'Manage Dependency' 'N', -- 'Manage VVC' ** NOT USED ** 'Y', -- 'Register Schema' 'Y', -- 'Set Policy' 'N', -- 'Purge' 'Y', -- 'Force Delete' 'N', -- 'Global Purge' 'Y', -- 'Connect via Repository Object Navigator' 'Y', -- 'Connect via Repository Adminstration Utility' 'Y', -- 'Connect via Matrix Diagrammer' 'Y', -- 'Connect via Repository Reports' 'Y', -- 'Connect via Command Line Interface' 'N', -- 'Connect via Version History Viewer' 'N') -- 'Connect
via Version Event Viewer'
where username = user
and sdd_owner = 'Y';
commit;
dbms_output.put_line('* Operation Complete');
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('* Exception Raised ');
dbms_output.put_line('...ERROR: '||substr(sqlerrm,1,240));
rollback work;
RAISE;
END; Cause
An error occurred while executing a SQL statement.
Action
Examine reported errors for specific details. Received on Sat Jul 15 2000 - 00:00:00 CEST