Allow values larger than 7999 for SQLTEXT_SQLSERVER_MAX_TEXT_LENGTH

Hi,

This was fixed in DPA 11.0 issue 876043 .

if you are still having this issue, please open a support ticket.

Brian

So it looks like something has been changed here, and it is allowing values up to 49,999.

Unfortuantely

1) I can't seem to get it to work.  Even after setting 49999 and restarting the monitor, I am not getting 49,999 characters

2) I fear this is still not a high enough maximum for us.

Any clarification?

This should be a no brainer! Allow the customer to adjust this variable as needed to accommodate their environment.

For example, tell me which table in the following query might need some index tweaking:

/* (inserted by DPA)

Text truncated due to excessive length

*/

SELECT [Project1].[id] AS [id], [Project1]

   .[doh] AS [doh], [Project1]

   .[C1] AS [C1], [Project1]

   .[version] AS [version], [Project1]

   .[date_created] AS [date_created], [Project1]

   .[has_vn_date] AS [has_vn_date], [Project1]

   .[last_updated] AS [last_updated], [Project1]

   .[md30] AS [md30], [Project1]

   .[name] AS [name], [Project1]

   .[on_order] AS [on_order], [Project1]

   .[qoh] AS [qoh], [Project1]

   .[rf_comment] AS [rf_comment], [Project1]

   .[rf_priority] AS [rf_priority], [Project1]

   .[rf_qty_wanted] AS [rf_qty_wanted], [Project1]

   .[sku] AS [sku], [Project1]

   .[supplier_id] AS [supplier_id], [Project1]

   .[vn_comment] AS [vn_comment], [Project1]

   .[vn_date] AS [vn_date], [Project1]

   .[vn_qty] AS [vn_qty], [Project1]

   .[qty_backordered] AS [qty_backordered], [Project1]

   .[weight] AS [weight], [Project1]

   .[assemblyonhand] AS [assemblyonhand], [Project1]

   .[laborseconds] AS [laborseconds], [Project1]

   .[extrabuildquantity] AS [extrabuildquantity], [Project1]

   .[metalsku] AS [metalsku], [Project1]

   .[paintsku] AS [paintsku], [Project1]

   .[monday_count] AS [monday_count], [Project1]

   .[tuesday_count] AS [tuesday_count], [Project1]

   .[wednesday_count] AS [wednesday_count], [Project1]

   .[thursday_count] AS [thursday_count], [Project1]

   .[friday_count] AS [friday_count], [Project1]

   .[saturday_count] AS [saturday_count], [Project1]

   .[pickup_from_paint] AS [pickup_from_paint], [Project1]

   .[received] AS [received], [Project1]

   .[can_build] AS [can_build], [Project1]

   .[skutype] AS [skutype], [Project1]

   .[hasSharedMetal] AS [hasSharedMetal], [Project1]

   .[is_Serialized] AS [is_Serialized], [Project1]

   .[m12] AS [m12], [Project1]

   .[m11] AS [m11], [Project1]

   .[m10] AS [m10], [Project1]

   .[m9] AS [m9], [Project1]

   .[m8] AS [m8], [Project1]

   .[m7] AS [m7], [Project1]

   .[m6] AS [m6], [Project1]

   .[m5] AS [m5], [Project1]

   .[m4] AS [m4], [Project1]

   .[m3] AS [m3], [Project1]

   .[m2] AS [m2], [Project1]

   .[m1] AS [m1], [Project1]

   .[partqtyshort] AS [partqtyshort], [Project1]

   .[partisblocking] AS [partisblocking], [Project1]

   .[formed] AS [formed], [Project1]

   .[thickness] AS [thickness], [Project1]

   .[lasorlaborseconds] AS [lasorlaborseconds], [Project1]

   .[adjmd30] AS [adjmd30], [Project1]

   .[aeOnOrder] AS [aeOnOrder], [Project1]

   .[plOnOrder] AS [plOnOrder], [Project1]

   .[lcOnOrder] AS [lcOnOrder], [Project1]

   .[bfAdjMd30] AS [bfAdjMd30], [Project1]

   .[needsBuilt] AS [needsBuilt], [Project1]

   .[shouldBuild] AS [shouldBuild], [Project1]

   .[minimumDOH] AS [minimumDOH], [Project1]

   .[safetyDOH] AS [safetyDOH], [Project1]

   .[leadTime] AS [leadTime], [Project1]

   .[minimumOrderQuantity] AS [minimumOrderQuantity], [Project1]

   .[needsBuiltAdjustment] AS [needsBuiltAdjustment], [Project1]

   .[isDropship] AS [isDropship], [Project1]

   .[isDiscontinued] AS [isDiscontinued], [Project1]

   .[AdjR7] AS [AdjR7], [Project1]

   .[AdjR14] AS [AdjR14], [Project1]

   .[AdjR60] AS [AdjR60], [Project1]

   .[AdjR90] AS [AdjR90], [Project1]

   .[BatchSize] AS [BatchSize], [Project1]

   .[AssemblyTimeCategory] AS [AssemblyTimeCategory], [Project1]

   .[OrphanBuildLimit] AS [OrphanBuildLimit], [Project1]

   .[CycleStock] AS [CycleStock], [Project1]

   .[SafetyStock] AS [SafetyStock], [Project1]

   .[TotalPartQuantityBackordered] AS [TotalPartQuantityBackordered], [Project1]

   .[PaintDensity] AS [PaintDensity], [Project1]

   .[ReorderPointBasedOnLimit] AS [ReorderPointBasedOnLimit], [Project1]

   .[SystemOfRecord] AS [SystemOfRecord], [Project1]

   .[TemporaryAsemblyLaborTimeInSeconds] AS [TemporaryAsemblyLaborTimeInSeconds], [Project1]

   .[ShouldBuildLimitingSku] AS [ShouldBuildLimitingSku], [Project1]

   .[CanBuildLimitingSku] AS [CanBuildLimitingSku], [Project1]

   .[QuantityOnHandStoneEdge] AS [QuantityOnHandStoneEdge], [Project1]

   .[ForecastedMonthlyDemand] AS [ForecastedMonthlyDemand], [Project1]

   .[BatchSizeForPurchasing] AS [BatchSizeForPurchasing], [Project1]

   .[CalculatedPush] AS [CalculatedPush], [Project1]

   .[MetalQuantityOnHand] AS [MetalQuantityOnHand], [Project1]

   .[PaintDensityMax] AS [PaintDensityMax], [Project1]

   .[ReorderPointShort] AS [ReorderPointShort], [Project1]

   .[SafetyStockShort] AS [SafetyStockShort], [Project1]

   .[OverbuiltShort] AS [OverbuiltShort], [Project1]

   .[MinimumRootDaysOnHand] AS [MinimumRootDaysOnHand], [Project1]

   .[IsPaintedMetal] AS [IsPaintedMetal], [Project1]

   .[OldestBackorderDate] AS [OldestBackorderDate], [Project1]

   .[IsBuiltToOrder] AS [IsBuiltToOrder], [Project1]

   .[AllocationShort] AS [AllocationShort], [Project1]

   .[LeadTimeNeedsBuilt] AS [LeadTimeNeedsBuilt], [Project1]

   .[DefaultWarehouseId] AS [DefaultWarehouseId], [Project1]

   .[DefaultResourceGroup] AS [DefaultResourceGroup], [Project1]

   .[ForecastedMonthlyDemandEvents] AS [ForecastedMonthlyDemandEvents], [Project1]

   .[C2] AS [C2], [Project1]

   .[LocalSku] AS [LocalSku], [Project1]

   .[WarehouseId] AS [WarehouseId], [Project1]

   .[ItemName] AS [ItemName], [Project1]

   .[QuantityOnHand] AS [QuantityOnHand], [Project1]

   .[MetalQuantityOnHand1] AS [MetalQuantityOnHand1], [Project1]

   .[CanBuild] AS [CanBuild] 

