Use of random macro without a length argument profiles indefinitely

Problem or error: If you use the Unica macro function random() without a length argument, Campaign generates as many random values as needed, but profiling this derived field never completes, because Campaign does not stop generating random values.

Solution: Unica recommends that you call the random() function with an appropriate argument specifying the number of random values to generate. If you want one random value per ID in a call, you can call random(count(AudienceID)). If you do profile a derived field using random() without a length argument, you can cancel the profile to continue working.