Message Boards

RE: upgrade DB 6.2.10 to 7.1.2-ga3 using tool db_upgradet - UpgradeDocumen

thumbnail
Suresh Nimmakayala, modified 2 Years ago.

upgrade DB 6.2.10 to 7.1.2-ga3 using tool db_upgradet - UpgradeDocumentLib

Liferay Master Posts: 690 Join Date: 8/17/04 Recent Posts
i am trying to ugrade db using db_upgrade 

upgrade process has stopped at  

Caused by: java.lang.NullPointerException
    at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary._updateLongFileNames(UpgradeDocumentLibrary.java:562)
    at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileVersionFileNames

2019-03-02 04:39:12.488 INFO  [main][UpgradeProcess:103] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId in 395790ms
2019-03-02 04:39:12.511 INFO  [main][UpgradeProcess:86] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary
2019-03-02 04:39:12.511 INFO  [main][LoggingTimer:72] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileEntryFileNames
2019-03-02 04:39:17.452 INFO  [main][LoggingTimer:38] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileEntryFileNames in 4941 ms
2019-03-02 04:39:17.453 INFO  [main][LoggingTimer:72] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileEntryTypeNamesAndDescriptions
2019-03-02 04:39:18.403 INFO  [main][LoggingTimer:38] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileEntryTypeNamesAndDescriptions in 950 ms
2019-03-02 04:39:18.403 INFO  [main][LoggingTimer:72] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileEntryTypeDDMStructureLinks
2019-03-02 04:39:20.207 INFO  [main][LoggingTimer:38] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileEntryTypeDDMStructureLinks in 1804 ms
2019-03-02 04:39:20.207 INFO  [main][LoggingTimer:72] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileVersionFileNames
2019-03-02 04:39:25.731 INFO  [main][LoggingTimer:38] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileVersionFileNames in 5524 ms
2019-03-02 04:39:25.731 INFO  [main][UpgradeProcess:103] Failed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary in 13220ms
2019-03-02 04:39:25.732 INFO  [main][UpgradeProcess:103] Failed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 837425ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.NullPointerException
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:97)
    at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
    at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
    at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
    at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:171)
    at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
    at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:155)
    at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:101)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.NullPointerException
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:97)
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:122)
    at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:77)
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:92)
    ... 12 more
Caused by: java.lang.NullPointerException
    at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary._updateLongFileNames(UpgradeDocumentLibrary.java:562)
    at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileVersionFileNames(UpgradeDocumentLibrary.java:388)
    at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:109)
    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:92)
    ... 15 more

 is it about long file names ?

based on above log  updateFileVersionFileNames is completed, so it's all about updateLongFileNames, how to fix it ?

​​​​​​​

2019-03-02 04:39:20.207 INFO  [main][LoggingTimer:72] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileVersionFileNames
2019-03-02 04:39:25.731 INFO  [main][LoggingTimer:38] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary#updateFileVersionFileNames in 5524 ms



Regards
​​​​​​​Suresh
thumbnail
Suresh Nimmakayala, modified 2 Years ago.

RE: upgrade DB 6.2.10 to 7.1.2-ga3 using tool db_upgradet - UpgradeDocumen

Liferay Master Posts: 690 Join Date: 8/17/04 Recent Posts
just a update i have tried to shorten long title names and tried to run 2-3 times doesn't work,
so i want to see what other  problems so have deleted all data from following tables
DLFileEntry
DLFileEntryMetadata
DLFileEntryType
DLFileEntryTypes_DDMStructures
DLFileRank
DLFileVersion
DLFolder
DLSyncEvent 

Guess  what happend 

