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

AccountUserRetrieverWhenSearchingAccountRoleUsersTest#testShouldReturnAccountRoleUsersWithPagination is failing on Oracle and SQLServer

    Description

    AccountUserRetrieverWhenSearchingAccountRoleUsersTest#testShouldReturnAccountRoleUsersWithPagination failing on Oracle 12.2 and SQL Server 2019:

    PortalLogAssertorTest#testScanXMLLog is also failing in SQL Server due to the same SQL Server error

    Oracle 12.2:

        [exec] com.liferay.account.retriever.test.AccountUserRetrieverWhenSearchingAccountRoleUsersTest > testShouldReturnAccountRoleUsersWithPagination FAILED
         [exec]     com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
         [exec]     	at com.liferay.portal.service.persistence.impl.UserFinderImpl.findByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:869)
         [exec]     	at com.liferay.portal.service.persistence.impl.UserFinderImpl.findByKeywords(UserFinderImpl.java:648)
         [exec]     	at com.liferay.portal.service.impl.UserLocalServiceImpl.search(UserLocalServiceImpl.java:3002)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]     	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
         [exec]     	at com.sun.proxy.$Proxy713.search(Unknown Source)
         [exec]     	at com.liferay.portal.kernel.service.UserLocalServiceWrapper.search(UserLocalServiceWrapper.java:2296)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]     	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
         [exec]     	at com.sun.proxy.$Proxy714.search(Unknown Source)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]     	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
         [exec]     	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
         [exec]     	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
         [exec]     	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
         [exec]     	at com.sun.proxy.$Proxy37.search(Unknown Source)
         [exec]     	at com.liferay.account.internal.retriever.AccountUserRetrieverImpl.searchAccountRoleUsers(AccountUserRetrieverImpl.java:96)
         [exec]     	at com.liferay.account.retriever.test.AccountUserRetrieverWhenSearchingAccountRoleUsersTest.testShouldReturnAccountRoleUsersWithPagination(AccountUserRetrieverWhenSearchingAccountRoleUsersTest.java:165)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]     	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]     	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]     	at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$2.evaluate(TestExecutorRunnable.java:234)
         [exec]     	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at com.liferay.portal.kernel.test.rule.TimeoutTestRule$1.evaluate(TimeoutTestRule.java:89)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]     	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$1.evaluate(TestExecutorRunnable.java:143)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]     	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable._execute(TestExecutorRunnable.java:181)
         [exec]     	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable.run(TestExecutorRunnable.java:95)
         [exec]     	at java.lang.Thread.run(Thread.java:745)
         [exec]     Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
         [exec]     	at com.liferay.portal.service.persistence.impl.UserFinderImpl.doFindByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:954)
         [exec]     	at com.liferay.portal.service.persistence.impl.UserFinderImpl.findByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:854)
         [exec]     	... 53 more
         [exec]     Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
         [exec]     	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:39)
         [exec]     	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:188)
         [exec]     	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:168)
         [exec]     	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:84)
         [exec]     	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:53)
         [exec]     	at com.liferay.portal.service.persistence.impl.UserFinderImpl.doFindByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:950)
         [exec]     	... 54 more
         [exec]     Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
         [exec]     	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
         [exec]     	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
         [exec]     	at org.hibernate.loader.Loader.doList(Loader.java:2545)
         [exec]     	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
         [exec]     	at org.hibernate.loader.Loader.list(Loader.java:2271)
         [exec]     	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
         [exec]     	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
         [exec]     	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
         [exec]     	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
         [exec]     	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:176)
         [exec]     	... 58 more
         [exec]     Caused by: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
         [exec] 
         [exec]     	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
         [exec]     	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
         [exec]     	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
         [exec]     	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
         [exec]     	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
         [exec]     	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
         [exec]     	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
         [exec]     	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
         [exec]     	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
         [exec]     	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
         [exec]     	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
         [exec]     	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
         [exec]     	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
         [exec]     	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
         [exec]     	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
         [exec]     	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
         [exec]     	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
         [exec]     	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
         [exec]     	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
         [exec]     	at org.hibernate.loader.Loader.doQuery(Loader.java:802)
         [exec]     	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
         [exec]     	at org.hibernate.loader.Loader.doList(Loader.java:2542)
         [exec]     	... 65 more
         [exec]     Caused by: Error : 918, Position : 28, Sql = select * from ( select row_.*, rownum rownum_ from ( (  SELECT DISTINCT User_.userId AS userId, User_.userId AS userId FROM User_   INNER JOIN UserGroupRole ON UserGroupRole.userId = User_.userId  WHERE  (UserGroupRole.groupId = :1 ) AND (UserGroupRole.roleId = :2 )    AND  (User_.companyId = :3 ) AND (User_.defaultUser = :4 ) AND ((LOWER(User_.firstName) LIKE :5  ESCAPE '\' AND :6  IS NOT NULL) OR (LOWER(User_.middleName) LIKE :7  ESCAPE '\' AND :8  IS NOT NULL) OR (LOWER(User_.lastName) LIKE :9  ESCAPE '\' AND :10  IS NOT NULL) OR (LOWER(User_.screenName) LIKE :11  ESCAPE '\' AND :12  IS NOT NULL) OR (LOWER(User_.emailAddress) LIKE :13  ESCAPE '\' AND :14  IS NOT NULL)) AND (User_.status = :15 )   ) ORDER BY User_.userId ASC ) row_ where rownum <= :16 ) where rownum_ > :17 , OriginalSql = select * from ( select row_.*, rownum rownum_ from ( (  SELECT DISTINCT User_.userId AS userId, User_.userId AS userId FROM User_   INNER JOIN UserGroupRole ON UserGroupRole.userId = User_.userId  WHERE  (UserGroupRole.groupId = ?) AND (UserGroupRole.roleId = ?)    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ((LOWER(User_.firstName) LIKE ? ESCAPE '\' AND ? IS NOT NULL) OR (LOWER(User_.middleName) LIKE ? ESCAPE '\' AND ? IS NOT NULL) OR (LOWER(User_.lastName) LIKE ? ESCAPE '\' AND ? IS NOT NULL) OR (LOWER(User_.screenName) LIKE ? ESCAPE '\' AND ? IS NOT NULL) OR (LOWER(User_.emailAddress) LIKE ? ESCAPE '\' AND ? IS NOT NULL)) AND (User_.status = ?)   ) ORDER BY User_.userId ASC ) row_ where rownum <= ?) where rownum_ > ?, Error Msg = ORA-00918: column ambiguously defined
         [exec] 
         [exec]     	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
         [exec]     	... 86 more
    

    SQL Server 2019:

         [exec]     com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
         [exec]         at com.liferay.portal.service.persistence.impl.UserFinderImpl.findByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:869)
         [exec]         at com.liferay.portal.service.persistence.impl.UserFinderImpl.findByKeywords(UserFinderImpl.java:648)
         [exec]         at com.liferay.portal.service.impl.UserLocalServiceImpl.search(UserLocalServiceImpl.java:3002)
         [exec]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]         at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]         at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
         [exec]         at com.sun.proxy.$Proxy694.search(Unknown Source)
         [exec]         at com.liferay.portal.kernel.service.UserLocalServiceWrapper.search(UserLocalServiceWrapper.java:2296)
         [exec]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]         at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]         at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
         [exec]         at com.sun.proxy.$Proxy695.search(Unknown Source)
         [exec]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]         at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]         at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
         [exec]         at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
         [exec]         at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
         [exec]         at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
         [exec]         at com.sun.proxy.$Proxy37.search(Unknown Source)
         [exec]         at com.liferay.account.internal.retriever.AccountUserRetrieverImpl.searchAccountRoleUsers(AccountUserRetrieverImpl.java:96)
         [exec]         at com.liferay.account.retriever.test.AccountUserRetrieverWhenSearchingAccountRoleUsersTest.testShouldReturnAccountRoleUsersWithPagination(AccountUserRetrieverWhenSearchingAccountRoleUsersTest.java:165)
         [exec]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [exec]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [exec]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [exec]         at java.lang.reflect.Method.invoke(Method.java:498)
         [exec]         at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$2.evaluate(TestExecutorRunnable.java:234)
         [exec]         at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]         at com.liferay.portal.kernel.test.rule.TimeoutTestRule$1.evaluate(TimeoutTestRule.java:89)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
         [exec]         at org.junit.rules.RunRules.evaluate(RunRules.java:20)
         [exec]         at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$1.evaluate(TestExecutorRunnable.java:143)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]         at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
         [exec]         at org.junit.rules.RunRules.evaluate(RunRules.java:20)
         [exec]         at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable._execute(TestExecutorRunnable.java:181)
         [exec]         at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable.run(TestExecutorRunnable.java:95)
         [exec]         at java.lang.Thread.run(Thread.java:745)
         [exec]     Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
         [exec]         at com.liferay.portal.service.persistence.impl.UserFinderImpl.doFindByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:954)
         [exec]         at com.liferay.portal.service.persistence.impl.UserFinderImpl.findByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:854)
         [exec]         ... 53 more
         [exec]     Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
         [exec]         at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:39)
         [exec]         at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:188)
         [exec]         at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:168)
         [exec]         at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:84)
         [exec]         at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:53)
         [exec]         at com.liferay.portal.service.persistence.impl.UserFinderImpl.doFindByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:950)
         [exec]         ... 54 more
         [exec]     Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
         [exec]         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
         [exec]         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
         [exec]         at org.hibernate.loader.Loader.doList(Loader.java:2545)
         [exec]         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
         [exec]         at org.hibernate.loader.Loader.list(Loader.java:2271)
         [exec]         at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
         [exec]         at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
         [exec]         at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
         [exec]         at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
         [exec]         at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:176)
         [exec]         ... 58 more
         [exec]     Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The column 'userId' was specified multiple times for '_temp_table_1'.
         [exec]         at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
         [exec]         at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624)
         [exec]         at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:594)
         [exec]         at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524)
         [exec]         at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
         [exec]         at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979)
         [exec]         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
         [exec]         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
         [exec]         at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:446)
         [exec]         at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
         [exec]         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
         [exec]         at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
         [exec]         at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
         [exec]         at org.hibernate.loader.Loader.doQuery(Loader.java:802)
         [exec]         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
         [exec]         at org.hibernate.loader.Loader.doList(Loader.java:2542)
         [exec]         ... 65 more
    

      Attachments

        Issue Links

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            jacob.cerda Jacob Cerda (Inactive)
            Participants of an Issue:
            Recent user:
            Calvin Vo
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Days since last comment:
              29 weeks, 3 days ago

                Packages

                Version Package