Forum Discussion

ManuMas's avatar
ManuMas
Frequent Visitor
2 years ago

GIT sync Data warehouse possible bug

Hi,

We are experiencing the following error when synchronizing a Fabric workspace content with GIT:

Cluster URI https://wabi-uk-south-redirect.analysis.windows.net/

Activity ID a3594a12-81df-4722-bfa7-b878427f17de

Request ID 8f2297d0-ffcb-204b-88da-403453076724

Workload Error Code InternalError

Workload Error Message The SQL query failed while running. Message=STRING_AGG aggregation result exceeded the limit of 8000 bytes. Use LOB types to avoid result truncation., Code=9829, State=1

ArtifactObjectId 1aca8247-1bfc-4e91-b42d-1ead864387d1

GitErrorDetails {"artifactType":"Datawarehouse","artifactDisplayName":"DWH_GOLD_FLOURISH","artifactLogicalId":"95c00e3d-79cf-4a24-8731-80b5dc6e7efc","rootActivityId":"8f2297d0-ffcb-204b-88da-403453076724","httpStatus":0,"errorType":"Exception","errorCode":null,"errorSource":1,"targetCommit":null,"artifacts":null,"errorDetails":{"ErrorCode":"InternalError","ErrorMessage":"The SQL query failed while running. Message=STRING_AGG aggregation result exceeded the limit of 8000 bytes. Use LOB types to avoid result truncation., Code=9829, State=1","ErrorParameters":null,"ErrorCategory":"Microsoft.ServicePlatform.Exceptions.DataContracts.ExceptionData","IsTransient":false,"AdditionalParameters":[{"Name":"ExceptionType","Value":"Microsoft.ServicePlatform.Exceptions.DataContracts.ExceptionData"},{"Name":"ArtifactObjectId","Value":"1aca8247-1bfc-4e91-b42d-1ead864387d1@6944c981-e7ba-44fc-a1cf-b37ceeead686$2024-05-02T14:48:59.6220929Z@ffef6655-99ab-4c2b-ac21-82ae988ff64a"}],"ErrorSource":0,"UserInteractionRequest":null},"gitProviderErrorResponse":null,"culprit":0}

