When attempting to publish synthetic data in a table, running on SYBASE ASE version 16.; we are only able to publish the data using Datamaker. When we try to use the Generator in TDM Portal, we received the following error:
Error "TransientDataAccessResourceException" about "JZ0TE: Attempted conversion between an illegal pair of types.".
If I run this from Datamaker it runs as expected, and publishes the generated data. It only fails from TDM Portal.
Release : TDM Portal 4.9.211.0
SYBASE Adaptive Server Enterprise/16.0 SP03 PL11
Component : TDM Portal Data Generation
The TDM 4.9 documentation shows that we only support Data Generation from GT Datamaker, and not from TDM Portal, when working with Sybase ASE.
See https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/installing/supported-data-sources.html
Supported Data Sources in TDM v4.9 | |||||||||||
Database | Dynamic Test Data Reservation | Data Generation | Data Masking | Data Subsetting | Test Match | vTDM | Data Modeling & PII Audit | Distributed with Driver | |||
TDM Portal | TDM Portal | Datamaker | TDM Portal | FDM | Datamaker | ||||||
Sybase-IQ 16.0 | Not Supported | Certified | Certified | Not Supported | Certified | Not Supported | Not Supported | Not Supported | Not Supported | Not Supported | Yes |
Sybase ASE (SAP ASE) | Not Supported | Not Supported | Supported | Not Supported | Supported | Not Supported | Supported | Not Supported | Not Supported | Not Supported | No |
However, for TDM 4.10 we have added additional database support, which includes Data Generation from TDM Portal for Sybase ASE 16.0.
Supported Data Sources in TDM v4.10 | |||||||||||
Database | Dynamic Test Data Reservation | Data Generation | Data Masking | Data Subsetting | Test Match | vTDM | Data Modeling & PII Audit | Distributed with Driver | |||
TDM Portal | TDM Portal | Datamaker | TDM Portal | FDM | Datamaker | ||||||
Sybase-IQ 16.0 | Not Supported | Certified | Certified | Certified | Not Supported | Certified | Not Supported | Not Supported | Not Supported | Not Supported | Yes |
Sybase ASE (SAP ASE) 15.7 | Not Supported | Not Supported | Supported | Not Supported | Supported | Not Supported | Supported | Not Supported | Not Supported | Not Supported | No |
Sybase ASE (SAP ASE) 16.0 | Supported | Supported | Supported | Supported | Supported | Not Supported | Supported | Not Supported | Not Supported | Supported | No |
Therefore, upgrading to TDM 4.10 would provide you with the ability to generate synthetic data from the TDM Portal.
Things to consider when upgrading TDM - https://knowledge.broadcom.com/external/article?articleId=193849
Who to engage to help with TDM Product upgrades? - https://knowledge.broadcom.com/external/article?articleId=205368
Test Data Manager Upgrade Review - https://knowledge.broadcom.com/external/article?articleId=239718