"2019-03-02 10:05:37.504 INFO  [main][VerifyProcess:66] Verifying com.liferay.portal.security.ldap.internal.verify.LDAPPropertiesVerifyProcess
INFO - Verifying com.liferay.portal.security.ldap.internal.verify.LDAPPropertiesVerifyProcess
2019-03-02 10:05:37.505 INFO  [main][LoggingTimer:72] Starting com.liferay.portal.security.ldap.internal.verify.LDAPPropertiesVerifyProcess#verifyLDAPProperties
INFO - Starting com.liferay.portal.security.ldap.internal.verify.LDAPPropertiesVerifyProcess#verifyLDAPProperties
2019-03-02 10:05:37.506 INFO  [main][LoggingTimer:38] Completed com.liferay.portal.security.ldap.internal.verify.LDAPPropertiesVerifyProcess#verifyLDAPProperties in 1 ms
INFO - Completed com.liferay.portal.security.ldap.internal.verify.LDAPPropertiesVerifyProcess#verifyLDAPProperties in 1 ms
2019-03-02 10:05:37.506 INFO  [main][VerifyProcess:81] Completed verification process com.liferay.portal.security.ldap.internal.verify.LDAPPropertiesVerifyProcess in 2ms
INFO - Completed verification process com.liferay.portal.security.ldap.internal.verify.LDAPPropertiesVerifyProcess in 2ms

Completed Liferay core upgrade and verify processes in 6331 seconds"

 that means i need to do some investigation on DLFileEntry data , i have to check where it is breaking 


 when i check the release_ it is showing buildNumber as 7006

my Query is i am running  liferay-ce-portal-tools-7.1.2-ga3-20190107144105508, so the buildNumber should be 7120 ? 

any one shed me the light , do i need to run that separately or when i start Liferay Server, it will upgrade to 7120 ?

i didn't start the server yet

Regards
​​​​​​​Suresh
thumbnail
Suresh Nimmakayala, modified 2 Years ago.

RE: upgrade DB 6.2.10 to 7.1.2-ga3 using tool db_upgradet - UpgradeDocumen

Liferay Master Posts: 690 Join Date: 8/17/04 Recent Posts
after core upgrade i have issued 
upgrade:executeAll command from cmd prompt 

