DBArtisan Home | DBArtisan Documentation | Embarcadero Technical Support | www.embarcadero.com
ReadMe Last Published: April 16, 2010. Any updates to these notes will be available at http://docs.embarcadero.com.
Thank you for using Embarcadero DBArtisan, the award winning DBA tool for enterprise-wide database administration. DBArtisan empowers you to manage all of your critical databases running on current versions of Oracle, SQL Server, Sybase ASE, and IBM DB2 across the UNIX, Linux, Windows NT and mainframe z/OS operating systems, from a single, consistent, user-friendly interface. Before you use DBArtisan, please read the information below.
What's New in Version 8.7/XE Pro
Color-coded or labeled datasources through categorization
Updated support for Microsoft SQL Server features
Updated support for IBM DB2 for Linux, Unix, and Windows features
Updated support for IBM DB2 for z/OS features
Updated support for Oracle features
Updated support for Sybase features
Release Notes
DBMS Versions No Longer Supported
Additional Resources
Licensing Your Embarcadero Product
Embarcadero Technologies Product Support
Embarcadero Technologies Technical Support
Embarcadero Technologies on the Web
What's New in Version 8.7/XE Pro
Color-coded or labeled datasources through categorization
You can now color-code or label user interface elements associated with datasources by selecting a category when creating or editing a datasource. Each named category has an associated color and label. Four default categories (Production, Development, QA, and Test) are provided and you can create custom categories from the Register Datasource dialog. When you assign a category to a datasource, the Datasource Explorer icons for the datasource show a distinctive color-coded category indicator. Optionally, you can use the Options Editor to customize your categorization scheme to include the following user interface elements:
Datasource storage options
The Datasource panel of the Options Editor now lets you select the method used to store and access the currently loaded Datasource Catalog:
Unicode support
DBArtisan now includes Unicode support throughout the application, allowing you to work with data in different languages and display the text correctly on screen.
ISQL editor updates
The ISQL Editor has been enhanced with a set of automated validation and code assistance features:
In addition, specified query options that customize the execution environment can now be saved and subsequently loaded. The frequency with which the options are sent to the server has been optimized.
Updated support for Microsoft SQL Server features
Index support in DBArtisan has been upgraded to account for newer Microsoft SQL Server index functionality. You can now rebuild, reorganize, and disable indexes, primary keys, and unique keys. When creating, dropping or rebuilding indexes, primary keys, or unique keys, online options are available with these operations. This release also offers sparse columns, MAXDOP support, and page and row locking.
Updated support for IBM DB2 for Linux, Unix, and Windows features
DBArtisan 8.7 supports the following recent upgrades to IBM DB2 for Linux, Unix, and Windows functionality:
Updated support for IBM DB2 for z/OS features
This release features the following feature upgrades or improvements:
Updated support for Oracle features
When creating or modifying tablespace datafiles, you can now set the availability of the datafile to either ONLINE or OFFLINE.
Updated support for Sybase features
A Server shutdown Wait Time option lets you enable a grace period, an upper limit on how long to wait for normal operations to complete before forcing a shutdown.
User interface improvements
The most significant user interface improvement for the 8.7 release is a significantly reworked data source tree. The new tree provides enhanced navigation, alternative views, and a more consistent approach to options. The key addition to data source management functionality is the ability to filter the data source view by a number of different criteria.
In addition, DBArtisan 8.7 continues the reworking of object editors and wizards. Aimed at improving workflow and the user interface experience, the new editors and wizards are being reworked for consistency. The following object editors/wizards were upgraded for this release:
Release Notes
DBMS SUPPORT
IBM DB2 UDB for OS/390 (z/OS)
Server: IBM DB2 UDB for OS/390 and z/OS v7, v8, and v9
Client: When going through a DB2 Connect gateway, DB2 UDB Client for Windows 6.0 or later. When going directly to the mainframe from the client, DB2 Connect Personal Edition v6 or higher on the client machine.
IBM DB2 UDB for LUWServer: IBM DB2 LUW Versions 8.x and 9.x
Client: IBM DB2 LUW Client for Windows 7.0 or later. When using a v8 client, DBArtisan only supports connecting to a v8 Database on Windows, Linux and Unix.
Microsoft SQL ServerServer: Microsoft SQL Server 2000, 2005, (All editions including 2000 SDE and 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64) and 2008.
Client: Microsoft SQL Server Client Library
MySQLServer: 4.x
Client: MySQL ODBC driver 3.5.1 - 4.x.
OracleServer: Oracle 8i, 9i, 10g, and 11g.
Client: Oracle SQL*Net Client
Sybase ASEServer: Sybase System 12.5, Sybase 15.x
Client: Sybase Open Client
DBMS VERSIONS NO LONGER SUPPORTED
All DBMS versions supported in the previous release are supported for this release.
KNOWN ISSUES
BUG FIXES
| Bugs Fixed in DBArtisan 8.7.4 and DBArtisan XE Pro | ||
|---|---|---|
| Issue # | Description | DBMS |
| DBA-19589 | [Options menu][JDBC]Modifications in the Default JDBC Driver section of the JDBC page are not kept when the application is reopened | All |
| DBA-19770 | [Indexing]Object Index file is growing rapidly in size | All |
| DBA-21719 | Database Monitor previously could be invoked upon a disconnected highlighted database which would then prompt a login. This feature has been inappropriately removed. | All |
| DBA-22330 | [ISQL/Extract] The "Extract"/ISQL window initially opens "not maximized" and then turns into "maximized" instead of opening maximized directly, on all platforms. | All |
| DBA-22775 | [ISQL] [Parser] The reserved word AND is not highlighted when its written after a char column | All |
| DBA-22838 | [ISQL Editor] When there's existing maximized SQL editor session open, opening any new SQL Editor will minimize everything and them maximize | All |
| DBA-22848 | [File / Options / Grid Properties] Preview window becomes black after unchecking an option and selecting a cell | All |
| DBA-22909 | [ISQL] Comments are losing the green color in certain cases | All |
| DBA-22951 | Editor to add data it always errors out saying not enough values | All |
| DBA-22638 | An unexpected token "DECLARE" was found following "LARE RCOUNT INTEGER" | DB2 |
| DBA-22657 | [Tables][Truncate] Error appears when trying to Truncate a table on DB2 v9.0.1 | DB2 |
| DBA-22811 | [ISQL] [Cast] Conversion from decimal to decfloat doesn't work | DB2 |
| DBA-22976 | An unexpected token "DECLARE" was found following "LARE v_maxDepth INT " | DB2 |
| DBA-21424 | After upgrade the redo log group screen shows incorrect first change number, size, and archived status | Oracle |
| DBA-22595 | [Triggers] "Extract" is empty when performed from outside the database Trigger editor, on Oracle | Oracle |
| DBA-22663 | [Table] [Blob] When trying to change the Segment Name for a Blob column, the generated script assigns a system-generated segment name | Oracle |
| DBA-22735 | Execution of valid a valid pl/sql code in DBArtisan results in an ORA-06550 error | Oracle |
| DBA-22818 | [Regression 8.6.4] Oracle case statement not working | Oracle |
| DBA-23037 | [Materialized Views][NON-DBA]Cannot see materialized views when connected with a NON-DBA user on Oracle | Oracle |
| DBA-21227 | Randomly crashing when connecting to datasources, opening objects, and performing extractions | SQL Server |
| DBA-21567 | Application crashes when closing the Performance Analyst | SQL Server |
| DBA-21585 | The ObjectRoot is in an inconsistent state (Text has not been set) when changing the order of a column | SQL Server |
| DBA-21632 | Java errors appear when attempting to add column to particular tables containing dependencies | SQL Server |
| DBA-22106 | Disabling SQL Parsing to get rid of the linked crash issue also disabled the column and object lookup feature | SQL Server |
| DBA-22454 | [Space Analyst] The Space Management Wizard does not prepend the Table name with the schema | SQL Server |
| DBA-22661 | [Data Editor] Unable to sort rows by any column when the table has a varchar(max)/text/image/xml column | SQL Server |
| DBA-22808 | [Dependencies] [User Datatypes] User datatypes are missing from table's Dependencies tab | SQL Server |
| DBA-22834 | [Parser] Error appears at the word "REQUIRED" when using it as a column name | SQL Server |
| DBA-22596 | [Table][Data Editor] When copying data from a cell and paste to another, it only paste parcel from that cell | Sybase |
| DBA-22412 | SQL_ASSIST: Error ' Encountered unexpected token "@table" ' when editing procedure. | Sybase |
| DBA-22627 | [DBMS Actions] When dropping a Sybase proxy table the sp_dropobjectdef is omitted | Sybase |
| DBA-22892 | [Filters] [Object Creation] Filter "Ignore System Objects" creates incorrect SQL | Sybase |
| Bugs Fixed in DBArtisan 8.7.3 | ||
|---|---|---|
| Issue # | Description | DBMS |
| DBA-19828 | [Data Editor][Save as] Cannot save result from Edit Data in .xls format | All |
| DBA-20657 | Selecting just part of a line the TAB button will move the whole line instead of overwriting the selection | All |
| DBA-21133 |
Ability to copy object name from explorer window to clipboard with | All |
| DBA-21372 | After upgrade, File>Save>As HTML from any DBMonitor tab result set generates garbage instead of a valid HTML report | All |
| DBA-22056 | [ISQL] Execution of SQL script with errors will show the errors correctly but the line number identified is incorrect and the cursor cannot be directed to the error by clicking on the error message | All |
| DBA-22313 | In the iSQL editor, hitting Ctrl+PgUp/PgDn doesn't switch between query window and result tab properly | All |
| DBA-22328 | [Space Analyst][Database Overview] Space Analyst "Log Overview" reporting wrong configuration for Log Retain value | All |
| DBA-22488 | [Explorer] Missing shortcut keys in the Explorer. | All |
| DBA-22645 | [ISQL] Replace All option for Wrap Around Search fails to replace correctly | All |
| DBA-22647 | [ALT+select] ALT+select should not also select 'File' when selecting a text in ISQL | All |
| DBA-21310 | When extract a table's DDL, the extracted DDL adds a comma into the CACHE amount | DB2 |
| DBA-21418 | On the DB2 node in right pane from Explorer window the servers are not in the alphabetical order | DB2 |
| DBA-21556 | When extract DDL for View, uninterruptable character is added. On the page it looks like any blank spot. | DB2 |
| DBA-22457 | [Tables] [Extended Alter] System Generated Constraints should not appear in a DROP statement | DB2 |
| DBA-15803 | Indexes are not been extracted with the included dependencies | Oracle |
| DBA-16263 | ORA-00904: Invalid column name" when clicking on Tablespaces node in Oracle 8.X | Oracle |
| DBA-17308 | [User Editor] Object permission tab - After granting a permission to a specific object type and owner, the grid is populated with all the objects of the same type | Oracle |
| DBA-21016 | At Storage > tablespace, "Used", "Free" and "%Free" columns are not sorted properly when click on their headers | Oracle |
| DBA-21063 | No SGA Overview - "Memory Information Not Available" | Oracle |
| DBA-21098 | Sort by Last Modified date/time doesn't work properly | Oracle |
| DBA-21134 | The DB Device Size(MB), Used(MB) and Free(MB) no longer sort correctly. | Oracle |
| DBA-21193 | Display seems to be corrupt when SQL Assist is enabled in ISQL editor | Oracle |
| DBA-21270 | Oracle Job "Next Date/Time" is incorrectly shows 7/10/2009 when it is actually 10/7/2009 | Oracle |
| DBA-21614 | When running a query on v&sql_bind_capture view empty columns show [NULL] in result set | Oracle |
| DBA-21616 | When running a query on v&sql_bind_capture view the column VALUE_ANYDATA shows wrong information "OciTypeBinder - Cannot convert type to Stream." for all rows | Oracle |
| DBA-21764 | When viewing and selecting from Configuration, the Extract and Report buttons are greyed out | Oracle |
| DBA-21805 | The status of the packages is wrongly obtained by querying the package bodies status | Oracle |
| DBA-21996 | Latest release inappropriately flags SQL (which worked in last 3 releases) as invalid. | Oracle |
| DBA-22142 | Not able to see blocking locks at Performance > Blocking Locks even after refreshing | Oracle |
| DBA-22215 | It takes 2-5 minutes to retrieve the user's list of tables (sysdba privs). | Oracle |
| DBA-22434 | [Datasource Registration] 'Reference to null JavaObject' warning appears when navigating to Datasource Group tab from Datasource Registration dialog on Oracle | Oracle |
| DBA-22450 | [DDL Extract] Long triggers and Views DDL extract are incomplete | Oracle |
| DBA-22577 | [SQL Parsers]On Oracle in the SET clause of an UPDATE statement we should permit the use of CTE on subqueries | Oracle |
| DBA-22581 | [Explorer][Schema][Java Sources]Unable to open a java compatible editor when selecting Open for Oracle Java Source | Oracle |
| DBA-22585 | [Configuration][Explorer] "Table or view does not exist" when trying to view the Oracle Configuration parameters connected with user "system" | Oracle |
| DBA-22603 | ORACLE_TABLESPACE: Used and Free space values are in wrong columns (been inverted). | Oracle |
| DBA-22723 | [Explorer] ORA-00903 "Invalid table name" error message returned when trying to populate Storage/ Security/Schema nodes | Oracle |
| DBA-22776 | [Datasource][Login] User is not able to login to a datasource when the password is about to expire | Oracle |
| DBA-22777 | [DBMS Actions] Data Dictionary View Usage options are not working anymore | Oracle |
| DBA-5988 | [Server][SQL Server Agent][Jobs] Getting "The object handle specified is not valid" on SQL server Jobs that have a space in the name | SQL Server |
| DBA-19966 | [SQL Server Agent][Script All] For Alerts, Operators and Jobs node Script All and Script options from the toolbar don't do anything or gives an error | SQL Server |
| DBA-21353 | After upgrade if you organize by object owner, SQL Server schemas list the number of objects in the schema only after clicking on it and the number is always 15 | SQL Server |
| DBA-21448 | When run extracted table DDL with foreign keys, error occurs due to dropping the table and creating the table in the DDL | SQL Server |
| DBA-21496 | Performance Analyst for OS tabs is not auto refreshing the graphs | SQL Server |
| DBA-21537 | The subject line of the email generated by using the script execution facility is garbled | SQL Server |
| DBA-21766 | Schema Migration fails to complete when using Windows Authentication - SQL Server 2005 | SQL Server |
| DBA-21767 | SQL Server error logs no longer include some pertinent information that it used to | SQL Server |
| DBA-21751 | Default server SET query options are ignored | SQL Server |
| DBA-21793 | select @@trancount is being added to queries executed in the SQL editor and this is causing performance issues. | SQL Server |
| DBA-22124 | Database search feature is not finding string matches on table objects | SQL Server |
| DBA-22179 | Capacity Analyst Collection Analysis not showing graphical result, Error The conversion of char data type to datetime data type value was out of range | SQL Server |
| DBA-22421 | [Backup Analyst] [Recovery] Invalid string or buffer length(HY090) when performing a Recovery | SQL Server |
| DBA-22453 | [Space Analyst] When running Quick Space Task, the owner name is replaced with another user | SQL Server |
| DBA-22652 | [Performance analyst]Bad performance for Performance Analyst utility | SQL Server |
| DBA-22656 | [SQL Server Agent][Alerts][Operators]Wrong date: The month is off by 1 and year is off by 19 centuries. | SQL Server |
| DBA-22659 | Last Occurred date under SQL Server Agent Alerts is off. | SQL Server |
| DBA-13429 | Incorrect size displaying the amount of Space for a segment | Sybase |
| DBA-16062 | [Capacity Analyst] Failed to Generate Analyst Report! when trying to generate a Database Growth Trends report on Sybase datasource | Sybase |
| DBA-18713 | Unable to close the connection on DBMS restart | Sybase |
| DBA-19254 | Users with a Sybase 15 client, who implement password encryption, can't connect to the Sybase 15 datasource without error: "Adaptive Server requires encryption of the login password...". | Sybase |
| DBA-21134 | The DB Device Size(MB), Used(MB) and Free(MB) no longer sort correctly. | Sybase |
| DBA-21257 | Database size in the database listing is incorrect | Sybase |
| DBA-21717 | Data Editor does not apply WHERE clause when data is refreshed in the data input display | Sybase |
| DBA-21785 | [Default] [Extract] Incorrect Extract is generated for a default with dependencies - statements are not in the correct order Sybase | |
| DBA-22051 | 4. Segments are still completely and totally incorrect | Sybase |
| DBA-22052 | 5. Incorrect (fails when executed), extraneous and redundant SETUSER (plus clear USER) are included in the table DDL Extract | Sybase |
| DBA-22053 | 6. Incorrect (fails when executed) sp_bindefaults show up in Table DDL Extract. | Sybase |
| DBA-22385 | [Extract][Default/UDT] User Defined Datatype extract is doing a DROP and CREATE only | Sybase |
| DBA-22392 | [Connectivity][Net Password Encryption]"Adaptive Server requires encryption of the login password on the network" is thrown when testing the connection even though the "Enable Net Password Encryption" option is checked | Sybase |
| DBA-22570 | [Space Analyst] Application crashes in Space Management Wizard | Sybase |
| DBA-22626 | [Explorer] [Navigation] No error messages are shown if the DB server shuts down and the user continues to expand the DBMS node | Sybase |
| Bugs Fixed in DBArtisan 8.7.2 | ||
|---|---|---|
| Issue # | Description | DBMS |
| DBA-12523 | [8.5.0#3529] - Save as output no such option when the data is displayed as HTML or ASCII. | All |
| DBA-13794 | Problem Report crash | All |
| DBA-13930 | Column size is not adjustable | All |
| DBA-14793 | Execute button is missing from the txt files editor toolbar | All |
| DBA-17065 | Not able to use Import Data from file feature - MS Excel 97 2003 xls file | All |
| DBA-18306 | Schema Migration wizard (and also the simpler Migration function) fails to show any information in the Summary screen of the migration wizard | All |
| DBA-20968 | [ISQL] Application sometimes crashes when opening a new ISQL right after connection to server and start typing a select statement | All |
| DBA-21166 | Have to scroll and position the cursor directly on the datasource name in order to disconnect | All |
| DBA-21226 | Problem Report crash: Landing page related | All |
| DBA-21512 | CNTRL + C for copy fails to copy items to clipboard buffer. Right click + copy works fine however | All |
| DBA-14978 | Extraction of specific MQT (materialized query tables) from DB2 incorrectly provides only the grant statements instead of including the Create Table statements | DB2 |
| DBA-16841 | DBArtisan fails to generate correct SQL for a change in data type for columns in a table | DB2 |
| DBA-18208 | Errors when trying to add DB2 tablespace. Pagesize field is disabled and leads to mismatch error when trying to add/create DB2 tablespace | DB2 |
| DBA-18748 | [RevokePrivileges][User/Table/Views Editor]The REVOKE CONTROL privilege is not generated correctly when revoking all the GRANTS that a user holds on a Table or View on db2 datasources | DB2 |
| DBA-20070 | Selection for more than 400 objects from a node with CTRL+A takes a long time | DB2 |
| DBA-20436 | The display for Permissions is not showing all the GRANTS for a VIEW | DB2 |
| DBA-21059 | Table with BLOB column populated with PDF docs no longer exports to desktop as PDF since upgrade. | DB2 |
| DBA-21604 | Creating stored procedures with in-line comments fails to execute and create the object | DB2 |
| DBA-22181 | Truncate Table statement for DB2 should include NONRECOVERABLE option to avoid leaving the tablespace in BACKUP PENDING status. | DB2 |
| DBA-22245 | When altering a table with a dependent view, the extended alter script does not include the security on the view | DB2 |
| DBA-22331 | Product is abending when attempting to connect to DB2 databases | DB2 |
| DBA-11929 | Permission page - incorrect DDL generated at ALTER if one grants and than revokes a privilege | DB2 z/OS |
| DBA-22407 | Create Table wizard populates the schema dropdown when invoked. This causes extreme delays, as this list can be long. | DB2 z/OS |
| DBA-21472 | Slow performance when drilling down into tables from explorer | MySQL |
| DBA-8584 | BUG DB812 : OCIEnvCreate not supported in Oracle 8 client error when registering datasource | Oracle |
| DBA-12079 | Oracle: synonyms is not shown in sequence dependencies tab | Oracle |
| DBA-13022 | Import Data Wizard generates errors when trying to import SQL or .CSV files | Oracle |
| DBA-14976 | Poor performance when selecting Tables in Explorer tab | Oracle |
| DBA-17808 | Oracle DB Monitoring is only showing partial information and is missing a lot of information - happens on RAC and non RAC servers | Oracle |
| DBA-17901 | Executing an alternated wrong and correct queries makes DBArtisan to hang | Oracle |
| DBA-17908 | Adding new column to a table and placing it anywhere in the list order of columns causes the ALTER to fail and also strips constraints from the object | Oracle |
| DBA-17988 | When several tables, views or packages are selected to create a synonym whether Public or private the DDL code is not generated | Oracle |
| DBA-20163 | Most of the valid actions are disabled from the context menu when selecting multiple objects, on Oracle. | Oracle |
| DBA-20167 | User Roles and Permissions are not populated when trying to view own roles/privileges, connected with non dba user. | Oracle |
| DBA-20218 | Database Monitor fails to kill any highlighted process, errors out with ORA-00030 message | Oracle |
| DBA-20252 | Ambigous error message is displayed when compiling an invalid object | Oracle |
| DBA-20326 | [Materialized View][Extract] Incomplete extract for a Materialized View when opened from object editor | Oracle |
| DBA-20906 | When Oracle DB is disconnected from server, shut down or power goes off (server), DBArtisan crashes when the user tries to disconnect | Oracle |
| DBA-20909 | Right-Click > Analyze functionality is grayed out when selecting multiple tables. | Oracle |
| DBA-20910 | Right-Click > Analyze & Rebuild functionalities are grayed out when selecting multiple indexes. | Oracle |
| DBA-20913 | Temp tablespace lists in explorer as N/A instead of the actual size | Oracle |
| DBA-20967 | On the tablespace information sort by percent-freespace "% Free" and "Used(M)" does not work | Oracle |
| DBA-20974 | Not able to log into any Unix server machine in Performance Analyst > O/S | Oracle |
| DBA-21061 | Capacity Analyst installation failure, ETRepoLog reports EAS_ADMIN code 933:column XX ORA-00933: SQL command not properly ended | Oracle |
| DBA-21077 | When establishing a connection, the value of the datasource is no longer populated in the datasource connection field . When double-clicking on the connection it populates the field with a previous value instead of the current value. | Oracle |
| DBA-21090 | Search and Replace operation causes DBArtisan to hang | Oracle |
| DBA-21245 | When vieiwing Materialized Views (snapshots), the Last Refresh date is incorrect | Oracle |
| DBA-21373 | When using DBMS_OUTPUT.Put_line from an anonymous block, it leaves prior output lines in the display buffer | Oracle |
| DBA-21387 | Materialized views created after upgrade do not show up. Materialized views created in the precediing release show up fine. | Oracle |
| DBA-21508 | Tablespaces with 0KB free appears with N/A in column Used Free and %Free. | Oracle |
| DBA-21560 | No longer able to change status when choose multiple foreign keys | Oracle |
| DBA-21630 | Rebuild of multiple indexes (selected) is grayed out after upgrade | Oracle |
| DBA-21768 | Many options are no longer available after highlight multiple indexes, for instance, rebuild option | Oracle |
| DBA-21764 | When viewing and selecting from Configuration, the Extract and Report buttons are greyed out | Oracle |
| DBA-21911 | Previous ability to change expired Oracle password has been broken | Oracle |
| DBA-21945 | Extract of stored proc results in DDL that causes an error to be reflected via the comments formatting. | Oracle |
| DBA-22109 | DBArtisan fails to point out the error when executing a long set of query statements that contain an error when Query Plan is enabled | Oracle |
| DBA-22202 | %NOTFOUND Cursor Attribute flagged as syntax error. | Oracle |
| DBA-22273 | Adding or extending a data file to existing tablespace, it takes 5 minutes to respond | Oracle |
| DBA-22277 | DB2sys.dll cannot be loaded! It is not advisable using the application" error message when clicking on PL/SQL Code Profiling | Oracle |
| DBA-8034 | DB812 3216 ENHANCEMENT Request to support varchar(max) for MS SQL 2005 | SQL Server |
| DBA-11731 | Extracted table ddl is incorrect for tables with varchar(max) and nvarchar(max) columns | SQL Server |
| DBA-15624 | System hangs after upgrade to DB854 when user tries to migrate data from SQL source Server 2005 tables to target database on another server | SQL Server |
| DBA-16041 | Repository Installation Failed - Connectivity issue | SQL Server |
| DBA-17182 | [regression 8.6.0] Application crashes when trying to debug a procedure on SQL Server | SQL Server |
| DBA-17848 | DBArtisan fails to report extended stored procedures granted to a database role. | SQL Server |
| DBA-17893 | After upgrade from DB855 to DB861, create like for logins generates incorrec syntax that references the OLD login name. It also fails to recognize databases where source login resides | SQL Server |
| DBA-18173 | Extracted DDL for creating schemas comes before the DDL for creating the database. It made the script un-useful for the user. | SQL Server |
| DBA-18236 | Send SET OPTIONS in ISQL Query Options is only affecting the first set of SELECT statements, subsequent datasets are displayed | SQL Server |
| DBA-19937 | [Tables] 'dtproperties' system table is incorrectly listed in "Tables" node, on MS SQL Server. | SQL Server |
| DBA-20141 | Extraction or ALTER of foreign key Incorrectly displays "With NOCHECK" setting for SQL Server 2005 9.00.4035 | SQL Server |
| DBA-20448 | [Schema Extraction/Migration ][Database]Incorect display of database name in the Schema Extraction/Migration wizard | SQL Server |
| DBA-20453 | [Performance Analyst] Application freezes after starting Performance Analyst for SQL Server datasource | SQL Server |
| DBA-20901 | Row count in the Explorer display different than the Select * from results | SQL Server |
| DBA-21013 | Ctrl+C doesn't work anymore when user wants to copy an object name from the explorer tree | SQL Server |
| DBA-21057 | Error logs under SQL Server JOBS only contain error designation codes omitting the descriptive text summary contained in previous versions | SQL Server |
| DBA-21073 | Last Run Status under SQL Server Agent Jobs: The word "SUCCEEDED" is spelled incorrectly as "SUCCEDED" | SQL Server |
| DBA-21074 | Last Run Status start date under SQL Server Agent Jobs: The month is off by 1 and year is off by 19 centuries. | SQL Server |
| DBA-21076 | Capacty Analyst is recording incorrect row cou | SQL Server |
| DBA-21311 | Comment in /* */ before CREATE statement disappeared after a stored procedure was created in an ISQL window | SQL Server |
| DBA-21585 | The ObjectRoot is in an inconsistent state (Text has not been set) when changing the order of a column | SQL Server |
| DBA-21653 | After compiling a stored procedure the comments at the top of the procedure (above Create Procedure) are erased. | SQL Server |
| DBA-21795 | Simple SQL script works fine in DB86x and fails in DB87x | SQL Server |
| DBA-21796 | Error logs for SQL server are not in the right order | SQL Server |
| DBA-21814 | SQL Server Agent Job list: Wrong year is displayed | SQL Server |
| DBA-21874 | When viewing Columns in a table with a column containing a datatype which contains a MAX value, the display shows a negative one (-1) | SQL Server |
| DBA-21875 | Product no longer allows the creation of columns with datatypes containing MAX value for size | SQL Server |
| DBA-22220 | Capacity Analyst Error: Incorrect syntax near ')'.(42000,102), Batch 1 Line 1 | SQL Server |
| DBA-22409 | [Table][Editor]Varchar(max) and varbinary(max) columns length is incorrectly displayed as -1 inside the Table editor | SQL Server |
| DBA-6956 | Inability to place breakpoint at a line of code when debugging a procedure on Sybase database | Sybase |
| DBA-11951 | DBA850 Customer consistently receives "unexpected error" when trying to migrate from source to target DB on same datasource | Sybase |
| DBA-12473 | Option to change datasource is disabled when running query in Sybase which makes it more cumbersome to run the same query on different servers | Sybase |
| DBA-13932 | isql window's minimize and maximize doesn't work properly | Sybase |
| DBA-14599 | [8.5.2] - Incorrect error message when dropping a user logged into the database through GUI | Sybase |
| DBA-16402 | Import Data From File doesn't work on Sybase. | Sybase |
| DBA-16804 | Frequently unable to select the segment/logsegment "Threshold" tab. | Sybase |
| DBA-16806 | Error on granting permissions to a procedure - Cyrillic (cp1251) | Sybase |
| DBA-17806 | After upgrading to DB861, the left pane of the explorer view doesn't update correctly (i.e. number of databases shown doesn't match actual number listed). | Sybase |
| DBA-18068 | Server Memory information (pie chart) not available in Explorer window because when system tables are interrogated, database name is not [always] prefixing them | Sybase |
| DBA-20277 | The SQL generated for a 'disk unmirror' operation is incorrect | Sybase |
| DBA-20617 | [Connectivity]Application crashes when connecting to a Sybase datasource | Sybase |
| DBA-20907 | When creating a database on Sybase ASE, DBArtisan is not calculating off of default page size | Sybase |
| DBA-21259 | Logsegment value totals > 100% | Sybase |
| DBA-21370 | Error 'Encountered unexpected token "UPDATE"' in the statement IF NOT UPDATE() within the trigger. | Sybase |
| DBA-21605 | No longer able to change Network Package Size that DBArtisan connect to Sybase servers at File > Options > Connection. It is always 512 when users view it at Database Monitor. | Sybase |
| DBA-21733 | Server > Configuration > double click on parameter > max & min are incorrect | Sybase |
| DBA-21967 | Crash after opened multiple ISQL windows | Sybase |
| DBA-22049 | 2. Partitions. Missing partition type in the partition tab | Sybase |
| DBA-22050 | 3. System tables show up in the drop-down lists of user tables | Sybase |
| DBA-22173 | Debuging stored procedures in Sybase does not support DATE or TIME data types. | Sybase |
| DBA-22192 | Procedure permissions are lost because GRANT EXEC ... statements are not added to the script when insert a column at table editor | Sybase |
| DBA-22329 | [Connection] Application crashes when trying to connect to a server which is in shutdown progress, on Sybase. | Sybase |
| Bugs Fixed in DBArtisan 8.7.1 | ||
|---|---|---|
| Issue # | Description | DBMS |
| DBA-8173 | When logging into a MySQL 5.0.22 database with landing page enabled, you get a "String data, right trncated" error | MySQL |
| DBA-12923 | Missing privelege details for MySQL | MySQL |
| DBA-13890 | When trying to connect after upgrade, MySQL customer receives Failed to create a connection. Url or driver class may be incorrect. Unknown character set: 'usa7' | MySQL |
| DBA-12704 | Unable to create/drop/view the properties of SQL Server Agent objects (Jobs, Alerts, and Operators) in Windows Vista Ultimate operating systems | SQL Server |
| DBA-19769 | Error: The ObjectRoot is in an inconsistent state. (ForeignKeyColumns has not been set) when adding column to table that has 65 foreign keys | Sybase |
| Bugs Fixed in DBArtisan 8.7 | ||
|---|---|---|
| Issue # | Description | DBMS |
| DBA-9044 | The GUI for "Save most recent commands" and "Emulation" in the Editor has some minor errors | All |
| DBA-12415 | Failed to execute query error message after migration | All |
| DBA-13503 | DBA850 #3599: Errors appear during migration using BCP for data movement in Sybase and SQL Server | All |
| DBA-14188 | Error output list doesn't refresh (intermittent) after upgrade to DB850 | All |
| DBA-17825 | ISQL Editor is not saving changes in the Syntax highlighting options | All |
| DBA-17910 | ISQL window not being made active when clicking on tab within window | All |
| DBA-17911 | Unable to drag registered datasource instances to another folder/group | All |
| DBA-17964 | Auto Column Lookup ignores Popup Delay ms option setting | All |
| DBA-18038 | DBArtisan 861: After upgrading from build 3893 to build 3899, the bookmarks get erased | All |
| DBA-18249 | CLONE -When you go to file > options > editor > printer font select a different font, then you go to print, it does not go with the printer font but the editor font | All |
| DBA-19032 | Slow performance in application for certain datasources | All |
| DBA-19115 | Excel output not correct, unicode characters not outputted correctly | All |
| DBA-19974 | The "Auto Connect" button does not work from login screen. | All |
| DBA-15318 | Procedure with XML datatype fails to compile | DB2 |
| DBA-15852 | When extracting privileges on a group, GRANT EXECUTE ON PROCEDURE schema.* is missing | DB2 |
| DBA-18108 | Altering a table generates the following error: "The ObjectRoot is in an inconsistent state (TriggerTime has not been set)" | DB2 |
| DBA-19037 | Unable to extract stored procedure that contains xquery syntax. | DB2 |
| DBA-19616 | When extracting a table, there is an error during object population. Type = Table caused by Overflow occurred during numeric data conversion | DB2 |
| DBA-19672 | User explorer displays system privileges incorrectly. Specifically Create External Routine | DB2 |
| DBA-8762 | Adding a new column and placing the column in the middle of the column list, does not result in an extended alter being created | MySQL |
| DBA-13892 | When trying to extract a schema from MySQL (after upgrade) the datetime fields come out in format "MON DD YYYY HH:MM:SS" which is not recognized as a valid date value when inserting into a MySQL table. | MySQL |
| DBA-15737 | Database monitor Processes show an error with a "String Data Right Truncated" message and are showing executed SQL statements as HEX | MySQL |
| DBA-7277 | Checking blocking locks from Database Monitor against Oracle 10g will cause high library cache waits contention if the share pool size is large. | Oracle |
| DBA-10502 | Grant or revoke 'CREATE JOB' OR 'CREATE ANY JOB' | Oracle |
| DBA-11393 | Unable to view Oracle 10 Tablespaces | Oracle |
| DBA-14015 | After extracting the DDL for a role the users assigned the role are no longer included | Oracle |
| DBA-14734 | Customer experiences crashes 4 or 5 times a day since upgrading to DB852 using Oracle 9i | Oracle |
| DBA-15503 | Slow to extract Function and Procedure from explorer window | Oracle |
| DBA-15552 | After upgrading to DB854 from DB815 Oracle compile no longer works and complains about invalid character when trying to execute | Oracle |
| DBA-15825 | Crash when running Performance Analyst when Internet Explorer 8.0 is installed | Oracle |
| DBA-17489 | Incorrect application behaviour when DBA_Role removed from user | Oracle |
| DBA-17880 | Error appears when navigating to Roles tab of the User editor, connected with non dba user. | Oracle |
| DBA-17969 | Migration - Include Storage option from Schema Migration does not work | Oracle |
| DBA-18380 | It takes a long time to extract a user definition | Oracle |
| DBA-18406 | [regression 861] Incomplete DDL generated for Roles (ALTER USER statements missing), on Oracle. | Oracle |
| DBA-18640 | Extracting many indexes sorted by "Dist Key" with drop indexes clause checked produce a ddl script where drop commands are not in the right order | Oracle |
| DBA-18685 | DB870 3954: files saved from DB previewing a compile are unusable for edit or run, invalid characters for editors like Codewright or SQL Plus | Oracle |
| DBA-18978 | Data load doesn't work in latest release. Customer is getting syntax errors when trying to load a table via the data load utility in the DBArtisan's latest release. | Oracle |
| DBA-18991 | When creating users, incorrect DDL is generated in the form of CREATE USER MY_NEW_ACCOUNT IDENTIFIED BY VALUES 'letmein'; when it should be CREATE USER MY_NEW_ACCOUNT IDENTIFIED BY letmein | Oracle |
| DBA-19127 | Not able to generate insert statement when right click on result set column name if schema name is not included in front of table before WHERE clause in the query | Oracle |
| DBA-19211 | Feature Data Load fails to load data into target object | Oracle |
| DBA-19212 | When performing Extract on Interval partitioned Table, error occurs Error During Object Population. Type = Table | Oracle |
| DBA-19228 | When partitioning a table, the user gets error: The ObjectRoot is in an inconsistent state. (TriggerTime has not been set) | Oracle |
| DBA-19269 | Error when attempting table open or extract on Oracle 8.1 datasource, Error during object population type = TABLE | Oracle |
| DBA-19296 | Not able to create synonyms when highlighting multiple tables > Create Synonyms | Oracle |
| DBA-19485 | User names cannot be sorted in alphabetical order at Security > Profiles > (profile name) > Users tab | Oracle |
| DBA-19570 | User extraction generates an ORA-01017 error | Oracle |
| DBA-19571 | Getting ORA-28009 when connected to DBArtisan 8.6.2 3952 using non default log in , and trying to extract an object | Oracle |
| DBA-19723 | ORA-24347: Warning of a NULL column in an aggregate function when performing a select query | Oracle |
| DBA-19762 | Opening an Oracle table or user object does nothing (see DBA-19571) | Oracle |
| DBA-19801 | After extract a table, varchar2(n) data type column becomes VARCHAR2(n CHAR) | Oracle |
| DBA-9133 | Unable to debug SQL Server procedures | SQL Server |
| DBA-13470 | Failed to create connection URL or Driver class may be incorrect. Unable to get information from SQL Server - error causes database to be inaccessible | SQL Server |
| DBA-13552 | During migrate table with BCP option DBArtisan crashed | SQL Server |
| DBA-16581 | Space Analyst object tab shows conflicting information between graph and details for SQL Server 2000. | SQL Server |
| DBA-17118 | VIEW_EXTRACT: Long View DDL not extracting fully and is truncated. | SQL Server |
| DBA-17727 | Schema Migration fails to complete when using Windows Authentication - SQL Server 2005 | SQL Server |
| DBA-17670 | Attempting to ALTER database to READ ONLY (SQL Server 2005), generated ALTER statements are incorrect | SQL Server |
| DBA-18055 | DB861 3899 Error During Object Population. Type = Login when extracting more than 80 objects at once | SQL Server |
| DBA-18133 | SID not extracted with Login on MSSQL Server 2005 | SQL Server |
| DBA-18142 | DB861 3899 extended alter does not recreate permisions for dependencies | SQL Server |
| DBA-19033 | After selecting the target DB Table migration inappropriately tries to login to the 1st source DB in the list instead of the source DB where the table resides. | SQL Server |
| DBA-19049 | Table extract inappropriately lists columns comprising clustered primary key in the order of table definition instead of the order in which they're defined via the clustered primary Key | SQL Server |
| DBA-19726 | Database Space usage exceeds total DB space available | SQL Server |
| DBA-19922 | When migrate SQL Server tables to Sybase, error: java.lang.NULLPointerException | SQL Server |
| DBA-20063 | Incorrect ALTER COLUMN statement when changing data scope. | SQL Server |
| DBA-7527 | DBA810 3089 BUG: Get Incorrect Syntax error when executing the SQL Statements on master.dbo.syslogins generated by using the Create Insert Statement tool | Sybase |
| DBA-8832 | DB811 One time crash when dropping users from Sybase | Sybase |
| DBA-8675 | DBA813 3301: An error message is displayed when Memory Detail window Data Cache is opened for a Sybase 15 ASE datasource. | Sybase |
| DBA-11543 | [8.5.0 #3524] Support for nullable datatypes ending with 'n' such as datetimn | Sybase |
| DBA-12725 | Select in Sybase 15.0.2 with Unicode generates WARNING! Some character(s) in the source string are considered illegal bytes in server's character set. All bytes after the first illegal bytes are truncated. | Sybase |
| DBA-13467 | When the Data Insert from an Alter Table script fails, the SCRIPT continues and DROPS the original table with all of the data. Recovery requires a complete DB restore | Sybase |
| DBA-14255 | DBA 851 #3649: java.lang.StackOverflowError when trying to create/alter/extract a very large procedure (~10 000 lines) on a Sybase datasource | Sybase |
| DBA-14555 | Invalid Column Name Error when using Performance Analyst with Sybase 15.2 server | Sybase |
| DBA-15058 | Attributes for indexes don't always match up between the indexes pane and the attributes tab | Sybase |
| DBA-15211 | Data load fails when running from a saved file | Sybase |
| DBA-16151 | SYSLOGINS Create Insert statement is not correctly creating quotes around the Column PWDATE | Sybase |
| DBA-17950 | When connecting to a Sybase 15 datasource the product (DB861 3893,3899,3911) successfully connects to the Sybase instance but the ASE's Log shows one - "Login failed. User: **** Client IP address: 'x.x.x.x'" message during the connection attempt | Sybase |
| DBA-18030 | Extracting a login - aliases are no longer extracted from each database | Sybase |
| DBA-18077 | After upgrading to DB861 3899 from DB855, Sybase DDL extracts inexplicably add revoke statements for users that have been explicitly granted permissions. | Sybase |
| DBA-18083 | PCTUSED (missing PCTFREE) is incorrectly being added to the DDL when extracting partitioned table objects, the resulting DDL does not execute properly | Sybase |
| DBA-18272 | Enabling Migration with BCP data movement causes task to fail with errors of either the desired objects not found or Establishing connection failed | Sybase |
| DBA-18452 | Lack of objects in the dependency tab: dependencies tab of tables used in a trigger definition don't contain the trigger | Sybase |
| DBA-18792 | When going to the DDL tab of a Sybase table the following error is written to the "Output": String index out of range: 8128 or 8240 | Sybase |
| DBA-18990 | DBArtisan inappropriately generates code with SETUSER command which causes error when run by non-DBO | Sybase |
| DBA-19126 | Migrating a database object from one Sybase datasource to another is no longer possible. | Sybase |
| DBA-19171 | DB search doesn't find strings that are split across multiple rows of Sybase system table syscomments | Sybase |
| DBA-19270 | Database Space usage is greater than 100% at certain time in DBArtisan | Sybase |
| DBA-19294 | Space in Datasource name causes connection to fail for Sybase datasource | Sybase |
| DBA-19481 | Unable to migrate from HP-UX to Linux ASE15 | Sybase |
| DBA-19728 | Performance Analyst error when attempting to view Data Cache on Sybase - Attempt to insert NULL value into column 'ProcessesAccessing', table '#mdi_values'; | Sybase |
| DBA-19802 | Extracted DDL does not contain sp_primarykey and sp_foreignkey commands used in SQL that created the table | Sybase |
| DBA-19969 | Wrong datetime format displayed when performing Create Insert Statements on a table with datetime columns - specifically syslogins | Sybase |
| DBA-20016 | Adding the variable @@sqlstatus in the watch window for a Sybase stored procedure makes DBArtisan to hang | Sybase |
| DBA-20105 | ISQL editor fails to keep session persistent and lock in set commands, prior versions supported this feature | Sybase |
Additional Resources
Licensing Your Embarcadero Technologies Product
All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. For information on licensing your product, refer to the DBArtisan Installation Guide. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.
Embarcadero Technologies Product Support
The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the Embarcadero Knowledge Base. Visit www.embarcadero.com/support, or click any of the links below, to find:
Embarcadero Technologies Technical Support
If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).
We encourage you to open technical support cases via the Technical Support request form. For additional information about Embarcadero Technologies Technical Support, visit the Support section of our Web site.
Embarcadero Technologies on the Web
To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.