This section includes the list of issues that is fixed.
This section contains the following topics:
The following issues are fixed in this release:
Problem No.: 11678 Issue No.: 21799070-1-Problem Creating Views
In CA ERwin Data Modeler release r9.5, when a DB2 for iSeries v5.x/6.x/7.x model was forward engineered, the schema did not include the related column name in the syntax for CREATE VIEW.
Problem No.: 12821 Issue No.: 21761196-1 - Forward Template Error
In CA ERwin Data Modeler Release r9.5.01, the button names are truncated on the Forward Engineer Schema Generation dialog on Windows 8 Korean language operating system.
Problem No.: 13029 Issue No.: 21846962-1 - Harden Physical Name Error
In CA ERwin Data Modeler Release r9.0 through r 9.5.2, when a self-referencing relationship was role-named in the Logical view of a Logical/Physical model, and the Physical name was hardened, the Physical view still showed the foreign key name .
Problem No.: 1332 Issue No.: 21703337-1- Martupgrade Utility – Stopped
When a specific Mart was being upgraded from Release r8.2 to r9.5 using the Mart Upgrade utility, the users and profiles were upgraded, but not the models. The utility stopped working as soon as the models were selected. The hardware details are as follows:
Problem No.: 12868 Issue No.: 21874953-1- Unchecking Delimit Identifiers
Issue No.: 21798744-1: DELIMIT IDENTIFIERS NOT FUNCTN
In CA ERwin Data Modeler Release r9.5.2, while forward engineering a SQL Server 2012 model, if the Delimit Identifiers check box was cleared, the generated script still included brackets for identifiers. It was noticed that the Using Brackets option was selected even when the Delimit Identifiers option was cleared.
Problem No.: 13027 Issue No.: 21873647-1- Oracle 11 Create Index Wo Drop
In an Oracle 11g model in CA ERwin Data Modeler Release r9.5.2, when an existing IE index was changed and the Alter script generated, there was no DROP INDEX statement before the CREATE INDEX statement.
Problem No.: 13049 Issue No.: 21913039-1- Wrong Connection Help File
In CA ERwin Data Modeler Release r9.5.2, the wrong help file appeared when the Database Connection option was clicked on the Actions menu. The help text described connecting to the Mart, instead of describing connecting to a database.
Problem No.: 13016 Issue No.: 21893401-1:MODEL CRASHES WHILE UPGRADING
When a specific model was opened in CA ERwin Data Modeler Release R9.5, it crashed and displayed a message to contact CA Technical Support.
Problem No.: 13019 Issue No.: 21883680-1:RUNTIME ERR OPEN MDL AFTER SAV
In a specific Oracle 10g model in CA ERwin Data Modeler Release R9.5, when the Subject Area was switched, a new table was added, and the model was saved, the model could not be opened again. The ‘Runtime Error’ message was displayed.
Problem No.: 13039 Issue No.: 21909226-1:DS COMMENT CARRIAGE RETURN
In CA ERwin Data Modeler Release r9.5.2, when the Data Movement check box was selected for a model, comments could not be entered properly in the DS Comments dialog, which is part of the Column Editor. When Enter was pressed in the first line of the comment, the Column Editor closed.
Problem No.: 12456 Issue No.: 21444712-1: TRY TO OPEN A R7.2.9 MODEL IN R8.2.3, ERWIN CRASH
When a specific model of Mart Release r7.2.9 was upgraded to Mart Release r8.2.3 and the model was opened in CA ERwin Data Modeler Release r8.2.3, the application crashed.
Problem No.: 12995 Issue No.: 21870698-1: DERIVED ENTITY HAS WRONG NAME
In a logical only model in CA ERwin Data Modeler Releases r9.2, r9.5, and r9.5.2, suppose a many-to-many relationship was created and transformed, and the associate entity was renamed. If a physical only model was derived from this model, the new name of the associate entity was not retained.
Problem No.: 12985 Issue No.: 21868566-1: DATE TRUNCATED ON PRINT DIAG
In CA ERwin Data Modeler Release r9.5.2, when the Region and Language of the operating system was changed to United Kingdom and English, the year portion of the date was truncated on the printed diagrams. The truncation appeared under Margins in the Page Setup dialog.
Problem No.: 12939 Issue No.: 21843223-1: REVERSE ENGINEER MYSQL CRASH
In CA ERwin Data Modeler Release r9.5, when a script was used to reverse engineer from a specific MySQL database, the application crashed without any error message. When an edited script was run, it displayed parsing errors.
Problem No.: 13018 Issue No.: 21867692-1- Connect To Oracle Failed
In CA ERwin Data Modeler Release r9.5.2, when connecting to a specific Oracle 11g Mart, the error message, "Unhandled exception has occurred in your application. If you click continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. Object reference not set to an instance of an object.”
Problem No.: 12994 Issue No.: 21867021-1: ERWIN CRASHES AT SUB-PARTITION
In CA ERwin Data Modeler Release r9.5 and r9.5.2, when a partition type was changed on the sub-partition Tab, the application crashed.
Problem No.: 12847 Issue No.: 21717539-1: REVERSE ENGINEER FAILS ON ORAC
In CA ERwin Data Modeler Release r9.5, when a specific Oracle 11g database was reverse engineered, the application crashed when Table, Synonym was selected in the option set. However, the database was reverse engineered without any problems when synonyms was not selected.
Problem No.: 12531 Issue No.: 21794739-1: ERWIN CRASH UPGRADE MDL TO 9.5
A specific CA ERwin Data Modeler Release r7.3.11 model could not be opened in r9.5. The user tried to open the model in multiple ways, but the application crashed every time.
Problem No.: 12935 Issue No.: 21844800-1: ALTER MISSING DROP IE INDEX
In an Oracle 10g/11g model in CA ERwin Data Modeler Release r8.2.08, suppose a table had an IE index, a PK index, and an AK index, and a few columns. If the data type of a column was changed and the ALTER script was generated, the script did not include DROP IE Index statements, but it included CREATE IE Index statements.
Problem No.: 12541 Issue No.: 21511492-1: DS COMMENTS LOST AFTER PASTE
In CA ERwin Data Modeler Release r9.0, suppose a comment was copied and pasted to multiple columns in the DS Comment tab in the Column Editor. While pasting comments, if the Forward and Back buttons were used to navigate between the columns, the comment entered in the previous column was lost when the Back button was clicked.
Problem No.: 12949 Issue No.: 21849876-1: Dangling Rel. Line
Dangling relationship lines are displayed in the Subject Area model view.
Problem No.: 12963 Issue No.: 21843606-1: FE SP_ADDEXTENDEDPROPERTY
When a specific SQL Server 2008/2012 model was upgraded from CA ERwin Data Modeler Release r7.3 to r9.5.2 and the model was forward engineered, the following error was displayed:
EXEC sp_addextendedproperty
@name = 'MS_Description', @value = 'Stores data about a patient.',
@level0type = 'SCHEMA', @level0name = 'dbo',
@level1type = 'TABLE', @level1name = 'Patient',
@level2type = 'INDEX' -- this parameter should not be generated for a table
go
EXEC sp_addextendedproperty
@name = 'MS_Description', @value = 'Defines the users in Five9 that are
allowed access to this database.',
@level0type = 'SCHEMA', @level0name = 'dbo',
@level1type = 'TABLE', @level1name = 'Five9User',
@level2type = 'CONSTRAINT' -- this parameter should not be generated for a
table
Go
This error was not displayed when the model was forward engineered in CA ERwin Data Modeler Release r7.3.
Problem No.: 12850 Issue No.: 21795357-1: FE-UDB PK DO NOT GENERATE
In a DB2 LUW model in CA ERwin Data Modeler Release r8.2.08, despite setting the Primary Key to Not Generate, the primary key constraint was generated during forward engineering.
Problem No.: 12968 Issue No.: 21864635-1: Add Dbo In The List Of Owners
In CA ERwin Data Modeler Release r9.5.2, dbo was missing in the list of owners in the SQL Server Schema Editor.
Problem No.: 11796 Issue No.: 21865311-1: Fe: Check Model Crash ERwin
In CA ERwin Data Modeler Release r9.5, when two specific Oracle 10g models were forward engineered, the process did not complete and the application stopped responding.
Problem No.: 12956 Issue No.: 21854890-1: TLX QUESTIONS ON WRITEFILE
In CA ERwin Data Modeler Release r9.5, documentation was missing for the new macro named WriteFile.
Problem No.: 12952 Issue No.: 21851810-1: CAN'T UPGRADE A BIG MODEL
When a specific model was being upgraded from CA ERwin Data Modeler Release r7 to r9.5 the error message, "Unexpected condition. Please contact CA Support." appeared.
Problem No.: 12964 Issue No.: 21572494-1: FAIL TO DRIVE PHYSICAL MODEL TO L/P MODEL
In CA ERwin Data Modeler Release r9.2, when a specific Physical Only model was derived to a Logical/Physical model, the GDM-23 error appeared and no objects were added to the target model.
Problem No.: 13091 Issue No.: 21816638-1: REVERSE ENGINEER DB2 ZLINUX
In CA ERwin Data Modeler Release r8.0, when a DB1/LUW 9.7 model was forward engineered, a column had the TIMESTAMP data type. However, when the database was reverse engineered, the data type showed as TIMESTAMP (6). Further, when the two models were compared using Complete Compare, the TIMESTAMP data type was shown as a difference.
Problem No.: 12840 Issue No.: 21768224-1: Query History List Array
In CA ERwin Data Modeler Release r9.5, the customer wanted a query that returned ENTITY event history, on the same lines as it is displayed in the History tab of the Entity editor.
Problem No.: 12945 Issue No.: 21852001-1: MAXIMUM LENGTH FOR VIEW NAMES
In CA ERwin Data Modeler Release r9.5.02, when the maximum length for View names was set to 18 characters for a DB2 z/OS version 8.1 model, the names that were more than 18 characters were not truncated.
Problem No.: 12801 Issue No.: 21750892-1- Upgrade Loses Partitioning Key
When a specific DB2 LUW model was upgraded from CA ERwin Data Modeler Release r7 to either r8.2.8 or r9.5.1, the Partitioning keys were missing from all the tables.
Problem No.: 12571 Issue No.: 21818942-1: FE TABLE IN NON-ALPHABETICAL ORDER
When a model was forward engineered in CA ERwin Data Modeler Release r7 and r8, the table names were displayed in alphabetical order in the script. However, in Release r9, the tables were not in alphabetical order. The customer wanted to know how to get the tables in alphabetical order in Release r9.
Problem No.: 12920 Issue No.: 21813889-1: BULK EDITOR-CSV IMPORT WIPES OUT DATA SOURCE
In CA ERwin Data Modeler Release r9.5, suppose the Bulk Editor was used to display the column name and data source and the details were exported to a CSV file. If some of the data types were modified in the CSV file and the file was imported, the data sources were not available.
Problem No.: 1324 Issue No.: 21801448-1: MDLMT CAN'T INITIALIZE MART/ERROR: MUST 32 MB OR MORE DB
In CA ERwin Data Modeler Release r9.5.02, a SQL Server 2008 database was created for a Mart on Windows Server 2008 R2 operating system. The Mart could not be initialized, as it failed with the error message, “Must select a 32 MB or greater size database in order to create a mart.”
Problem No.: 12876 Issue No.: 21793864-1: IN CC MISSING PERIOD WHEN CREATE WHENUPDATED SYNTAX MYSQL
When a specific existing MYSQL model (right model) was compared with a model reverse engineered from a database (left model) and some changes were made to the right model and the ALTER script was generated, the script didn’t include a period between the owner name and the table name.
Problem No.: 1322 Issue No.: 21781921-1: MDLMT UNABLE CHANGE PASSWORD WHNE LOGIN MART BY UPPER CASE USER ID
In CA ERwin Data Modeler Release r9.5.1, when a user logged in to a Mart using the user name in upper case letters, the user could not change the password.
Problem No.: 12362 Issue No.: 21837468-1: Query Tool Export Excel Size
In CA ERwin Data Modeler Release r9.0, when the definitions in an Oracle 10g model were exported to CSV, the size was limited to just over 4000 characters. The remaining portion of the definition was truncated.
Problem No.: 12825 Issue No.: 21775543-1: US BANK - Error Message
In CA ERwin Data Modeler Releases r8.2.8 and r9.5, when a specific model was upgraded from Release r7.3 and a data type was changed in the physical side of the model, the error message, "Unexpected and serious condition occurred in the application" appeared repeatedly.
Problem No.: 10470 Issue No.: 18593841-1: Table Clustered Index Append
In a DB2 LUW model in CA ERwin Data Modeler Release r7.3.6, a clustered index could be created on a table that was defined as Appendable.
Problem No.: 11609 Issue No.: 21783866-1-Print To Pdf Not Printing Head
In CA ERwin Data Modeler Release r8.2.08, when a model from the Model Manager was printed, the page header printed extra characters as given below:
FINMET Data Mart Netezza?lid={8C203745-69B6-4C6E-B32E-B54B2958CA6A}+00000000
mid={E09C8306-311E-4BB3-A53D-E119033265D5}+00000000 ver=27"
Problem No.: 12307 Issue No.: 21714234-1: When Creating The Modules
In CA ERwin Data Modeler Releases r9.5, when a model was created from a specific template, the attributes of the templates were not copied to the model. This happened especially when the name macro for a user defined domain was changed in the template. The name of the domain reverted to the original name in the new model.
Problem No.: 12884 Issue No.: 21809486-1: NO GENERATING IDENTITY PROPERY
In CA ERwin Data Modeler Release r9.5, for a SQL Server 2008 model, if the Starting Value and Increment By values were not filled, the column was not created as an Identity column. However, this was possible in SQL Server 2012 with Release r9.5.2.
Problem No.: 12796 Issue No.: 21750582-1- Data Source Import Crash
In an Oracle 10g model in CA ERwin Data Modeler Release r9.5, data source could not be imported from one model to another. The application stopped responding.
Problem No.: 13092 Issue No.: 21619369-1: Stored Procs Not Generating
When a model was upgraded from CA ERwin Data Modeler Release r7.3.8 to r9.0 and forward engineered, a stored procedure was generated only for the first table, although it was attached to multiple tables. When the user upgraded to CA ERwin Data Modeler Release r9.5, and tried the same model, the problem recurred.
Problem No.: 12642 Issue No.: 21590427-1: Fe:use Old Validtn/defalt Name
In CA ERwin Data Modeler Release r8.2.08, for an Oracle 10g model, when an attribute was copied from another entity/attribute, the existing default and check constraints were copied over as it is.
Problem No.: 12475 Issue No.: 21468376-1: Cc Option Not Saved
In CA ERwin Data Modeler Release r9.5.0, when Complete Compare (CC) was performed repeatedly, all the selected options were brought over from one CC session to the next, except for Include Generated Object Only. Although this option was not selected originally, it was selected for all new CC sessions.
Problem No.: 13093 Issue No.: 21633543-1: Refresh After Change Of Dts
In CA ERwin Data Modeler Release r9.0, if a data type standard was changed from active to inactive, the physical model did not refresh to show it. However, if the data type standard was changed from inactive to active, the model refreshed immediately.
Problem No.: 12560 Issue No.: 21517625-1- Reverse Engineer Owner Problem
In CA ERwin Data Modeler Release r8.2.07, while reverse engineering an Oracle 10g/11g model, if a Tablespace and the owner were specified, the owner was ignored and only the tables owned by the current user were included.
Problem No.: 12310 Issue No.: 21655903-1: PHYSICAL DICTIONARY DEFECT
In CA ERwin Data Modeler Release r9.5, when the Physical Dictionary report was generated, the comments added to attributes were not included.
Problem No.: 12819 Issue No.: 21458716-1: MACROS %FOREACHLOGENTITY() RETURN PHYSICAL ONLY TABLE
In CA ERwin Data Modeler Release r9.0, the macros %ForEachLogEntity(), %ForEachEntity() and %ForEachTable() ignore the Logical only (for entities) and Physical Only (for tables) settings. %ForEachLogEntity() returns physical only tables as well, and, %ForEachTable() returns logical only entities as well.
Problem No: 12615 Issue No.: 21546550-1: CAN'T LOGIN FROM ERWIN TO MART BY USING LDAP USERS
In CA ERwin Data Modeler Release r9.2, if an Active Directory member was added as a Mart user, but the user was not added as a named Windows user, then when the user tried to log in to Mart, the error message, “Invalid user ID or password. Please try to log in again” appeared.
Problem No.: 1312 Issue No.: 21430896-1: MDLMT MART REPORT DB LOGIN FAILED
In CA ERwin Data Modeler Release r8.2.07, r9.0, and r9.1, when a Windows-authenticated user logged in to a SQL Server 2008 Mart and tried to create reports such as entities.rpt, datatype nulls.rpt, the log in dialog did not have the Windows authentication option. If the user typed the credentials manually, the error message, “Login failed, please try again” appeared. This error started appearing after the Mart was moved to a new database.
Problem No.: 12566 Issue No.: 21543577-1: PSEUDO TABLE USER-DEFINED SQL MARKED TO GENERATE
In CA ERwin Data Modeler Release r9.2, when reversing engineering a SQL Server 2012 script or database, for views with User-defined SQL that referenced another database (objects such as synonyms, stored procedures, and functions) the pseudo table that the application created were marked to generate in the Table Editor.
Problem No.: 12535 Issue No.: 21517932-1: FE SS 2012 GET TRIGGER ERROR INCORRECT SYNTAX NEAR '@ERRNO'
In CA ERwin Data Modeler Release r9.2, when a specific SQL Server 2012 model was forward engineered, the error, “[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '@errno'. Execution Failed!” appeared.
Problem No.: 12432 Issue No.: 21403615-1: Oracle Re Failure 9.2 (part2)
In CA ERwin Data Modeler Release r9.2, when a specific Oracle 11g database was reverse engineered, the process was terminated abruptly. The SQL trace file did not include any error. However, the same database could be reverse engineered to earlier versions of the application properly.
Problem No.: Issue No.: 21892904-1: RPT DESGNR DIAGRAM ALPHA SORT
In CA ERwin Data Modeler Release r9.5, when a Subject Area report was generated using the Report Designer, the Subject Areas could not be sorted alphabetically.
Problem No.: Issue No.: 21799178-1: SERVER USER
In CA ERwin Data Modeler Release r9.5, when a Subject Area report was generated and exported to PDF, the order of the diagrams in the PDF did not match the order in the application.
Problem No.: 13118 Issue No.: 21981226-1: CANNOT RENAME MQT INDEXES
In a DB2 LUW version 9.7 model in CA ERwin Data Modeler Release r8.2.08, suppose that a macro was used to name the table indexes. The application populated the names of materialized query table indexes automatically. It did not let the use change the names of materialized query table indexes.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|