​​​​​​​upgrade:check
There is an upgrade process available for com.liferay.site.my.sites.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.item.selector.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.contacts.service from 0.0.0 to 2.0.2
There is an upgrade process available for com.liferay.login.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.calendar.web from 0.0.1 to 1.0.1
There is an upgrade process available for com.liferay.site.navigation.menu.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.nested.portlets.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.invitation.invite.members.service from 0.0.0 to 1.0.1
There is an upgrade process available for com.liferay.journal.content.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.journal.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.blogs.recent.bloggers.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.mobile.device.rules.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.social.user.statistics.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.asset.display.web from 0.0.0 to 1.0.0
There is an upgrade process available for com.liferay.hello.world.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.plugins.admin.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.xsl.content.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.blogs.layout.prototype from 0.0.0 to 1.0.1
There is an upgrade process available for com.liferay.sync.service from 1.0.0 to 1.0.4
There is an upgrade process available for com.liferay.asset.categories.navigation.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.portlet.configuration.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.portal.instances.service from 0.0.0 to 1.0.0
There is an upgrade process available for com.liferay.flags.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.sync.web from 0.0.0 to 1.0.0
There is an upgrade process available for com.liferay.rss.web from 0.0.1 to 3.0.0
There is an upgrade process available for com.liferay.social.activities.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.wiki.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.product.navigation.product.menu.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.dynamic.data.lists.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.portal.scheduler.quartz from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.iframe.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.blogs.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.directory.web from 0.0.1 to 1.0.1
There is an upgrade process available for com.liferay.bookmarks.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.staging.bar.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.wiki.service from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.site.navigation.breadcrumb.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.license.manager.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.contacts.web from 0.0.0 to 1.0.1
There is an upgrade process available for com.liferay.comment.page.comments.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.asset.publisher.layout.prototype from 0.0.0 to 1.0.1
There is an upgrade process available for com.liferay.trash.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.announcements.web from 0.0.1 to 1.0.3
There is an upgrade process available for com.liferay.document.library.layout.set.prototype from 0.0.0 to 1.0.0
There is an upgrade process available for com.liferay.portal.search.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.journal.content.search.web from 0.0.1 to 1.0.1
There is an upgrade process available for com.liferay.recent.documents.web from 0.0.1 to 1.0.1
There is an upgrade process available for com.liferay.document.library.service from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.image.uploader.web from 0.0.0 to 1.0.0
There is an upgrade process available for com.liferay.site.navigation.language.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.marketplace.service from 1.0.0 to 2.0.2
There is an upgrade process available for com.liferay.site.browser.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.microblogs.service from 0.0.0 to 1.0.2
There is an upgrade process available for com.liferay.portal.settings.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.flags.service from 0.0.0 to 2.0.1
There is an upgrade process available for com.liferay.social.group.statistics.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.message.boards.layout.set.prototype from 0.0.0 to 1.0.0
There is an upgrade process available for com.liferay.exportimport.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.social.activity.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.dynamic.data.mapping.web from 0.0.0 to 1.0.0
There is an upgrade process available for com.liferay.site.navigation.directory.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.wiki.layout.prototype from 0.0.0 to 1.0.1
There is an upgrade process available for com.liferay.portlet.configuration.css.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.mobile.device.rules.service from 0.0.1 to 1.0.1
There is an upgrade process available for com.liferay.quick.note.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.social.requests.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.server.admin.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.portlet.configuration.sharing.web from 0.0.0 to 1.0.0
There is an upgrade process available for com.liferay.asset.tags.compiler.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.bookmarks.service from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.microblogs.web from 0.0.1 to 1.0.1
There is an upgrade process available for com.liferay.document.library.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.monitoring.web from 0.0.0 to 1.0.0
There is an upgrade process available for com.liferay.message.boards.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.my.account.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.portal.workflow.kaleo.runtime.impl from 0.0.0 to 2.0.3
There is an upgrade process available for com.liferay.portal.lock.service from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.web.proxy.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.dynamic.data.mapping.service from 0.0.1 to 1.0.2
There is an upgrade process available for com.liferay.asset.browser.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.site.navigation.site.map.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.portal.background.task.service from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.portal.instances.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.polls.service from 0.0.1 to 1.0.4
There is an upgrade process available for com.liferay.hello.velocity.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.notifications.web from 0.0.1 to 2.1.0
There is an upgrade process available for com.liferay.portal.security.service.access.policy.service from 0.0.0 to 2.0.13
There is an upgrade process available for com.liferay.portal.workflow.kaleo.service from 1.1.0 to 1.3.2
There is an upgrade process available for com.liferay.asset.tags.navigation.web from 0.0.1 to 1.0.0
There is an upgrade process available for com.liferay.calendar.service from 1.0.0 to 1.0.6
There is an upgrade process available for com.liferay.wiki.navigation.web from 0.0.0 to 1.0.1
There is an upgrade process available for com.liferay.ratings.page.ratings.web from 0.0.1 to 1.0.0
upgrade:executeAll

...

INFO - Completed upgrade process com.liferay.asset.publisher.web.upgrade.v1_0_0.UpgradePortletPreferences in 1153ms
INFO - Upgrading com.liferay.layout.admin.web.internal.upgrade.v_1_0_0.UpgradeLayout
INFO - Starting com.liferay.layout.admin.web.internal.upgrade.v_1_0_0.UpgradeLayout#updateLayouts
INFO - Completed com.liferay.layout.admin.web.internal.upgrade.v_1_0_0.UpgradeLayout#updateLayouts in 222 ms
INFO - Completed upgrade process com.liferay.layout.admin.web.internal.upgrade.v_1_0_0.UpgradeLayout in 223ms
INFO - Upgrading com.liferay.layout.admin.web.internal.upgrade.v_1_0_1.UpgradeLayoutType
INFO - Completed upgrade process com.liferay.layout.admin.web.internal.upgrade.v_1_0_1.UpgradeLayoutType in 3ms
All modules were successfully upgraded
g!

still buildNumber is showing 
mysql> select buildNumber from release_ where servletContextName='portal';
+-------------+
| buildNumber |
+-------------+
|        7006 |
+-------------+
1 row in set (0.00 sec)
thumbnail
Alberto Chaparro, modified 2 Years ago.

