Designer 2000 v6.0.5.0 bugs

From: <kramm_at_pcnet.com>
Date: 1995/07/17
Message-ID: <3uet9a$3fk_at_emperor.texas.net>


Mark A. Kramm (Oracle*CASE Specialist)
Palindrome Solutions, Inc.
kramm_at_pcnet.com
800-483-8771

Desiger 2000 v6.0.5.0 Bugs

This is a working document that I have been compiling. I have found more bugs then have been identified in this document. If you would like to contribute to this document, please e-mail your bugs to kramm2pcnet.com or call 800-483-8771. I will post an update early next week. Most of these problems should be fixed in the new release 6.0.6.0. I am installing it today, I will let you know.

  1. In Edit Function window of the Function Hierarchy Diagrammer using the Attribute Usage Tab, When you insert an attribute, the previous attribute loses its properties in the usage type checkboxes. When you then try to recheck the usage boxes a dialog box appeares that displays"? The selected element has has been deleted from the Repository YES NO". Respond NO otherwise it will delete the attribute from the function.
  2. The Function Hierarchy Diagrammer does not display the Master Function on the screen for a common functions. You must look at the details of the function to identifie the master function.
  3. REPORT: "Entities not used by functions" in the "Report Repository" under
    "Tools" does not run. Error "REP-1814:Infinite report detected. Object
    `G_E_3' can never fit horizontally".
  4. Requery does not work for all objects in the Object Navigator Screen Modules do not get requeried all other objects do.
  5. When mapping Entites to Tables recieved error message CDA-01026: Table
    "table_name": Maximum length of Journal table names is 27 characters. I
    think that what the tool is doing is for Primary and Foreign key names, it is adding a "_PK" or "_FK" to the names. If the entity name is 30 to begin with it is exceeding the 30 character limit for oracle. We changed all entities of 30 characters to 27. Also the `Help' for entities indicates the length maximum is 40 characters.
  6. Recieved error `ORA-00904: Invalid Column Name' When generating Tables and Indexes at the same time or when generating indexes only. Solution: Generate Tables first, then generate the indexes.
  7. When generating DDL, `UTILITIES>DDL GENERATER', click off Oracle 7.1. DLL will not generate if it is cheked on.
  8. Generating modules - Do not use commas (,) in short definition of the function in the function hierarchy. Each comma (,) appears to truncate everything after it when generating candidate Modules. The report cdad.lis shows this problem.

The following is how Notes, Descreiption and Comments migrate and are used  from upper CASE "Entities" down through to lower CASE as a "genterated Form".

Enity
  Description becomes table description
  Notes becomes table notes  

Attribute
  Comment becomes Column Hint
  Description becomes Column Description   Notes becomes Column Notes
Table
  Table Description came from Entity Description   Table Notes came from Entity Notes  

Column
  Column (Comment, Hint) comes from Attribute Comment  Column Description (Nothing migrated down) (We typed in manually)  Column Notes (Nothing migrated down) (We typed in manually)  

Module
  Description (A "." always appeared) (We typed in manually)   Notes "Developed by Design Wizard" (can be overriden)   User Help Text (Nothing migrated down) (We typed in manually)

Detail Module Table Usage
  Description (Nothing migrated down) (We typed in manually)   Notes (Nothing migrated down) (We typed in manually)   User Help Text (Nothing migrated down) (We typed in manually)

Detail Module Column Usage
  Hint Text came from Table Comments
  Description (Nothing migrated down) (We typed in manually)   Notes (Nothing migrated down) (We typed in manually)   User Help Text (Nothing migrated down) (We typed in manually)

Generated Form
  Detail Module Colunm Usage User Help Text became the Field Level Help Text   Detail Module Table Usage User Help Text became the Block Level Help Text   Module User Help Text became the Form Level Help Text  


|Mark A. Kramm                                              Palindrome Solutions Inc.|
| - Oracle*CASE Designer 2000 Specialist      (800) 483-8771                |
| - Data Architect/Facilitator                            kramm_at_pcnet.com         |
 --------------------------------------------------------------------------------------------------------------
Received on Mon Jul 17 1995 - 00:00:00 CEST

Original text of this message