TDM Porta 4.9 - Error TransientDataAccessResourceException on sybase table
Article ID: 247846
Updated On:
Products
Issue/Introduction
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.
Environment
Release : TDM Portal 4.9.211.0
SYBASE Adaptive Server Enterprise/16.0 SP03 PL11
Component : TDM Portal Data Generation
Cause
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 |
Resolution
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.
Additional Information
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
Feedback
