Unable to create Web Content with "Upload" structure field

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.3.X, Master
• Fix Version/s: 7.1.10 DXP FP23, 7.1.10.6 SP6, 7.1.X, 7.2.10 DXP FP11, 7.2.10.4 DXP SP4, 7.2.X, 7.3.10 DXP FP1, 7.3.10.1 DXP SP1, 7.3.6 CE GA7, 7.3.X, 7.4.13 DXP GA1, Master
• Component/s: Data Engine
• Labels:
  • QA-AUTOMATION
  • QA-FP
  • ee-ts
  • fc_21_01
  • liferay-dxp-71-sp6
  • liferay-dxp-72-sp4
  • liferay-dxp-73-sp1
  • liferay-fixpack-dxp-1-7310
  • liferay-fixpack-dxp-11-7210
  • liferay-fixpack-dxp-23-7110
  • migration_to_dataengine
• Branch Version/s:
  7.3.x, 7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 5
• Git Pull Request: https://github.com/liferay-lima/liferay-portal/pull/1401
• QA Test Name:
  • LocalFile.BulkEditing#MoveDocumentsToFolder
  • LocalFile.CPBlogs#SearchBlogsImagesViaItemSelector
  • LocalFile.CPBlogs#ViewCoverImageDetails
  • LocalFile.CPDocumentsandmedia#DownloadDocumentAfterMoveBetweenFolders
  • LocalFile.CPDocumentsandmedia#MoveDocumentToFolder
  • LocalFile.CPDocumentsandmedia#MoveFolderToFolder
  • LocalFile.DepotDocuments#MoveDocumentToFolder
  • LocalFile.DocumentsadministrationUsecase#ViewDocumentWithGlobalScope
  • LocalFile.DocumentsadministrationUsecase#ViewPaginationToolbarCheckboxAndMoveMultiplePaginationDocuments
  • LocalFile.Forms#SubmitFormWithAllFieldTypesAndThreePages
  • LocalFile.Forms#SubmitFormWithUploadField
  • LocalFile.Forms#SubmitFormWithUploadFieldAsNewUser
  • LocalFile.GDPR#ExportAllEntries
  • LocalFile.ImageSelector#PreviewMultipleImagesInBlogsImages
  • LocalFile.ImageSelector#PreviewSingleImage
  • LocalFile.ItemSelector#ViewBlogsImageNoScopeFilter
  • LocalFile.MessageboardsUsecase#SearchMessageBoardsAttachment
  • LocalFile.PGDocumentsandmedia#MoveDocumentWithSlashesInTitle
  • LocalFile.PGDocumentsandmedia#MoveFolderDocumentDuplicateToFolder
  • LocalFile.PGDocumentsandmedia#MoveFolderDocumentToFolder
  • LocalFile.PGMessageboards#AddMBThreadWithMultipleAttachments
  • LocalFile.PGMessageboards#ReplyAfterDownloadingMBThreadAttachmentTwice
  • LocalFile.PGWiki#AddFrontPageWithAttachments
  • LocalFile.PGWiki#AddPageWithInlineImage
  • LocalFile.PublicationsDM#PublishDocumentFolderWithEditedDocument
  • LocalFile.RecycleBin#RecycleBinMBAttachment
  • LocalFile.RemoteStagingBlogs#StagingRemoteLiveChangeBlogsEntryCoverImage
  • LocalFile.StagingBlogs#ViewBlogsAsAGuestAndSiteMember
  • LocalFile.StagingWiki#RemoveStagedWikiAttachment
  • LocalFile.WYSIWYGUsecase#AddBlogsEntryWithImageViaBlogsImages
  • LocalFile.WikiUsecase#ActivateInitialStagingWithAttachment
  • LocalFile.WikiUsecase#SearchFrontPageAttachments
• QA Test Score: 137

Steps to reproduce:

1. Create a Web Content Structure with a Upload field
2. Create a Web Content with that structure
3. Try to Upload a document

Expected result:
File selector appears

Actual result:

Dialog opens, but "Document Selector is temporarily unavailable."

Server log:

2021-01-22 08:12:17.592 ERROR [http-nio-8080-exec-5][render_portlet_jsp:131] null
java.lang.IllegalArgumentException: Positional parameter does not exist: 2 in query: SELECT COUNT(DISTINCT DLFileVersion.fileEntryId) AS COUNT_VALUE FROM DLFileVersion WHERE (DLFileVersion.groupId = ?) AND (DLFileVersion.status = ?) AND ((DLFileVersion.folderId = 38957))
at org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:382)
at org.hibernate.impl.AbstractQueryImpl.setLong(AbstractQueryImpl.java:536)
at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.setLong(SQLQueryImpl.java:329)
at com.liferay.portal.kernel.dao.orm.QueryPos.add(QueryPos.java:221)
at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileEntryFinderImpl.doCountByG_F(DLFileEntryFinderImpl.java:538)
at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileEntryFinderImpl.countByG_F(DLFileEntryFinderImpl.java:128)
at com.liferay.portlet.documentlibrary.service.impl.DLFileEntryLocalServiceImpl.getFileEntriesCount(DLFileEntryLocalServiceImpl.java:1126)
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
at com.liferay.portal.repository.liferayrepository.LiferayLocalRepository.getFileEntriesCount(LiferayLocalRepository.java:335)
at com.liferay.portal.repository.util.LocalRepositoryWrapper.getFileEntriesCount(LocalRepositoryWrapper.java:210)
at com.liferay.portal.repository.util.LocalRepositoryWrapper.getFileEntriesCount(LocalRepositoryWrapper.java:210)
at com.liferay.portal.repository.util.LocalRepositoryWrapper.getFileEntriesCount(LocalRepositoryWrapper.java:210)
at com.liferay.portal.repository.util.LocalRepositoryWrapper.getFileEntriesCount(LocalRepositoryWrapper.java:210)
at com.liferay.portal.repository.util.LocalRepositoryWrapper.getFileEntriesCount(LocalRepositoryWrapper.java:210)
at com.liferay.portal.repository.capabilities.CapabilityLocalRepository.getFileEntriesCount(CapabilityLocalRepository.java:303)
at com.liferay.document.library.repository.portlet.file.repository.internal.PortletFileRepositoryImpl.getPortletFileEntriesCount(PortletFileRepositoryImpl.java:518)
at com.liferay.portal.kernel.portletfilerepository.PortletFileRepositoryUtil.getPortletFileEntriesCount(PortletFileRepositoryUtil.java:235)