DBArtisan ReadMe

Welcome to DBArtisan® XE 2 and DBArtisan® 9.0.1

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

ReadMe Last Published: Sept. 22, 2011. 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, MySQL, 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 9.0/XE 2

Performance Analyst Updates

Unicode Updates

Datasource/Server Updates

Updated support for IBM DB2 for z/OS features

Updated support for Oracle features

Updated support for Microsoft SQL Server features

Updated support for Sybase features

User interface improvements

Release Notes

DBMS Support

DBMS Versions No Longer Supported

Important Advisory Notes

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 9.0/XE 2

Performance Analyst Updates

This release introduces support for the SP_SYSMON NOCLEAR option, introduced for Sybase ASE 12.5.3 and 15.0.2. The noclear option specifies that a temporary file be used for monitoring. This ensures that DBArtisan cannot zero out monitors, and cannot therefore corrupt statistics by other applications currently using monitoring.

Unicode Updates

Unicode character-handling has been improved in the ISQL Editor and Data Editor. This includes:

Improved encoding detection and options when saving and opening files
Additional UTF-8, UTF-16, and UTF32 encodings with BOM and endian variations are now available
Handling of surrogate pairs and characters made up of multiple unicode (LTR scripts only) have been brought in line with Windows Vista and Windows 7 support.

Datasource/Server Updates

Updates in the category include:

JDBC Driver Availability - When registering or editing datasources, third-party JDBC driver options are no longer available.
Current Session Role Activation - For Oracle and Sybase datasources, you can now activate and deactivate roles for the current login or user within the current session.

Updated support for IBM DB2 for Linux, Unix, and Windows features

DBArtisan now provides support for version 9.7

Updated support for IBM DB2 for z/OS features

DB2 z/OS currency updates for this release include:

Additional Status/Performance Information - Three new subnodes available under the Performance node, Databases, Restricted Tablespaces, and Database Locks, provide additional status information about databases.

Updated support for Oracle features

Oracle currency updates for this release include:

The Reorganize operation, applied to a table, can now be executed online. This allows access to table data while the reorganization is in progress.
Oracle's Recycle Bin lets you store dropped objects until they are explicitly purged. The Recycle Bin is now available under the Schema datasource node. Selecting that node displays dropped objects in the right side of the Datasource Explorer. Associated object actions offer purge, recover, and query options. You can enable and disable the Recycle Bin at the datasource level.
For Oracle 11g datasources, the Index Wizard and Index Editor now have Invisible properties. Invisible indexes are not used by the optimizer during queries unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the session or system level.
Also against Oracle 11g datasources, DBArtisan now supports virtual columns. When defining a column in the Table Editor, you can use the new Virtual property to define a column as virtual. You then use the Default Value control to enter a column expression that calculates the value of the virtual column.
Temporary tablespaces can now be assigned to temporary tablespace groups (SYS.DBA_TABLESPACE_GROUPS).
A new Change Access Status action lets you toggle a table between READ ONLY and READ WRITE modes.
The Partition tab for a partitioned Oracle index now displays whether Oracle has marked a partition definition as unusable.
DBArtisan now provides support for ASM instances and specifically for disk groups. New Instance > ASM and Instance > ASM > Disk Groups nodes are visible, and disk groups can be created and edited. You also have access to Check Disk Group, Mount Disk Group, Rebalance Disk Group, and Undrop Disk object operations. Manage ASM Connection and Disconnect ASM Connection operations let you toggle between the default datasource connection and the dedicated ASM instance connection.
The Analyze object action now offers options corresponding to the following DBMS_STATS package procedure calls: DBMS_STATS.GATHER_INDEX_STATS, DBMS_STATS.GATHER_TABLE_STATS, DBMS_STATS.DELETE_INDEX_STATS, DBMS_STATS.DELETE_TABLE_STATS, DBMS_STATS.IMPORT_INDEX_STATS, and DBMS_STATS.IMPORT_TABLE_STATS.

