"Restricted data type attribute violation" on Gen 8.6 CREATE

Products

• Gen
• Gen - Host Encyclopedia
• Gen - Run Time Distributed
• Gen - Workstation Toolset

Issue/Introduction

With Gen 8.6 Windows/SQL Server client/server application, receive error "Restricted data type attribute violation" executing CREATE statement.
The entered table field values seem to be OK and there is no conflict between the model's data structure list and the table fields in the database schema.

Resolution

The problem occurred when using both SQL Native Client 11 and Microsoft ODBC drivers.
After installing the latest SQL Server ODBC Client driver (version 2022) the problem was resolved.

Additional Information

To try to find more information about specific fields in the table that could be causing the problem execute the SQL code within "Microsoft SQL Server Management Studio" which has a GUI interface and may give more useful error information.