Affects Version/s: 7.0.X EE, Master
Component/s: Collaboration > Upgrade
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:
- Set the following property in the portal-ext.properties for 6.2:
- Startup your 6.2 server
- Create a web content and set a non numeric string as id
- 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)
You will get an SQL exception truncating that field into a Long in JournalServiceVerifyProcess
No exceptions is thrown