Designer 10g/XE - Repository Installation fails at CKSYSFOL

From: Michelle <rr_at_somewhere.com>
Date: Tue, 06 Jun 2006 15:22:36 +0200
Message-ID: <4485819a$0$12367$626a54ce_at_news.free.fr>

Operation: Started : 06/06/06 14:10:26
Reading File: cksysfol.sql
Object : CKSYSFOL CKSYSFOL

   Executing statement(s)...
Error Submitting Definition: User intervention required... RME-02124: Failed to execute SQL statement: DECLARE

   ar_irid                 number; 
   wkarea_irid		   number; 
   dummy_wrkarea           boolean := FALSE; 
   folder_irid             number; 
   folder_ivid             number; 
   org_irid                number; 
   org_ivid                number; 
   max_default_value_types number; 
   rtn_id                  number;  
   vat_type                number;   
   comment                 varchar2(100); 
   ps1_irid                number; 
   ps1_ivid                number; 
   l_SUPPORTS_DESIGNER     varchar2(1); 
   l_SUPPORTS_JDEVEE       varchar2(1); 
 
   TYPE t_Value_Type is record  
     ( name         varchar2(20)  
     , datatype     varchar2(20)  
     , lob_flag     varchar2(1)  
     , derived_from binary_integer  -- index number of source record  
     , irid         number          -- store irid for later use  
     ) ;  
  

   Type tt_Value_Type is table of t_Value_Type index by binary_integer;   

   init_value_types tt_Value_Type;   

BEGIN
  dbms_output.enable(1000000);  

• Added for Bug 1326447 update ck_installed_objects set ci_created = 'N' where ci_stage='CKSYSFOL';
• End addition for Bug 1326447

  select SUPPORTS_JDEVEE
  , SUPPORTS_DESIGNER
  into l_SUPPORTS_JDEVEE
  , l_SUPPORTS_DESIGNER
  from rm$repositories;  

• Check Global Shared Workarea exists dbms_output.put_line('* Checking if Global Shared Wokrarea exists' ); begin select irid into wkarea_irid from I$sdd_workareas where name = 'GLOBAL SHARED WORKAREA'; exception when no_data_found then dummy_wrkarea := TRUE;
  • Create a dummy workarea to put the SYSTEM FOLDER in wkarea_irid := jr_workarea.create_workarea( user, 'SYSTEM WORKAREA', 'Temporay WorkArea used to create the SYSTEM FOLDER'); end;
• Set workarea context jr_context.set_workarea(wkarea_irid);
• Now ORA-06512: à ligne 1270 ORA-04088: erreur lors d'exécution du déclencheur 'REPOS_MANAGER.SDD_FOLDERS_I' ORA-06512: à "REPOS_MANAGER.SDD_FOLDERS_I", ligne 136 ORA-06512: à "REPOS_MANAGER.JR_FOLDER", ligne 535 ORA-06508: PL/SQL : unité de programme nommée : "REPOS_MANAGER.JR_REG_IO" introuvable [Quoted] ORA-04063: package body "REPOS_MANAGER.JR_REG_IO" comporte des erreurs

Received on Tue Jun 06 2006 - 15:22:36 CEST