We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

resetting Study subject ID

Dear all,
I have come upon the strangest thing. I have just built a new study in the
newly installed OpenClinica 3.0, and the first study subject id that was
generated automatically was 457.
Has anyone encountered such a problem?
How can I reset it to start at 1, or 100?
Thanks,
Miriam

Comments

  • haenselhaensel Posts: 602 ✭✭✭
    Hi Miriam
    The auto generated subject ids are based on the entries in the database. If you want to install a fresh instance of OpenClinica it is necessary to use a new database and not to reuse an instance from another study (this is the only reasonable explanation for this behavior). The subject ids should start with 1 if you create a new database and change the responding settings in datainfo.properties.
    Hope this helps.
    Regards,
    Christian
    Am 31.3.2011 20:10, schrieb Miriam Ivenshitz:
    > Dear all,
    > I have come upon the strangest thing. I have just built a new study in the
    > newly installed OpenClinica 3.0, and the first study subject id that was
    > generated automatically was 457.
    > Has anyone encountered such a problem?
    > How can I reset it to start at 1, or 100?
    > Thanks,
    > Miriam
    >
  • JanusJanus Posts: 260
    This fact leads to a "warning": The subject IDs has to be unique across all
    trials within your OpenClinica installation. Therefore you should take a
    moment and think about how you want to distinguish your subjects from each
    other. Personally, I use a prefix which associates to which study the
    subjects belong, e.g. LTS001, LTS002 for the Liver Transplant Study and
    HS001, HS002 for the Headache Study.
    The absolute best solution is to make OpenClinica only require uniqueness
    of Subject ID within each study. Alternatively, have a built-in option the
    automatically prefix the subject IDs.
    Best regards,
    Janus

    Christian Hänsel
    To
    Sent by: [email protected]
    [email protected] cc
    nclinica.com
    Subject
    Re: [Users] resetting Study subject
    01-04-2011 08:34 ID


    Please respond to
    [email protected]
    .com


    Hi Miriam
    The auto generated subject ids are based on the entries in the database.
    If you want to install a fresh instance of OpenClinica it is necessary
    to use a new database and not to reuse an instance from another study
    (this is the only reasonable explanation for this behavior). The subject
    ids should start with 1 if you create a new database and change the
    responding settings in datainfo.properties.
    Hope this helps.
    Regards,
    Christian
    Am 31.3.2011 20:10, schrieb Miriam Ivenshitz:
    > > Dear all,
    > > I have come upon the strangest thing. I have just built a new study in
    the
    > > newly installed OpenClinica 3.0, and the first study subject id that was
    > > generated automatically was 457.
    > > Has anyone encountered such a problem?
    > > How can I reset it to start at 1, or 100?
    > > Thanks,
    > > Miriam
    > >
  • haenselhaensel Posts: 602 ✭✭✭
    Hi Janus
    The auto generated ids are unique across a single OC installation. Since you use only one database per OC installation and the ids are unique within the database.
    Regards,
    Christian
    Am 1.4.2011 10:26, schrieb [email protected]:
    > This fact leads to a "warning": The subject IDs has to be unique across all
    > trials within your OpenClinica installation.
    --
    ------------------------------------------------------------------------
    Dipl.-Inf. Christian Hänsel
    IT / Software Developer
    Tel.: +49-(0)89-5526189-16
    Fax : +49-(0)89-5526189-55
    E-Mail: [email protected]
    ReliaTec GmbH
    Schleissheimer Str. 37
    85748 Garching Germany
    HRB 150060 / AG München
    Gf Thomas Herbig
    http://www.reliatec.de
    =========================================================================
  • miklamikla Posts: 20
    Hello,Miriam.
    I'm not totally sure that it works, but theoretically you may change the value of study_subject_study_subject_id_seq sequence.
    Be sure that you don't have any study subject IDs that bigger than new study_subject_study_subject_id_seq value to prevent data collision
    On Fri, Apr 1, 2011 at 2:21 PM, Christian Hänsel wrote:
    Hi Janus
    The auto generated ids are unique across a single OC installation. Since you use only one database per OC installation and the ids are unique within the database.
    Regards,
    Christian
    Am 1.4.2011 10:26, schrieb [email protected]:
    This fact leads to a "warning": The subject IDs has to be unique across all
    trials within your OpenClinica installation.
    --
    ------------------------------------------------------------------------
    Dipl.-Inf. Christian Hänsel
    IT / Software Developer
    Tel.: +49-(0)89-5526189-16
    Fax : +49-(0)89-5526189-55
    E-Mail: [email protected]
    ReliaTec GmbH
    Schleissheimer Str. 37
    85748 Garching Germany
    HRB 150060 / AG München
    Gf Thomas Herbig
    http://www.reliatec.de
    =========================================================================
  • jmedaliejmedalie Posts: 32
    Hi Miriam,

    How odd that the first study you created in a clean installation was 457. You can change the sequence study_subject_study_subject_id_seq. If this is really the first study, then you won't have any issues resetting the sequence to 1:
    ALTER SEQUENCE "public"."study_subject_study_subject_id_seq"
    RESTART 1;
    Additionally, you can change the Study Subject ID manually in a subject's record, if you set your Study Paramater Configuration settings for the study to "Manual Entry" or "Auto-generated and Editable". If you do this, you can enter any value you want (including words), as long as it has not already been used in the study.

    -Julie

    Julie Medalie
    CTRIC
    University of Maryland, DEPH
    10 South Pine Street MSTF 257
    Baltimore MD 21201
    410-706-2060
    >>> Miriam Ivenshitz 3/31/2011 2:10 PM >>>
    Dear all,
    I have come upon the strangest thing. I have just built a new study in the
    newly installed OpenClinica 3.0, and the first study subject id that was
    generated automatically was 457.
    Has anyone encountered such a problem?
    How can I reset it to start at 1, or 100?
    Thanks,
    Miriam
  • JanusJanus Posts: 260
    That is true, but I can think of a few reasons not to use several OC
    installations and databases for hosting several studies:
    *) Computer resources (and maintenance, etc)
    *) One site is conducting more than one studie at a time, they may very
    well be interested in keeping their data in one database (ease of change
    between studies)
    There probably are several more good reasons. Never the less, since the
    subjects in OpenClinica already have a unique identifier (OID), the unique
    constraint on the subject table isn't per se vital?
    Best regards,
    Janus

    Christian Hänsel
    To
    Sent by: [email protected]
    [email protected] cc
    nclinica.com
    Subject
    Re: [Users] resetting Study subject
    01-04-2011 13:29 ID


    Please respond to
    [email protected]
    .com


    Hi Janus
    The auto generated ids are unique across a single OC installation. Since
    you use only one database per OC installation and the ids are unique
    within the database.
    Regards,
    Christian
    Am 1.4.2011 10:26, schrieb [email protected]:
    > > This fact leads to a "warning": The subject IDs has to be unique across
    all
    > > trials within your OpenClinica installation.
    --
    ------------------------------------------------------------------------
    Dipl.-Inf. Christian Hänsel
    IT / Software Developer
    Tel.: +49-(0)89-5526189-16
    Fax : +49-(0)89-5526189-55
    E-Mail: [email protected]
    ReliaTec GmbH
    Schleissheimer Str. 37
    85748 Garching Germany
    HRB 150060 / AG München
    Gf Thomas Herbig
    http://www.reliatec.de
    =========================================================================
  • Please do not send any mails to my id..I am not using openclinica..and
    very soon am going to change my e mail address.
    Thank you
    Madhvi Sharma
    On 4/1/11, [email protected] wrote:
    > > That is true, but I can think of a few reasons not to use several OC
    > > installations and databases for hosting several studies:
    > > *) Computer resources (and maintenance, etc)
    > > *) One site is conducting more than one studie at a time, they may very
    > > well be interested in keeping their data in one database (ease of change
    > > between studies)
    > >
    > > There probably are several more good reasons. Never the less, since the
    > > subjects in OpenClinica already have a unique identifier (OID), the unique
    > > constraint on the subject table isn't per se vital?
    > >
    > >
    > > Best regards,
    > > Janus
    > >
    > >
    > >
    > >
    > > Christian Hänsel
    > > > ec.de> To
    > > Sent by: [email protected]
    > > [email protected] cc
    > > nclinica.com
    > > Subject
    > > Re: [Users] resetting Study subject
    > > 01-04-2011 13:29 ID
    > >
    > >
    > > Please respond to
    > > [email protected]
    > > .com
    > >
    > >
    > >
    > >
    > >
    > >
    > > Hi Janus
    > >
    > > The auto generated ids are unique across a single OC installation. Since
    > > you use only one database per OC installation and the ids are unique
    > > within the database.
    > >
    > > Regards,
    > > Christian
    > >
    > > Am 1.4.2011 10:26, schrieb [email protected]:
    >> >> This fact leads to a "warning": The subject IDs has to be unique across
    > > all
    >> >> trials within your OpenClinica installation.
    > >
    > > --
    > > ------------------------------------------------------------------------
    > >
    > > Dipl.-Inf. Christian Hänsel
    > >
    > > IT / Software Developer
    > >
    > > Tel.: +49-(0)89-5526189-16
    > > Fax : +49-(0)89-5526189-55
    > > E-Mail: [email protected]
    > >
    > > ReliaTec GmbH
    > > Schleissheimer Str. 37
    > > 85748 Garching Germany
    > > HRB 150060 / AG München
    > > Gf Thomas Herbig
    > > http://www.reliatec.de
    > >
    > > =========================================================================
    > >
    > >
  • kristiakkristiak Posts: 1,338 ✭✭✭
    I can equally think of many good reasons why you would want to keep each
    protocol or at least project on a separate server. There is no issue with
    licence costs with OC. An HP Proliant Microserver with Windows server 2008
    R2 is ideal and cost no more than 500-600 USD's including operating system.
    If one of them goes down it only affects one study and they are so easy to
    manage. The also consume very little power, in the range of 150W.
    Have a nice week-end
    Krister
    -----Original Message-----
    On Behalf Of [email protected]
    Sent: 01 April 2011 14:22
    To: [email protected]
    Subject: Re: [Users] resetting Study subject ID
    That is true, but I can think of a few reasons not to use several OC
    installations and databases for hosting several studies:
    *) Computer resources (and maintenance, etc)
    *) One site is conducting more than one studie at a time, they may very well
    be interested in keeping their data in one database (ease of change between
    studies)
    There probably are several more good reasons. Never the less, since the
    subjects in OpenClinica already have a unique identifier (OID), the unique
    constraint on the subject table isn't per se vital?
    Best regards,
    Janus

    Christian Hänsel
    To
    Sent by: [email protected]
    [email protected] cc
    nclinica.com
    Subject
    Re: [Users] resetting Study subject
    01-04-2011 13:29 ID


    Please respond to
    [email protected]
    .com


    Hi Janus
    The auto generated ids are unique across a single OC installation. Since you
    use only one database per OC installation and the ids are unique within the
    database.
    Regards,
    Christian
    Am 1.4.2011 10:26, schrieb [email protected]:
    > > This fact leads to a "warning": The subject IDs has to be unique
    > > across
    all
    > > trials within your OpenClinica installation.
    --
    ------------------------------------------------------------------------
    Dipl.-Inf. Christian Hänsel
    IT / Software Developer
    Tel.: +49-(0)89-5526189-16
    Fax : +49-(0)89-5526189-55
    E-Mail: [email protected]
    ReliaTec GmbH
    Schleissheimer Str. 37
    85748 Garching Germany
    HRB 150060 / AG München
    Gf Thomas Herbig
    http://www.reliatec.de
    =========================================================================
  • kristiakkristiak Posts: 1,338 ✭✭✭
    I can equally think of many good reasons why you would want to keep each
    protocol or at least project on a separate server. There is no issue with
    licence costs with OC. An HP Proliant Microserver with Windows server 2008
    R2 is ideal and cost no more than 500-600 USD's including operating system.
    If one of them goes down it only affects one study and they are so easy to
    manage. The also consume very little power, in the range of 150W.
    Have a nice week-end
    Krister
    -----Original Message-----
    On Behalf Of [email protected]
    Sent: 01 April 2011 14:22
    To: [email protected]
    Subject: Re: [Users] resetting Study subject ID
    That is true, but I can think of a few reasons not to use several OC
    installations and databases for hosting several studies:
    *) Computer resources (and maintenance, etc)
    *) One site is conducting more than one studie at a time, they may very well
    be interested in keeping their data in one database (ease of change between
    studies)
    There probably are several more good reasons. Never the less, since the
    subjects in OpenClinica already have a unique identifier (OID), the unique
    constraint on the subject table isn't per se vital?
    Best regards,
    Janus

    Christian Hänsel
    To
    Sent by: [email protected]
    [email protected] cc
    nclinica.com
    Subject
    Re: [Users] resetting Study subject
    01-04-2011 13:29 ID


    Please respond to
    [email protected]
    .com


    Hi Janus
    The auto generated ids are unique across a single OC installation. Since you
    use only one database per OC installation and the ids are unique within the
    database.
    Regards,
    Christian
    Am 1.4.2011 10:26, schrieb [email protected]:
    > > This fact leads to a "warning": The subject IDs has to be unique
    > > across
    all
    > > trials within your OpenClinica installation.
    --
    ------------------------------------------------------------------------
    Dipl.-Inf. Christian Hänsel
    IT / Software Developer
    Tel.: +49-(0)89-5526189-16
    Fax : +49-(0)89-5526189-55
    E-Mail: [email protected]
    ReliaTec GmbH
    Schleissheimer Str. 37
    85748 Garching Germany
    HRB 150060 / AG München
    Gf Thomas Herbig
    http://www.reliatec.de
    =========================================================================
  • kristiakkristiak Posts: 1,338 ✭✭✭
    You have to unsubscribe yourself. Please follow the instructions at the very
    bottom of the mail,
    /Krister
    -----Original Message-----
    On Behalf Of Madhvi Sharma
    Sent: 01 April 2011 17:07
    To: [email protected]
    Subject: Re: [Users] resetting Study subject ID
    Please do not send any mails to my id..I am not using openclinica..and very
    soon am going to change my e mail address.
    Thank you
    Madhvi Sharma
    On 4/1/11, [email protected] wrote:
    > > That is true, but I can think of a few reasons not to use several OC
    > > installations and databases for hosting several studies:
    > > *) Computer resources (and maintenance, etc)
    > > *) One site is conducting more than one studie at a time, they may
    > > very well be interested in keeping their data in one database (ease of
    > > change between studies)
    > >
    > > There probably are several more good reasons. Never the less, since
    > > the subjects in OpenClinica already have a unique identifier (OID),
    > > the unique constraint on the subject table isn't per se vital?
    > >
    > >
    > > Best regards,
    > > Janus
    > >
    > >
    > >
    > >
    > > Christian Hänsel
    > > > ec.de> To
    > > Sent by: [email protected]
    > > [email protected] cc
    > > nclinica.com
    > > Subject
    > > Re: [Users] resetting Study subject
    > > 01-04-2011 13:29 ID
    > >
    > >
    > > Please respond to
    > > [email protected]
    > > .com
    > >
    > >
    > >
    > >
    > >
    > >
    > > Hi Janus
    > >
    > > The auto generated ids are unique across a single OC installation.
    > > Since you use only one database per OC installation and the ids are
    > > unique within the database.
    > >
    > > Regards,
    > > Christian
    > >
    > > Am 1.4.2011 10:26, schrieb [email protected]:
    >> >> This fact leads to a "warning": The subject IDs has to be unique
    >> >> across
    > > all
    >> >> trials within your OpenClinica installation.
    > >
    > > --
    > > ----------------------------------------------------------------------
    > > --
    > >
    > > Dipl.-Inf. Christian Hänsel
    > >
    > > IT / Software Developer
    > >
    > > Tel.: +49-(0)89-5526189-16
    > > Fax : +49-(0)89-5526189-55
    > > E-Mail: [email protected]
    > >
    > > ReliaTec GmbH
    > > Schleissheimer Str. 37
    > > 85748 Garching Germany
    > > HRB 150060 / AG München
    > > Gf Thomas Herbig
    > > http://www.reliatec.de
    > >
    > > ======================================================================
    > > ===
    > >
    > >
This discussion has been closed.