Developer forum

Hi Kim,

I think it is the way to go, but I am not sure what agreements you have with your cloud solution (I am just a developer) :)

Maybe your syntax is wrong, or the table already exists?

I have no problem creating tables via the Firehose by doing this:

Hi

I can create your table to, but not this. It works in MSSMS so maybe dw firehose has some limitations

CREATE TABLE SalesOrders123 (
    Id NVARCHAR(50),
    Number NVARCHAR(MAX),
    ExternalDocumentNumber NVARCHAR(MAX),
    OrderDate DATE,
    PostingDate DATE,
    CustomerId NVARCHAR(50),
    CustomerNumber NVARCHAR(MAX),
    CustomerName NVARCHAR(MAX),
    BillToName NVARCHAR(MAX),
    BillToCustomerId NVARCHAR(50),
    BillToCustomerNumber NVARCHAR(MAX),
    ShipToName NVARCHAR(MAX),
    ShipToContact NVARCHAR(MAX),
    SellToAddressLine1 NVARCHAR(MAX),
    SellToAddressLine2 NVARCHAR(MAX),
    SellToCity NVARCHAR(MAX),
    SellToCountry NVARCHAR(MAX),
    SellToState NVARCHAR(MAX),
    SellToPostCode NVARCHAR(MAX),
    BillToAddressLine1 NVARCHAR(MAX),
    BillToAddressLine2 NVARCHAR(MAX),
    BillToCity NVARCHAR(MAX),
    BillToCountry NVARCHAR(MAX),
    BillToState NVARCHAR(MAX),
    BillToPostCode NVARCHAR(MAX),
    ShipToAddressLine1 NVARCHAR(MAX),
    ShipToAddressLine2 NVARCHAR(MAX),
    ShipToCity NVARCHAR(MAX),
    ShipToCountry NVARCHAR(MAX),
    ShipToState NVARCHAR(MAX),
    ShipToPostCode NVARCHAR(MAX),
    ShortcutDimension1Code NVARCHAR(MAX),
    ShortcutDimension2Code NVARCHAR(MAX),
    CurrencyId NVARCHAR(50),
    CurrencyCode NVARCHAR(MAX),
    PricesIncludeTax BIT,
    PaymentTermsId NVARCHAR(50),
    ShipmentMethodId NVARCHAR(50),
    Salesperson NVARCHAR(MAX),
    PartialShipping BIT,
    RequestedDeliveryDate DATE,
    DiscountAmount FLOAT,
    DiscountAppliedBeforeTax BIT,
    TotalAmountExcludingTax FLOAT,
    TotalTaxAmount FLOAT,
    TotalAmountIncludingTax FLOAT,
    FullyShipped BIT,
    Status NVARCHAR(MAX),
    LastModifiedDateTime DATETIME,
    PhoneNumber NVARCHAR(MAX),
    Email NVARCHAR(MAX)
);

Hi

Yeah i get the same error, when trying with your table.

I've tried to remove some columns from your table, and was able to create it with this many columns:

Hi Kim,

When I tried to do it locally, I had no problems creating your table, I've tried version 10.18 (our master branch), but when I did it on a released testsite (also a 10.18 version) then I was able to reproduce it, as I wrote before.

I've spoken with my tech-lead, his idea is that the IIS has some limits for both your cloud-solution and the testsite I've testet on.

A solution for now could be that you create the table partially, then do an alter table to add the last columns should loke like this (2 different "Fire")

CREATE TABLE SalesOrders123 (
    Id NVARCHAR(50),
    Number NVARCHAR(MAX),
    ExternalDocumentNumber NVARCHAR(MAX),
    OrderDate DATE,
    PostingDate DATE,
    CustomerId NVARCHAR(50),
    CustomerNumber NVARCHAR(MAX),
    CustomerName NVARCHAR(MAX),
    BillToName NVARCHAR(MAX),
    BillToCustomerId NVARCHAR(50),
    BillToCustomerNumber NVARCHAR(MAX),
    ShipToName NVARCHAR(MAX),
    ShipToContact NVARCHAR(MAX),
    SellToAddressLine1 NVARCHAR(MAX),
    SellToAddressLine2 NVARCHAR(MAX),
    SellToCity NVARCHAR(MAX),
    SellToCountry NVARCHAR(MAX),
    SellToState NVARCHAR(MAX),
    SellToPostCode NVARCHAR(MAX),
    BillToAddressLine1 NVARCHAR(MAX),
    BillToAddressLine2 NVARCHAR(MAX),
    BillToCity NVARCHAR(MAX),
    BillToCountry NVARCHAR(MAX),
    BillToState NVARCHAR(MAX),
    BillToPostCode NVARCHAR(MAX),
    ShipToAddressLine1 NVARCHAR(MAX),
    ShipToAddressLine2 NVARCHAR(MAX),
    ShipToCity NVARCHAR(MAX),
    ShipToCountry NVARCHAR(MAX),
    ShipToState NVARCHAR(MAX),
    ShipToPostCode NVARCHAR(MAX),
    ShortcutDimension1Code NVARCHAR(MAX),
    ShortcutDimension2Code NVARCHAR(MAX),
    CurrencyId NVARCHAR(50),
    CurrencyCode NVARCHAR(MAX),
    PricesIncludeTax BIT,
    PaymentTermsId NVARCHAR(50),
    ShipmentMethodId NVARCHAR(50),
    Salesperson NVARCHAR(MAX)
);

ALTER TABLE SalesOrders123 
ADD PartialShipping BIT,
    RequestedDeliveryDate DATE,
    DiscountAmount FLOAT,
    DiscountAppliedBeforeTax BIT,
    TotalAmountExcludingTax FLOAT,
    TotalTaxAmount FLOAT,
    TotalAmountIncludingTax FLOAT,
    FullyShipped BIT,
    Status NVARCHAR(MAX),
    LastModifiedDateTime DATETIME,
    PhoneNumber NVARCHAR(MAX),
    Email NVARCHAR(MAX);

My tech-lead did say that we do have the Firehose in the spotlight, about this matter, but not sure when this will be fixed, so I hope this solution/work-around can help you for now.

BR

Matthias Sort

If the solution is an upgrade, it can be a database level is set too low. Ensure it is set to 150.

You can run this SQL to test it: SELECT compatibility_level FROM sys.databases WHERE name=DB_NAME()

Next release of Dynamicweb 10 has this as a general health check in insights.

It works to divide them into 2, so that's how I'll proceed.