Error "Component Mapping without constant value or columns is not valid for component 'DD_ID' with parent '50175'"
NB! The request is urgent as @dbarraclough99 needs to make a drilldown demo tomorrow
We have an issue with data uploads to the Dataflow OECD.DAF:DSD_DEBT_TRANS_DDOWN@DF_DDOWN(1.0) in OECD-design and OECD-staging. The e-mail says: Component Mapping without constant value or columns is not valid for component 'DD_ID' with parent '50175'.
Structure deletion and cleanup doesn't help, the error still occurs after you re-upload the structures.
Structure and data upload of the same files in staging:SIS-CC-stable and QA spaces works fine.
Exception from the logs:
"exception": "Estat.Sri.Mapping.Api.Exceptions.ValidationException: Component Mapping without constant value or columns is not valid for component 'DD_ID' with parent '50175'\n at Estat.Sri.Mapping.MappingStore.Engine.ComponentMappingPersistenceEngine.Add(ComponentMappingEntity componentMappingEntity)\n at Estat.Sri.Mapping.MappingStore.Engine.UserActionEngine
1.Add(TPermissionEntity entity)\n at Estat.Sri.Mapping.Api.Manager.EntityPersistenceManager.Add[TEntity](TEntity entity)\n at Estat.Sri.Mapping.Api.Manager.EntityPersistenceManager.AddEntities[TEntity](IEnumerable
1 entities)\n at DotStat.MappingStore.MappingStoreDataAccess.SaveMappings(String storeId, String mappingSetId, String dataSetId, IEnumerable1 components)\n at DotStat.MappingStore.MappingStoreDataAccess.CreateOrUpdateMappingSet(String dataSpace, Dataflow dataFlow, Char targetVersion, Nullable
1 validFrom, Nullable1 validTo, String query)\n at DotStat.Db.Repository.SqlServer.SqlTransactionRepository.ManageDataflowMappingsets(Dataflow dataFlow, IMappingStoreDataAccess mappingStoreDataAccess, IDataStoreRepository dataStoreRepository)\n at DotStat.Db.Repository.SqlServer.SqlTransactionRepository.InitializeDataflowEmptyMappingsets(Dataflow dataFlow, IManagementRepository mgmtRepository, IMappingStoreDataAccess mappingStoreDataAccess)\n at DotStat.Db.Repository.SqlServer.SqlTransactionRepository.TryNewTransaction(Int32 transactionId, Dataflow dataflow, IMappingStoreDataAccess mappingStoreDataAccess, TargetVersion transferTargetVersion, Boolean isRollbackOrRestore, DotStatPrincipal principal)\n at DotStat.Transfer.Consumer.SqlConsumer.Save(ITransferParam transferParam, Dataflow dataflow, TransferContent transferContent, IManagementRepository mgmtRepository, ITransactionRepository transRepository, IDataStoreRepository dataStoreRepository, ISqlDatasetAttributeDatabaseValidator datasetAttributeDatabaseValidator, IDatasetAttributeValidator datasetAttributeValidator, IKeyableDatabaseValidator keyableDatabaseValidator, ICodeTranslator codeTranslator) in /app/DotStat.Transfer/Consumer/SqlConsumer.cs:line 150\n at DotStat.Transfer.Consumer.SqlConsumer.Save(ITransferParam transferParam, Dataflow dataflow, TransferContent transferContent) in /app/DotStat.Transfer/Consumer/SqlConsumer.cs:line 79\n at DotStat.Transfer.Manager.SdmxFileToSqlTransferManager.Transfer(SdmxFileToSqlTransferParam transferParam) in /app/DotStat.Transfer/Manager/SdmxFileToSqlTransferManager.cs:line 35\n at DotStatServices.Transfer.Controllers.ImportController.<>c__DisplayClass17_0
1.<b__0>d.MoveNext() in /app/DotStatServices.Transfer/Controllers/ImportController.cs:line 355"
OECD.DAF-DSD_DEBT_TRANS_DDOWN_DF_DDOWN-1.0-all.xml DSD_DEBT_TRANS_COLL_DF_COLL_100_random_data_10_dates_Drilldown_-_Copy.csv OECD.DAF-DSD_DEBT_TRANS_DDOWN_DF_DDOWN-1.0-data.xml