Release Notes
Go Up to What's New
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.
- 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 IDERA 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 IDERA Sybase Debugger:
- sp_tempdb "bind" , "ap", "Sybase Debugger", "DB", "<tempdb name>"
- To bind the user:
- sp_tempdb "bind", "lg", "<login id>", "DB", "<tempdb name>"
- To bind the IDERA Sybase Debugger:
- 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.
- 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 16.6.1
Issue # | Description | DBMS |
DBA-34006 |
DDL user extract not returning correctly on Oracle 11g R1 |
Oracle |
Bugs Fixed in DBArtisan 16.6
Issue # | Description | DBMS |
RAP-5816 |
[SQL Editor][Code Complete] Auto Complete feature fails to function properly, nothing appears after period |
Sybase ASE |
RAP-6118 |
Proc Missing Defines Test gives an error message |
Oracle |
RAP-6120 |
ETSQLProblemRequestManagerThread.log |
|
DBA-15442 |
View Extraction sometimes works but will cause the application to crash or be in a hung status |
Oracle |
DBA-24417 |
[SQL Assist] Code complete is enabled but does not display suggested columns |
Oracle |
DBA-29432 |
Comment lines not showing in the transaction logs |
|
DBA-31490 |
[SQL Editor] Explain plan is not displaying all the steps for a parallel DML |
Oracle |
DBA-33555 |
DBArtisan 2016 when extract SQL for a GLOBAL index it gets converted to a LOCAL index in the extraction |
Sybase ASE |
DBA-33690 |
Sybase User Object Editor crashes |
Sybase ASE |
DBA-33697 |
Oracle passwords are not taking during new user creation |
Oracle |
DBA-33843 |
DBArtisan discovers a data source multiple times and adds it with a new extension |
Oracle |
DBA-33870 |
DBArtisan discovers a data source multiple times and adds it with a new extension |
Oracle |
DBA-33903 |
Oracle extract is not pulling complete information and is giving a message, AS LANGUAGE C NAME , LIBRARY |
Oracle |
DBA-33910 |
Just upgraded to DBArtisan 2016 9.7.5 and on my Oracle connection I cannot see the parameters for an instance |
Oracle |
DBA-33911 |
Copying the connection description for an AWS connection to Oracle the program core dumps and exits |
Oracle |
DBA-33935 |
Last datasource registered using a TNSNames alias does not show in list |
Oracle |
DBA-33971 |
Create like function not working properly |
Oracle |
DBA-33974 |
DBArtisan crash |
Bugs Fixed in DBArtisan 2016+ (16.5)
Issue # | Description | DBMS |
RAP-6086 |
Login Dialog crash |
|
RAP-6048 |
[Data Source Navigator] Occasional crashes when expanding databases node from the datasource navigator |
SQL Server |
DBA-33446 |
[Data Cache] After Preview statements are in the wrong order. |
Sybase ASE |
DBA-33390 |
[BNF] CBufferedOutputRouter crash. |
|
DBA-33331 |
PCLender Crash |
SQL Server |
DBA-32998 |
[Sybase][Parsers] Batch delimiter ‘go’ on its own is treated as procedure instead of empty statement. |
Sybase ASE |
DBA-32608 |
[Oracle][Extract Role] Extracting DDL a role, the users assigned to the role are no longer included. |
Oracle |
DBA-31248 |
[Crash Report] DBArtisan crashes while outputting SQL results. |
All |
DBA-30756 |
[DBMS Actions] Cannot create insert statements from a particular table. |
Sybase ASE |
DBA-30248 |
Error establishing a debugger session with the server. |
DB2 for LUW |
DBA-18630 |
Extraction issue – XML INLINE LENGTH and compression not recognized. |
DB2 for LUW |
Bugs Fixed in DBArtisan 2016 Patch (16.0.1)
Issue # | Description | DBMS |
RAP-6050 |
[JDBC][Procedures] Smallint being treated as bit datatype. |
SQL Server |
RAP-6048 |
[Data Source Navigator] Occasional crashes when expanding databases node from the datasource navigator. |
SQL Server |
RAP-6027 |
[Crash] Sybase IQ customer crashes. |
Sybase IQ |
DBA-33166 |
Case Number 00455434: Invalid column name 'systemwide password expiration' |
Sybase ASE |
DBA-33159 |
[Enhancement] Change fillfactor default value to prevent space consumption and performance issues on index rebuild |
SQL Server |
DBA-33154 |
[BCBSVT] [SQL Editor] Application crashes during SQL Editor session |
DB2 for LUW |
DBA-33152 |
DBA-33150 [Enhancement] Improve the exception handling in case of driver blowing up |
Oracle |
DBA-33151 |
DBA-33150 [ISQL] Nomura crashes |
Oracle |
DBA-33150 |
Find a solution to the random crashes experienced by customers |
All |
DBA-33141 |
[DBMS Object Management] Crash and inoperative state with views |
DB2 for LUW |
DBA-33108 |
Oracle 11g and higher already has a PLAN_TABLE installed |
Oracle |
DBA-33095 |
Provide support for SQL*PLUS script commands |
Oracle |
DBA-33076 |
[Analysts] Unable to run an analysis report |
SQL Server |
DBA-33068 |
[Enhancement][Functions]Some objects do leave out the schema name in the CREATE |
SQL Server |
DBA-33033 |
Customer case 00443195: Schedule of Capacity Analyst does not work on machines with Windows in Spanish |
SQL Server |
DBA-32999 |
[DBMS Object Management] Database option "allow incremental dumps" is not shown for Sybase 15.7 SP130 |
Sybase ASE |
DBA-32987 |
[Edit Data] Copy-Paste from Edit Data grid returns weird characters |
SQL Server |
DBA-32967 |
[Schema extraction/publication] Can't execute schema extraction and schema publication with some DBMS |
SQL Server |
DBA-32960 |
In Edit Data, the DELETE of a row is not actually performed in the table |
SQL Server |
DBA-32959 |
[Enhancement]Migrate Database object is missleading |
Sybase ASE |
DBA-32945 |
[DBMS Object Management] Can't exchange a table partition |
Oracle |
DBA-32943 |
Unable to kill sessions from the Lock tab in Database monitoring |
Sybase ASE |
DBA-32935 |
Analyst update error on Oracle datasources ORA-01031: insufficient privileges |
Oracle |
DBA-32713 |
[Utilities] No records are migrated with migrated feature |
Sybase ASE |
DBA-32698 |
[ISQL] Crashes in Isql when running multiple scripts |
All |
DBA-31366 |
[DBMS Actions] Tables based on materialized views do not get extracted with the appropiate unique index |
Oracle |
Bugs Fixed in DBArtisan 2016 (16.0.0)
Issue # | Description | DBMS |
RAP-5970 |
Customer case 00430700: The application generates a corrupt xlsx file when importing results to Excel. |
Oracle |
RAP-5865 |
[Tools] Ability to save a .csv file from results where all the fields are enclosed in double quotes. |
Oracle |
RAP-5742 |
508 compliance for the application: JAWS incorrectly reads the drop-down options that have separators. |
|
DBA-32830 |
Not consistently opening SQL files from location set in Directories option for "User SQL Scripts" |
|
DBA-32585 |
Lapsed time clock at the bottom of a Query/Results tab frame no longer works |
Oracle |
DBA-32474 |
[File Execution Facility] After row 43, Dates are being returned as zeros |
All |
DBA-32472 |
[Regression][DMBS Actions] Hide time portion of DATE datatype if zero option suppresses the time portion for all rows, even if they have non-zero times |
Oracle |
DBA-31935 |
[Schema Extraction] When extracting or compiling Function, the comments are missing from Function |
Oracle |
DBA-30919 |
[DBMS Actions] Ability to name output file |
All |
DBA-22901 |
Request support for Excel 2007 |
All |
DBA-22732 |
[Editor results]Request for support for the option to save the result in Excel binary format, extension xlsb |
All |
DBA-4638 |
Wrong database device size is displayed in Explorer window |
Sybase ASE |