Re: CDI-15002 Error: Could not process Synonym 'RETAIL_TRANSACTIONS'

From: Jusung Yang <jusungyang_at_yahoo.com>
Date: 7 Aug 2002 20:54:24 -0700
Message-ID: <42ffa8fa.0208071954.5714d47e_at_posting.google.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_at_airmail.net> wrote in message news:<EC240555544D90D1.7702301F08BB3D37.3E9DD270251300A0_at_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?
Received on Thu Aug 08 2002 - 05:54:24 CEST