Microsoft SQL Server Release Notes

Release notes are displayed in descending order from the most recent release to the oldest. Known Issues are listed with the most recent release.

See TIBCO Scribe® Online Connector For Microsoft SQL Server for more information.

Note: To access any changes to metadata support, such as new operations, entities, or fields, reset metadata for the Connection. See Resetting Metadata.

Version 1.3.0

Released April 10, 2018.

New And Noteworthy

There are no new features in this release.

Closed Issues

SCMSSQL-62163

When running a Solution where Microsoft SQL Server is the source, records returned from SQL by the Query are sorted by the Net Change date and the Most Recent Record Processed date is set to the date of the last record used in a target operation.

SCMSSQL-62432

Added support for the ApplicationIntent=ReadWrite connection property in the Additional Parameters field on the Connection dialog.

SCMSSQL-62575

If you change the case on a field name or table column in your source data after replicating data to Microsoft SQL Server, subsequent replications ignore the case change and continue to replicate data to the correct table and column in Microsoft SQL Server.

Note: The correction to support changing the case on a field name or table column is not supported if you are replicating to Microsoft Azure SQL and the database collation is set to case sensitive.

Known Issues

SCMSSQL-55

Summary: When using TIBCO Scribe On-premise agent released on '7 Apr 2022', the following error is returned:

Could not load file or assembly 'Microsoft.SqlServer.Types, Version=10.0.0.0

Workaround: None

SCMSSQL-42

Summary: When using Microsoft SQL Server as a target datastore for a Replication Solution, if the source data contains a Date datatype, that type is converted to a DateTime datatype. If the date value in the source data is earlier than 1/1/1753, such as 0001-01-01, the solution stops with a fatal error similar to the following:

The following error has occurred in the SQL Connector: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

Workaround: Manually modify the datatype to Date in the target Microsoft SQL Server database. Then, use an Integration Solution to create the records in the SQL database. Using a Replication Solution after modifying the datatype will not solve the issue because Replication Solutions reset the datatype each time they execute.

SCMSSQL-33

Summary: When running a Replication Solution that replicates a very large entity, such as an Audit table, the Net Change process may time out when determining which records are new or updated. Errors similar to the following are generated:

Error Message: Object Reference not set to instance of an object.
Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Workaround: Work with your database administrator to create an index on the table you are attempting to replicate in the Microsoft SQL server database.

SCMSSQL-26

Summary: If you create a table in your Microsoft SQL Server server database that contains a period in the name, TIBCO Scribe® Online interprets the information before the period as the schema. For example, a table named DB.TEST is treated as schema name DB, table name TEST. This generates errors similar to the following: Entity ‘DB.TEST’ was not found. The metadata for this connection may have changed.

Workaround: Rename the table and exclude periods from the name.

SCMSSQL-19

Summary: If your Microsoft SQL Server database has multiple schemas and one or more schemas have tables with periods (.) in the name, TIBCO Scribe® Online may interpret the tables as duplicates. For example, [dbo].[DEL.CRM.US_PRODUCT] and [dbo].[DEL.CRM_US_PRODUCT] are interpreted as the same table name. This generates errors similar to the following when attempting to retrieve metadata:

An item with the same key cannot be added

Workaround: Rename the schema or table, or try the following:

Abstract the tables via a SQL view.
Create a user that has access only to those views.
Setup a Microsoft SQL Server connection in TIBCO Scribe® Online using that user.

SCMSSQL-15

Summary: If the size of a source field is larger than the size of the target field in your Microsoft SQL Server database, a truncation error similar to the following is generated, but the field name is not included:

String or binary data would be truncated.

Workaround: Refer to the following Knowledge Base article: Replication Services Error: Failed to insert record

SCMSSQL-14

Summary: The Connector cannot add new columns to a Replication Solution target database if the Microsoft SQL Server database access is set to Windows authentication with the fully qualified domain format “Username@domain.com”.

Workaround: Use Windows authentication with the FQDN format domain\Username or SQL authentication.

SCMSSQL-11

Summary: The version of Microsoft .Net Framework used with this Connector does not support querying decimal values with a large number of values to the right of the decimal point, such as 20 places to the right of the decimal, and generates Conversion Overflow errors.

Workaround: Use a Native Query and the CAST () function to convert the field to a lower decimal type or convert it to char ().

SCMSSQL-3

Summary: If Agent Debug logging is enabled, stored procedures executed by the Connector return the following error:

“The given key was not present in the dictionary.”

Workaround: Do not enable debug on the Agent.

Version 1.2.0

Released November 30, 2017.

New And Noteworthy

Added support for Batch Processing for the following operations:
- Create (45679)
- Delete (46763)
Added support for SQL tables with names that start with numbers. (45682)
Validated support for Microsoft SQL Server 2017: Enterprise, Standard, and Express. (48409)

