Issue
After executing a load, the `[bfx].[ConfigVariable]` table does UPDATE the `[VariableValue]` or `[PreviousValue]` columns.Cause
This issue presents itself when the follow are all true:
-
Parameter is an int or decimal datatype
-
Parameter already has an entry in [bfx].[ConfigVariable]
-
The current [VariableValue] can be evaluated as a date
-
Specifically if ISDATE( [VariableValue] ) = 1 on SQL Server
-
-
The value being loaded does CAN NOT be evaluated as a date
-
Specifically if ISDATE( [VariableValue] ) = 0 on SQL Server
-
Resolution
As of the BimlFlex 2021 release, this issue can be circumvented via manual database update statement.
A DATATYPEOVERRIDE column has been placed in the `[bfx].[ConfigVariable]` table in the BimlCatalog. If there is an affected Parameter, this value can be manually updated to `int` or `decimal` to prevent incorrectly flagging a value as a 'date'.
Additional documentation can be found here: Load Parameters