Welcome to DBArtisan® XE and DBArtisan® 8.7.6

DBArtisan Home | DBArtisan Documentation | Embarcadero Technical Support | www.embarcadero.com

ReadMe Last Published: October 24, 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.5/XE

Updated SQL Agent Support

Offline License Borrowing

Performance Improvements

What's New in Version 8.7/XE

Color-coded or labeled datasources through categorization

Datasource storage options

Unicode

ISQL editor updates

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

User interface improvements

Release Notes

DBMS Support

DBMS Versions No Longer Supported

Known Issues

Bug Fixes

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.5/XE

Updated SQL Agent Support

Previous DBArtisan versions provided only limited SQL Agent support after Microsoft SQL Server 2000. SQL Agent functionalty is now available with version 2005 and 2008 clients. In addition, SQL Agent functionality has been more closely integrated with the DBArtisan object model. Wizards and editors are provided to create and edit alerts, operators, and jobs. A set of object actions lets you start, stop, enable, disable, and change ownership for a job.

Offline License Borrowing

DBArtisan now allows you to consume a license in offline mode. When you explicitly check out a license (Help > Checkout License) for offline use, you can use DBArtisan without a connection to your License Center for a specified duration. This lets you work while travelling or commuting, work away from your primary work area, or use DBArtisan when a network connection is unavailable or not required. You can also check a borrowed license back in (Help > Checkin License) before the duration expires.

Performance Improvements