Updated support for Microsoft SQL Server features

SQL Server currency updates for this release include:

Synonym support lets you create one-part object names used in SQL statements to reference a partially-qualified to fully-qualified, multi-part object names.
Partitioning is now supported for tables and indexes. In support, two new object types are also now available: Partition Schemas and Partition Functions.
Full-text Search object types, Full-text Catalogs and Full-text Indexes, are now available. A set of associated object actions let you rebuild catalogs, merge smaller indexes, enable and disable indexes, and provide native control options for index population.
A new Server Roles Editor lets you modify the login membership of SQL Server’s fixed server roles: bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, serveradmin, setupadmin, and sysadmin.
DBArtisan now provides support for Database Triggers and Server Triggers. These triggers fire in response to DDL events. A full set of creation wizards, editors, and object operations are provided.

Updated support for Sybase features

Sybase currency updates for this release include:

Two new object actions (Add/Modify Login Trigger and Drop Login Trigger) let you configure login triggers for a login. The name of the configured login trigger is now available in the Login Editor.
The new Hide Text operation provides sp_hidetext call support, letting you hide source text of compiled objects. It can be applied to check constraints, databases, defaults, extended procedures, functions, procedures, rules, tables, triggers, users, and views
User-defined function object support includes a creation wizard, an editor, and basic object operations.
Trigger support now includes views as a parent type. The Trigger Wizard generates INSTEAD OF trigger syntax for these triggers.
A full range of show... Set Option command variations now lets you generate diagnostic output in text format.
Data caches now support partitioning. In addition, tables, indexes, and databases can be bound during data cache creation.

User interface improvements

This release 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:

Oracle – Tablespaces
SQL Server – Logins
Sybase – Logins, Dump Devices, Groups, Remote Servers, Roles, User Messages

Release Notes

DBMS SUPPORT

IBM DB2 for z/OS

Server: IBM DB2 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 for LUW

Server: IBM DB2 LUW Versions 8.0 - 9.7

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 ASE 12.5 - 15.0.3

Client: Sybase Open Client

DBMS VERSIONS NO LONGER SUPPORTED

All DBMS versions supported in the previous release are supported for this release.

KNOWN ISSUES

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.

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

