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!

“Oops! An error has occurred” Really? That's the only clue about where and what needs to be fixed?

Hi team

In trying to upload a newly-written CRF to the OpenClinica testing environment, we received the following error message: “Oops! An error has occurred”. There is no mention of where the error is or what type of error it is / they are.

Is there truly no other way to fix this than to spend the next few weeks trawling through comma’s, brackets and spaces? Surely, with thousands of OpenClinica users, someone must have written a simple software to search for grammatical errors in newly written CRF’s?

It seems crazy that a human eye has to do this.

Please help.

Regards

Steve Innes

Tagged:

Comments

  • kristiakkristiak Posts: 1,318 ✭✭✭
    via Email
    This is usually due to a serious syntax error that can be spotted easily. One common error is that you have save invisible characters n the spreadsheet by not deleting them properly,

    Regards

    Krister
  • steve_innessteve_innes Posts: 10
    via Email
    Hi Kristiak
    Thanks for your reply!
    What do you refer to by "invisible characters"?
    Best regards
    Steve
  • kristiakkristiak Posts: 1,318 ✭✭✭
    via Email
    If you have edited your Excel sheet and simple deleted an item by erasing by using the delete button or use space to erase an item you may leave invisible character in you spreadsheet, The best way to make sure there are no invisible characters left in "empty" rows is to select the entire row or rows in you r spreadsheet and by using the delete function in the menu simply erase any rows that may store invisible characters. I usually delete some twenty rows to make sure that rest is clean.
  • rpetrusevschirpetrusevschi Posts: 24 admin
    Hi Steve,

    You can also check whether the version of the Excel file is compatible with OC.


    Best,
    Rodica 
  • parlayanparlayan Posts: 139
    Hi Steve, 
    Check if you have  different RESPONSE OPTIONS for the same
    RESPONSE LABEL. This should never cause a "oops" error but in the past it caused a lot of trouble for us. (the tool-tips of the columns in CRF excel explains how it should be)
    Regards, 
    Cuneyt.
  • steve_innessteve_innes Posts: 10
    via Email
    Thanks Cuneyt!
    Kind regards
    Steve

    On 16 Dec 2014, at 4:15 PM, "parlayan" wrote:

    Hi Steve, Check if you have different RESPONSE OPTIONS for the same

    RESPONSE LABEL. This should never cause a "oops" error but in the past it caused a lot of trouble for us. (the tool-tips of the columns in CRF excel explains how it should be)Regards,

    Cuneyt.
  • mvirtosumvirtosu Posts: 275
    Steve,

    You can also look in the "logs" folder, if you have access to the backend.

    Mihai
This discussion has been closed.