Sybase driver error- Column does not allow nulls

Document ID : KB000008882
Last Modified Date : 14/02/2018
Show Technical Document Details
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:

These knowledge documents outline the cause of this error (you will need to login to your Sybase SAP account to view them):

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