The BCP (bulk copy) data movement option is disabled for cross-platform migration. In addition, to use the BCP in a Sybase-to-Sybase migration, the user must be logged in as System Administrator *or* the "select into/bulkcopy/pllsort" database option must be true on the target catalog. If this option is "false" on the target catalog, BCP will not appear as a data movement option for non-system users.

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 9.0.1/XE 2
Issue #	Description	DBMS
DBA-25419	[Application][Toolbar] The ISQL toolbar buttons are displayed incorrectly when extracting objects and the application visual style is set to Microsoft Office 2010	All
DBA-25514	[ISQL] Comments in Check Constraints get lost when the object is created in ISQL	All
DBA-25653	[Tools] Unable to send email notification for a scheduled job in DBartisan if your email client is Outlook 2003.	All
DBA-26223	[Explorer] Selecting dependent Stored Procedure under the Packages group will not open the SP	All
DBA-26254	[Filter][Explorer] Datasource Table filter affects Primary Key constraint and Indexes	All
DBA-26381	[Crash][SQL Editor] Using the CLOSE ALL feature to close Results tabs causing program to crash	All
DBA-25633	DB2 table viewing error Overflow occurred during numeric data type conversion. SQLSTATE=22003	DB2
DBA-25900	TS:[ALTER TABLE] The ObjectRoot is in an inconsistent state error	DB2
DBA-25963	As a DB2 z/OS DBA, the performance when trying to open a table is unacceptably slow.	DB2 z/OS
DBA-25741	TS: [Results] Product crashes when sorting a VARCHAR column	Oracle
DBA-25959	TS: [Explorer] No tables or views are returned when Schema name contains the $ sign	Oracle
DBA-26108	[DBMS Object Management] Tablespace objects displays with negative size.	Oracle
DBA-26217	TS: On Oracle11g SYS.USER$ view is queried in order to retrieve user's information	Oracle
DBA-26259	TS: [Reorganize table] The indexes aren't rebuild when a table in reorganize in offline mode	Oracle
DBA-26262	[DBMS Output] DBMS_OUTPUT option restricted to only 2000 bytes	Oracle
DBA-26308	Tablespace size is showing large -ve numbers when real size is > 2Gb.	Oracle
DBA-24721	[SQL Editor] Errors in the Output messages, display the entire DDL of stored procedure	SQL Server
DBA-24767	[Object Alter]When trying to change a column (bOwner) from null to not null, error occurs ObjectRoot is in an inconsistent state	SQL Server
DBA-26112	[DBMS Object Management] The display of Varchar column max, there are inconsistencies between the display data when the column contains empty strings.	SQL Server
DBA-26269	[Database object][Password Change] Error when attempting password change of USER containing dash or hyphen, Incorrect syntax near '-'	SQL Server
DBA-25567	[Tables / Indexes] Reorganize action is disabled outside the editor for Sybase system tables / system indexes	Sybase
DBA-25579	[View] Permissions on specific columns are not displayed in Permissions tab of Views editor.	Sybase
DBA-25663	Partitions not displayed	Sybase
DBA-25699	Error when not NULL column at the end of the table, The ObjectRoot is in a inconsistent state (Text has not been set)	Sybase
DBA-25720	[Performance Analyst] Graphs are not populated correctly when foreign locale is set	Sybase
DBA-26031	[Constraints] [DDL Extract] Unable to extract Sybase column level check constraints correctly	Sybase
DBA-26032	[DBMS Object Management] Unable to alter table :The object root is in an inconsistent state	Sybase
DBA-26055	[Data Source Explorer] After create insert statement on a table with set rowcount, list of tables are limited displayed in explorer..	Sybase
DBA-26093	[Ad-hoc Migration] Unable to perform an ad-hoc migration with Bulk Copy (Sybase -> Sybase / SQL Server -> SQL Server) - "Table has a null catalog"	Sybase
DBA-26106	[Schema Migration] USE Statement incorrect referring to Source DB instead of Target DB	Sybase
DBA-26126	[Database Search] [Regression] failed to find the string ""	Sybase
DBA-26158	Toolbar Icons are not displayed properly after extracting an Object	Sybase
DBA-26182	[Schema Extraction]Table extraction is extracting Stored Procedure dependencies even though it is unselected	Sybase
DBA-26196	[Ad-Hoc Extraction] [Extraction Options] Index is extracted even when not selected	Sybase

Bugs Fixed in DBArtisan 9.0/XE 2
Issue #	Description	DBMS
DBA-8498	Error installing DB812 on Japanese Windows XP machines	All
DBA-9244	DBArt813.exe caused a Microsoft C++ Exception (0xE06D7363) in module C:\WINDOWS\system32\kernel32.dll at 001B:7C812A5B	All
DBA-11247	Upgrading from DBArtisan 8.1.4 to 8.1.5 does not retain settings	All
DBA-11947	Unable to select and copy to clipboard any of the contents of the "Ready to Install" information	All
DBA-12498	Useless to have "Owner" as the first column for the database with dbo being owner of all objects	All
DBA-12664	Latin South American text, tilde is not supported	All
DBA-12954	Managed Datasource folder structure is corrupted when upgrading from DB720 to the latest version	All
DBA-13609	Unable to change emulator in options	All
DBA-13681	DBArtisan 8.5.0.3592 - Problem Report	All
DBA-13691	Crash submitted via Problem Report	All
DBA-13696	Crash submitted via Problem Report	All

