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

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)

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,

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

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

@ 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