On 27/02/06, Kalamegam, Poongundran (Poongs), ALABS <[EMAIL PROTECTED]> wrote:
> Thanks Sebb.
>
> The session-id is a unique string (max length of 64 bytes)
> It's a mix of alpha numberic characters and can have - in it.
>
> To give an example, this is one of the insert statements that is sent.
>
> insert
> into
> wevscust.jcp001_host_activity_data
> (
> call_id,called_ph_num,service_id,end_time,host_latency,host_response,hos
> t_access_error_code,error_result,host_sequence
> )
> values
> (
> ${call_id},c,${__Random(0,60,rnd_1)},(sysdate+(${__Random(0,60,rnd_sec)}
> /10000)),2,1,0,,16
> )
>
> And ${call_id} I used was
> ${__threadNum()}-${__Random(100000,99999,myR)}.
>
> This was throwing the unique constraint errors.Why? What numbers were duplicated? All numbers, or just some? Any pattern to the duplication? Did you try adding a number to distinguish the thread groups? > Any help to create a unique session-id would be greatly appreciated. > Is there a way, we can generate a random value out of a given strings of > characters?? Create a file of random session ids and use CSV Data Set to read them. If you are running 4 independent thread groups you may need to create 4 disjoint random files, or add a distinct suffix or prefix. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
