Datamaker: Unable to rollback procedure on datapool error using Sybase ASE

Document ID : KB000009247
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Using Datamaker to publish a subset on Sybase ASE, a test was performed.  It encountered an error regarding foreign keys. 

If there is an error when publishing the data, the standard internal procedure is to perform a rollback.  When evaluating the resulting rollback command, the delete command is malformed.  

Datamaker wrong command line: 
DELETE FROM dbo.TbPessoaSobAnalise WHERE [CdPessoaSobAnalise] = '242060179' 

ASE Valid command Line: 
DELETE FROM dbo.TbPessoaSobAnalise WHERE [CdPessoaSobAnalise] = 242060179 

It is putting single quotation marks on the field, but it is a numeric field which does not require single quotes.  Why?

Environment:
Driver Version here is 15.7.0.1360, and ODBC Version is 03.51.
Cause:

This is not a TDM Error.  Development discovered this while reviewing a Sybase ASE rollback command in TDM.  TDM simply tells the driver to rollback and does not generate the command; the driver does.  Development then checked the Sybase ASE forums, and they discovered that there is a known rollback issue with the driver. 

Our recommendation is to get the latest driver based on the Client Site's procedures for replacing drivers.

Resolution:

Development found on the Sybase ASE forums that this is a known rollback driver issue.  The recommendation is to get the latest version of the driver.  This is completely controlled by the Client's DBAs to maintain stability of their system.  It is the DBA's responsibility to review their driver version and get a stable version for their system based on their internal procedures.  CA cannot recommend a specific version due to the stability concern.