Ask Questions and Find Answers

I was able to circumvent the issue by making sure that /global is for classNameid's whihc point to company and not for organization type .In my db there were some  Gorup_ records with multiple /global entries , i cleared away those

Thanks @Rajesh for clarifying the issue.
At first glance it seemed that the failure was caused because the friendlyUrl which was initially null was set as global but there is another group with the global friendlyURL and that's not possible.
Please, be sure that the global site maintains the global friendlyUrl.
I hope the issue is solved after what you did.
Cheers!

I was able to resolve major issues but i am getting lot of warnings like the below which make me think i need to keep data folder within Liferay bundle so that these dont appear , also please confirm if i need to add some portal ext properties for doc lib path etc:
14:57:06,946 WARN [localhost-startStop-1][VerifyDocumentLibrary:279] Unable to find file version 1.0 for file entry 1927781com.liferay.portlet.documentlibrary.NoSuchFileException: D:\LiferayHome\62\liferay-portal-6.2-ce-ga3\data\document_library\10026\665455589\1927781\1.0 at com.liferay.portlet.documentlibrary.store.FileSystemStore.getFileAsStream(FileSystemStore.java:215) at com.liferay.portlet.documentlibrary.store.StoreProxyImpl.getFileAsStream(StoreProxyImpl.java:178) at com.liferay.portlet.documentlibrary.store.SafeFileNameStoreWrapper.getFileAsStream(SafeFileNameStoreWrapper.java:264) at com.liferay.portlet.documentlibrary.store.DLStoreImpl.getFileAsStream(DLStoreImpl.java:300) at com.liferay.portlet.documentlibrary.store.DLStoreUtil.getFileAsStream(DLStoreUtil.java:452) at com.liferay.portlet.documentlibrary.service.impl.DLFileEntryLocalServiceImpl.getFileAsStream(DLFileEntryLocalServiceImpl.java:1005) at com.liferay.portlet.documentlibrary.service.impl.DLFileEntryLocalServiceImpl.getFileAsStream(DLFileEntryLocalServiceImpl.java:984) at sun.reflect.GeneratedMethodAccessor405.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498)

Also let me know if data folder is not provided , can we circumvent the above issue ?

https://issues.liferay.com/browse/LPS-94541  mentions the issue fix but when i picked the jar and put it in lib path of tomcat and still the error couldnot go away.
Can you help me identify if the authorization for s3 access on AWS can be changed to AWS4-HMAC-SHA256 for a bucket general-dms-bucket name ?I am using the liferay-portal-6.2-ce-ga3 bundle and trying to upgrade DB from 6.1 to 6.2.We are storing docs on s3 so trying to refer to those while db upgrade is run  with following config in portal-ext:
-------
jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.default.url=jdbc:sqlserver://localhost;databaseName=Resilience
jdbc.default.username=sa
jdbc.default.password=Itsc1809passwords.encryption.algorithm.legacy=SHA#Set this to true to disable database transaction management during upgrades. This forces autocommit, which will speed up the upgrade process
upgrade.database.transactions.disabled=true
#Set the maximum size for a file's indexable content. Files larger than this property will only have this amount of their content indexed. A value of -1 indicates that all of a file's #content will be indexed. A value of 0 indicates that none of the file's content will be indexed.
dl.file.indexing.max.size=0
#s3 settings
dl.store.impl=com.liferay.portlet.documentlibrary.store.S3Store
dl.store.s3.access.key=ADDHCiddddkddkdGHskdls
dl.store.s3.secret.key=TYskss9903mJjjHHHHGFD
dl.store.s3.bucket.name=general-dms-bucket

---------
The DB upgrade terminates in between due to this with below exception -Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: org.jets3t.service.S3ServiceException: S3 Error Message. -- ResponseCode: 400, ResponseStatus: Bad Request, XML Error Message: <?xml version="1.0" encoding="UTF-8"?><Error><Code>InvalidRequest</Code><Message>The authorization mechanism you have provided is not supported. Please use AWS4-HMAC-SHA256.</Message><RequestId>34F2GGsfssl88D34FE7</RequestId><HostId>3T9777KKKQoHJKFLLGLLbBBIHSaLV43tJ7mU7hMZE=</HostId></Error>at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:170)at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:162)at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:114)at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:94)at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:138)at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61)at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143)at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:180)at com.liferay.portal.events.StartupAction.run(StartupAction.java:73)... 19 moreCaused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: org.jets3t.service.S3ServiceException: S3 Error Message. -- ResponseCode: 400, ResponseStatus: Bad Request, XML Error Message: <?xml version="1.0" encoding="UTF-8"?><Error><Code>InvalidRequest</Code><Message>The authorization mechanism you have provided is not supported. Please use AWS4-HMAC-SHA256.</Message><RequestId>34F2BA7688D34FE7</RequestId><HostId>3T9QoI99uThblc1ti2z45obBBIHSaLGFY5P0rM7XspkCaQbE5YORUXkYTI3JGRV43tJ7mU7hMZE=</HostId></Error>at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:170)

