Uploaded image for project: 'PatientManager'
  1. PatientManager
  2. PAM-479

Database issue when deploying the tool with postgres 9.6.5

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 9.6.0
    • Fix Version/s: 9.8.0
    • Component/s: None
    • Labels:
      None
    • Account:
      Maintenance 2017 (MAINTENANCE2017)

      Description

      2017-10-16 11:51:01,553 WARN () [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 57 ) SQL Error: 0, SQLState: 42703
      2017-10-16 11:51:01,554 ERROR () [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 57 ) ERROR: column am.amcanorder does not exist
        Position: 427
      2017-10-16 11:51:01,554 ERROR () [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 57 ) HHH000299: Could not complete schema update: java.lang.NullPointerException
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) [hibernate-core-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) [hibernate-core-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:157) [hibernate-core-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.cfg.Configuration.generateSchemaUpdateScriptList(Configuration.java:1173) [hibernate-core-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:237) [hibernate-core-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:203) [hibernate-core-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:509) [hibernate-core-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1799) [hibernate-core-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96) [hibernate-entitymanager-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915) [hibernate-entitymanager-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:900) [hibernate-entitymanager-4.2.20.Final.jar:4.2.20.Final]
      at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:76) [hibernate-entitymanager-4.2.20.Final.jar:4.2.20.Final]
      at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:200) [jboss-as-jpa-7.2.0.Final.jar:7.2.0.Final]
      at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.access$600(PersistenceUnitServiceImpl.java:57) [jboss-as-jpa-7.2.0.Final.jar:7.2.0.Final]
      at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:99) [jboss-as-jpa-7.2.0.Final.jar:7.2.0.Final]
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) [rt.jar:1.7.0_151]
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) [rt.jar:1.7.0_151]
      at java.lang.Thread.run(Thread.java:748) [rt.jar:1.7.0_151]
      at org.jboss.threads.JBossThread.run(JBossThread.java:122)

        Attachments

          Activity

            People

            • Assignee:
              aberge Anne-Gaelle Berge
              Reporter:
              aberge Anne-Gaelle Berge
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 4 hours
                4h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 30 minutes Time Not Required
                30m

                  Potential Duplicates