Workflow title with trailing space causes error using PostgreSQL

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X EE
• Fix Version/s: 7.0.0 DXP FP21, 7.0.0 DXP SP4, 7.0.X EE, Master
• Component/s: Workflow
• Labels:
  • QA-V
  • ee-ts
  • fw_test_needed
  • liferay-digital-enterprise-70-sp4
  • liferay-fixpack-de-21-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.5
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal-ee/pull/17420

Description

When creating Kaleo workflow definition, if the title contains trailing space, it will cause error. This issue only occurs when using PostgreSQL.

Reproduction Steps

1. Unzip a vanilla Liferay Digital Enterprise SP3 bundle connecting with PostgreSQL 9.4.
2. Navigate to Control Panel > Configuration > Kaleo Designer > Add new definition.
3. Attempt to create a new workflow titled 'Test Workflow 1 ' that has trailing space in the title field.
Expected Result: The title with trailing space should not cause any error
Actual Result: An error occurs in the console. Editing the workflow definition will cause UI error "Kaleo Designer is temporarily unavailable."

Error

06:49:58,996 WARN  [http-nio-8080-exec-7][ProxyMessageListener:86] com.liferay.portal.kernel.workflow.WorkflowException: com.liferay.portal.workflow.kaleo.exception.NoSuchDefinitionException: No KaleoDefinition exists with the key {companyId=20116, name=Test Workflow 1, version=1}
com.liferay.portal.kernel.workflow.WorkflowException: com.liferay.portal.workflow.kaleo.exception.NoSuchDefinitionException: No KaleoDefinition exists with the key {companyId=20116, name=Test Workflow 1, version=1}
	at com.liferay.portal.workflow.kaleo.runtime.integration.impl.internal.WorkflowDefinitionManagerImpl.getWorkflowDefinition(WorkflowDefinitionManagerImpl.java:194)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
......

Branch

ee-7.0.x reproduced
ID: a74b874a146ca6e112b80b9ccd8cc464a642ca69
master There is no Kaleo Designer in this build
ID: b5d83ca5a84480920c8cfd2b4d1630596910be12