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

SQL errors when creating a fragment on oracle database

    Details

      Description

      Steps to reproduce:

      1. Go to Bulid > Page Fragments
      2. Create a fragment collection
      3. Click add plus sign to create fragment after creating a collection
      4. Add some paragraph and css
      5. Click Publish

      Expected result:
      No SQL errors in the console.

      Actual result:

      2018-06-13 19:22:51.965 ERROR [default task-90][JDBCExceptionReporter:234] ORA-00909: invalid number of arguments_ [Sanitized]
      2018-06-13 19:22:51.974 ERROR [default task-90][IncludeTag:128] Current URL /group/site-name/~/control_panel/manage/-/fragments/fragment_collection/37839?p_p_auth=1fX2Up8V generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      Error : 909, Position : 7, Sql = SELECT COUNT(DISTINCT FragmentEntryLink.classNameId, FragmentEntryLink.classPK) AS COUNT_VALUE FROM FragmentEntryLink WHERE (FragmentEntryLink.groupId = :1 ) AND (FragmentEntryLink.fragmentEntryId = :2 )   , OriginalSql =   SELECT COUNT(DISTINCT FragmentEntryLink.classNameId, FragmentEntryLink.classPK) AS COUNT_VALUE FROM FragmentEntryLink WHERE (FragmentEntryLink.groupId = ?) AND (FragmentEntryLink.fragmentEntryId = ?)   , Error Msg = ORA-00909: invalid number of arguments_ [Sanitized]
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
      	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)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              koor.gai Koor Gai
              Reporter:
              koor.gai Koor Gai
              Participants of an Issue:
              Recent user:
              Brian Wulbern
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 23 weeks ago

                  Packages

                  Version Package
                  7.1.X
                  Master