FROM 

   ( 

   SELECT [Extent1].[id] AS [id], [Extent1]

      .[version] AS [version], [Extent1]

      .[date_created] AS [date_created], [Extent1]

      .[doh] AS [doh], [Extent1]

      .[has_vn_date] AS [has_vn_date], [Extent1]

      .[last_updated] AS [last_updated], [Extent1]

      .[md30] AS [md30], [Extent1]

      .[name] AS [name], [Extent1]

      .[on_order] AS [on_order], [Extent1]

      .[qoh] AS [qoh], [Extent1]

      .[rf_comment] AS [rf_comment], [Extent1]

      .[rf_priority] AS [rf_priority], [Extent1]

      .[rf_qty_wanted] AS [rf_qty_wanted], [Extent1]

      .[sku] AS [sku], [Extent1]

      .[supplier_id] AS [supplier_id], [Extent1]

      .[vn_comment] AS [vn_comment], [Extent1]

      .[vn_date] AS [vn_date], [Extent1]

      .[vn_qty] AS [vn_qty], [Extent1]

      .[qty_backordered] AS [qty_backordered], [Extent1]

      .[weight] AS [weight], [Extent1]

      .[assemblyonhand] AS [assemblyonhand], [Extent1]

      .[laborseconds] AS [laborseconds], [Extent1]

      .[extrabuildquantity] AS [extrabuildquantity], [Extent1]

      .[metalsku] AS [metalsku], [Extent1]

      .[paintsku] AS [paintsku], [Extent1]

      .[monday_count] AS [monday_count], [Extent1]

      .[tuesday_count] AS [tuesday_count], [Extent1]

      .[wednesday_count] AS [wednesday_count], [Extent1]

      .[thursday_count] AS [thursday_count], [Extent1]

      .[friday_count] AS [friday_count], [Extent1]

      .[saturday_count] AS [saturday_count], [Extent1]

      .[pickup_from_paint] AS [pickup_from_paint], [Extent1]

      .[received] AS [received], [Extent1]

      .[can_build] AS [can_build], [Extent1]

      .[skutype] AS [skutype], [Extent1]

      .[hasSharedMetal] AS [hasSharedMetal], [Extent1]

      .[is_Serialized] AS [is_Serialized], [Extent1]

      .[m12] AS [m12], [Extent1]

      .[m11] AS [m11], [Extent1]

      .[m10] AS [m10], [Extent1]

      .[m9] AS [m9], [Extent1]

      .[m8] AS [m8], [Extent1]

      .[m7] AS [m7], [Extent1]

      .[m6] AS [m6], [Extent1]

      .[m5] AS [m5], [Extent1]

      .[m4] AS [m4], [Extent1]

      .[m3] AS [m3], [Extent1]

      .[m2] AS [m2], [Extent1]

      .[m1] AS [m1], [Extent1]

      .[partqtyshort] AS [partqtyshort], [Extent1]

      .[partisblocking] AS [partisblocking], [Extent1]

      .[formed] AS [formed], [Extent1]

      .[thickness] AS [thickness], [Extent1]

      .[lasorlaborseconds] AS

Disappointed it cuts off before the FROM clause that lists any actual tables (not to mention the WHERE clause)? Me too!

Entity framework can be a beast! It's really hard to figure out what's up with a query without seeing the full thing.