Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-10122

Backport OPENIDM-8834: SQL exception when running oracle script for repo

    Details

      Description

      I think in the openidm.sql script for Oracle is an a problem.

      I did this steps.

      https://hub.docker.com/r/wnameless/oracle-xe-11g/

      1. docker run -d -p 49160:22 -p 49161:1521 -e ORACLE_ALLOW_REMOTE=true wnameless/oracle-xe-11g 
      2. docker cp /home/vagrant/Documents/openidm.sql zealous_meitner:tmp 
      3. ssh root@localhost -p 49160 
      4. sqlplus

      SQL> show user; 
      USER is "SYSTEM"

      SQL> @/tmp/openidm.sql

      Creating Foreign Key Constraint fk_relationshipproperties_conf on table relationshipproperties... 
      REFERENCES relationships 

      ERROR at line 6: 
      ORA-00942: table or view does not exist

      This happen by an Oracle 12 also.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                patrickdiligent patrick diligent
                Reporter:
                mark.offutt Mark Offutt
                QA Assignee:
                Jakub Janoska
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: