Test Data Manager

 View Only

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

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

    Posted Dec 13, 2017 10:00 AM

    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