Data upload issues with non-coded dimensions (blocking issue!)
-
(high-critical) The transfer is unable to upload data and fails with the message “Object reference not set to an instance of an object.". The DSD contains many non-coded dimensions.
- All structures: ESCBSHS-ESCBSHS_SHS_ISIN_HOLDING-1.0-all.xml
- Small data: SHS_ISIN_Small_File_Data.csv
The Transfer logs says:
{ "level": "ERROR", "message": "Object reference not set to an instance of an object.", "exception": "System.NullReferenceException: Object reference not set to an instance of an object.\n at DotStat.Db.Engine.SqlServer.SqlDsdEngine.BuildDynamicDataDsdView(Dsd dsd, Char targetVersion, SqlDotStatDb dotStatDb, CancellationToken cancellationToken)\n at DotStat.Db.Engine.DsdEngineBase`1.CreateDynamicDbObjects(Dsd dsd, TDotStatDb dotStatDb, CancellationToken cancellationToken)\n at DotStat.Db.Repository.SqlServer.SqlArtefactRepository.VerifyAndCreateOrUpdateDynamicTables(Dsd dsd, Boolean factTableExists, CancellationToken cancellationToken)\n at DotStat.Db.Service.DotStatDbService.FillDbIdsAndCreateMissingDbObjects(IImportReferenceableStructure referencedStructure, IMappingStoreDataAccess mappingStoreDataAccess, CancellationToken cancellationToken, Boolean skipDsd, Boolean throwConcurrencyError)\n at DotStat.Db.Service.DotStatDbService.TryNewTransaction(Transaction transaction, IImportReferenceableStructure importReferenceStructure, IMappingStoreDataAccess mappingStoreDataAccess, CancellationToken cancellationToken, Boolean onlyLockTransaction)" }
This could be reproduced in QA with %dotstatsuiteNET@gingerbread patch 1.
-
(less-critical) The transfer is unable to upload data and fails with the message "There is a synchronisation issue between the structure and data database concerning the dimension FUNCTIONAL_CATEGORY (which has an invalid internal ID 0). Please (re-)initialise the data database content for the underlying dataflow using the Transfer service method '/init/dataflow'. If the problem persists then contact your system administrator.". The DSD contains many non-coded dimensions, of which one
FUNCTIONAL_CATEGORY
doesn't have a LocalRepresentation.- All structures: ESCBSHS-ESCBSHS_SHS_ISIN_HOLDING-1.0-all_without_localrepresentation.xml
- Small data: SHS_ISIN_Small_File_Data.csv
The Transfer logs says:
{ "level": "ERROR", "message": "There is a synchronisation issue between the structure and data database concerning the dimension FUNCTIONAL_CATEGORY (which has an invalid internal ID 0). Please (re-)initialise the data database content for the underlying dataflow using the Transfer service method '/init/dataflow'. If the problem persists then contact your system administrator.", "exception": "DotStat.Common.Exceptions.DotStatException: There is a synchronisation issue between the structure and data database concerning the dimension FUNCTIONAL_CATEGORY (which has an invalid internal ID 0). Please (re-)initialise the data database content for the underlying dataflow using the Transfer service method '/init/dataflow'. If the problem persists then contact your system administrator.\n at DotStat.Db.Engine.DimensionEngineBase`1.CleanUp(Dimension component, TDotStatDb dotStatDb, CancellationToken cancellationToken)\n at DotStat.Db.Repository.SqlServer.SqlArtefactRepository.TryCreateDimensionComponent(Dimension dim, SDMXArtefactType dimType, CancellationToken cancellationToken)\n at DotStat.Db.Service.DotStatDbService.VerifyAndCreateDimensions(IImportReferenceableStructure referencedStructure, IList`1 componentItems, Boolean factTableExists, Boolean throwConcurrencyError, CancellationToken cancellationToken)\n at DotStat.Db.Service.DotStatDbService.FillDbIdsAndCreateMissingDbObjects(IImportReferenceableStructure referencedStructure, IMappingStoreDataAccess mappingStoreDataAccess, CancellationToken cancellationToken, Boolean skipDsd, Boolean throwConcurrencyError)\n at DotStat.Db.Service.DotStatDbService.TryNewTransaction(Transaction transaction, IImportReferenceableStructure importReferenceStructure, IMappingStoreDataAccess mappingStoreDataAccess, CancellationToken cancellationToken, Boolean onlyLockTransaction)" }
This could be reproduced in QA with %dotstatsuiteNET@gingerbread patch 1.