issue in deploying migration table

[dracovoldy]

Tutorials: https://developers.sap.com/tutorials/hana-cloud-collaborative-database-development-3.html

Step 3 "Recreate the table using an HDBMIGRATIONTABLE object" cannot be completed as it gives the following error during deploy.

Error: "db://INVENTORY": the object cannot be provided more than once [8212002]
"src/inventory.hdbmigrationtable": the file would provide it
"src/inventory.hdbtable": the deployed file already provides it
Error: Could not compose a consistent make graph [8212012]
Error: Calculating dependencies... failed [8212108]
Make failed (4 errors, 0 warnings): tried to deploy 1 files, undeploy 0 files, redeploy 0 dependent files
Error: Making... failed [8211605]

Project structure screenshot to confirm that all steps were followed including renaming of hdbtable to hdbtable.txt

Full Error log:

@sap/hdi-deploy, version 4.3.0 (mode default), server version 4.00.000.00.1646729894 (4.0.0.0), node version 14.17.6, HDI version 1007, container API version 1004
Deployment started at 2022-03-18 15:48:16
Using default environment variables from file "default-env.json"
No ignore file at /home/user/projects/WS3_1/db/.hdiignore.
Collecting files...
Collecting files... ok (0s 2ms)
1 directories collected
2 files collected
0 reusable modules collected
Target service: WS3_1-hdidb-ws-wqz88
Session variable APPLICATION is set to "SAP_HDI//".
Previous build with request ID 53 finished at 2022-03-18 15:47:25.106657000 with status Finished and message: Make failed (4 errors, 0 warnings): tried to deploy 1 files, undeploy 0 files, redeploy 0 dependent files.
Processing revoke files...
Processing revoke files... ok (0s 0ms)
Processing grants files...
Processing grants files... ok (0s 0ms)
Preprocessing files...
Preprocessing files... ok (0s 0ms)
Connecting to the container "WS3_1_HDI_DB_1"...
Connecting to the container "WS3_1_HDI_DB_1"... ok (0s 132ms)
Locking the container "WS3_1_HDI_DB_1"...
Locking the container "WS3_1_HDI_DB_1"... ok (0s 169ms)
Synchronizing files with the container "WS3_1_HDI_DB_1"...
  Deleting files...
  Deleting files... ok
  Writing files...
  Writing files... ok
Synchronizing files with the container "WS3_1_HDI_DB_1"... ok (0s 377ms)
added files: [ 'src/inventory.hdbmigrationtable' ]
modified files: []
deleted files: [ 'src/inventory.hdbtable', 'src/inventory.hdbtable.txt' ]
1 modified or added files are scheduled for deploy based on delta detection
0 deleted files are scheduled for undeploy based on delta detection (filtered by undeploy allowlist)
1 files are scheduled for deploy based on explicit specification
0 files are scheduled for undeploy based on explicit specification
Deploying to the container "WS3_1_HDI_DB_1"...
 Starting make in the container "WS3_1_HDI_DB_1" with 1 files to deploy, 0 files to undeploy... 
  Disabling table replication for the container schema "WS3_1_HDI_DB_1"... 
  Disabling table replication for the container schema "WS3_1_HDI_DB_1"... ok  (0s 101ms)
  Migrating libraries... 
  Migrating libraries... ok  (0s 8ms)
  Making... 
   Preparing... 
   Preparing the make transaction... 
   Adding "src/inventory.hdbmigrationtable" for deploy... 
   Adding "src/inventory.hdbmigrationtable" for deploy... ok  (0s 9ms)
   Preparing... ok  (0s 25ms)
   Preparing the make transaction... ok  (0s 70ms)
   Calculating dependencies... 
    Expanding... 
     Expanding "src/inventory.hdbmigrationtable"... 
     Expanding "src/inventory.hdbmigrationtable"... ok  (0s 6ms)
    Expanding... ok  (0s 23ms)
    Precompiling... 
     Precompiling "src/inventory.hdbmigrationtable"... 
     Precompiling "src/inventory.hdbmigrationtable"... ok  (0s 6ms)
    Precompiling... ok  (0s 17ms)
    Merging... 
    Merging... ok  (0s 6ms)
    Error: "db://INVENTORY": the object cannot be provided more than once [8212002]
     "src/inventory.hdbmigrationtable": the file would provide it 
     "src/inventory.hdbtable": the deployed file already provides it 
    Error: Could not compose a consistent make graph [8212012]
   Error: Calculating dependencies... failed [8212108]
   Make failed (4 errors, 0 warnings): tried to deploy 1 files, undeploy 0 files, redeploy 0 dependent files 
  Error: Making... failed [8211605]
 Error: Starting make in the container "WS3_1_HDI_DB_1" with 1 files to deploy, 0 files to undeploy... failed [8214168]
Deployment to container WS3_1_HDI_DB_1 failed - error: HDI make failed [Deployment ID: none].
Deployment ended at 2022-03-18 15:48:18
Error: HDI make failed
(2s 237ms)

[VolkerSaggau]

An hdbmigrationtable object can take over the hdbtable object. Renaming the inventroy.hdbtable to inventory.hdbtable .txt will make this declaration out of scope. (all .txt objects are treated as "neutral" objects)
The HDI will now see that there is a run-time objects inventory but the design time has changed and change the ownership.
It looks to me that you have not "neutralized" the old inventroy.hdbtable.
As a result you have now 2 definitions for the same run-time object. Can you please verify.
BR Volker

[MichaelCzcz]

Thank you for your feedback. We haven't heard from you in a while, so we are closing the issue.

If you still have questions, feel free to reopen the issue.