Path: news.easynews.com!easynews!ps01-sjc1!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: jusungyang@yahoo.com (Jusung Yang)
Newsgroups: comp.databases.oracle.tools
Subject: Re: CDI-15002 Error: Could not process Synonym 'RETAIL_TRANSACTIONS'
Date: 7 Aug 2002 20:54:24 -0700
Organization: http://groups.google.com/
Lines: 92
Message-ID: <42ffa8fa.0208071954.5714d47e@posting.google.com>
References: <EC240555544D90D1.7702301F08BB3D37.3E9DD270251300A0@lp.airnews.net>
NNTP-Posting-Host: 64.172.47.117
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028778864 24080 127.0.0.1 (8 Aug 2002 03:54:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2002 03:54:24 GMT
Xref: easynews comp.databases.oracle.tools:52902
X-Received-Date: Wed, 07 Aug 2002 20:51:29 MST (news.easynews.com)

This looks to be a Designer-specific error. This DOC from Metalink may
help, even though the error was due to sequence in this case?



Problem Description
-------------------
You try to generate a sequence to the database, using the Oracle
Designer Server
Generator. Generation fails with the following message:
 
     CDI-15002: Could not process sequence '<seq_name>' when creating
sequences.

Solution Description
--------------------
The problem indicates that the CG_CODE_CONTROLS table contains errors.
The
CG_CODE_CONTROLS table is generated to keep track of the sequence
generated.
This problem occurs only for code control sequences, because only
these
sequences make use of the CG_CODE_CONTROLS table.

You can check if the sequence that causes the error is a code control
sequence
by looking at the property 'Code Control?' in the property palette of
the
sequence:

1. Open the Design Editor.
2. Open the Tab Server Model.
3. Open the sequence node.
4. Open the property palette for the sequence that gives the problem.
5. Check the property 'Code Control?'. It will be set to 'Code Control
   Sequence'.

To investigate the CG_CODE_CONTROLS table:

1. Connect to the schema in which the sequence is generated using
SQL*Plus.
2. Do:

      SQL> SELECT cc_domain FROM cg_code_controls;

3. You will find more than one entry with CC_DOMAIN = <sequence name>.

CG_CODE_CONTROLS should only have ONE record with CC_DOMAIN=<sequence
name>.

Correct this by removing the duplicate record(s) and regenerating the
sequence,
or, if it is possible, remove the CG_CODE_CONTROLS table and
regenerate the
sequence.


jhking <jhking@airmail.net> wrote in message news:<EC240555544D90D1.7702301F08BB3D37.3E9DD270251300A0@lp.airnews.net>...
> I'm having a bit of trouble with Designer.
> 
> Designer 6.0 patch 7
> Server Generator 6.0.3.10.0.
> Client Windows 2000 sp 2, 256 mb ram.
> Server 8.1.7.3.0 on Windows NT.
> 
> On some tables I get this error:
> CDI-15002 Error: Could not process Synonym 'RETAIL_TRANSACTIONS'
> repeated 10's (in this case 51) times.  I was attempting to generate the 
> table retail_transactions.
> Other tables generate just fine.  I can work-around by generating to 
> file and then applying the file, but I'd like to get this to work, 
> because it seems to cause Designer to GPF if I do a bulk generate 
> involving one of the tables where I get this error.
> 
> I can make the problem go away by dropping public synonyms on the table 
> in the instance to which I'm compiling.
> I've been through the help on 'synonyms' about every way I can think of, 
> and nothing came up that seemed to apply.
> 
> Oracle's help for CDI-15002 is
> CDI-15002 Could not process %1 '%2'
> 
> Cause:
> 
> The specified object breaks internal Server Generator rules and cannot 
> be processed
> 
> Action:
> 
> Contact CASE support
> 
> Any thoughts or suggestions?