Closed Issues

SCMSSQL-15512

When a Replication Solution is running, if the target table is missing a required primary key constraint, the table is recreated before the associated records are replicated.

SCMSSQL-32222 / SCMSSQL-48928

When the server time on the source datastore and the server time on the Agent server differed, some records were not Updated or Deleted during the execution of a Replication Solution.

SCMSSQL-36974 / SCMSSQL-38071

Using the Create Block with Microsoft SQL Server sometimes returns more than one success message per record, which was generating an Error Number: 0 error.

SCMSSQL-43462

When using Windows Authentication via a group to access Microsoft SQL Server, the default schema could not be accessed preventing the Connector from retrieving metadata.

SCMSSQL-44134 / SCMSSQL-46610

Improved retry logic when the Connector receives an inbound message to be processed by a Request/Reply Map to solve intermittent exceptions similar to the following:

The connection is broken and recovery is not possible. The connection is marked by the client driver as unrecoverable. No attempt was made to restore the connection.

SCMSSQL-44479

Using the Query Block to access a Microsoft SQL Server database was locking third-party systems out of that database until the TIBCO Scribe® Online Agent was stopped.

SCMSSQL-48970 / SCMSSQL-49125

Replication Solutions were attempting to alter the decimal precision on float data types resulting in reduced performance for large datasets.

SCMSSQL-52181

When using Microsoft SQL Server as a target datastore for Replication Solutions, the most recent date in the SCRIBE_MODIFIEDON target field for each table was used as a filter to query the corresponding source entity for new, changed, and deleted.This resulted in some deleted records being reprocessed in cases where the date in the SCRIBE_DELETEDON target field was newer than the most recent date in the SCRIBE_MODIFIEDON target field.

SCMSSQL-52387

The TargetTimeout setting on the Connection configuration dialog used the default value of 30 seconds regardless of the actual setting.

Fall 2015 Release

New And Noteworthy

The Microsoft SQL Server Connector was installed automatically with any Agent installation. In this release, the Microsoft SQL Server Connector has been moved to the TIBCO Scribe® Online Marketplace.

This Connector has been enhanced to support the TIBCO Scribe® Online Cloud Service regardless of the location of the Microsoft SQL Server database including Microsoft Azure. The database can be on premise or in the cloud.

Closed Issues

There are no closed issues in this release.

August 2015 Release

New And Noteworthy

Added support for TargetTimeout and QueryTimeout parameters in the Additional Parameters field on the Connection dialog for the TIBCO Scribe® Online Connector for Microsoft SQL Server. Use these parameters to modify the default timeout settings for target and source operations when processing Microsoft SQL Server records.

Closed Issues

There are no closed issues in this release.

May 2015 Release

New And Noteworthy

There are no new features in this release.

Closed Issues

SCMSSQL-9658

A Timeout Expired error was generated when trying to delete a large number of records in Execution History.

Winter 2015 Release

New And Noteworthy

There are no new features in this release.

Closed Issues

Improved SQL Azure Support in Replication Services (RS) to generate a Fatal Error and stop running if there are any record errors. TIBCO Scribe® Online sometimes failed with timeout errors that resulted in missing records in the target database. RS updated the last modified time based on newer records that were processed correctly, and the missing records were not replicated in a future run.

SCMSSQL-9093

Integration Solutions that contained maps where the source was Microsoft SQL Server and the maps were created using older metadata sometimes generated an invalid field name nativequery.bounddate error when you attempted to save them.

SCMSSQL-9338

Replication Services (RS) Solutions using Microsoft SQL Server as the target were not replicating some entities.

October 2014 Release

New And Noteworthy

Enhanced the SQL connection dialog to include Additional Parameters and Object Filter fields. Additional Parameters is an optional field used to specify one or more connection parameters that enable or disable the use of Stored Procedures, Tables, or Views. Additional connection parameters defined on the MSDN reference site can also be used. Object Filter is used to select or limit the stored procedures, tables and/or views returned in metadata when you connect to your SQL database.
Added support for complex data types, such as geometry, geography, and user-defined types.
Validated support for Microsoft SQL Server 2014: Enterprise, Standard and Express.

Closed Issues

SCMSSQL-8187

After a bulk process was performed on an entity and the changes were confirmed, subsequent runs of the Solution caused those entities to be reprocessed, even if no changes were made to those entities between the two runs.

SCMSSQL-9098

Replicating to a SQL database when the SQL connection was configured for Windows Authentication and the source datastore had schema changes caused errors. In addition, if tables were manually deleted from the target database, they were not recreated during subsequent replication jobs.

July 2014 Release

New And Noteworthy

There are no new features in this release.

Closed Issues

SCMSSQL-8944