In response to customer feedback, performance improvements have been made in the areas of connection pooling, ISQL editor functionality, and schema extraction and migration. This work includes the following user interface changes:

  • Editor options (File > Options > ISQL > Editor) now offer cut-and-paste options for line ending conversions. If end-of-line characters are replaced with platform-specific equivalents (Windows - CR LF, UNIX - LF, Macintosh - CR) for environments that require platform-specific end-of-line characters, unnecessary characters and incorrect display are avoided, but cut-and-paste operations take more time to complete. If end-of-line characters are not replaced, cut-and-paste operations take less time to complete.
  • Configuration of the Syntax Checking, Semantic Validation, and SQL Assist features (File > Options > ISQL > Code Assist) has been simplified.
  • What's New in Version 8.7/XE

    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:

    The Import/Export functions of the Manage Datasources facility have been updated to account for the new file-based methods.

    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

    NOTE: Since DBArtisan is a 32-bit application that runs emulated on 64-bit versions of Windows, only 32-bit versions of the DBMS client software are supported.

    IBM DB2 UDB for z/OS

    Server: IBM DB2 UDB for z/OS 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 LUW

    Server: 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 Server

    Server: 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

    MySQL

    Server: 4.x

    Client: MySQL ODBC driver 3.5.1 - 4.x.

    Oracle

    Server: Oracle 8i, 9i, 10g, and 11g.

    Client: Oracle SQL*Net Client

    Sybase ASE

    Server: 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


  • For Oracle 10g systems, the Oracle client software must be installed within the the C:\Program Files (x86) directory to properly provide connectivity and required functionality to DBArtisan.
  • Populating Explorer trees and lists with a very large number of database objects causes high memory utilization. Filtering can be used to mitigate the problem.
  • The current version of DBArtisan does not support the MySQL ODBC client that shipped with previous versions of DBArtisan. If DBArtisan crashes after connecting to a MySQL data source:
    1. Close DBArtisan.
    2. Uninstall the older MySQL ODBC client.
    3. Restart DBArtisan and try connecting to a MySQL datasource. You are prompted to install the MySQL client drivers.
    4. Follow the installation instructions to install the new driver.
  • Note that when debugging a procedure against an Oracle data source, DBartisan performs a compilation before debugging. During a compilation, Oracle invalidates referencing objects. For example, if procedures A2 and A3 both reference procedure A1, debugging procedure A1 in DBArtisan, will result in procedures A2 and A3 being invalidated.
  • Currently, for Sybase data sources, the Sybase JTDS Driver does not support cp866 codepages. If you are making use of cp866 codepages, ensure that you are using another driver.
  • In some situations the Database Monitor may prompt to connect to an already connected datasource if auto-connect is not enabled for that datasource
  • DBArtisan installs the incorrect stored procedures for Capacity Analyst for a Sybase 15 database. Please refer to this Knowledge Base article: www.embarcadero.com/jive/entry.jspa?externalID=1030&caID=2
  • For servers running on Sybase version 12.5.3a, the CREATE ENCRYPTION KEY and DECRYPT permissions do not display properly--they'll be shown as null. See Sybase's document CR392544 ("sp_helpprotect does not show privileges related to encryption keys."). This has been fixed in ASE version 12.5.3a/ESD#1 (now available as a download) and ASE version 12.5.4.
  • When you are using the Debugger:
  • Schema migration jobs created in earlier versions of DBArtisan that were saved with a .migrate file extension must be re-created in DBArtisan 8.1 or later. Only migration jobs with a .sav extension can be reused.
  • DBArtisan is currently unable to create table names, column names, and check constraint names longer than 18 characters on an OS390 mainframe database.
  • On SQL Server 2005, the Browser component is disabled by default. With this service disabled, in DBArtisan you cannot reference SQL Server instances by name, only by port number. If you want the ability to reference SQL Server instances by name, you must enable this service on the server.
  • BUG FIXES

    Bugs Fixed in DBArtisan XE and and DBArtisan 8.7.6
    Issue # Description DBMS
    DBA-24339 [FONTS] Font incorrect when copying from the ISQL Window All
    DBA-17927 [Debug] When debugging a procedure and choosing "No" when asked whether to compile the procedure before starting the debugger, "DB2 - DB2-0" service on the server stops causing the datasource connection to fail, on DB2. DB2
    DBA-22794 [Debug] When debugging a procedure and choosing "No" when asked whether to compile the procedure before starting the debugger, "DB2 - DB2-0" service on the server stops causing the datasource connection to fail, on DB2. DB2
    DBA-23896 [Tables][Editor] Application crashes when trying to expand column Type combobox inside the editor of a Table on a DB2 97 server DB2
    DBA-24055 [Edit Table][Datatype] Editing datatype of a table column causes crash DB2
    DBA-24318 [SQL Parser] Error when calling DB2 SP, escape character is not valid DB2
    DBA-22748 Right-clicking a process, then Kill in the Processes area under Performance doesn't work Oracle
    DBA-24043 [Database Monitor] Active session sql in the processes area of the Monitor it's not returned Oracle
    DBA-24178 [Formatting] SQL formatting fails to parse SQL which affects Explain plan results as well Oracle
    DBA-24177 [Data Source Explorer] databases with "-" characters in the name will not connect SQL Server
    DBA-24281 [Datasource Explorer] MS SQL Server Error Logs are not displayed in Explorer SQL Server
    DBA-24081 [Capacity Analyst][Email notifications] Crash when executing collection in Capacity Analyst due to email notification Sybase
    DBA-24151 [ SQL Execution] Unable to save all the input parameters in the procedure execution window Sybase
    DBA-24163 [Devices][Mirror] Device Mirror wizard fails to generate any PREVIEW SQL or create mirror device Sybase
    Bugs Fixed in DBArtisan XE and and DBArtisan 8.7.5
    Issue # Description DBMS
    DBA-21873 DBArtisan gradually slows down or freezes in ISQL windows after upgrade All
    DBA-22048 Product unusable CPU and Performance issues All
    DBA-23016 [Explorer] Unable to open the object nodes from underneath the "Schema","Security", "Storage", databases and "Performance" nodes after doing stress test on the explorer tree, on Oracle. [problem extends to other platforms after following the steps] All
    DBA-23189 [Workspaces] Crash occurs when changing a workspace from View->Workspaces combo. All
    DBA-23203 Performance Analyst not working All
    DBA-22324 Executing SQL to create DB2 stored procedure the SQL failed SQLSTATE=42704 SQLSTATE=42601 DB2
    DBA-22733 [Performance][SQL Editor]The SQL Parsing option appears to be causing a performance and Runtime Crash issues when typing any queries in the editor DB2
    DBA-22835 [Data Editor] The import into a blob column is not working when table contains a timestamp column DB2
    DBA-22895 During Extract of Table with Long Table Space, the syntax does not display Long Table Space DB2
    DBA-23086 [Update Stats] Table's indexes are not updated when an update statistics is run on a table DB2
    DBA-23106 [Indexes] When creating an Index the LEVEL2 PCTFREE value is not displayed in the Extract, "DDL View" tab nor Report, on DB2 DB2
    DBA-23866 Unable to run 2 batches of SQL within the sql editor. DB2
    DBA-23871 [SQL Editor] Results from time query are incorrect, select current time from sysibm.sysdummy1 DB2
    DBA-23331 [RUNSTATS] Issues with ZOS utility submissions for runstat execution DB2 z/OS
    DBA-13256 The RULE hint in Oracle seems to be causing a delay in refreshing table information and Oracle Job queue listing Oracle
    DBA-15171 Printing out a package from the Alter screen doesn't print the document correctly Oracle
    DBA-15793 Registering datasources using ALIAS option or Discover Datasources fails to connect when using fully qualified names Oracle
    DBA-17867 After upgrade, attempt to drop a table partition incorrectly generates SQL that drops all table indexes, renames table to an alias then creates new table without the partition that you wanted to drop Oracle
    DBA-20675 Wrong syntax for ALTER SYSTEM SET db_recovery_file_dest Oracle
    DBA-20981 Oracle Redo Log generates errors: Column 5 is the wrong type. Result set reader expects a Integer, column type in database is NUMBER Oracle
    DBA-21003 Table extraction is unusable Oracle
    DBA-21269 [Performance]The SQL Parsing option appears to be causing a performance issue when opening SQL files and when typing in the SQL Files as well Oracle
    DBA-21287 Ddl extract containing nested table column is missing nested table storage clause Oracle
    DBA-21826 Application abends when NON-SYSDBA user runs Select * from DBA_Views in ISQL window Oracle
    DBA-22023 DB Export fails with parameter file error. The Oracle export utility works on previous version's parameter file. Oracle
    DBA-22142 [Datasource Explorer][Performance][Blocking Locks]Not able to see blocking locks at Performance > Blocking Locks even after refreshing Oracle
    DBA-22352 [Package] [Compile] When compiling an invalid package, user doesn't get detailed error messages as it used to be in previous versions Oracle
    DBA-22456 Encountered unexpected token "ADD" when adding a materialized View to Refresh Group Oracle
    DBA-22762 Schema Extraction]DBArtisan Shuts down during complete schema extraction when Group Dependencies option is selected Oracle
    DBA-23028 [Object Explorer][Synonyms]Issue with expanding the SYNONYMS in an Oracle Database, extremely long response time (10 minutes or more) Oracle
    DBA-23058 [Schema Extraction] The foreign keys are missing from a table DDL when using Schema Extraction Utility Oracle
    DBA-23118 [Reorganize] 'SQL command not properly ended' error occurs when performing Reorganize on a table and Data Dictionary View Usage is set to DBA Views Oracle
    DBA-23297 [Capacity Analyst] Error "ORA-01756: quoted string not properly terminated" when creating new collection for capacity analyst for Oracle Oracle
    DBA-23307 [ISQL] Incorrect message displayed when running specific code in ISQL Oracle
    DBA-23316 [Procedure] [Compile] When compiling an invalid procedure, user doesn't get detailed error messages as it used to be in previous versions Oracle
    DBA-23330 [Object Editor][Storage] The UNLIMITED option is missing from the Maximum Extents drop-down list Oracle
    DBA-23428 [Instance][Configuration]Wrong syntax for ALTER SYSTEM SET optimizer_features_enable Oracle
    DBA-23432 SQL Editor] CLOB is not being displayed Oracle
    DBA-23445 [Package][Privileges] The privileges don't show up in the package/package body editor Oracle
    DBA-23447 [Performance Analyst][Failure to launch]Performance Analyst launch errors and hangs with ORA-24344 Oracle
    DBA-23493 [Roles/Users] The System Privileges/System Permissions list does not contain all the privileges/permissions in Oracle 11 Oracle
    DBA-23498 [Crash] [Space Analyst] [Reorg] Unexpected crash when performing a re-org on an Oracle tablepspace Oracle
    DBA-23623 [Licensing] Incorrect error message "Connection failed" when user has only the base license in the Named Users List Oracle
    DBA-23626 [Performance Analyst] Specifying any SQL search string under the Criteria tab in TOP SQL produce no results when there should be results Oracle
    DBA-23891 [Performance Analyst]Unable to bring up SQL Detail tab, blank results appear in display Oracle
    DBA-23892 [Performance Analyst][historical session] When selecting to view Historical Session, program crashes Oracle
    DBA-12091 Unable to create new Alerts, Jobs and Operators for SQL Server 2005 SQL Server
    DBA-14709 Trying to view a job in the SQL Agent is unsuccessful using a SQL Server 2005 client or server SQL Server
    DBA-17727 Schema Migration fails to complete when using Windows Authentication - SQL Server 2005 SQL Server
    DBA-17893 Create like for logins generates incorrect syntax that references the OLD login name. It also fails to recognize databases where source login resides SQL Server
    DBA-21067 "Error 18456: Login failed for user..." is popping up even though the user is already connected SQL Server
    DBA-21766 Schema Migration fails to complete when using Windows Authentication - SQL Server 2005 SQL Server
    DBA-21796 Error logs for SQL server are not in the right order SQL Server
    DBA-22382 [ISQL] A delay appears when scroll is used in an ISQL window containing a multi-line statement SQL Server
    DBA-22444 [SQL Editor] Runtime error message pops up when modifying a line in a SQL file SQL Server
    DBA-22605 When running Space Analyst, the databases are not brought up SQL Server
    DBA-22860 [Schema Extraction] Database extraction is incorrectly reporting database data file path SQL Server
    DBA-23018 [Logins] 'Change password' action is disabled from outside of a login editor SQL Server
    DBA-23309 Extraction for index does not include filegroup SQL Server
    DBA-23499 [Connectivity]Error on connection, Not valid user in database SQL Server
    DBA-23550 [SQL Editor] Application exits when querying a table which contains two periods SQL Server
    DBA-23678 [Data Source Explorer] DBArtisan display SQL Server error logs in non sequential order SQL Server
    DBA-18628 In Debug mode, the smalldatetime type parameter is appearing as a NULL value Sybase
    DBA-20091 Procedure extraction causes a login failure (in unix log - not DBArtisan) for user with Sybase 15 client Sybase
    DBA-21683 SQL Editor interface is extremely slow navigating, viewing, and scrolling Sybase
    DBA-22489 [Triggers] Trigger status is incorrectly shown in the explorer list view for triggers that reside on the same table, on Sybase Sybase
    DBA-22582 [DBMS Actions] Request to fill by default the "Physical Name" field, from Database Device Wizard, with "/" for Sybase servers located on UNIX Sybase
    DBA-22635 [DDL Extract] Unique index is excluded from the table DDL if a FK its referencing on it Sybase
    DBA-22725 [Schema Extraction]Slow performance on extractions, opening objects, and on connections in comparison to prior releases Sybase
    DBA-22744 [ISQL][Parser] Incorrect syntax highlighting when using a temporary table in a query Sybase
    DBA-22926 RS755 3386: The debugger does not correctly represent the line it is on Sybase
    DBA-22927 Code Assist (auto column lookup) is not functional Sybase
    DBA-22946 [Users] Cannot select multiple users when the explorer tree is organized by Object Owner Sybase
    DBA-22972 [Debugger] Temp tables toolbar become unavailable when a procedure is debugged more than one time Sybase
    DBA-23020 [SQL Editor][Results] In the results display, using the Ctrl+End sends the selector into the last cell, but the viewport is showing the column last-1 Sybase
    DBA-23049 [Debugger] When debugging a stored procedure DBArtisan throws an Error signature error Sybase
    DBA-23218 [ISQL] Comments are removed when a trigger SQL is executed Sybase
    DBA-23219 CLONE -Convert datetime is not returning correct date format results Sybase
    DBA-23319 Data editor cannot be used on system tables Sybase
    DBA-23431 [Utilities][Data Unload] Data Unload feature does not extract seconds and milliseconds into DAT file Sybase
    DBA-23596 [Database][Restore] Error in Restore wizard, Must have exclusive use of the database Sybase
    DBA-23619 [SQL Editor] Not all the Logical Foreign Keys are extracted Sybase
    DBA-23621 [Security][Roles] Incorrect display for Object Privileges after changing the Privilege Level Sybase
    DBA-23622 [Security][Roles] Incorrect display for Object Privileges after changing the Object Type Sybase
    DBA-23641 [SQL Editor] Editing large procedures application crashes Sybase
    DBA-23797 [Explorer] The set rowcount statement affects the number of objects shown in the explorer tree Sybase
    Bugs Fixed in DBArtisan XE and and DBArtisan 8.7.4
    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 has been disabled. Worked in previous versions (e.g. DB815) 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 sales@embarcadero.com, or uk.sales@embarcadero.com 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.