Cannot insert the value NULL into column "ColumnName", Column does not allow nulls - Designer

Hi David,

Do you get the same error when you execute the smartobject from the smartobject tester tool?

What version of K2 are you using?

It seems you're using the smartbox service, can you access the K2 DB and generate a scrip of the table BroadbandDevice then attach it here?

I did run it through the SMO Services tester tool, and I had the same issue.

The version of K2 is actually very outdated, 4.6.11 to be exact. We are in the process of upgrading it to 4.7 but it won't happen until either end of this week or next week.

The insert script is as follows: 

INSERT INTO [K2Dev].[dbo].[BroadbandDevice]
           ([IMEI]
           ,[Number]
           ,[User]
           ,[SIM]
           ,[personally_paid]
           ,[previous_user]
           ,[order_number]
           ,[date_activated]
           ,[date_assigned]
           ,[HW_billed_to]
           ,[Notes]
           ,[part_number]
           ,[Serial_Number]
           ,[inactive]
           ,[replaces])
     VALUES
           (<IMEI, nvarchar(100),>
           ,<Number, nvarchar(100),>
           ,<User, nvarchar(100),>
           ,<SIM, nvarchar(100),>
           ,<personally_paid, nvarchar(100),>
           ,<previous_user, nvarchar(100),>
           ,<order_number, nvarchar(100),>
           ,<date_activated, date,>
           ,<date_assigned, date,>
           ,<HW_billed_to, nvarchar(100),>
           ,<Notes, nvarchar(max),>
           ,<part_number, nvarchar(100),>
           ,<Serial_Number, nvarchar(100),>
           ,<inactive, nvarchar(100),>
           ,<replaces, nvarchar(100),>)
GO

in the SQL tablle itself I do see the option of whether to allow null or not, but it will not let me save it.

I'm not sure if it would have cause other issues if it did save, but that would allow it to have a null value.

I think in this case you would need to use a stored procedure to insert the record, as K2 only sees the not null field and makes it required to be passed in.