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

unable to create a new version

Dear All

This happened 1st time in last 4 years!

I get the error while uploading the new version of the CRF. Pl see the enclosed pdf.

Any suggestion? ( We are using linux and OC 3.1)

Best regards
------
Charu Joglekar
Sr Statistician
Diabetes Unit
King Edward memorial Hospital Research Centre
Pune 411011
INDIA

Phone: +91-20-66405731
Mobile: +91-9822874350
Fax : +91-20-26111958
www.kemdiabetes.org

Attachments:
error.pdf 134 KB

Comments

  • Dear Charu,

    Please attach your source document as well.

    Thanks and Regards,
    Ajith

    Ajith B.S
    Kreara Solutions Pvt Ltd. Technopark
    Trivandrum, Kerala
    Sent: Thursday, December 05, 2013 3:19 PM
    To: [email protected]
    Subject: [Users] unable to create a new version

    Dear All

    This happened 1st time in last 4 years!

    I get the error while uploading the new version of the CRF. Pl see the enclosed pdf.

    Any suggestion? ( We are using linux and OC 3.1)

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
  • charudattacharudatta Posts: 42
    I am attaching the excel spreadsheet which I am trying to upload.

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
    Sent: Thursday, December 05, 2013 3:36 PM
    To: [email protected]
    Subject: Re: [Users] unable to create a new version

    Dear Charu,

    Please attach your source document as well.

    Thanks and Regards,
    Ajith

    Ajith B.S
    Kreara Solutions Pvt Ltd. Technopark
    Trivandrum, Kerala
    Sent: Thursday, December 05, 2013 3:19 PM
    To: [email protected]
    Subject: [Users] unable to create a new version

    Dear All

    This happened 1st time in last 4 years!

    I get the error while uploading the new version of the CRF. Pl see the enclosed pdf.

    Any suggestion? ( We are using linux and OC 3.1)

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org

    Attachments:
    temp.xls 82.0 KB
  • Dear Charu,
    this is another O.C. "feature" I find from time to time. That happened
    to me two weeks ago.
    I just waited a few minutes and tried again without problems.
    Sometimes is useful to load another, non-related CRF to the database;
    then try again with the CRF with errors (not modified, the same one)
    and then it loads successfully.
    Don't know if someone else will have this same experience with the reloading.
    Good luck!
    KR/
    Pedro
    -- On Thu, Dec 5, 2013 at 10:49 AM, Charu Joglekar wrote:
    > > Dear All
    > >
    > >
    > >
    > > This happened 1st time in last 4 years!
    > >
    > >
    > >
    > > I get the error while uploading the new version of the CRF. Pl see the
    > > enclosed pdf.
    > >
    > >
    > >
    > > Any suggestion? ( We are using linux and OC 3.1)
    > >
    > >
    > >
    > > Best regards
    > > ------
    > > Charu Joglekar
    > > Sr Statistician
    > > Diabetes Unit
    > > King Edward memorial Hospital Research Centre
    > > Pune 411011
    > >
    > > INDIA
    > >
    > >
    > >
    > > Phone: +91-20-66405731
    > > Mobile: +91-9822874350
    > > Fax : +91-20-26111958
    > > www.kemdiabetes.org
    > >
    > >
    > >
    > >
    > >
  • ikhanikhan Posts: 2
    You might want to try fixing your response labels and see what happens..


    Imran Khan
    SilverlightHealth, LLC
    HealthCare IT is our business
    Phone: 877-754-9778 (Ext. 101)
    http://www.SilverLightHealth.com
    Toll Free: 877-SLH-XPRT
    Fax: 732-414-7222
    Sent: Thursday, December 05, 2013 5:19 AM
    To: [email protected]
    Subject: Re: [Users] unable to create a new version

    I am attaching the excel spreadsheet which I am trying to upload.

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
    Sent: Thursday, December 05, 2013 3:36 PM
    To: [email protected]
    Subject: Re: [Users] unable to create a new version

    Dear Charu,

    Please attach your source document as well.

    Thanks and Regards,
    Ajith

    Ajith B.S
    Kreara Solutions Pvt Ltd. Technopark
    Trivandrum, Kerala
    Sent: Thursday, December 05, 2013 3:19 PM
    To: [email protected]
    Subject: [Users] unable to create a new version

    Dear All

    This happened 1st time in last 4 years!

    I get the error while uploading the new version of the CRF. Pl see the enclosed pdf.

    Any suggestion? ( We are using linux and OC 3.1)

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
  • parlayanparlayan Posts: 139
    You can't have this:
    Inline image 1
    It should be:
    Inline image 2
    Check if there is more of those.
    See the instructions tab and see other posts about this.
    Best, Cuneyt.
    On Thu, Dec 5, 2013 at 12:45 PM, Imran Khan wrote:
    You might want to try fixing your response labels and see what happens..


    Imran Khan
    SilverlightHealth, LLC
    HealthCare IT is our business
    Phone: 877-754-9778 (Ext. 101)
    http://www.SilverLightHealth.com
    Toll Free: 877-SLH-XPRT
    Fax: 732-414-7222
    Sent: Thursday, December 05, 2013 5:19 AM
    To: [email protected]
    Subject: Re: [Users] unable to create a new version

    I am attaching the excel spreadsheet which I am trying to upload.

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
    Sent: Thursday, December 05, 2013 3:36 PM
    To: [email protected]
    Subject: Re: [Users] unable to create a new version

    Dear Charu,

    Please attach your source document as well.

    Thanks and Regards,
    Ajith

    Ajith B.S
    Kreara Solutions Pvt Ltd. Technopark
    Trivandrum, Kerala
    Sent: Thursday, December 05, 2013 3:19 PM
    To: [email protected]
    Subject: [Users] unable to create a new version

    Dear All

    This happened 1st time in last 4 years!

    I get the error while uploading the new version of the CRF. Pl see the enclosed pdf.

    Any suggestion? ( We are using linux and OC 3.1)

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
  • tdpurnattdpurnat Posts: 126
    Hi,
    I have had this error in the past too --- when I was loading into the system a new version of a previously uploaded CRF.
    Two things have worked for me, but alternating --
    1. Log out of OC and clear browser cache, then log back in and try again. Sometimes the upload of new CRF version worked for me without any other issues.
    2. Load a new version of a CRF, with one item, named completely differently form anythingelse used previously in this CRF, make it default version in any events it is used at. I sometimes remove other versions or not (to me it hasn't mattered). Then try to reupload your correct version of CRF.
    This second issue has something to do with how the items in the default version of CRF are evaluated when you are uploading a new version.
    Tina
    ----------
    Tina D Dannemann Purnat, M.Sc., PMP, CCDM
    Skype tdpurnat | Office +49 89 38 03 89 67 | http://www.linkedin.com/in/tinadpurnat
    Why are my emails so terse? emailcharter.org
    2013/12/5 Charu Joglekar
    Dear All

    This happened 1st time in last 4 years!

    I get the error while uploading the new version of the CRF. Pl see the enclosed pdf.

    Any suggestion? ( We are using linux and OC 3.1)

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
  • charudattacharudatta Posts: 42
    Hi All
    Can somebody urgently help me out? I am unable to load even a fresh CRF I am enclosing the excel file .
    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
    Sent: Thursday, December 05, 2013 10:20 PM
    To: [email protected]
    Subject: Re: [Users] unable to create a new version

    Hi,

    I have had this error in the past too --- when I was loading into the system a new version of a previously uploaded CRF.

    Two things have worked for me, but alternating --
    1. Log out of OC and clear browser cache, then log back in and try again. Sometimes the upload of new CRF version worked for me without any other issues.

    2. Load a new version of a CRF, with one item, named completely differently form anythingelse used previously in this CRF, make it default version in any events it is used at. I sometimes remove other versions or not (to me it hasn't mattered). Then try to reupload your correct version of CRF.
    This second issue has something to do with how the items in the default version of CRF are evaluated when you are uploading a new version.

    Tina




    ----------
    Tina D Dannemann Purnat, M.Sc., PMP, CCDM
    Skype tdpurnat | Office +49 89 38 03 89 67 | http://www.linkedin.com/in/tinadpurnat

    Why are my emails so terse? emailcharter.org

    2013/12/5 Charu Joglekar
    Dear All

    This happened 1st time in last 4 years!

    I get the error while uploading the new version of the CRF. Pl see the enclosed pdf.

    Any suggestion? ( We are using linux and OC 3.1)

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
  • tdpurnattdpurnat Posts: 126
    Hi,
    Please find attached CRF that works in my test system 3.1.4.1.
    CRF tab: I shortned the CRF name (deleted hyphens).
    ITEMS tab:
    - in response_label column, i deleted spaces in some label names. Same with slashes.
    - I also added a checkbox example for using all items together in one coded value list. It would reduce a chance of the error below.
    What tripped you up was response set in item with name "genex7" (see error I also got below). The coded value for it was names "other", while the same label, just capitalized ("Other"), was used in item "cvs9". It seems the DB didn't like this....
    So the change that helped was to make all "Other" response labels and values capitalized in both items. One coudl also make them both small letters. They just needed to be consistent.
    The following error was returned from the database: ERROR: null value in column "response_set_id" violates not-null constraint using the following query: INSERT INTO ITEM_FORM_METADATA (CRF_VERSION_ID, RESPONSE_SET_ID,ITEM_ID,SUBHEADER,HEADER,LEFT_ITEM_TEXT,RIGHT_ITEM_TEXT,PARENT_ID,SECTION_ID,ORDINAL,PARENT_LABEL,COLUMN_NUMBER,PAGE_NUMBER_LABEL,question_number_label,REGEXP,REGEXP_ERROR_MSG,REQUIRED,DEFAULT_VALUE,RESPONSE_LAYOUT,WIDTH_DECIMAL, show_item) VALUES ((SELECT CRF_VERSION_ID FROM CRF_VERSION WHERE NAME ='1' AND CRF_ID=92),(SELECT RESPONSE_SET_ID FROM RESPONSE_SET WHERE LABEL='other' AND VERSION_ID=(SELECT CRF_VERSION_ID FROM CRF_VERSION WHERE NAME ='1' AND CRF_ID=92)), (SELECT I.ITEM_ID FROM ITEM I LEFT OUTER JOIN ITEM_FORM_METADATA IFM ON I.ITEM_Id = IFM.ITEM_ID LEFT OUTER JOIN CRF_VERSION CV ON IFM.CRF_VERSION_ID = CV.CRF_VERSION_ID WHERE ( I.NAME='genex7' AND I.owner_id = 2 AND CV.CRF_VERSION_ID is null ) OR ( I.NAME='genex7' AND I.owner_id = 2 AND CV.CRF_VERSION_ID is not null AND CV.CRF_ID =92 ) ORDER BY I.OID DESC LIMIT 1) ,'','','7','',0, (SELECT SECTION_ID FROM SECTION WHERE LABEL='exam' AND CRF_VERSION_ID IN (SELECT CRF_VERSION_ID FROM CRF_VERSION WHERE NAME ='1' AND CRF_ID=92)), 26,'',1,'','','','', false, '','horizontal','',true)
    ----------
    Tina D Dannemann Purnat, M.Sc., PMP, CCDM
    Skype tdpurnat | Office +49 89 38 03 89 67 | http://www.linkedin.com/in/tinadpurnat
    Why are my emails so terse? emailcharter.org
    2013/12/6 Charu Joglekar
    Hi All
    Can somebody urgently help me out? I am unable to load even a fresh CRF I am enclosing the excel file .
    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
    Sent: Thursday, December 05, 2013 10:20 PM
    To: [email protected]
    Subject: Re: [Users] unable to create a new version

    Hi,

    I have had this error in the past too --- when I was loading into the system a new version of a previously uploaded CRF.

    Two things have worked for me, but alternating --
    1. Log out of OC and clear browser cache, then log back in and try again. Sometimes the upload of new CRF version worked for me without any other issues.

    2. Load a new version of a CRF, with one item, named completely differently form anythingelse used previously in this CRF, make it default version in any events it is used at. I sometimes remove other versions or not (to me it hasn't mattered). Then try to reupload your correct version of CRF.
    This second issue has something to do with how the items in the default version of CRF are evaluated when you are uploading a new version.

    Tina




    ----------
    Tina D Dannemann Purnat, M.Sc., PMP, CCDM
    Skype tdpurnat | Office +49 89 38 03 89 67 | http://www.linkedin.com/in/tinadpurnat

    Why are my emails so terse? emailcharter.org

    2013/12/5 Charu Joglekar
    Dear All

    This happened 1st time in last 4 years!

    I get the error while uploading the new version of the CRF. Pl see the enclosed pdf.

    Any suggestion? ( We are using linux and OC 3.1)

    Best regards
    ------
    Charu Joglekar
    Sr Statistician
    Diabetes Unit
    King Edward memorial Hospital Research Centre
    Pune 411011
    INDIA

    Phone: +91-20-66405731
    Mobile: +91-9822874350
    Fax : +91-20-26111958
    www.kemdiabetes.org
This discussion has been closed.