i got quite a bit done by ensuring I only edited and saved one event at a time… but think I may have hit a new roadblock: I discovered I needed to handle a REST lookup that might not return a result, ie cgheck for undefined. Added the condition and weid ythings started happening again. Went back to examine what was saved in ICE.XXXDef, SysCharacter03, and found incomplete json.
Maybe this is just an artifact of copying from sql mgmt studio column in the query results, but the character lnegth looks suspiciously like I may have exceeed syscharacter03’s capacity? Yikes.
EDIT Googling it suggests nvarchar(max)can hold 2GB, and exporting to csv and fluffing around I was able to bring in the complete json…phew.
But yes its scarmbling my condition statement resultant actions:
How its supposed to work:
How it incorrectly represents it internally:
