Use of random() macro without a length argument profiles indefinitely

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

Solution: You should 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 profile a derived field using random() without a length argument, you can cancel the profile to continue working.