I was able to migrate the 6.1 DB to 6.2 and then i proceeded with 7.2 migration.Everything was moving ahead smoothly but now the VerifyPermission is executing.This step has taken more than 24 hours and has not yet finished.I wanted to know how much time it usually take?2020-05-16 16:53:23.608 INFO  [main][VerifyProcess:80] Completed verification process com.liferay.portal.verify.VerifyProperties in 277 ms
2020-05-16 16:53:23.609 INFO  [main][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyPermission

Hi Rajesh,
The verifyPermission process usually takes time but there are some ways to try to speed it up. Can you take a look a the upgrade performance benchmark and see if you can apply some of the recommendations included there?
https://www.liferay.com/resource?folderId=3292406&title=Liferay+DXP+7.1+Upgrade+Performance+Benchmark

The benchmark contains Liferay 7.1 data but it applies to all Liferay versions.
I hope it helps.
Cheers!

Hi Rajesh,Regarding your question:

Do i need to again run that during DXP step or i can skip in DXP stage with value  verify.frequency=0

Maybe you don't need to execute it again, but it's better if only disable the ResourcePermission, you have to add this instead:

verify.processes=com.liferay.portal.verify.VerifyProperties,\
com.liferay.portal.verify.VerifyPermission,\
com.liferay.portal.verify.VerifyGroup,\
com.liferay.portal.verify.VerifyAuditedModel,\
com.liferay.portal.verify.VerifyResourceActions,\
com.liferay.portal.verify.VerifyUser

Hi Rajesh,
Sorry, I made a mistake in the property value, I remove verifyResourcePermission instead of VerifyPermission, this will be the proper value:

verify.processes=com.liferay.portal.verify.VerifyProperties,\
com.liferay.portal.verify.VerifyGroup,\
com.liferay.portal.verify.VerifyAuditedModel,\
com.liferay.portal.verify.VerifyResourceActions,\
com.liferay.portal.verify.VerifyResourcePermissions,\
com.liferay.portal.verify.VerifyUser

Can you repeat the upgrade with that property in portal-upgrade-ext.properties?

Thanks.

Yes Alberto I will do the same and update on the outcome.Thanks once again

Hi Alberto
I am getting below error now
2020-05-22 03:37:07.079 ERROR [main][DBUpgrader:114] Unable to execute verify process: java.lang.Exception: Verification error: com.liferay.portal.verify.VerifyResourcePermissions
com.liferay.portal.verify.VerifyException: java.lang.Exception: Verification error: com.liferay.portal.verify.VerifyResourcePermissions
 at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:74)
 at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
 at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
 at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
 at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:163)
 at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:89)
 at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:246)
 at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:109)
 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:498)
 at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
Caused by: java.lang.Exception: Verification error: com.liferay.portal.verify.VerifyResourcePermissions
 at com.liferay.portal.verify.VerifyProcess.doVerify(VerifyProcess.java:122)
 at com.liferay.portal.verify.VerifyResourcePermissions.verify(VerifyResourcePermissions.java:72)
 at com.liferay.portal.verify.VerifyResourcePermissions.doVerify(VerifyResourcePermissions.java:84)
 at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:71)
 ... 12 more
