Sybase driver error- Column does not allow nulls
Article ID: 8882
Updated On:
Products
Issue/Introduction
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.
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 read and write to the database.
Environment
Cause
Write permissions are required to create temporary tables.
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
These knowledge documents outline the cause of this error (you will need to login to your Sybase SAP account to view them):
Attachments
Feedback
