Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-129558

Invalid object name 'CTSchemaVersion' on change tracking integration tests on SQLServer 2019

    Description

    modules-integration-sqlserver2019-jdk8/0:

    Error Message
    com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:600)
    	at com.liferay.change.tracking.service.persistence.impl.CTSchemaVersionPersistenceImpl.findAll(CTSchemaVersionPersistenceImpl.java:1012)
    	at com.liferay.change.tracking.service.persistence.impl.CTSchemaVersionPersistenceImpl.findAll(CTSchemaVersionPersistenceImpl.java:929)
    	at com.liferay.change.tracking.service.persistence.impl.CTSchemaVersionPersistenceImpl.findAll(CTSchemaVersionPersistenceImpl.java:893)
    	at sun.reflect.GeneratedMethodAccessor823.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	at com.liferay.portal.kernel.test.ReflectionTestUtil.invoke(ReflectionTestUtil.java:221)
    	at com.liferay.portal.kernel.test.rule.DataGuardTestRule.lambda$_captureDataMap$0(DataGuardTestRule.java:343)
    	at com.liferay.portal.spring.transaction.BaseTransactionExecutor.execute(BaseTransactionExecutor.java:37)
    	at com.liferay.portal.spring.transaction.TransactionInvokerImpl.invoke(TransactionInvokerImpl.java:39)
    	at com.liferay.portal.kernel.transaction.TransactionInvokerUtil.invoke(TransactionInvokerUtil.java:28)
    	at com.liferay.portal.kernel.test.rule.DataGuardTestRule._captureDataMap(DataGuardTestRule.java:333)
    	at com.liferay.portal.kernel.test.rule.DataGuardTestRule.beforeClass(DataGuardTestRule.java:156)
    	at com.liferay.portal.kernel.test.rule.DataGuardTestRule.beforeClass(DataGuardTestRule.java:73)
    	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:54)
    	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
    	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
    	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
    	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable._execute(TestExecutorRunnable.java:316)
    	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable.run(TestExecutorRunnable.java:95)
    	at java.lang.Thread.run(Thread.java:745)
    Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:39)
    	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:124)
    	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:104)
    	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:61)
    	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:53)
    	at com.liferay.change.tracking.service.persistence.impl.CTSchemaVersionPersistenceImpl.findAll(CTSchemaVersionPersistenceImpl.java:1002)
    	... 20 more
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    	at org.hibernate.loader.Loader.doList(Loader.java:2545)
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
    	at org.hibernate.loader.Loader.list(Loader.java:2271)
    	at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:940)
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:112)
    	... 24 more
    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'CTSchemaVersion'.
    	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
    	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624)
    	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:594)
    	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524)
    	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
    	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979)
    	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
    	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
    	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:446)
    	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
    	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
    	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
    	at org.hibernate.loader.Loader.doQuery(Loader.java:802)
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    	at org.hibernate.loader.Loader.doList(Loader.java:2542)
    	... 31 more
    

      Attachments

        Activity

          People

          Assignee:
          support-lep@liferay.com SE Support
          Reporter:
          linda.sui Linda Sui
          Participants of an Issue:
          Recent user:
          Linda Sui
          Votes:
          0 Vote for this issue
          Watchers:
          0 Start watching this issue

            Dates

            Created:
            Updated:
            Days since last comment:
            11 weeks, 5 days ago

              Packages

              Version Package