dcm4chee
  1. dcm4chee
  2. DCMEE-1814

problem with column type on sql server prevents dcm4chee from starting up

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Tracking Status:
      Risk Analysis - Todo, Test Spec - ToReview, Test State - Not tested

      Description

      If you check out dcm4chee from trunk, build and deploy it for SQL Server, you will get this error in the log file when JBoss starts up:

      09:15:55,031 WARN [ServiceController] Problem starting service persistence.units:ear=dcm4chee-web-ear-3.0.1-mssql.ear,unitName=dcm4chee-arc
      javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: sps_status, expected: int
      at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720)
      at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
      at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:246)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      ...

      This error prevents many EJBs from starting up.

      A workaround is to change the column type in SQL Server to int:

      drop index sps_status on mwl_item
      alter table mwl_item alter column sps_status int
      create index sps_status on mwl_item(sps_status)

      While I am sure this is not the real fix, this will at least allow JBoss to start up error-free and allow dcm4chee to receive images...

        Activity

        Hide
        Ruben added a comment -

        This is also happening to me with dcm4chee-2.17.1-mssql and MSSQL 2012 Express... What the description of the issue says fixes the problem to me as well

        Show
        Ruben added a comment - This is also happening to me with dcm4chee-2.17.1-mssql and MSSQL 2012 Express... What the description of the issue says fixes the problem to me as well
        Hide
        Rubin Webb added a comment -

        Same issue for me, the workaround fixed it though. Got stuck for a day or so before I found this, thank you.

        Show
        Rubin Webb added a comment - Same issue for me, the workaround fixed it though. Got stuck for a day or so before I found this, thank you.

          People

          • Assignee:
            Gunter Zeilinger
            Reporter:
            Marc Durand
          • Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Development