gilta03

Tech Tip: Sybase driver error- Column does not allow nulls

Discussion created by gilta03 Champion on Dec 13, 2017

This document can also be viewed at https://support.ca.com/us/knowledge-base-articles.TEC1891533.html 

To see more documents like this, check out our TDM knowledge base here CA Test Data Manager 

Issue:

When registering a table from a data source, we receive the following error from the ASE ODBC Driver: 
Attempt to insert NULL value into column 'PKNAME', table '#ofkey_res'; column does not allow nulls. Update fails. 

 

sybase ase driver error.png

 

 

The difference between our Source Profile and Target Profile is that in Data Source, the user is a read only user because it is a production environment. On Data Target, the user can can read and write to database. 

Environment:
CA Test Data Manager (TDM)- Datamaker & Sybase ASE
Cause:
Resolution:

When registering a table, we also query FK relationships. As part of that process, the Sybase ASE ODBC Driver needs to create temporary tables, like #ofkey_res. However, if the user does not have write access, then this will fail. This is nothing Datamaker has control over since the Sybase ASE driver is responsible for this. 

If you only have write access for the user in one profile, like the target, we suggest registering the table from the target, rather than the source. 

Additional Information:

If you experience any further issues, we highly recommend working with your internal DBA. You can also open a support case by going to https://support.ca.com/us.html

Outcomes