JR30557: Problems reverse engineering a DDL file

Rational Application Developer for WebSphere Software, Version 7.5.3
Rational Software Architect Standard Edition, Version 7.5.3

APAR status

• Closed as fixed if next.

Error description

• ****Description field information .****
  What action is Support requesting from Development?
     Information on errors, why this is happening.
  Problem Description
     When generating PDM from DDL script, errors
  appear.
  Is this an evaluation customer?
     No
  Can the customer upgrade to the latest version? What version do
  they need a fix for?
     Already using latest version.
  What is the Operating System & Service Pack?
     Windows XP SP2
  What are the RDA Build ID, version number, and other Rational
  Products Installed?
     7.0.0.5
  Is this an existing install or new install?
     Existing
  Where is RDA installed?
     Locally
  Were there any errors during installation?
     None
  Does the user(s) have read/write privileges to the registry?
     Yes
  How many users are affected?
     All
  Is the customer using Version control? If so, what?
     N/A
  What file(s) failed to load?
     None
  Can they send the model?
     Yes - They sent DDL script
  What has changed since the last time the product worked?
     Nothing
  Has a check model been performed?
     Yes
  Are you able to reproduce this?
     Yes
  What are the exact steps to reproduce the issue(s)?
  1)   Create a new Data Design Project
  2)   Create new text document as test.ddl and paste
  in script provided at the end of this document
  3)   Save test.ddl, in RDA go to File -> Import ->
  File System and select test.ddl
  4)   Right Click Data Models and choose New ->
  Physical Data Model
  5)   Choose a filename with an Oracle 10 Database
  6)   Select ?Create from reverse engineering? and
  click next
  7)   Choose ?DDL Script? and then locate test.ddl on
  the next screen.
  8)   Leave all 3 check boxes in the Options window
  blank and click next.
  9)   Note that 2 errors occur. One at ?SELECT? and
  the other on ?+?
  What things have you tried?
     Syntactical changes
   Is it happening on just one machine?
     No
  What is the customer expecting as the result?
     An explanation of the ?SELECT? and ?+? errors,
  or a workaround
  Does the customer have a work around?
     No
  What is the customer?s temperature?
     Warm
  What version database are you trying to connect to?
     Oracle 10
  What driver is being used?
     N/A
  Did you try exporting to DDL and reverse engineering? Is the ddl
  attached?
     Yes, this is when the errors are thrown. The
  DDL script text is included at the end of this document.
  Is this known product defect? If so, provide a RATLC number?
     Not a known defect.
  Have you attached all related files?
     Yes
  Who is their sales rep and is a sale on the line?
     Unknown
  
  
  ////////////////////////////////////////////////////////////////
  ///////////////////////////////////////////////////////////
  test.ddl script text
  
  CREATE TABLE S527.SCL_ANDAMENTO_ADV (
  
    ANAD_NUM_ANDAMENTO NUMBER(2 , 0) NOT NULL,
  
    ADSI_NUM_ADITIVO NUMBER(2 , 0) NOT NULL,
  
    PRLI_NUM_SOL NUMBER(12 , 0) NOT NULL,
  
    ANAD_DSC_ANDAMENTO VARCHAR2(4000),
  
    ANAD_DAT_CADASTRO DATE,
  
    ANAD_DAT_CANCELAMENTO DATE,
  
    ANAD_DSC_ASSUNTO VARCHAR2(100),
  
    ANAD_DAT_OCR_FATO DATE,
  
    USUA_NUM_SEQ NUMBER(5 , 0)
  
   );
  
  
  
  CREATE PROCEDURE usp_527_andamento_adv_insert (
  
    V_NumSol IN SCL_ANDAMENTO_ADV.PRLI_NUM_SOL%TYPE,
  
    V_NumAditivo IN SCL_ANDAMENTO_ADV.ADSI_NUM_ADITIVO%TYPE,
  
    V_NumAndamento IN SCL_ANDAMENTO_ADV.ANAD_NUM_ANDAMENTO%TYPE,
  
    V_DscAndamento IN SCL_ANDAMENTO_ADV.ANAD_DSC_ANDAMENTO%TYPE,
  
    V_DscAssunto IN SCL_ANDAMENTO_ADV.ANAD_DSC_ASSUNTO%TYPE,
  
    V_DatOcrFato IN SCL_ANDAMENTO_ADV.ANAD_DAT_OCR_FATO%TYPE,
  
    V_NumSeq IN SCL_ANDAMENTO_ADV.USUA_NUM_SEQ%TYPE
  
    )
  
  AS
  
  BEGIN
  
    INSERT INTo SCL_ANDAMENTO_ADV (
  
      PRLI_NUM_SOL,
  
      ADSI_NUM_ADITIVO,
  
      ANAD_NUM_ANDAMENTO,
  
      ANAD_DSC_ANDAMENTO,
  
      ANAD_DAT_CADASTRO,
  
      ANAD_DAT_CANCELAMENTO,
  
      ANAD_DSC_ASSUNTO,
  
      ANAD_DAT_OCR_FATO,
  
      USUA_NUM_SEQ)
  
    VALUES (
  
      V_NumSol,
  
      V_NumAditivo,
  
      (SELECT COALESCE(MAX(ANAD_NUM_ANDAMENTO), 0)+1 from
  
  SCL_ANDAMENTO_ADV where PRLI_NUM_SOL= V_NumSol and
  ADSI_NUM_ADITIVO =
  V_NumAditivo),
  
      V_DscAndamento,
  
      sysdate,
  
      null,
  
      V_DscAssunto,
  
      V_DatOcrFato,
  
      V_NumSeq);
  
  END;;
  

Local fix

Problem summary

• Fixed in next release
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R750 PSY

     UP