Does anyone know what this means?
"List generation has failed.: Conversion failed when converting the varchar value '077-34612 ' to data type int. (Error 245 in n/a[1], Severity 16, State 1) Uncommittable transaction is detected at the end of the batch. The transaction is rolled back."
I'm basically trying to identify records that have an attribute, but are not on another list and it was working when I first set it up, but once I added values (the 077 number) to the attributes I started getting this error. I removed the attribute for the record in question, then it just went to the next one. I put a help ticket in, but so far they don't seem to know what it might be.
Thank you!!
Hi Jennifer,I get that when I am trying to stuff a string (like 007-34612) into a integer field and it can happen in a couple of places in the database. Is it like that when you are adding that value to an attribute in the Constituent Record > Attributes Tab or when you pull a list and use that as an output set element?
Could be the latter if the element is set up as an integer but the Attribute data is a varchar (string or non number).
H
only on the output, so that must be it. If I change the data type to something else it won't format the way I want. And will it mess up all of my values? I have over 300 entered. Thank you for your help!!
The other thing that's odd is that it works on output for one of my lists, but not this one where I'm trying to identify ones to deactivate.
You can use integer for data like 007-34612 because it's not a number and will fail. If it works on other lists it may be because they have attributes that are easily converted to numbers.
Eg: mobile phone numbers over here like 0414310104 are stored as varchar because we need the leading zero. It could be pulled as an integer but would end up being 414310104.