Time Thu May 02 2024 16:49:02 GMT+0200 (Central European Summer Time)

 
I have discovered that the error comes from a table with a large number of columns created in a Data Warehouse artifact. If I drop the table or remove some columns, I get the conent. My guess is that it is a bug since I haven't found any reference in official documentation to limits in the number of columns in a data warehouse table.
This is the create table statement if anybody wants to test:
CREATE TABLE [dbo].[FACT_O2C_SalesOrders](
[WID_SalesOrder] [varchar](139) NOT NULL,
[DefaultLedgerDimensionDisplayValue] [varchar](500) NULL,
[MainAccountIDDisplayValue] [varchar](500) NULL,
[IsDeliveryAddressOrderSpecific] [varchar](3) NULL,
[OrderLineReference] [varchar](30) NULL,
[SalesOrderNumber] [varchar](20) NULL,
[WID_InventoryLotID] [varchar](121) NULL,
[SalesOrderLineStatus] [varchar](100) NULL,
[IsLineStopped] [varchar](3) NULL,
[CustomersLineNumber] [int] NULL,
[CustomsDocumentDate] [datetime2](6) NULL,
[CustomsDocumentNumber] [varchar](21) NULL,
[CustomsDocumentName] [varchar](60) NULL,
[SalesOrderPromisingMethod] [int] NULL,
[DeliveryAddressName] [varchar](100) NULL,
[DeliveryModeCode] [varchar](10) NULL,
[DeliveryMode] [varchar](60) NULL,
[DeliveryTermsID] [varchar](10) NULL,
[DeliveryTerms] [varchar](60) NULL,
[ExternalItemNumber] [varchar](20) NULL,
[WID_BomID] [varchar](121) NULL,
[WID_ItemNumber] [varchar](121) NULL,
[WID_RouteID] [varchar](121) NULL,
[LineAmount] [numeric](32, 6) NULL,
[LineDiscountAmount] [numeric](32, 6) NULL,
[LineDiscountPercentage] [numeric](32, 6) NULL,
[MultiLineDiscountAmount] [numeric](32, 6) NULL,
[MultiLineDiscountPercentage] [numeric](32, 6) NULL,
[LineDescription] [varchar](1000) NULL,
[AllowedOverDeliveryPercentage] [numeric](32, 6) NULL,
[PackingUnitSymbol] [varchar](10) NULL,
[WillAutomaticInventoryReservationConsiderBatchAttributes] [varchar](3) NULL,
[WillRebateCalculationExcludeLine] [varchar](3) NULL,
[SalesRebateProductGroupID] [varchar](10) NULL,
[SalesPriceQuantity] [numeric](32, 12) NULL,
[EinvoicePropertyNumber] [varchar](20) NULL,
[CustomerRequisitionNumber] [varchar](20) NULL,
[ConfirmedReceiptDate] [datetime2](6) NULL,
[RequestedReceiptDate] [datetime2](6) NULL,
[InventoryReservationMethod] [int] NULL,
[CommissionSalesRepresentativeGroupID] [varchar](10) NULL,
[CommissionSalesRepresentativeGroup] [varchar](60) NULL,
[FixedPriceCharges] [numeric](32, 6) NULL,
[SalesPrice] [numeric](32, 6) NULL,
[OrderedSalesQuantity] [numeric](32, 6) NULL,
[OrderedCatchWeightQuantity] [numeric](32, 6) NULL,
[SalesUnitSymbol] [varchar](10) NULL,
[ServiceOrderNumber] [varchar](10) NULL,
[ConfirmedShippingDate] [datetime2](6) NULL,
[RequestedShippingDate] [datetime2](6) NULL,
[SalesTaxGroupCode] [varchar](10) NULL,
[SalesTaxGroup] [varchar](60) NULL,
[SalesTaxItemGroupCode] [varchar](10) NULL,
[AllowedUnderDeliveryPercentage] [numeric](32, 6) NULL,
[SalesProductCategoryName] [varchar](254) NULL,
[NGPCode] [bigint] NULL,
[BID_ProductConfigurationID] [varchar](50) NULL,
[ItemBatchNumber] [varchar](20) NULL,
[WID_ProductColorID] [varchar](111) NULL,
[WID_WarehouseID] [varchar](111) NULL,
[WID_ShippingSiteID] [varchar](111) NULL,
[WID_ProductSizeID] [varchar](111) NULL,
[OrderedInventoryStatusID] [varchar](10) NULL,
[ProductStyleID] [varchar](10) NULL,
[ProductVersionID] [varchar](10) NULL,
[FormattedDelveryAddress] [varchar](250) NULL,
[DeliveryBuildingCompliment] [varchar](60) NULL,
[EinvoiceDimensionAccountCode] [varchar](35) NULL,
[WithholdingTaxGroupCode] [varchar](10) NULL,
[ItemWithholdingTaxcodeGroupCode] [varchar](10) NULL,
[DeliverySalesTaxGroupCode] [varchar](10) NULL,
[DeliverySalesTaxItemGroupCode] [varchar](10) NULL,
[DeliveryCFOPCcode] [varchar](5) NULL,
[CFOPCode] [varchar](5) NULL,
[LineNumber] [int] NULL,
[LineCreationSequenceNumber] [int] NULL,
[SkipCreateAutoCharges] [int] NULL,
[WID_ProjectID] [varchar](121) NULL,
[ProjectLinepropertyID] [varchar](10) NULL,
[CurrencyCode] [varchar](3) NULL,
[WID_ShippingWarehouseLocationID] [varchar](111) NULL,
[ItemSerialNumber] [varchar](20) NULL,
[RetailCalculatedLineDiscountAmount] [numeric](32, 6) NULL,
[RetailCalculatedLineDiscountPercentage] [numeric](32, 6) NULL,
[RetailCalculatedManualLineDiscountAmount] [numeric](32, 6) NULL,
[RetailCalculatedManualLineDiscountPercentage] [numeric](32, 6) NULL,
[RetailCalculatedPeriodicDiscountAmount] [numeric](32, 6) NULL,
[RetailCalculatedPeriodicDiscountPercentage] [numeric](32, 6) NULL,
[RetailCalculatedTotalDiscountAmount] [numeric](32, 6) NULL,
[RetailCalculatedTotalDiscountPercentage] [numeric](32, 6) NULL,
[RetailCalculatedTenderDiscountAmount] [numeric](32, 6) NULL,
[RetailCalculatedTenderDiscountPercentage] [numeric](32, 6) NULL,
[IsPriceLocked] [varchar](3) NULL,
[FulfillmentStatus] [int] NULL,
[FulfillmentsSoreID] [varchar](10) NULL,
[PlanningPriority] [numeric](32, 2) NULL,
[SalesOrderLineCreationMethod] [int] NULL,
[OverrideSalesTax] [int] NULL,
[SalesDeliverNow] [numeric](32, 6) NULL,
[SubBillRevenueSplit] [int] NULL,
[IsSoftReservedExternally] [varchar](3) NULL,
[ExcludeFromMasterPlanning] [varchar](3) NULL,
[DataAreaID] [varchar](4) NULL,
[WID_Company] [varchar](105) NULL,
[WID_MainAccount] [varchar](351) NULL,
[WID_Division] [varchar](351) NULL,
[WID_Department] [varchar](351) NULL,
[WID_Site] [varchar](351) NULL,
[WID_ItemGroup] [varchar](351) NULL,
[WID_Customer] [varchar](351) NULL,
[WID_Interco] [varchar](351) NULL,
[WID_Project] [varchar](351) NULL,
[WID_BusinessUnit] [varchar](1102) NULL,
[DeliveryAddressCountryRegionISOCode] [varchar](2) NULL,
[IsExportSale] [varchar](3) NULL,
[SalesOrderProcessingStatus] [int] NULL,
[AreTotalsCalculated] [varchar](3) NULL,
[TransportationDocumentLineID] [uniqueidentifier] NULL,
[OrderCreationDateTime] [datetime2](6) NULL,
[DefinitionGroup] [varchar](60) NULL,
[WID_OrderingCustomerccountNumber] [varchar](121) NULL,
[WID_Invoicecustomeraccountnumber] [varchar](121) NULL,
[LineDiscountCustomerGroupCode] [varchar](10) NULL,
[CashDiscountCode] [varchar](10) NULL,
[PaymentTermsBaseDate] [datetime2](6) NULL,
[CommissionCustomerGroupID] [varchar](10) NULL,
[WID_ContactPersonID] [varchar](121) NULL,
[CustomersOrderReference] [varchar](60) NULL,
[TotalDiscountPercentage] [numeric](32, 6) NULL,
[Email] [varchar](80) NULL,
[TotalDiscountCustomerGroupCode] [varchar](10) NULL,
[ExportReason] [varchar](30) NULL,
[FixedDueDate] [datetime2](6) NULL,
[FixedExchangeRate] [numeric](32, 16) NULL,
[InvoicePaymentAttachmentType] [int] NULL,
[ArePricesIncludingSalesTax] [varchar](3) NULL,
[LanguageID] [varchar](7) NULL,
[ChargeCustomerGroupID] [varchar](10) NULL,
[ChargeCustomerGroup] [varchar](30) NULL,
[IsSalesProcessingStopped] [varchar](3) NULL,
[MultiLineDiscountCustomerGroupCode] [varchar](10) NULL,
[IsOneTimeCustomer] [varchar](3) NULL,
[PaymentTermsName] [varchar](100) NULL,
[PaymentScheduleName] [varchar](30) NULL,
[CustomerPaymentMethodName] [varchar](10) NULL,
[CustomerPaymentMethodSpecificationName] [varchar](10) NULL,
[SalesRebateCustomerGroupID] [varchar](20) NULL,
[SalesRebateCustomerGroup] [varchar](60) NULL,
[PriceCustomerGroupCode] [varchar](10) NULL,
[PriceCustomerGroup] [varchar](60) NULL,
[PriceCustomerGroupOricingPriority] [int] NULL,
[QuotationNumber] [varchar](20) NULL,
[SalesOrderName] [varchar](60) NULL,
[SalesOrderOriginCode] [varchar](10) NULL,
[SalesOrderPoolID] [varchar](10) NULL,
[SalesOrderPool] [varchar](60) NULL,
[WID_SalesUnitID] [varchar](121) NULL,
[CustomerTransactionSettlementType] [int] NULL,
[CampaignID] [varchar](10) NULL,
[WID_OrderResponsiblePersonnelNumber] [varchar](126) NULL,
[WID_OrderTakerPersonnelNumber] [varchar](126) NULL,
[IsEntryCertificateRequired] [varchar](3) NULL,
[InvoiceType] [int] NULL,
[TransportationBrokerID] [varchar](20) NULL,
[Isconsolidatedinvoicetarget] [varchar](3) NULL,
[CreditNoteReasonCode] [varchar](10) NULL,
[CFPSCode] [varchar](4) NULL,
[IsFinalUser] [varchar](3) NULL,
[OrderTotalAmount] [numeric](32, 6) NULL,
[OrderTotalChargesAmount] [numeric](32, 6) NULL,
[OrderTotalDiscountAmount] [numeric](32, 6) NULL,
[OrderTotalTaxAmount] [numeric](32, 6) NULL,
[OrderHeaderTaxAmount] [numeric](32, 6) NULL,
[TotalDiscountAmount] [numeric](32, 6) NULL,
[InvoiceAddressCountryRegionISOCode] [varchar](2) NULL,
[OrderOrAgreementCode] [varchar](100) NULL,
[ReportingCurrencyFixedExchangeRate] [numeric](32, 6) NULL,
[DataSourceId] [varchar](100) NULL
GO
 
 
 
 
 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ManuMas ,

    Thanks for using Fabric Community.
    At this time, we are reaching out to the internal team to get some help on this .
    We will update you once we hear back from them.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi ManuMas ,

      Apologize for the issue you are facing. This looks like a bug. 
      The best course of action is to open a support ticket and have our support team take a closer look at it and get this resolved.

       

      Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link 

       

      After creating a Support ticket please provide the ticket number as it would help us to track for more information.

       

      Hope this helps. Please let us know if you have any other queries.

  • ManuMas's avatar
    ManuMas
    Frequent Visitor

    Thank you for your fast response. This is the Support TrackingID #2405030050002345.

  • ManuMas's avatar
    ManuMas
    Frequent Visitor

    Thank you. This is the Microsoft Support TrackingID #2405030050002345