Troubleshooting: Failed to create UDF

From AutoCount Resource Center

Question : When I try to create a new UDF, system prompts error message during save – “Unknown Sql Exception (Number=1505, Message=The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.DODTL' and the index name 'UK__DODTL__UDF_TICKET'. The duplicate key value is (<NULL>).” Why?

Version : 1.8 / 1.9 / 2.0

Possible Reason :

You’re trying to create an UDF with Unique behaviour. If you’ve more than 1 record for the entity that you are trying to create the UDF with, it will always prompt this error. The reason is because if this column is added as unique into the table, by default the column will be filled with NULL value, which violates the Unique behaviour and thus prompting you the error.

Solution :

1) Create your UDF without Unique behaviour first.

2) Edit the previous Delivery Order and key in the value in the new UDF column and click on Save.

3) Edit the UDF and enable the Unique behaviour, click on OK and Save.

By : Jae Sen 180814, Lay Swan 180823, P180823

Go to menu

AutoCount Accounting 2.0 & 2.1

AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS

AutoCount On The Go
AutoCount Accounting Plug-In Documentations