Re: Designer 10g/XE - Repository Installation fails at CKSYSFOL

Michelle schrieb:
> Hi all,
>
> I am trying to reinstall Oracle Designer, but can't get further than
> stage CKSYSFOL. It complains about missing REPOS_MANAGER.JR_REG_IO
> code for trigger on SDD_FOLDERS ... For what i understand
>
> The attached report includes messages in french,
> that I translate approximately here:
>
> ORA-06512: at line 1270
> ORA-04088: error when running trigger 'REPOS_MANAGER.SDD_FOLDERS_I'
> ORA-06512: at "REPOS_MANAGER.SDD_FOLDERS_I", line 136
> ORA-06512: at "REPOS_MANAGER.JR_FOLDER", line 535
> ORA-06508: PL/SQL : could not find program unit "REPOS_MANAGER.JR_REG_IO"
> ORA-04063: package body "REPOS_MANAGER.JR_REG_IO" has errors
>
> I cleaned all and restarted, but the same error occurs again.
>
> On Google, I found a single discussion about CKSYSFOL ...
> back in 2001 on Designer 6i:
> http://groups.google.com/group/relcom.comp.dbms.oracle/browse_thread/thread/fa433af4657adf96/115fd0e8425dd408?lnk=st&q=cksysfol+error&rnum=1&hl=fr#115fd0e8425dd408
>
> , but it is in russian, that I can't understand.
>
> I use a fresh install of Database XE, which runs ok.
>
> Would someone have any idea ?
>
> --
> TIA
>
> Michelle Baert
>
>
> ------------------------------------------------------------------------
>
> 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
> ORA-04063: package body "REPOS_MANAGER.JR_REG_IO" comporte des erreurs

[Quoted] In the thread you cited the problem was missed grant on sys.utl_file to repository owner (it claims also , it is not documented to have this grant). After grant was issued problem is gone. Maybe it helps. I can good imagine this can be your issue, because in XE utl_file is not more granted to public.

Best regards

Maxim Received on Tue Jun 06 2006 - 15:35:54 CEST