Uploaded image for project: 'Openmeetings'
  1. Openmeetings
  2. OPENMEETINGS-1483

Error while installing OM on MSSQL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.3
    • Fix Version/s: 3.1.4, 3.2.0, 4.0.0
    • Component/s: Builds
    • Labels:
      None
    • Environment:
      DB: MS SQL 2014
      encoding: Cyrillic_General_CI_AI

      Description

      Caused by: <openjpa-2.4.1-r422266:1730418 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Incorrect syntax near the keyword 'key'. {stmnt 1149624438 CREATE TABLE configuration (id BIGINT NOT NULL IDENTITY, comment TEXT, deleted BIT, inserted DATETIME2, key VARCHAR(255), updated DATETIME2, value VARCHAR(255), user_id BIGINT, PRIMARY KEY (id), CONSTRAINT U_CNFGRTN_KEY UNIQUE (key))} [code=156, state=S0001]
                      at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:561)
                      at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:457)
                      at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)
                      at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)
                      at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)
                      at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:208)
                      at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:154)
                      at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:226)
                      at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:153)
                      at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:59)
                      at org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:449)
                      at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:369)
                      ... 12 more
      

      link to the thread: http://markmail.org/message/kluuge4hd6pit7wv

        Attachments

          Activity

            People

            • Assignee:
              solomax Maxim Solodovnik
              Reporter:
              solomax Maxim Solodovnik
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: