Hi
I am trying to add elements to an existing output set and keep getting the following error:
"String or binary data would be truncated. The statement has been terminated."
The elements work on their own but for some reason when combined I cannot save.
Anyone seen this before?
ThanksJess LevySan Francisco Opera
Is it a particularly large output set in terms of elements?
No. When testing, I can save 6 elements but when I add the 7th, I get the error.
Any element name aliases or filters?
Have you checked the accounts in question for that list and output element? It might be possible that one of the actual data points you are trying to return is inordinately large.
I am building it directly in Output Set Manager so it is not attached to any customer data yet.All of the elements are filterable. One of the Output element groups has aliases and the other is just a table.
I think John is onto something. That message is returned by SQL when the data that is being inserted or updated in a column is longer than the column definition. Without knowing the details of the elements in question, it's going to be difficult to guide you as to where to look.
I removed one of my filters (Package Name) and now the other elements are adding...I will try rebuilding that filter in TR_QUERY_ELEMENT_PARAMETER.Thanks for your help!
Ah! In that case, it might be a datatype mismatch on the TR_QUERY_ELEMENT_PARAMETER table. I have seen that cause some issues before.
All fixed! I made some adjustments and now I can filter on package name again! Thanks again!