How to overcome PRIMARY KEY constraint SQL exception during Rules Migration as a part of upgrade?
I received the following error during migration phase of rules upgrade. How can I overcome this error?
"com.microsoft.sqlserver.jdbc.SQLServerException: Cannot define PRIMARY KEY constraint on nullable column in table 'pc_index_flowref'."
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Labb Ltd
GB
Looks like pzInskey column in the table defintion is NULL instead of Not NULL.
Manually change all mandatory columns in the generated sql file from NULL to Not NULL.
Areteans Technology
IN
pzInskey is not null and primary key for the table pc_index_flowref. Check how did you create the table in your upgrade process. Did you created the tables manually using sql or the upgrade wizard ?
Thanks,
Ashok