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

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

    Details

      Description

      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
       

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 24 weeks, 3 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP20
                  7.0.3 CE GA4
                  7.0.0 DXP SP4
                  7.0.X EE
                  7.1.X
                  Master