DBA-13700	Crash submitted via Problem Report	All
DBA-13827	DBArtisan - Problem Report: Crash	All
DBA-13828	DBArtisan - Problem Report: Crash	All
DBA-13834	DBArtisan - Problem Report: Crash	All
DBA-13835	DBArtisan - Problem Report: Crash	All
DBA-13836	DBArtisan - Problem Report: Crash	All
DBA-13853	DBArtisan 8.5.0.3603 - Problem Report	All
DBA-13863	RSQL 7.5.0.3363 - Problem Report	All
DBA-13874	Problem Report crash	All
DBA-13875	Problem Report crash	All
DBA-13876	Problem Report crash	All
DBA-13879	Problem Report crash	All
DBA-14264	'Landing Page View' gets enabled for all platforms when installing 851, though they were not enabled in 8.1.5, and the user chooses to 'retain previous settings' during the installation	All
DBA-14808	Crash report when starting DBArtisan	All
DBA-14905	Charachter display problems with Chinese_Taiwan code set	All
DBA-14906	Space Analyst - Incorect display with DBCS characters (Chinese_Taiwan)	All
DBA-15117	After installing DB815, it crashes with a memory could not be read error when attempting a print preview or printing an ISQL query. Printing a report works fine	All
DBA-15923	During installation, get an error message DBArt8512.reg and DBArt8542.reg were missing from "C:\Documents and Settings\\Local Settings\Temp\" directory	All
DBA-16013	Formatting is not preserved when copying the results of a Schema Extraction or Migration script to Notepad	All
DBA-16261	Installation fails with this error message - Error 1327 invalid drive	All
DBA-17062	DBArtisan crashes at will	All
DBA-17300	Incorrect result appears when performing Schema/Dependencies action on a table - XML format appears - on WinXP SP3	All
DBA-18081	Prolonged usage of DBArtisan causes various UI issues - Crashing, Editor color mismatch, Datasource names missing from drop down	All
DBA-18150	After making a change to a VIEW in the display view, if the user changes to another view and select CANCEL to the Would you like to Save, any changes are lost	All
DBA-23033	Problem Report Crash: Changing Datasources	All
DBA-23545	[Crash][Landing Page View] Crash when connecting to Oracle, Sybase ASE and DB2 LUW	All
DBA-23792	[Object ALTER][Datatype size] Column size changes to 1 when editing the datatype	All
DBA-24077	[Script Execution Facility] The Execute button is greyed out	All
DBA-24115	[UI] Incorrect position for the Output Messages window when launching the application without having Registered Datasources	All
DBA-24344	SQL Editor is not highlighting the syntax correctly	All
DBA-24418	[SQL Editor][Print Preview and Printing] Code displayed in Print Preview is being cut off and subsequently also cut in the printing of document	All
DBA-24729	[Explorer][Bookmarks] When accessing bookmarks on seperate Datasource Explorer, wrong datasource is selected on swapping Explorer tabs	All
DBA-24744	[Application Status Bar] Incorrect description appears in the Status Bar for the entries of the sub-menus	All
DBA-24811	[UI][Schema Extraction / Migration] Tooltips don't appear anymore on the values of a combo box after expanding it	All
DBA-24827	[Code Complete] Performance and usability problems with Code Complete	All
DBA-24829	[Columns tab] Re-sizable columns return to the default size when switching between windows causing annoyance to the user	All
DBA-25069	Application creates file named file.log in Program Files area should be in the users area	All
DBA-25143	[Indexes / Triggers Wizard] Parent Schema and Parent Name combo boxes should be populated with values when opening the Wizard from an empty Index / Trigger editor	All
DBA-25326	[Syntax color] Incorrect coloring for multi-line quoted text	All
DBA-14162	While doing a tablespace extraction the user cannot see all the raw files	DB2
DBA-15233	Drop and recreate a materialized view when the column length of the base table changes	DB2
DBA-21122	'Execution failed due to a distribution protocol error that caused deallocation of the conversation' when extracting stored procedure or index	DB2
DBA-21388	Is there native XML support for DB2? After upgrade, procedure no longer executes or runs but it ran in DB855 without error or issue	DB2
DBA-21968	Table names and the number of rows are no longer expanded in the table list. User has to manually expand to see the full information	DB2
DBA-22690	[Database Search] No results returned when trying to find columns in views using Database Search	DB2
DBA-22795	[Index] Running update statistics for a index that is more than 18 characters fails	DB2
DBA-23827	[DBMS Object Management] Displaying a tablespace which should have objects from a partitioned table shows no objects	DB2
DBA-23856	[Users][Groups] System privileges are incorrectly displayed for a user that has the same name as a group	DB2
DBA-24318	[SQL Parser] Error when calling DB2 SP, escape character is not valid	DB2
DBA-24426	[Tables] The User Datatypes are not shown for column's datatypes in the table's editor on DB2 v9.7	DB2
DBA-24460	Return status is not working	DB2
DBA-24866	Incorrect statement is generated when altering a non identity column within a table	DB2
DBA-24867	[Data Unload] Data Unload error SQL3022N SQL error -104	DB2
DBA-25320	[Space Analyst] Partitioned tables do not appear in Space Analyst -> Tables - DB2	DB2
DBA-22125	DBArtisan freezes up after user double clicks on the DB2 table to view table information	DB2 z/OS
DBA-24120	[Command] Attempting to run QUIESCE utility ends in errors	DB2 z/OS
DBA-20545	[Query Builder][Join On] Join On clause is missing from the query on MySQL datasource	MySQL
DBA-22327	Problem Report Crash: Changing filter in explorer	MySQL
DBA-9030	Oracle DB proc extraction handles quotes incorrectly with the parameter or custom expression	Oracle
DBA-9586	Crashing on Schema Extraction	Oracle
DBA-11897	Error of ORA-01756: quoted string not properly terminated, Batch 1 Line 1 Col 1 when using Accented Characters	Oracle
DBA-14015	After extracting the DDL for a role the users assigned the role are no longer included	Oracle
DBA-15068	[8.5.2]: Unable to copy/save SQL in plain text format, copy and paste from ISQL window results in ANSI Text being copied over	Oracle
DBA-15194	Growing a tablespace generates an alter statement that turns off the autoextend. The audit record will inappropriately indicate that the user turned off autoextend	Oracle
DBA-15195	Incorrectly adding a new USER when USER already exists will incorrectly ALTER the DEFAULT ROLE	Oracle
DBA-15208	Application hangs when getting tablespace information	Oracle
DBA-15481	Failed to create a connection Error after changing password for current user	Oracle
DBA-15489	Database Monitor is showing multiple processes on an Oracle RAC server	Oracle
DBA-16173	DDL Tab is not showing the correct DDL for a BIGFILE TABLESPACE	Oracle
DBA-17515	Error: OCI-21560: argument 3 is null, invalid, or out of range, Batch 1 Line 1 Col 1	Oracle
DBA-17900	When trying to execute a procedure SELECT privilege is required on several system tables	Oracle
DBA-18246	The schema PUBLIC is missing from selection when creating a Synonym for a single object	Oracle
DBA-18289	The new password for a registered Oracle datasource is not saving into the datasource Auto connect buffer	Oracle
DBA-18647	DB870 3954: Right-click->extract (Procedures) doesn't always append the object owner to the object name it extracts	Oracle
DBA-20157	[Roles] After granting a role to a User, the role DDL/extract no longer displays the statements for users having that specific role as the default one, on Oracle	Oracle
DBA-20953	When running a query on an Oracle server several columns aren't populated	Oracle
DBA-21135	Customer experiences extreme performance degradation with upgrade. Worked fine in DB86x	Oracle
DBA-21350	Opening a Tablespace is taking a long time, 10+ minutes	Oracle

