Troubleshooting: Failed to create UDF

From AutoCount Resource Center
Revision as of 01:57, 29 August 2018 by LaySwan (talk | contribs) (Created page with "'''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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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?

Udf fail1.jpg


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.

Udf fail2.jpg

Udf fail3.jpg


Solution :

1) Create your UDF without Unique behaviour first.

Udf fail4.jpg


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

Udf fail5.jpg


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

Udf fail2.jpg


By : Jae Sen 180814, Lay Swan 180823, P180823



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations