Problem or error: If you use the IBM ® 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: IBM® 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 profile a derived field using random() without a length argument, you can cancel the profile to continue working.