RE: upgrade DB 6.2.10 to 7.1.2-ga3 using tool db_upgradet - UpgradeDocumen

Liferay Master Posts: 528 Join Date: 4/25/11 Recent Posts
Hi Suresh,

The portal release record is updated when the upgrade and verifiers run correctly. My guess is that you get some error in this process or the removal of those tables have caused a strange behaviour.

I recommend you to follow Jose's ticket to apply the final solution in the code or data somehow.

Best regards.
thumbnail
Jose Jimenez, modified 2 Years ago.

RE: upgrade DB 6.2.10 to 7.1.2-ga3 using tool db_upgradet - UpgradeDocumen

Regular Member Posts: 176 Join Date: 8/22/12 Recent Posts
Hi @Suresh, 

Could you confirm you are using Oracle DB?

This is a problem trying to load empty extension files in some databases that manage empty strings as nulls

I have addressed this issue and I am working in a fix: LPS-91476

Best regards,
thumbnail
Suresh Nimmakayala, modified 2 Years ago.

RE: upgrade DB 6.2.10 to 7.1.2-ga3 using tool db_upgradet - UpgradeDocumen

Liferay Master Posts: 690 Join Date: 8/17/04 Recent Posts
Hi Alberto  & Jose i am using mysql, and i didn't delete tables just deleted data,  checking all DL files for any problems, because this Liferay data is upgraded since or before 5.2 .

what i observed as jose said some records don't have extension, so i have added  extension, still breaking  same point

2019-03-05 00:16:43.466 INFO  [main][UpgradeProcess:103] Failed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary in 13097ms
2019-03-05 00:16:43.466 INFO  [main][UpgradeProcess:103] Failed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 525703ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.NullPointerException
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:97)
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:171)
        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:155)
        at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:101)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:483)
        at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.NullPointerException
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:97)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:122)
        at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:77)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:92)
        ... 12 more
Caused by: java.lang.NullPointerException
        at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary._updateLongFileNames(UpgradeDocumentLibrary.java:562)
        at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileVersionFileNames(UpgradeDocumentLibrary.java:388)
        at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:109)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:92)
        ... 15 more
thumbnail
Jose Jimenez, modified 2 Years ago.

RE: upgrade DB 6.2.10 to 7.1.2-ga3 using tool db_upgradet - UpgradeDocumen

Regular Member Posts: 176 Join Date: 8/22/12 Recent Posts
Hi Suresh,

the fix can not be done in the upgrade process because it is related with corrupted data in dLFileEntry that seems not to be generated by the Liferay UI itself, at least at the moment.

You can fix the title better than the extension, because the required field is the title and it should be enought for avoiding the problem with the extension.

For the new errors that you have found, it is better to start a different thread in the forum.

Best regards,
Jose
thumbnail
Suresh Nimmakayala, modified 2 Years ago.

RE: upgrade DB 6.2.10 to 7.1.2-ga3 using tool db_upgradet - UpgradeDocumen

Liferay Master Posts: 690 Join Date: 8/17/04 Recent Posts
@ Thanks Jose & Alberto

Finally db upgrade  core done ,

just an update for others , this thread might help

one more table i need to see is DLFileVersion and extension column, after i have updated extension core db is upgraded successfully 

however still buildNumber showing as 7006
​​​​​​​
mysql> select buildNumber from release_ where servletContextName='portal';
+-------------+
| buildNumber |
+-------------+
|        7006 |
+-------------+
1 row in set (0.00 sec)

so next i have  issued upgrade:executeAll to execute all pending module

then this error came : 

The following modules had errors while upgrading:
        com.liferay.journal.service
        com.liferay.sync.service
        com.liferay.dynamic.data.mapping.service

Use the command upgrade:list <module name> to get more details about the status of a specific upgrade.
g!
--------------
upgrade:list com.liferay.journal.service
Registered upgrade processes for com.liferay.journal.service 0.0.5-step-6
        {fromSchemaVersionString=0.0.0, toSchemaVersionString=1.0.2, upgradeStep=Initial Database Creation}
