Verify process assumes articleId is a long when it is a String

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X EE, Master
• Fix Version/s: 7.0.0 DXP FP20, 7.0.3 CE GA4, 7.0.0 DXP SP4, 7.0.X EE, 7.1.X, Master
• Component/s: Collaboration > Upgrade
• Labels:
  • liferay-digital-enterprise-70-sp4
  • liferay-fixpack-de-20-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.5
• Fix Priority: 3
• Git Pull Request: https://github.com/liferay/com-liferay-journal/pull/351

This doesn't cause issues normally, but some users are running into an "Error converting data type nvarchar to bigint".

We aren't sure what the exact circumstances are that raise the error (we have tried adding string values to the column), and we have been unable to recreate it from a clean bundle, but the code itself is definitely wrong.

Steps to reproduce it:

1. Set the following property in the portal-ext.properties for 6.2:

   journal.article.force.autogenerate.id=false

2. Startup your 6.2 server
3. Create a web content and set a non numeric string as id
4. Upgrade to DXP.

(you can also reproduce it without an upgrade setting the property journalArticleForceAutogenerateId from com.liferay.journal.web.configuration.JournalWebConfiguration to false and executing the JournalServiceVerifyProcess)

Results:
You will get an SQL exception truncating that field into a Long in JournalServiceVerifyProcess

Expected results:
No exceptions is thrown