HANA XSA Deployment to Quality not working

[gmitrani]

Hi Experts,

I am trying to deploy a MTA application ( HDB Module only ) to Quality landscape using XS CLI ( XS_CLIENT00P_116-70001791 ) and it is not working. It works perfect in Development landscape which is same version has Quality ( HDB 2.00.040.00.1553674765 ).

I am putting a relevant excerpt from the log below -

#2.0#2019 08 02 16:19:32.337#+02:00#DEBUG#com.sap.cloud.lm.sl.xs2.20559.codi-sl-db.stageAppTask#
######com.sap.cloud.lm.sl.cf.persistence.services.ProcessLogger########flowable-async-job-executor-thread-2###
[PollStageAppStatusExecution] [codi-sl-db]  [Fri Aug 02 15:11:47 CEST 2019]        at "src/data/tableData/REGION_AREA.hdbtabledata" (0:0) (STDOUT, APP/1-0/deploy)#


#2.0#2019 08 02 16:19:32.338#+02:00#DEBUG#com.sap.cloud.lm.sl.xs2.20559.codi-sl-db.stageAppTask#
######com.sap.cloud.lm.sl.cf.persistence.services.ProcessLogger########flowable-async-job-executor-thread-2###
[PollStageAppStatusExecution] [codi-sl-db]  [Fri Aug 02 15:11:47 CEST 2019]     Warning: Worker 14 running the "com.sap.hana.di.tabledata" plugin has encountered an error while deploying 1 objects [8212030] (STDOUT, APP/1-0/deploy)#


#2.0#2019 08 02 16:19:32.338#+02:00#DEBUG#com.sap.cloud.lm.sl.xs2.20559.codi-sl-db.stageAppTask#
######com.sap.cloud.lm.sl.cf.persistence.services.ProcessLogger########flowable-async-job-executor-thread-2###
[PollStageAppStatusExecution] [codi-sl-db]  [Fri Aug 02 15:11:47 CEST 2019]      Warning: com.sap.hana.di.tabledata: Could not get the import settings from the key table "sl.data.table.masterData::TEAM" and the file "" [8251553] (STDOUT, APP/1-0/deploy)#


#2.0#2019 08 02 16:19:32.338#+02:00#DEBUG#com.sap.cloud.lm.sl.xs2.20559.codi-sl-db.stageAppTask#
######com.sap.cloud.lm.sl.cf.persistence.services.ProcessLogger########flowable-async-job-executor-thread-2###
[PollStageAppStatusExecution] [codi-sl-db]  [Fri Aug 02 15:11:47 CEST 2019]       Warning: com.sap.hana.di.tabledata: Database error 591: : connection is poisoned due to transaction errors; statement was rejected (920) [8201003] (STDOUT, APP/1-0/deploy)#


#2.0#2019 08 02 16:19:32.338#+02:00#DEBUG#com.sap.cloud.lm.sl.xs2.20559.codi-sl-db.stageAppTask#
######com.sap.cloud.lm.sl.cf.persistence.services.ProcessLogger########flowable-async-job-executor-thread-2###
[PollStageAppStatusExecution] [codi-sl-db]  [Fri Aug 02 15:11:47 CEST 2019]      Error: com.sap.hana.di.tabledata: Access to the runtime container "SL#DI" is blocked due to transaction errors [8207011] (STDOUT, APP/1-0/deploy)#

it gives me error related to hdbtabledata plugin which I don't understand because it works perfectly in development.

Things already tried -

1) Changing version of XS CLI to deploy.

2) Using Latest working version of XS CLI.

3) Changing plugin version in hdiconfig (2.0.40.0 tried ).

4) Checking all dependencies and maintaining them in Quality.

If someone has faced any similar situation, any help would be highly helpful.

Thanks!

Gaurav

[gmitrani]

The XS CLI log doesn't give the root cause of the issue and that was the problem. After checking the diserver traces we found the origin of the problem was at a different point which lead us to the solution and we solved it.