• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
    •

    Oracle error invalid identifier

    Technical Questions
    #1

    Hello,

    We are using OpenSpeciman v1 and getting the following error when trying to create a specimen:

    ORA-00904: “SPECIMENEV0_1_”.“SPE_ID”: invalid identifier

    Is anyone seeing anything similar?

    Thank you.

    #2

    @Kenneth_Buck

    Can you pls attach or email us the server log file?

    Thanks,
    ~Sri

    #3

    On the end user side of things, when I attempt to log a specimen collection event, I either receive a system error or the following error messages:

    Error! could not insert: [edu.wustl.catissuecore.domain.ReceivedEventParameters] or
    Error! could not insert: [edu.wustl.catissuecore.domain.CollectionEventParameters]

    Thanks,
    Shannon

    #4

    Here is the server.log file with errors.

    server.log.2015-04-02 (1.9 MB)

    #5

    @Kenneth_Buck The server log is not accessible. Can you try again?

    Is this v1.1 or v2.0?

    ~Sri

    #6

    server.log (949.4 KB)

    #7

    Hi @Kenneth_Buck,

    The error log shows that specimen event tables are not altered. The reasons for this could be:

    1. username was not specified while deployment

    To fix this please run either of the following commands:

    If app deployed from source directory:
    ant -f deploy.xml migrate_specimen_events -Dusername=admin@admin.com

    If app deployed from OS release tarball:
    ant migrate_specimen_events -Dusername=admin@admin.com

    Replace admin@admin.com with active admin username for your instance.

    After this please restart the JBoss.

    ~Nitesh

    #8

    Hi Nitesh,

    I was able to collect planned specimens after the fix. However, I am still unable to collect unplanned specimens. Attached is the server log.

    Thanks,
    Shannon

    OS_server_log_2015_04_08.docx (133.7 KB)

    #9

    Hi @Shannon_Dalton,

    This issue was present in the earlier release i.e. OS-v1.1_RC1 and was fixed in latest release OS-v1.1_RC3. So we will suggest you to take the latest OS-v1.1 build and do a deploy app. Please follow below steps:

    1. Download the latest build from release folder .
    2. Unzip it into a directory, we will refer this as OS_HOME
    3. Fill up the caTissueinstall.properties file
    4. Open terminal/command and prompt traverse to OS_HOME
    5. Run command: ant deploy_app
    6. Start the JBoss server.

    ~Nitesh

    #10

    Is the RC3 deployment supposed to be done over a RC1 deployment? Or can this be done as a new deployment?
    Are there any other migration steps we need to take to go from RC1 to RC3?

    #11

    @Kenneth_Buck You need to run the steps mentioned by Nitesh in the previous post on top of your current v1.1 setup.

    ~Sri

    #12

    We have a fresh instance of OS-v1.1_RC3. I am still receiving a system error when logging an unplanned specimen to a collection protocol.

    Thanks,
    Shannon

    #13

    Hi @Shannon_Dalton,

    Could you please share the server log?

    ~Nitesh