Hi Experts,
usually we are using this scrIpts (.hdbtabledata) to import the data in our tables. But since a couple of weeks we are struggling with a strange behaviour when using the .hdbtabledata.
After building the db module and using this script the data are loaded, everything is fine.
But after building the db module again, all the data are gone, although we have changed the parameter before to:
"no_data_import": true, "delete_existing_foreign_data": false,
But even if we take this script out of the db folder the data are gone. We were checking the whole folder more times, but there is no other hdbtabledata which could cause this.
We do have more hdbtabledata files, but only this one is causing this behaviour. Or more specific we can only see that the tables from this file are empty.
Our last idea was that there was something already deployed and is now running when building the db module... But we tried it to undeploy (undeploy.json), in hope this would fix this issue... but didn't help us.
Expanded from "src/data/loads/A_Tables/A_Tables.hdbtabledata" Warning: com.sap.hana.di.tabledata: No "include_filter" is specified; it's strongly recommended to define an "include_filter" to also allow other table imports into the table; if no other table imports are intended, please specify at least an empty "include_filter" [8251576] at "src/data/loads/A_Tables/A_Tables.hdbtabledata" (0:0) Suppressed data import for data source file "TBASE.db.data.loads.A_Tables::A_Kennzahl.csv" into the target table "TBASE.db.data::tbase.cds.md.A_Kennzahl" Deploying "src/data/loads/A_Tables/A_Tables.hdbtabledata$13.expand"... ok
Suppressed data import for data source file "TBASE.db.data.loads.A_Tables::A_Kennzahl.csv --> but the table is empty
{
"format_version": 1,
"imports": [
{
"target_table": "TBASE.db.data::tbase.cds.md.A_Kennzahl",
"source_data": {
"data_type": "CSV",
"file_name": "TBASE.db.data.loads.A_Tables::A_Kennzahl.csv",
"has_header": true,
"no_data_import": true,
"delete_existing_foreign_data": false,
"dialect": "HANA",
"type_config": {
"delimiter": ","
}
},
"import_settings": {
"import_columns": [
"KennzahlID",
"Art"
]
}
}
]
}