Skip to main content
kristinf8610
April 24, 2025
Question

Random unknown value writing to DB instead of value in PM?

  • April 24, 2025
  • 5 replies
  • 0 views

I have an issue I'm stuck on. We have this value writing to the DB for this column: 


And here it is after the Write to Records node:



Does -2137483649 mean anything in the crazy world of data? I tried searching it but didn't return anything useful.

    5 replies

    mikes0011
    Brainy
    April 24, 2025

    Look how similar your mystery value is to the "negative integer overflow" (the lowest negative integer you can store before it overflows).  The most curious thing here is that it's slightly off.  But either way, this suggests to me that the value is being set to something totally bonkers, like an accidentally blank but not null value, or something else.

    Oh wait - are you trying to save a field of type "text" to an integer field?  I expect that might have highly unexpected results (like the above).  Why can't you either make your DB field TEXT or change your RecordType field type to INTEGER?

    kristinf8610
    April 24, 2025

    The field is text, and the DB field is varchar:

    Most of our numbers associated with this app (filing #s, etc.) have a type of text because the value for some of them can get so long that it exceeds the integer value.

    mikes0011
    Brainy
    April 24, 2025

    Then I'm guessing something goes haywire at some point while a number is being converted - it's hard to say without seeing the code / process steps involved.

    mathieud0001
    April 24, 2025

    I would bet on something (rule input, process variable etc) that has an unexpected type somewhere.