search

diffix / explorer

Tool to automatically explore and generate stats on data anonymized using Diffix
MIT License
2 stars 1 forks source link

Date column names are not quoted in multi-column queries. #378

Closed sentry-io[bot] closed 3 years ago

sentry-io[bot] commented 3 years ago

Date column names are not quoted in multi-column queries.

Sentry Issue: EXPLORER-11W

Aircloak.JsonApi.Exceptions.ResultException: Aircloak API query error.
DataSource: NAV_W1_TENANT_WS001.
Error: Expected `from`.

The error was detected at line 3, column 32:

    2:                    select
    3:                        grouping_id(
                                         ^
    4:                            bucket ("Line No_" by 2000.0),"Type","Location Code","Unit of Measure",bucket ("Quantity" by 0.1),bucket ("Unit Price" by 0.0001),bucket ("Unit Cost (LCY)" by 0.0001),"VAT _","Line Discount _",bucket ("Gross Weight" by 0.0001),"Shortcut Dimension 1 Code","Shortcut Dimension 2 Code","Customer Price Group","Gen_ Bus_ Posting Group","Gen_ Prod_ Posting Group","VAT Bus_ Posting Group","VAT Prod_ Posting Group",bucket ("Unit Cost" by 0.0001),"VAT Identifier",date_trunc('year', Posting Date),"Dimension Set ID","Unit of Measure Code",bucket ("Quantity (Base)" by 0.1),"Nonstock","Purchasing Code","Allow Line Disc_","Customer Disc_ Group","Combined Item Header","Qty_ per Header","Allow Payment Discount","Fastfit Discount"
Query Id: 7728b05c-7384-4335-ab93-e91d56720d93
Query Statement: 
                select
                    grouping_id(
                        bucket ("Line No_" by 2000.0),"Type","Location Code","Unit of Measure",bucket ("Quantity" by 0.1),bucket ("Unit Price" by 0.0001),bucket ("Unit Cost (LCY)" by 0.0001),"VAT _","Line Discount _",bucket ("Gross Weight" by 0.0001),"Shortcut Dimension 1 Code","Shortcut Dimension 2 Code","Customer Price Group","Gen_ Bus_ Posting Group","Gen_ Prod_ Posting Group","VAT Bus_ Posting Group","VAT Prod_ Posting Group",bucket ("Unit Cost" by 0.0001),"VAT Identifier",date_trunc('year', Posting Date),"Dimension Set ID","Unit of Measure Code",bucket ("Quantity (Base)" by 0.1),"Nonstock","Purchasing Code","Allow Line Disc_","Customer Disc_ Group","Combined Item Header","Qty_ per Header","Allow Payment Discount","Fastfit Discount"
                    ),
                    bucket ("Line No_" by 2000.0),"Type","Location Code","Unit of Measure",bucket ("Quantity" by 0.1),bucket ("Unit Price" by 0.0001),bucket ("Unit Cost (LCY)" by 0.0001),"VAT _","Line Discount _",bucket ("Gross Weight" by 0.0001),"Shortcut Dimension 1 Code","Shortcut Dimension 2 Code","Customer Price Group","Gen_ Bus_ Posting Group","Gen_ Prod_ Posting Group","VAT Bus_ Posting Group","VAT Prod_ Posting Group",bucket ("Unit Cost" by 0.0001),"VAT Identifier",date_trunc('year', Posting Date),"Dimension Set ID","Unit of Measure Code",bucket ("Quantity (Base)" by 0.1),"Nonstock","Purchasing Code","Allow Line Disc_","Customer Disc_ Group","Combined Item Header","Qty_ per Header","Allow Payment Discount","Fastfit Discount",
                    count(*),
                    count_noise(*)
                from "SalesInvoiceLine"
                group by grouping sets ((2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),(31),(32))
  File "/build/src/aircloak/JsonApi/JsonApiClient.cs", line 192, in MoveNext
  File "/build/src/aircloak/JsonApi/JsonApiClient.cs", line 210, in MoveNext
  File "/build/src/aircloak/JsonApi/JsonApiClient.cs", line 97, in MoveNext
  File "/build/src/aircloak/JsonApi/AircloakConnection.cs", line 85, in MoveNext
  File "/build/src/explorer/Components/ColumnCorrelationComponent.cs", line 72, in DrillDown
...
(43 additional frame(s) were not displayed)

Error in MultiColumnExploration for NAV_W1_TENANT_WS001/SalesInvoiceLine/Line No_,Type,No_,Location Code,Posting Group,Shipment Date,Description,Unit of Measure,Quantity,Unit Price,Unit Cost (LCY),VAT _,Line Discount _,Allow Invoice Disc_,Gross Weight,Net Weight,Units per Parcel,Unit Volume,Appl_-to Item Entry,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Customer Price Group,Job No_,Work Type Code,Shipment No_,Shipment Line No_,Inv_ Discount Amount,Drop Shipment,Gen_ Bus_ Posting Group,Gen_ Prod_ Posting Group,VAT Calculation Type,Transaction Type,Transport Method,Attached to Line No_,Exit Point,Area,Transaction Specification,Tax Category,Tax Area Code,Tax Liable,Tax Group Code,VAT Clause Code,VAT Bus_ Posting Group,VAT Prod_ Posting Group,Blanket Order No_,Blanket Order Line No_,Unit Cost,System-Created Entry,VAT Difference,VAT Identifier,IC Partner Ref_ Type,IC Partner Reference,Prepayment Line,IC Partner Code,Posting Date,Line Discount Calculation,Dimension Set ID,Job Task No_,Job Contract Entry No_,Deferral Code,Variant Code,Bin Code,Qty_ per Unit of Measure,Unit of Measure Code,Quantity (Base),FA Posting Date,Depreciation Book Code,Depr_ until FA Posting Date,Duplicate in Depreciation Book,Use Duplication List,Responsibility Center,Cross-Reference No_,Unit of Measure (Cross Ref_),Cross-Reference Type,Cross-Reference Type No_,Item Category Code,Nonstock,Purchasing Code,Product Group Code,Appl_-from Item Entry,Return Reason Code,Allow Line Disc_,Customer Disc_ Group,Price description,Center of Distribution,Do not print line,Do not print price,Do not print quantity,Read Only,Combined Item Header,BOM Explosion Type,Dimension Source,Service Package Header,Qty_ per Header,Call Center,Manual BOM,Allow Payment Discount,Manual Not Print Line,Manual Not Print Price,Manual Not Print Quantity,Group Number,Fastfit Discount,Fixed Price,Representative Code,CB-Price,Consignment,Price Change From User,Bonus Allowed,Bonus _,Bonus Code,Bonusable Amount,Bonusable Amount (CB),Bonus Amount (Expected),Null Position,Price Locked,Net Price,Discount 1 _,Text Discount 1,Discount 2 _,Text Discount 2,Discount 3 _,Text Discount 3,Discount 4 (LCY),Text Discount 4,Discount 5 _,Text Discount 5,BAH Option,Text Item No_,Text Quantity,Text Unit Price,Text Amount,Text CB-Price,Text Line Discount _,Qty_ Transferred From BAH,Remaining Qty on BAH,Minimum Price,Discount 1 Code,Discount 2 Code,Discount 3 Code,Discount 4 Code,Discount 5 Code,Location Name,Central Maintenance,Price UOM,Unit Price per Price UOM,Net Price per Price UOM,Has Additional Items,Additional Item Type,Appl_-to Exch_ Part Entry No_,Tire Hotel No_,Retread Order No_,Retread Line No_,Tour Code,Tour Placement,Noise Performance,Noise Class Type,Fuel Efficiency,Service Center,EC_Vehicle Class,EU Directive Number,Wet Grip,Customer Commission Code,Product Commission Code,Salesperson Code,Salesperson Code 2,Fitter 1,Fitter 2,Fitter 3,Commission Posted,Deleteable Additional Item,Add_ Items - Att_ To Line,DatEuropa code,Engine Codes,EurotaxNat Code,Mileage(KM),National Code,License No_,TecDoc ID,VIN,Interface Description,Promotion Condition No_,Promotion Bonus Line No_,Discount Operation 2,Discount Operation 3,Discount Operation 5,Internal Comment,Deleted By HQ,Replication Date,Repl_ Post Run Finished,Replication Filter,Additional Sale,Prevent Synchronization,Prevent Replication.
sentry-io[bot] commented 3 years ago

Sentry issue: EXPLORER-11Y