31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!

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.