Caused by: com.liferay.portal.kernel.exception.NoSuchResourceActionException: com.liferay.portal.kernel.model.Group#PUBLISH_PORTLET_INFO
 at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.getResourceAction(ResourceActionLocalServiceImpl.java:321)
 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:498)
 at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
 at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
 at com.sun.proxy.$Proxy98.getResourceAction(Unknown Source)
 at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl._updateResourcePermission(ResourcePermissionLocalServiceImpl.java:2072)
 at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.addResourcePermissions(ResourcePermissionLocalServiceImpl.java:369)
 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:498)
 at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
 at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
 at com.sun.proxy.$Proxy97.addResourcePermissions(Unknown Source)
 at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:266)
 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:498)
 at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
 at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
 at com.sun.proxy.$Proxy106.addResources(Unknown Source)
 at com.liferay.portal.kernel.service.ResourceLocalServiceUtil.addResources(ResourceLocalServiceUtil.java:215)
 at com.liferay.portal.verify.VerifyResourcePermissions._verifyResourcedModel(VerifyResourcePermissions.java:154)
 at com.liferay.portal.verify.VerifyResourcePermissions._verifyResourcedModel(VerifyResourcePermissions.java:196)
 at com.liferay.portal.verify.VerifyResourcePermissions.access$100(VerifyResourcePermissions.java:48)
 at com.liferay.portal.verify.VerifyResourcePermissions$VerifyResourcedModelCallable.call(VerifyResourcePermissions.java:211)
 at com.liferay.portal.verify.VerifyResourcePermissions$VerifyResourcedModelCallable.call(VerifyResourcePermissions.java:207)
 at com.liferay.petra.function.UnsafeConsumer.accept(UnsafeConsumer.java:42)
 at com.liferay.petra.function.UnsafeConsumer.accept(UnsafeConsumer.java:30)
 at com.liferay.portal.verify.VerifyProcess.doVerify(VerifyProcess.java:104)
 ... 15 more
com.liferay.portal.verify.VerifyException: java.lang.Exception: Verification error: com.liferay.portal.verify.VerifyResourcePermissions
 at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:74)
 at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
 at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
 at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
 at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:163)
 at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:89)
 at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:246)
 at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:109)
 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:498)
 at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
Caused by: java.lang.Exception: Verification error: com.liferay.portal.verify.VerifyResourcePermissions
 at com.liferay.portal.verify.VerifyProcess.doVerify(VerifyProcess.java:122)
 at com.liferay.portal.verify.VerifyResourcePermissions.verify(VerifyResourcePermissions.java:72)
 at com.liferay.portal.verify.VerifyResourcePermissions.doVerify(VerifyResourcePermissions.java:84)
 at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:71)
 ... 12 more
Caused by: com.liferay.portal.kernel.exception.NoSuchResourceActionException: com.liferay.portal.kernel.model.Group#PUBLISH_PORTLET_INFO
 at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.getResourceAction(ResourceActionLocalServiceImpl.java:321)
 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:498)
 at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
 at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
 at com.sun.proxy.$Proxy98.getResourceAction(Unknown Source)
 at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl._updateResourcePermission(ResourcePermissionLocalServiceImpl.java:2072)
 at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.addResourcePermissions(ResourcePermissionLocalServiceImpl.java:369)
 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:498)
 at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
 at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
 at com.sun.proxy.$Proxy97.addResourcePermissions(Unknown Source)
 at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:266)
 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:498)
 at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
 at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
 at com.sun.proxy.$Proxy106.addResources(Unknown Source)
 at com.liferay.portal.kernel.service.ResourceLocalServiceUtil.addResources(ResourceLocalServiceUtil.java:215)
 at com.liferay.portal.verify.VerifyResourcePermissions._verifyResourcedModel(VerifyResourcePermissions.java:154)
 at com.liferay.portal.verify.VerifyResourcePermissions._verifyResourcedModel(VerifyResourcePermissions.java:196)
 at com.liferay.portal.verify.VerifyResourcePermissions.access$100(VerifyResourcePermissions.java:48)
 at com.liferay.portal.verify.VerifyResourcePermissions$VerifyResourcedModelCallable.call(VerifyResourcePermissions.java:211)
 at com.liferay.portal.verify.VerifyResourcePermissions$VerifyResourcedModelCallable.call(VerifyResourcePermissions.java:207)
 at com.liferay.petra.function.UnsafeConsumer.accept(UnsafeConsumer.java:42)
 at com.liferay.petra.function.UnsafeConsumer.accept(UnsafeConsumer.java:30)
 at com.liferay.portal.verify.VerifyProcess.doVerify(VerifyProcess.java:104)
 ... 15 more

g! upgrade:check
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.dynamic.data.mapping.service from 1.1.1 to 3.2.1

