There is a hot fix for this problem that has not yet made it to the patch download page. Below are instructions on getting and applying this hot fix.
Note if you do not have SR1 installed as mentioned below, you can get SR1 from: http://www.rational.com/support/downloadcenter/upgrades/rose.jsp After applying that, you would go ahead and replace the DM files. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Location of OM .20 Data Modeler Files: ftp://exchange.rational.com/exchange/outgoing/cathyr/om_dm_20 This can only be applied to Rose 2002 + Service Release 1. NOTE you should have Service Release 1 installed, prior to installing this patch. In this directory you will find 3 files: RoseDataModeler.Dll RoseDataModeler.Zip RoseDataModelerResources.Dll Instructions to install 1. Shut down Rose, 2. Copy these 3 files to, C:\Program Files\Rational\Rose\datamodeler or the location you installed Rose to. 3. When prompted to replace files, click "Yes to All" 4. From the command line, register the Data Modeler dll file (RoseDataModeler.dll) using regsvr32 with the commands: C:\Program Files\Rational\Rose\datamodeler> regsvr32 RoseDataModeler.Dll NOTE: RoseDataModelerResources.dll does NOT need to be registered. 5. Restart Rose. -------------------------------------------------------------------- Data Modeler Defects addressed in this update -------------------------------------------------------------------- 21000 - Oracle columns having NUMBER type without width specifier are being reverse engineered as FLOAT type columns. 25269 - Opening models created with previous versions of Rose could cause deletion of primary keys. 26023 - Requirement to support Unicode and Unicode Big Endian file for Oracle parser. 28329 - Help button on Oracle Tablespace Spec linking to SQL Server help topic. 29869 - Unable to use Data Modeler:New when parent package is write protected. 31323 - Data modeler requires write access to the model file. 53698 & 82856 - Settings not retained correctly in reverse engineering wizard. 54219 - Language default changes incorrectly to Data Modeler upon using Data Modeler to reverse engineer a DB from a database. 54925 - Unable to update Table Specification in a write-enabled controlled unit nested in a write-protected controlled unit or model. 56226 - Data Modeler duplicates the foreign keys when regenerating the data model. 56320 - Visual defect when reassigning the schema to a new database. 57794 - Unable to reverse engineer DDL script files using MS SL 2000. 58227 - Transform to Data Model for Sybase does not function as expected. 58674 - Reverse engineering a Sybase 12 Database may cause java. lang.ArrayIndexOutOfBound Exception. 66308 - Not Null values not retained in column specification. 66487 - Unable to uncheck Not Null Checkbox in Domain Specification Window. 66530 - NOT NULL stays checked in domain types assigned to a column. 70539 - Sorting columns may cause an com.ms.wfc.core.WFC Exception. 70568 - Exception may occur when reverse engineering database - java.lang.IndexOutOfBoundsException: Insufficient space in SAFEARRAY. 71609 - Upon to locate schema information upon attempting to reverse engineer in Sybase 12 database, 71844 - Parser error (Error: Encountered "KEY" at column n[xx]l) occurs when attempting to reverse engineer from DDL in Oracle 8.x. 72171 & 82857 - Parser error on ALTER TABLE, PRIMARY KEY (Error: Encountered "KEY" at column n(T_n)) may occur upon reverse engineering in Oracle 8. 72763 - Requirement to support Oracle 9i. 73038 & 75794 - Error occurs upon attempting to reverse engineer DDL file which includes date type in Oracle 8.x. 76731 & 82859 - DB2 parser error occurs upon attempting to reverse engineer DDL which includes REFERENCE clause. 76802 - DB2 OS/390 reverse engineering issues if the table creator is not the same as the creator of the database. 78479 - NULL value of Not Null not retained in specification dialog. 80439 - Rose may crash upon transforming views from object to data model. 81337- Not Null settings not retained correctly. Once domain is assigned UNIQUE checkbox is read only, which is correct. It is necessary to edit the domain for unique constraint, not from the column which has a domain data type. 82856 - Reverse engineered DDL Script location doesn't persist after wizard is closed (...then reopened). 86336 - Crash when reverse engineering schema that does not belong to UserID and TBCreator is specified. -------------------------------------------------------------------- Patrick Kennedy Rational Support -----Original Message----- From: Sundareswaran, Sumesh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 8:25 AM To: [EMAIL PROTECTED] Subject: (ROSE) Domain - Not Null problem Hi, When I create a domain, it gives the domain the not null property by default. Even if I remove it, it tends to stick...Is this a bug? Thanks, *************************************** Sumesh Sundareswaran KPMG Consulting - Atlanta,GA Off : 404-352-6519 Cell : 678-524-3022 *************************************** ************************************************************************ * Rose Forum is a public venue for ideas and discussions. * For technical support, visit http://www.rational.com/support * * Post or Reply to: [EMAIL PROTECTED] * Subscription Requests: [EMAIL PROTECTED] * Archive of messages: * http://www.rational.com/support/usergroups/rose/rose_forum.jsp * Other Requests: [EMAIL PROTECTED] * * To unsubscribe from the list, please send email * To: [EMAIL PROTECTED] * Subject: <BLANK> * Body: unsubscribe rose_forum ************************************************************************* ************************************************************************ * Rose Forum is a public venue for ideas and discussions. * For technical support, visit http://www.rational.com/support * * Post or Reply to: [EMAIL PROTECTED] * Subscription Requests: [EMAIL PROTECTED] * Archive of messages: * http://www.rational.com/support/usergroups/rose/rose_forum.jsp * Other Requests: [EMAIL PROTECTED] * * To unsubscribe from the list, please send email * To: [EMAIL PROTECTED] * Subject: <BLANK> * Body: unsubscribe rose_forum *************************************************************************
