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

OpenClinica Bugs

To whom it may concern;
I downloaded and installed OpenClinica 1.1 on my PC (which runs Windows XP
Professional). I found a couple of bugs in the code, and I have a couple of
questions/enhancement suggestions.
Bug #1: openclinica Database trigger function -- user_account_trigger
Issue: I cannot delete users from the database, due to a syntax error in
the code.
Details/Resoltuion: The INSERT command has some parameters that are missing
the string concatenation character between the space character and
last_name.
INSERT INTO AUDIT_EVENT_VALUES (AUDIT_ID, COLUMN_NAME, OLD_VALUE,
NEW_VALUE)
VALUES
(pk,'Name', null, OLD.first_name || ' ' OLD.last_name);
This occurs in two other locations in this function.
Bug #2: 'Gender' not displaying correctly
Issue: I created a co-ed study, but the patients listed in the 'Subjects'
section of the Administer Studies page (under 'Business Admin') are all
displaying as male.
Reslution: Not sure. Unable to test, because I am unable to recompile the
source code at this point.
Please contact me if you have any questions.
I also have an enhancement suggestion: it would be nice to display the user
role in the users table.
And, a question. When creating a new user, why am I unable to assign the
role of 'System Admin' to my new user? In order to create a new
administrative user (to replace the default 'root'), I had to manipulate the
openclinica postgres tables directly.
Thanks for your help!
Michelle
----------------------------------------------------------------------
Michelle L. McCotter
Programmer Analyst
Childrens Center for Cancer and Blood Diseases
Childrens Hospital of Los Angeles
Phone: (323) 644-8648
Email: [email protected]
----------------------------------------------------------------------

Comments

  • Jun XuJun Xu Posts: 20
    Hi Michelle,
    To create a system admin, you can choose 'business admin' or 'technical admin' in the 'user type' entry. In OpenClinica,
    admin is a user type not a user role. User role is typically related to a study, even an admin needs to have a study user role to access a specific study.

    -Jun
    ------------------------------------
    Jun Xu
    Akaza Research
    One Kendall Square Bldg. 400, 4th Floor
    Cambridge, MA 02139
    tel: 617.621.8585
    fax: 617.621.0065
    www.akazaresearch.com
    Open Informatics for Public Research
    Sent: Thu 7/6/2006 7:58 PM
    To: OpenClinica Developers (E-mail)
    Subject: [Developers] OpenClinica Bugs
    To whom it may concern;
    I downloaded and installed OpenClinica 1.1 on my PC (which runs Windows XP
    Professional). I found a couple of bugs in the code, and I have a couple of
    questions/enhancement suggestions.
    Bug #1: openclinica Database trigger function -- user_account_trigger
    Issue: I cannot delete users from the database, due to a syntax error in
    the code.
    Details/Resoltuion: The INSERT command has some parameters that are missing
    the string concatenation character between the space character and
    last_name.
    INSERT INTO AUDIT_EVENT_VALUES (AUDIT_ID, COLUMN_NAME, OLD_VALUE,
    NEW_VALUE)
    VALUES
    (pk,'Name', null, OLD.first_name || ' ' OLD.last_name);
    This occurs in two other locations in this function.
    Bug #2: 'Gender' not displaying correctly
    Issue: I created a co-ed study, but the patients listed in the 'Subjects'
    section of the Administer Studies page (under 'Business Admin') are all
    displaying as male.
    Reslution: Not sure. Unable to test, because I am unable to recompile the
    source code at this point.
    Please contact me if you have any questions.
    I also have an enhancement suggestion: it would be nice to display the user
    role in the users table.
    And, a question. When creating a new user, why am I unable to assign the
    role of 'System Admin' to my new user? In order to create a new
    administrative user (to replace the default 'root'), I had to manipulate the
    openclinica postgres tables directly.
    Thanks for your help!
    Michelle
    ----------------------------------------------------------------------
    Michelle L. McCotter
    Programmer Analyst
    Childrens Center for Cancer and Blood Diseases
    Childrens Hospital of Los Angeles
    Phone: (323) 644-8648
    Email: [email protected]
    ----------------------------------------------------------------------
This discussion has been closed.