+7Attempting to set an alternate key on a custom field and receiving the following error:
COMPILE_ERROR2: Error during compilation of LU.
Error details: -12801 in \CUSTOM LU
CODE\BILLING_CUSTOMER_JOBS_CLT.CRE\ALTERNATE_KEY
Has anyone come across this and come to any solution?
+11The column which you are setting as the alternate key, has that already got an index defined? If so, remove the index and repeat the process of setting the alternate key.
+7None of the columns are indexed, this is what has me stumped.
+11Have you got conflicting data i.e. duplicate records against the alternate key column. If so, you will need to clean up the data first as well before setting the alternate key.
There is a similar thread “Custom Form Primary Key” that highlights a similar if not the same issue.
+7I will look into this, thank you for responding! This has given me hope!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.