g! upgrade:execute com.liferay.marketplace.service
INFO - Upgrading com.liferay.marketplace.internal.upgrade.v1_0_0.UpgradeApp
INFO - Failed upgrade process com.liferay.marketplace.internal.upgrade.v1_0_0.UpgradeApp in 5 ms
ERROR - Failed upgrade process for module com.liferay.marketplace.service
com.liferay.portal.kernel.upgrade.UpgradeException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "Marketplace_App" because it does not exist or you do not have permissions.
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:137)
        at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:195)
        at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:121)
        at com.liferay.portal.upgrade.internal.executor.SwappedLogExecutor.execute(SwappedLogExecutor.java:47)
        at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:148)
        at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:117)
        at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.execute(ReleaseManagerOSGiCommands.java:142)
        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:498)
        at org.apache.felix.gogo.runtime.Reflective.invoke(Reflective.java:139)
        at org.apache.felix.gogo.runtime.CommandProxy.execute(CommandProxy.java:91)
        at org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:599)
        at org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:526)
        at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:415)
        at org.apache.felix.gogo.runtime.Pipe.doCall(Pipe.java:416)
        at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:229)
        at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:59)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "Marketplace_App" because it does not exist or you do not have permissions.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:845)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:752)
        at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:680)
        at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:117)
        at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
        at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:349)
        at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:315)
        at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:66)
        at com.liferay.marketplace.internal.upgrade.v1_0_0.UpgradeApp.updateModules(UpgradeApp.java:31)
        at com.liferay.marketplace.internal.upgrade.v1_0_0.UpgradeApp.doUpgrade(UpgradeApp.java:26)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
        ... 23 more

g! upgrade:execute com.liferay.dynamic.data.mapping.service
INFO - Upgrading com.liferay.dynamic.data.mapping.internal.upgrade.v1_1_2.UpgradeDynamicDataMapping
INFO - Failed upgrade process com.liferay.dynamic.data.mapping.internal.upgrade.v1_1_2.UpgradeDynamicDataMapping in 367 ms
ERROR - Failed upgrade process for module com.liferay.dynamic.data.mapping.service
com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.NullPointerException
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:137)
        at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:195)
        at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:121)
        at com.liferay.portal.upgrade.internal.executor.SwappedLogExecutor.execute(SwappedLogExecutor.java:47)
        at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:148)
        at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:117)
        at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.execute(ReleaseManagerOSGiCommands.java:142)
        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:498)
        at org.apache.felix.gogo.runtime.Reflective.invoke(Reflective.java:139)
        at org.apache.felix.gogo.runtime.CommandProxy.execute(CommandProxy.java:91)
        at org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:599)
        at org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:526)
        at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:415)
        at org.apache.felix.gogo.runtime.Pipe.doCall(Pipe.java:416)
        at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:229)
        at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:59)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException
        at com.liferay.dynamic.data.mapping.util.DDMFormValuesTransformer.transform(DDMFormValuesTransformer.java:45)
        at com.liferay.dynamic.data.mapping.internal.upgrade.v1_1_2.UpgradeDynamicDataMapping.transformDDMFormFieldValues(UpgradeDynamicDataMapping.java:232)
        at com.liferay.dynamic.data.mapping.internal.upgrade.v1_1_2.UpgradeDynamicDataMapping.upgradeDDMContentReferences(UpgradeDynamicDataMapping.java:298)
        at com.liferay.dynamic.data.mapping.internal.upgrade.v1_1_2.UpgradeDynamicDataMapping.upgradeDDLDDMContentReferences(UpgradeDynamicDataMapping.java:278)
        at com.liferay.dynamic.data.mapping.internal.upgrade.v1_1_2.UpgradeDynamicDataMapping.doUpgrade(UpgradeDynamicDataMapping.java:123)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
        ... 23 more

Hi Rajesh,
The error in the verifyResourcePermission is probably caused because of not running verifyPermission before. As I said earlier probably the best approach is that you take a look at the following performance benchmark:
https://www.liferay.com/resource?folderId=3292406&title=Liferay+DXP+7.1+Upgrade+Performance+Benchmark

And execute at least the following things before the upgrade:

• Clean up the database: remove useless data that you don't need anymore, you will save a lot of time during and after the upgrade and you will prevent a lot of issues.

• Configure your database accordingly for the upgrade: that document includes some useful tips and configurations for this.

For your case, a big database and coming from 6.1, these steps are required. We can check other errors later after the clean up.


Thanks.