Release Notes for DBArtisan XE6 Patch
Go Up to What's New in DBArtisan XE6 Patch
Contents
Important Advisory Notes
- If you want to run DBArtisan on Microsoft Windows 8.1, verify that third-party DBMS native drivers install properly. Consider using a JDBC connection.
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:
- If the user that runs DBArtisan is not a domain user, create the same user with the same password on the server.
- 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.7.5/XE6 Patch
Issue # | Description | DBMS |
DBA-32274 |
query_cache_type becomes invalid |
MySQL |
DBA-32175 |
Unknown system variable |
MySQL |
DBA-32017 |
[Enhancement][Oracle] semicolon not filtered when it should be |
All |
DBA-31951 |
[SQL Editor] Rule hint is causing a large consumption of the temp space |
Oracle |
DBA-31937 |
Oracle 12c Add IDENTITY data type support in table editors/wizards |
Oracle |
DBA-31935 |
[Schema Extraction] When extracting or compiling Function, the comments are missing from Function |
Oracle |
DBA-31873 |
[DBMS ACTION ] Table "Segment Usage" show incorrect values for tables/indexes |
Sybase ASE |
DBA-31850 |
[Enhancement] Oracle Database 12.1.0.2 user DDL extraction issue |
Oracle |
DBA-31814 |
[DBMS Actions] would like to be allowed the entry of -1 in the 'maximum login attempts' |
Sybase ASE |
DBA-31785 |
Performance Analyst Space tab has error message about sp_embt_ps_space_drill_tables Implicit Conversion from datatype INT |
Sybase ASE |
DBA-31780 |
DBArtisan does not generate the new 'create or replace' SQL |
Sybase ASE |
DBA-31778 |
[Sybase 16] Some Database options are not refreshing after being enabled |
Sybase ASE |
DBA-31769 |
Performance Analyst launches with errors, Ambiguous Column name Hostname |
Sybase ASE |
DBA-31754 |
Performance Analyst launches with errors, Procedure (sp_sysmon_collect) Invalid parameter '00:00:00' Attempt to insert NULL value into column 'value', table 'sybsystemprocs.dbo.embt_pa_monitor';column does not allow nulls. Update fails. |
Sybase ASE |
DBA-31672 |
Copy/Paste using CTRL-Mouse Click not consistent in SQL window |
All |
DBA-31638 |
[Schema extraction] DDL Extraction is not formatted correctly |
DB2 for z/OS |
DBA-31616 |
Function Call fails (with ORA-06550) on the last 2 versions of DBArtisan 9.6.1 build 13123, and 9.7.1 build 13242 |
Oracle |
DBA-31602 |
[Schema Migration] The Option Overwrite Existing is not working |
Sybase ASE |
DBA-31577 |
[SQL Editor] Scripts fail to stop executing when an error is encountered |
DB2 for LUW |
DBA-31567 |
[DBMS Object Management] not able to select compatibility level for SQL Server 2014 |
SQL Server |
DBA-31565 |
Ability to save 'Results' in same folder as opened SQL file |
All |
DBA-31458 |
Oracle 12c IDENTITY data type does not appear in table extraction |
Oracle |
DBA-31417 |
[Database Monitor] displaying incorrect info for Database column for Network Handler system processes |
Sybase ASE |
DBA-31410 |
Login Extract fails to execute due to this SQL line "ALTER LOGIN login here ADD AUTO ACTIVATED ROLES sa_role |
SQL Server |
DBA-31368 |
[DBMS Actions] Existing procedures are no longer ale to be compiled |
Oracle |
DBA-30853 |
[Drop] Application is freezing when trying to perform a multiple drop on PostgreSQL |
PostgreSQL |
DBA-30817 |
[Schema Migration] Schema Migration fails to import data when Identity column exists |
SQL Server |
DBA-30813 |
[Database objects] Does not show Views in tab "Dependencies", section "Referenced By" for Mviews |
Oracle |
DBA-29771 |
Need an option to assign a default driver to all |
All |
DBA-29764 |
Procedure not showing for SQL server 2012 |
All |
DBA-29747 |
[Schema Migration] No data migrated when using Migration, error ORA-01005 |
Oracle |
DBA-29746 |
The object permissions display keeps reverting to a particular database on datasource |
Sybase ASE |
DBA-29745 |
Logical Foreign key table column names blank |
Sybase ASE |
DBA-28844 |
[Datasource Registration] Username is not saved when unchecking "Auto connect" |
All |
DBA-25563 |
[Procedure Definition][Oracle] Schema name is replaced by spaces in definition of an invalid procedure |
Oracle |
DBA-20505 |
[SQL Editor]"Auto-Save File Every mins" option does not work. |
All |
DBA-18689 |
Extraction of proxy table is incorrect |
Sybase ASE |
DBA-18341 |
Request for better bookmark management menu |
All |
DBA-18192 |
ROLE is missing SYSTEM PRIVILEGE called CHANGE NOTIFICATION |
Oracle |
DBA-17897 |
extract on sybase 15 user datatype unsigned does not return the create statement |
Sybase ASE |
DBA-16931 |
Extracting particular Stored Procedure causes DBArtisan to hang freeze up and the process has to be killed in Task Manager |
SQL Server |
DBA-16870 |
Compound partition columns not displayed correctly |
Oracle |
DBA-16859 |
Currently connected datasource in drop down disappears after 8th or 9th execution of SQL script in ISQL editor |
Oracle |
DBA-16675 |
Serial Number is either invalid or expired (7013) |
All |
DBA-15060 |
Request to clear the User ID (Login ID) field when choosing to not "Auto Connect" to a datasource |
All |
DBA-14989 |
Double clicking a user name under Security does not return results |
Oracle |
DBA-14340 |
DB2 package drop fails due to wizard not getting the version identifier |
DB2 for LUW |
DBA-14292 |
Script is generated incorrectly for table of function indexes (new Sybase 15 feature) |
Sybase ASE |
DBA-13759 |
When opening and viewing table Attributes, then swapping over the Properties tab, the Properties tab information takes a long time to generate |
DB2 for LUW |
DBA-12846 |
In Database Manager, clicking on the Placement tab causes the Space and DDL View tabs to become disabled |
Sybase ASE |
DBA-12767 |
Datasource toolbar looses content after switching back and forth between DBArtisan and other applications |
All |
DBA-12592 |
When listing fields in Oracle VIEW, Customer would like decimal portion of NUMBER type to show up |
Oracle |
DBA-11850 |
Unable to rename index when both column and index are of the same value |
Sybase ASE |
DBA-11431 |
high memory usage until connection to database is disconnected and re-established |
Sybase ASE |
DBA-10615 |
When Data Unload all the "tables are skipped because they had zero rows", even they contain data. |
Sybase ASE |
DBA-9527 |
Tables and views are not listed for the databases that are linked using the linked server wizard. |
SQL Server |
DBA-9020 |
Missing column when performing an alter to the table |
DB2 for LUW |
DBA-8349 |
DB812 3216 Bug: when a table with dependent stored procedure is modified, the privileges on table got lost |
All |
DBA-7016 |
Request: graphic layout of an explain plan like that of Enterprise Manager |
SQL Server |