The Microsoft SQL Server connector was fixed to release connections that it is no longer using. This should end most execution failures caused by all connections in the connection pool being in use.

August 2013 Release

New And Noteworthy

There are no new features in this release.

Closed Issues

SCMSSQL-7136

Errors were generated when adding additional fields to Lead Entity

SCMSSQL-7753

Replication Solution SQL Azure - A transport-level error occurred when receiving results from the server

June 2013 Release

New And Noteworthy

New Native Query Block – When using a native Microsoft SQL Server connection as your source in an Integration Solution Map, the Native Query Block allows you to write your own query, rather than using the structure provided by the regular Query block. For more information, see Native Query Block.

Note: For existing Microsoft SQL Server connections, the Native Query Block will not display until you refresh the connection as described in Editing Connections.

Support for Stored Procedures with Microsoft SQL Server (Beta) — For Microsoft SQL Server connections, an Execute block (similar to a Create block) is available to allow you to execute simple stored procedures within Integration Solution Maps.

Closed Issues

There are no closed issues in this release.

April 2013 Release

New And Noteworthy

There are no new features in this release.

Closed Issues

SCMSSQL-6990

Replicating CRM 2011 to SQL Azure resulted in a fatal error that it was losing connection to SQL Azure. The error was: (Case#49941)

“Fatal Exception: System.Data.SqlClient.SqlException 
(0x80131904): A transport-level error has occurred”

July 2012 Release

New And Noteworthy

There are no new features in this release.

Closed Issues

SCMSSQL-6374

Unable to see Entities using Oracle ODBC Connection – This issue manifested itself across SQL, ODBC, and OLEDB connectors in cases where two entities were reported with the same name but different cases, and a third entity, even, may exist with the same name and a numeric suffix (e.g., account, Account, Account2). This has been fixed such that we will be able to list these entities in the field lists without stack errors. (Case # 47001)

May 2012 Release

New And Noteworthy

TIBCO Scribe® Online now officially supports Microsoft SQL Server 2012 (Enterprise, Standard, and Express editions)

Closed Issues

There are no closed issues in this release.

March 2012 Release

New And Noteworthy

There are no new features in this release.

Closed Issues

SCMSSQL- 6070 / SCMSSQL-6080 / SCMSSQL-6083

Text and Microsoft SQL Server Connectors now support entity and field names with spaces and special characters — For Text and Microsoft SQL Server Connectors, you can now map field and entity names that contain spaces and most special characters, with some caveats:

Field or entity names that contain special characters will display in TIBCO Scribe® Online as follows:
- Any space or special character is dropped from the name.
- If the resulting name duplicates another existing entity name, each duplicate will be numbered (for example, field1, field2… For 10 or more duplicates, the fields will be numbered field01, field02… and so on).
To use these fields or entities in maps (including in formulas), use the adjusted names as they appear in TIBCO Scribe® Online. The original names will still display in the Map page Property pane and in any runtime errors that reference these objects.
Periods (.) and double quotes (“) are currently not supported in entities and field names. This is a known issue that is under investigation.

February 2012 Release

New And Noteworthy

There are no new features in this release.

Closed Issues

Refreshing metadata against Connections for a Microsoft SQL Server data source with many entities took several minutes. With this release, this operation should complete in several seconds.

May 2011 Release

New And Noteworthy

TIBCO Scribe® Online now supports a wider number of Microsoft SQL Server versions including Microsoft SQL Server Express and SQL Azure.

Closed Issues

There are no closed issues in this release.

April 2011 Release

New And Noteworthy

Users can now connect to the Microsoft SQL Server replication database via Windows Authentication or SQL Authentication. Earlier versions of TIBCO Scribe® Online only supported SQL Authentication.

TIBCO Scribe® Online now supports custom Microsoft SQL Server data types. Columns that are defined with custom data types in a Microsoft SQL Server table will no longer appear as fields with a datatype of "Unsupported". Instead, these fields now display as having a data type of "Object." You can now link to or from fields with custom data types, although you may need to convert the data using a data conversion function such as TOSTRING.

Closed Issues

Updated Agents received an error that an index array was out of bounds when attempting to establish a connection to Microsoft SQL Azure. Newly installed Agents worked correctly. Microsoft recently released updated versions of their code libraries which are used by the Agent. However, the latest versions of those code libraries were not installed as part of the Agent update process. With this new Agent release, all Agents will have the latest Microsoft libraries and are able to connect to Microsoft SQL Azure. .

January 2011 Release

New And Noteworthy

If you build a Map in TIBCO Scribe® Online and select Microsoft SQL Serveras your source connection, you can now select database views as source entities (in addition to tables). Note that database views will display in the list of target entities, but cannot be selected.

Closed Issues

There are no closed Issues in this release.