g!
-------------
upgrade:list com.liferay.sync.service
Registered upgrade processes for com.liferay.sync.service 1.0.2-step-1
        {fromSchemaVersionString=0.0.0, toSchemaVersionString=1.0.4, upgradeStep=Initial Database Creation}
        {fromSchemaVersionString=0.0.1, toSchemaVersionString=1.0.0, upgradeStep=com.liferay.portal.kernel.upgrade.DummyUpgradeStep@46f0bace}
        {fromSchemaVersionString=1.0.0, toSchemaVersionString=1.0.1, upgradeStep=com.liferay.portal.kernel.upgrade.DummyUpgradeStep@6ee6f7a6}
        {fromSchemaVersionString=1.0.1, toSchemaVersionString=1.0.2-step-1, upgradeStep=com.liferay.sync.internal.upgrade.v1_0_2.UpgradeSchema@7a4a159e}
        {fromSchemaVersionString=1.0.2, toSchemaVersionString=1.0.3, upgradeStep=com.liferay.sync.internal.upgrade.v1_0_3.UpgradeSchema@37537b12}
        {fromSchemaVersionString=1.0.2-step-1, toSchemaVersionString=1.0.2, upgradeStep=com.liferay.sync.internal.upgrade.v1_0_2.UpgradeSyncDLObject@74b681fc}
        {fromSchemaVersionString=1.0.3, toSchemaVersionString=1.0.4, upgradeStep=com.liferay.sync.internal.upgrade.v1_0_4.UpgradeSchema@2d34130b}
g!
------------

upgrade:list com.liferay.dynamic.data.mapping.service
Registered upgrade processes for com.liferay.dynamic.data.mapping.service 1.0.0-step-2
        {fromSchemaVersionString=0.0.0, toSchemaVersionString=1.0.2, upgradeStep=Initial Database Creation}
        {fromSchemaVersionString=0.0.1, toSchemaVersionString=0.0.2, upgradeStep=com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeSchema@5aae1744}
        {fromSchemaVersionString=0.0.2, toSchemaVersionString=0.0.3, upgradeStep=com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeKernelPackage@757472b7}
        {fromSchemaVersionString=0.0.3, toSchemaVersionString=1.0.0-step-2, upgradeStep=com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeCompanyId@14f1f59c}
        {fromSchemaVersionString=1.0.0, toSchemaVersionString=1.0.1, upgradeStep=com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_1.UpgradeResourcePermission@dbbce92}
        {fromSchemaVersionString=1.0.0-step-1, toSchemaVersionString=1.0.0, upgradeStep=com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeLastPublishDate@2705fc56}
        {fromSchemaVersionString=1.0.0-step-2, toSchemaVersionString=1.0.0-step-1, upgradeStep=com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeDynamicDataMapping@71b2d3cb}
        {fromSchemaVersionString=1.0.1, toSchemaVersionString=1.0.2, upgradeStep=com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_2.UpgradeDDMTemplateSmallImageURL@6a749574}

those are the modules had error while upgrading


​​​​​​​INFO - Failed upgrade process com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeDynamicDataMapping in 171661ms

Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: Model com.liferay.dynamic.data.lists.model.DDLRecordSet does not support DDM structure permission checking
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:97)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:129)
        at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfosRunnable.run(ReleaseManagerOSGiCommands.java:539)
        ... 33 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: Model com.liferay.dynamic.data.lists.model.DDLRecordSet does not support DDM structure permission checking
        at com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeDynamicDataMapping.getStructureModelResourceName(UpgradeDynamicDataMapping.java:473)
        at com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeDynamicDataMapping.upgradeStructurePermissions(UpgradeDynamicDataMapping.java:1096)
        at com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeDynamicDataMapping.upgradeStructuresPermissions(UpgradeDynamicDataMapping.java:1243)
        at com.liferay.dynamic.data.mapping.internal.upgrade.v1_0_0.UpgradeDynamicDataMapping.doUpgrade(UpgradeDynamicDataMapping.java:259)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:92)
        ... 35 more


​​​​​​​is anyone seen these kind of erros ?

appreciate for your Response,Thanks
Suresh