Hi all,
We just want to transfer some changes to the factories crs and crsq from the Dev system into a test system and have already successfully exported both factories with db_promote export.
Now we want to import the corresponding data records into the target system with db_promote import.
The following errors occur in the dbpromote.log:
07/05 11:53:57.186[main] DEBUG root 130 Multi-tenancy is enabled and factory : crs is TENANT_OPTIONAL. Final secondary key: sym,tenant
07/05 11:53:57.186[main] DEBUG SlumpDataLoader 113 Got secondary keys for factory : crs >> sym,tenant
07/05 11:53:57.186[main] DEBUG SlumpDataLoader 134 Got default attribute for factory => sapolicy:is_default
07/05 11:53:57.186[main] ERROR SlumpDataLoader 1360 Unable to get where clause for attribute : tenant. Reason : attribute resolution failed, the related object might not exists.
07/05 11:53:57.186[main] ERROR SlumpDataLoader 1414 Error while importing record for persid : crs:5216. Reason : Unable to get where clause for attribute : tenant. Reason : attribute resolution failed, the related object might not exists.
07/05 11:53:57.186[main] DEBUG DataImportManager 1326 Import Status : 1 srcPersId : crs:5216 targetPersId :
07/05 11:53:57.186[main] DEBUG XmlInputReader 369 Getting data for current table cursor : 1 and row cursor : 0
07/05 11:53:57.186[main] ERROR SlumpDataLoader 1360 Unable to get where clause for attribute : tenant. Reason : attribute resolution failed, the related object might not exists.
07/05 11:53:57.186[main] ERROR SlumpDataLoader 1414 Error while importing record for persid : crs:40002. Reason : Unable to get where clause for attribute : tenant. Reason : attribute resolution failed, the related object might not exists.
07/05 11:53:57.186[main] DEBUG DataImportManager 1326 Import Status : 1 srcPersId : crs:40002 targetPersId :
07/05 11:53:57.186[main] DEBUG XmlInputReader 369 Getting data for current table cursor : 1 and row cursor : 1
07/05 11:53:57.186[main] ERROR SlumpDataLoader 1360 Unable to get where clause for attribute : tenant. Reason : attribute resolution failed, the related object might not exists.
07/05 11:53:57.186[main] ERROR SlumpDataLoader 1414 Error while importing record for persid : crs:5218. Reason : Unable to get where clause for attribute : tenant. Reason : attribute resolution failed, the related object might not exists.
Our guess is that this is related to the tenant. If we look at the column "tenant" at data base level in both the source system and the target system, then the values on both sides are "NULL".
You see this error in line2 from log.
We are looking for a way to transfer the data records accordingly.
If you need more logs, please report them once.
I will attach the whole dbpromote.log to this case to, you should look at time frame 11:53:57 and later.
Kind regards,
Tobias Reichert