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.
18.8 Fixed Issues
| Issue # |
Description |
DBMS
|
| DBA-34801 |
Resolves an issue preventing the Login tab from showing the correct value for Password Expire. |
Sybase ASE
|
| DBA-34831 |
Resolves an issue causing DBArtisan to crash after unregistering an Azure SQL DataSource and refreshing. |
SQL Azure
|
| DBA-34877 |
Resolves an issue causing DBArtisan to crash when clicking Refresh after unregistering a DataSource. |
|
| DBA-34930 |
Resolves an issue preventing Varchar(max) from displaying more than 8kb of data. |
SQL Server
|
| SC-14845 |
[Change Manager] Resolves an issue preventing PDF exports. |
|
| SC-14858 |
[Change Manager] Resolves an issue caused when attempting to generate a Configuration Archive report. |
|
| SC-14861 |
[Change Manager] Allows users to use Schema Compare on a Sybase table with defaults. |
Sybase ASE
|
Known Issues
| Issue # |
Description |
DBMS
|
| DBA-34729 |
Role permissions are not saved when a second role is created. |
DB2 for LUW
|
| DBA-34304 |
Inherited Partitions on Index are not showing while creating index from table in Data Compression tab. |
SQL Server
|
| DBA-34302 |
Selection issues in schema migration. |
|
| DBA-34298 |
Schema migration does not work for a few cases. |
|
| DBA-34296 |
Incorrect alter query generating in the cases of extended alter for In-memory and temporal tables. |
SQL Server
|
| DBA-34294 |
Remote Debugger Support. |
SQL Server
|
| DBA-34271 |
Filestream creation is not available in DBArtisan. |
SQL Server
|
| DBA-34270 |
Schema migration doesn't work if object not selected explicitly. |
|
| DBA-34223 |
[SQL Azure] Unable to create In-memory Tables in Azure. |
SQL Azure
|
| DBA-34222 |
[SQL Azure] Data Masking property is not showing in table columns in Azure. |
SQL Azure
|
| DBA-34221 |
[SQL Azure] Temporal properties tab is not showing while creating tables. |
SQL Azure
|
| DBA-34220 |
[SQL Azure] Unable to create Spatial Index in Azure. |
SQL Azure
|
| DBA-34219 |
[SQL Azure] Unable to create Secondary XML index in Azure. |
SQL Azure
|
| DBA-34218 |
[SQL Azure] Unable to create Primary XML index in Azure. |
SQL Azure
|
| DBA-34216 |
[SQL Azure] Columnstore index is not available in index types in Azure to create. |
SQL Azure
|
| DBA-34215 |
[SQL Azure] Data compression tab in Index is disabled in Azure. |
SQL Azure
|
| DBA-34214 |
[SQL Azure] Data compression tab for table is disabled in Azure. |
SQL Azure
|
| DBA-34197 |
Extract is different for Snapshot Database in DBArtisan and SSMS. |
SQL Server
|
| DBA-34184 |
[Postgres] unable to perform extract operation on roles. |
PostgreSQL
|
| DBA-34157 |
"Table columns" button is not present in create index wizard in postgres". |
PostgreSQL
|
| DBA-34149 |
Refresh issue in object population for indexes. |
|
| DBA-34141 |
"Showing exclusion constraint as exclusion key " in combo box on top when opened exclusion constraint in Postgres. |
PostgreSQL
|
| DBA-34140 |
[postgres]Schema Publication - com.embarcadero.dboject.generic.framework.indexcolumnlmpl Error. |
PostgreSQL
|
| DBA-34138 |
[postgres]Schema Publication - concurrentmodificationexception Error. |
PostgreSQL
|
| DBA-34136 |
[postgres]Schema publication - Null Point Exception error. |
PostgreSQL
|
| DBA-34135 |
[primary key] Does primary key editor should contain index name under attributes or not? |
PostgreSQL
|
| DBA-34133 |
[views]Revoke cascading option is not available in permissions tab->revoke drop down. |
PostgreSQL
|
| DBA-34055 |
With NOCHECK' property for constraints while creating new table. |
SQL Server
|
| DBA-34013 |
Full.At shutdown for Durability is not applicable for TEMP db-Sybase. |
Sybase
|
Additional 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 then 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, results in invalidating procedures A2 and A3.
- In some situations, the Database Monitor may prompt to connect to an already-connected datasource if auto-connect is not enabled for that datasource.
- 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. A workaround is:
- 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, you cannot undock the Debugger windows (Variables, Watch, CallStack, Dependency). This behavior is deliberate and is true only for the Debugger windows. You can undock the Output window.
- 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>"
- 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.
See Also