DBA-21763	The display listing for Foreign Keys is taking a very long time to return results	Oracle
DBA-22216	[Database Monitor] Incorrect blocking locks information--multiple schema is locking each other in RAC datasource	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-22609	[Connectivity] Failed to connect to an Oracle server with comma in server alias name	Oracle
DBA-22616	[Code Analyst][Object Selection]Only the current owner is displayed in the Object Selection page of the Create New Collection wizard	Oracle
DBA-22723	[Explorer] ORA-00903 "Invalid table name" error message returned when trying to populate Storage/ Security/Schema nodes	Oracle
DBA-23043	DBMS_OUTPUT not working	Oracle
DBA-23238	[Schema Extraction]Order incorrect for extracted indexes for an Oracle Partitioned table	Oracle
DBA-23299	[SQL Editor]Results with the [NULL] placeholders cannot be copy/pasted into a query window or third party program	Oracle
DBA-23615	[Connectivity] Generic connectivity error does not provide more insight to the issue	Oracle
DBA-23889	[Crash][ORA-00000] Crash when executing SQL - ORA-00000: normal, successful completion	Oracle
DBA-24112	[Synonyms][Wizard]Schema drop down list is not returning all the database users	Oracle
DBA-24122	[Datasource Explorer][Performance][Blocking Locks]Not able to see blocking locks at Performance > Blocking Locks even after refreshing	Oracle
DBA-24486	[Object Management] Tables are not sorted correctly when sorting by rows	Oracle
DBA-24624	[Schema Extraction] ORA-00918 error returned when extracting users	Oracle
DBA-24631	[SQL Execution] - Incorrect handling of Stored procedure with default date parameters	Oracle
DBA-24844	[Application] Unable to display memory configuration with clustered server	Oracle
DBA-25004	[Object Management] Incorrect alter generated when changing the status of two foreign keys	Oracle
DBA-25092	How to send SQL statement string to the server when the client is UTF-8 and the server is not	Oracle
DBA-25125	[Tools] "Out of Memory" error when running data import	Oracle
DBA-25213	[DBMS Object Management] Spaces are added when viewing a procedure definition	Oracle
DBA-25340	ORA-00942: table or view does not exist when opening tablespace	Oracle
DBA-25481	[Packages] DDL extract does not contain privileges	Oracle
DBA-25553	Explorer objects are not populated if the network connection is lost	Oracle
DBA-959	Functions object is not included in the Schema Publication wizard (MSSQL server 2005)	SQL Server
DBA-11790	System objects always show up on certain configuration of server	SQL Server
DBA-13623	Schema publication doesn't have any details for columns in the table reports	SQL Server
DBA-14101	[8.5.1#3643] - Failed to populate for object type TRIGGER: Error during object population. Type = TRIGGER	SQL Server
DBA-14781	CLONE -Error during object population while extracting a trigger	SQL Server
DBA-16985	SQL Server 2005 Schema extract fails with "Failed to find requested ObejctRoot: "	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-20045	[Error Logs][Toolbar]"Open", "Toggle All Messages/Errors Only", "Report" buttons are missing from Error Logs toolbar on MSSQL datasources	SQL Server
DBA-20185	[JOBS][Actions] Manage Jobs Categories and View Job History are not doing any actions on SQL Server	SQL Server
DBA-20478	[ISQL]Cannot type the same name in lower case if the name was written before in uppercase in the Replace with combobox in the Find and Replace window	SQL Server
DBA-20874	When viewing list of Login names in the explorer, disabled logins are listed as YES under the ACCESS column	SQL Server
DBA-21075	Last Run Status under SQL Server Agent Jobs: Right-Click on any job always returns no job information history	SQL Server
DBA-21632	Java errors appear when attempting to add column to particular tables containing dependencies	SQL Server
DBA-22445	[SQL Execution]The logo keeps spinning after the results are returned	SQL Server
DBA-22614	[ISQL] Embarcadero globe logo keeps spinning well after results are returning, this makes things confusing if the query return is large	SQL Server
DBA-22618	[Explorer][Connection]Datasource connection failure error for passwords with special characters	SQL Server
DBA-23030	[Explorer][Jobs] The status of a retrying job is incorrectly displayed as Not running	SQL Server
DBA-24217	[DBMS Object Management] Schedule editor creates script with invalid date	SQL Server
DBA-24326	[SQL Parser] An error occurs when trying to execute jobs, SQL parser not escaping any ' characters	SQL Server
DBA-24489	[DBMS Object Management] Job step extraction creates script with incorrect @command string	SQL Server
DBA-24510	[Object Management][Schema] When opening the schema for two tables with the same name the second window does not appear and the first minimizes	SQL Server
DBA-24714	[Schema Extraction] When chosing "Playback an existing extraction" the proper database is not selected by default in the wizard	SQL Server
DBA-24800	[ISQL] Incorrect behavior of the Unlock Connection causes inconvenient in working with temporary tables - Sybase	SQL Server
DBA-24807	[Jobs] Unable to start a job from a desired step	SQL Server
DBA-24819	Problems displaying Greek character sets	SQL Server
DBA-24855	[Object Management] Incorrect extract for users when granting schema permissions	SQL Server
DBA-24856	Extract of DB Triggers incomplete	SQL Server
DBA-25212	[Query Builder] Application crashes when opening query builder files from previous release	SQL Server
DBA-25288	CLONE -Invalid extract for foreign keys on sql server	SQL Server
DBA-25556	[ALTER TABLE] When a char column is altered as a datetime the insert statement it fills the datetime column with 'getdate'	SQL Server
DBA-25558	[Display][Indexes] Indexes are missing that have very large values in the index_id column (>255)	SQL Server
DBA-6938	[Object Editor] [Keyboard Shortcuts] Shortcuts such as Ctrl+C, Shift+Del, Ctrl+X, Shift+Ins, Ctrl+V don't work in the object editors	Sybase
DBA-8122	DB812[3216]: DBArtisan is not putting single quotes around the parameters being passed to sp_password	Sybase
DBA-8335	DB812 3216 Receive error on 'test' connection to roman8 Sybase server (error only occurs on test connection, main application connection is fine)	Sybase
DBA-11100	Extracted SQL for views is corrupted on Sybase 15 databases	Sybase
DBA-12019	Crashes when trying to connect to a Sybase datasource	Sybase
DBA-12524	[8.5.0#3529] - Server class not extracted	Sybase
DBA-13666	[8.5.0#3603] - Stored Procedure which contains danish characters (in comments or in strings) DBArtisan put spaces in the source code	Sybase
DBA-14018	[8.5.0#3603] - Killing Process - Unable to kill process with PID> =1000	Sybase
DBA-14119	No columns appearing when trying to edit data for a table	Sybase
DBA-15015	[8.5.3: #3744] - Logsegment - Threshold tab not working for Sybase ASE 15.0	Sybase
DBA-15154	Unable to add Alias on DB when creating user	Sybase
DBA-15241	"Error executing database statistics query" message when viewing a database on certain servers	Sybase
DBA-15381	Sybase - Extract a segment and sp_extendsegment	Sybase
DBA-15750	After upgrading from DB815 to DB852 to DB854, a user logged in as SA gets incorrect syntax errors when trying to examine a Sybase login	Sybase
DBA-16007	Updating accented data results in mangled results	Sybase
DBA-18082	When creating database raw partition device, a direct IO clause is being incorrectly added in the DDL	Sybase
DBA-18738	Sybase ReOrganize command creates 'select into/bulkcopy/pllsort', true command when the database is already set to true	Sybase
DBA-21607	When SQL Parsing option is enabled, valid SQL statements are being flagged with a misleading error X icon and unexpected token error	Sybase
DBA-21608	Most admin tasks that require sso_role will fail with errors, if connect with a login that has the password protected sso_role role enabled	Sybase
DBA-22312	When the Log SQL option is enabled, the logging process may not log anything for days	Sybase
DBA-22658	CLONE -[ISQL] [Performance] [Results] Performance issue when performing a SELECT from a table with 30k~ rows	Sybase
DBA-22696	Different error messages in results from simple select statement on particular table	Sybase
DBA-22773	[Results][Save] User would like to be able to save the results files to the last folder used	Sybase
DBA-22809	[Import] Import data from file doesn't work for tables that contain an identity column	Sybase
DBA-22950	[Datasource Explorer] Sybase datasource takes upwards of 30 seconds or more to expand database tree	Sybase
DBA-23063	[Users] User Extract does not list the GRANT statements when "Extract" is made from outside the editor, or from inside the editor if not going to "DDL View" tab on prior, on Sybase	Sybase
DBA-23578	SQL_EXEC - Comment is ignored before 'CREATE' statement	Sybase
DBA-23602	[Application] Server name and datasource name is removed after manually typing in server name during datasource registration	Sybase
DBA-23608	[Data cache] - [I/O Size] - Memory Pool attributes do not adhere to ASE rules	Sybase
DBA-23653	[DBMS Object Management] The I/O size of pool doesn't show correctly	Sybase
DBA-23691	[ISQL][Parser] Incorrect syntax highlighting for reserved word: "insensitive"	Sybase
DBA-24151	[ SQL Execution] Unable to save all the input parameters in the procedure execution window	Sybase
DBA-24162	[Schema Extraction] Error when extracting large number of Sybase schema objects, string index out of range 12592	Sybase
DBA-24163	[Devices][Mirror] Device Mirror wizard fails to generate any PREVIEW SQL or create mirror device	Sybase
DBA-24358	[Logins][Drop] Incorrect DDL is generated when dropping Logins with Roles. Roles are granted after the logins are dropped	Sybase
DBA-24360	[SQL Editor] Application crash during ISQL session	Sybase
DBA-24443	[SQL Execution] Runtime error when executing stored procedure by checking default box	Sybase
DBA-24487	[SQL Editor] Cannot locate newlines with Find/replace	Sybase
DBA-24622	[ISQL] Include keyword is working even if it is commented or used as a string on Sybase	Sybase
DBA-24809	[Table][Extract] Foreign Key is not extracted along with the parent (referenced) table	Sybase
DBA-24821	[Login] Customer would like to see the Group name also for the login users in Users Tab - Sybase	Sybase
DBA-24857	[Upgrade][Datasources][Server Principal] Server Principal fails to update when updating DBArtisan to latest release	Sybase
DBA-24860	[Login] Incomplete list of databases appears in Users tab of the Login editor in "Databases where the login HAS a user account"	Sybase
DBA-24875	[Databases][DDL] Incorrect "WITH DBID=n" clause in the definition of databases starting with Sybase 15.0.2 datasources	Sybase
DBA-24947	[SQL Editor][Query] Query working on 815 but not working on 876	Sybase
DBA-25108	[Explorer List View][User Datatypes] IDs instead of object names appear in the Explorer List View for Bound Rule and Bound Default	Sybase
DBA-25166	[Login] Change the message related to password expiration at login , to be marked as an Warning not an error	Sybase
DBA-25176	[Analysts] Error "The name is not a valid identifier" when launching Space Analyst	Sybase
DBA-25185	[Explorer List View] [Configuration Parameters] The "Dynamic" column always shows "YES" - Sybase	Sybase

DBA-25399	[Table Editor][Space Tab] Incorrect information is displayed in the Space Tab of the Table editor on Sybase	Sybase
DBA-25484	[Query Builder] Selected system table is not automatically added into the SQL Diagram pane	Sybase
DBA-25502	[Logins] "Default" combo should be set on YES by default when granting roles to a login	Sybase
DBA-25503	[Tables] Tables List View is not refreshed after performing a Truncate - Sybase	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.