DBArtisan ReadMe

Welcome to DBArtisan® 8.7.2

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

ReadMe Last Published: February 1, 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.2

Color-coded or labeled datasources through categorization

Datasource storage options

What's New in Version 8.7

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.2

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:

A short name label included in the Datasource toolbar combo/dropdown when a categorized datasource is selected
Color-coded tabs on windows associated with actions against a categorized datasource, editor or ISQL windows for example
Color-coding of the status bar at the bottom of the DBArtisan window

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:

Windows Registry datasource catalog - The datasource catalog is stored and managed locally, in the Windows registry. This user can add and delete datasources and edit the registration details of existing resources. Any changes are retained across startups of DBArtisan.
File based datasource catalog - The datasource catalog is stored locally and is file-based (%APPDATA%\Embarcadero\Data Sources\ in a default installation). This user can add and delete datasources and edit the registration details of existing resources. Any changes are retained across startups of DBArtisan.
Network shared datasource catalog - The datasource catalog is file-based, and obtained from the location specified in the Location of shared datasources file control on the Datasource tab of the Options editor. Changes such as new datasources, deleted datasources or edited datasource registrations are lost as soon as this user shuts down DBArtisan.

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

What's New in Version 8.7

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:

On-the-fly syntax-checking locates and diagnoses syntax errors as you type
Semantic validation eliminates typographical errors and helps avoid outdated references in specified object names.
Code Complete analyzes statements as you type and offers intelligent suggestions with regard to object names

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:

IMMEDIATE and DEFERRED options when editing buffer pools
Encoding scheme options of ASCII, UNICODE, or NONE for character or graphic string parameters in procedures and functions
Object ownership transfer for object owners and users with SECADM authority
Additional “history” deadlock event types for Event Monitors
Inherit isolation level with or without lock request options on Structured Type methods

Updated support for IBM DB2 for z/OS features

This release features the following feature upgrades or improvements:

The truncate operation has been extended to control DROP STORAGE/REUSE STORAGE, RESTRICT WHEN DELETE TRIGGERS/IGNORE DELETE TRIGGERS, and IMMEDIATE clauses of the TRUNCATE TABLE statement.
Revised calculation and display of certain index and table statistics to reflect 8.x changes to system catalogs
Support for long object names
Modification of column sizes and default values with a simple ALTER TABLE statement
Features formerly provided through proprietary stored procedures now use native stored procedures

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:

Microsoft SQL Server – Backup Devices, Linked Servers, Remote Servers, Roles, User Messages
DB2 for Linux, Unix, and Windows – Event Monitors, Structured Types

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

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:

Close DBArtisan.
Uninstall the older MySQL ODBC client.
Restart DBArtisan and try connecting to a MySQL datasource. You are prompted to install the MySQL client drivers.
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.

The SQL Server Agent fails using SQL Server 2005.

The SQL Server Agent failing problem is caused by the lack of permission to enumerate the status of the server service. To determine the status of the server, the user must have permission to check the status of the server service. If the user running DBArtisan at the client machine is a not a local user who can be authenticated at the server machine, the Server Agent jobs will fail.
Workaround:
a. If the user that runs DBArtisan is not a domain user, create the same user with the same password on the server.
b. If the user is a domain user, make sure the user can login to the server.

When you are using the Debugger:

The Debugger windows (Variables, Watch, CallStack, Dependency) cannot be undocked. This behavior is deliberate and is true only for the Debugger windows. The Output window can be undocked.
When running Windows XP SP2, SQL Server 2000 SP4 is required on both the client and the server.
When running the Debugger on SQL Server 2005 CLIENTS:

Verify that the file ssdebugps.dll is registered on the client machine. This file is REQUIRED for debugging and Microsoft only installs it on the server machine and not as a part of a client-only install.
Follow the instructions under the "Configure DCOM on the computer that is running Visual Studio. NET" heading from Microsoft to reconfigure the DCOM settings on your client machine: http://support.microsoft.com/default.aspx?kbid=833977.
On the Default Properties tab of the My Computer dialog box, make sure the Default Authentication Level is set to None and that the Default Impersonation Level is set to Impersonate.

When using the Embarcadero Sybase debugger against a Sybase database with multiple temporary databases (supported in Sybase ASE 12.5.0.3 and above), either the user or the debugger application must be bound to a specific temporary database.

To bind the Embarcadero Sybase Debugger:
sp_tempdb "bind" , "ap", "Sybase Debugger", "DB", "<tempdb name>"
To bind the user:
sp_tempdb "bind", "lg", "<login id>", "DB", "<tempdb name>"

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 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-21257	Database size in the database listing is incorrect	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.