I am trying to achieve something very simple. There is this field on my knownerror table. It’s VARCHAR(60) so it gets filled up very soon and client wants the space to be extended. The following error is received while filling up the field and data is truncated:
“Length (145 bytes) of data for field aat.rejection.reason in knownerror exceeds max (60 bytes), truncated (se.base.method,update.record)”
I changed the SQL data type to VARCHAR (180) but even that’s not enough. So I thought of changing data type to text so that there is no space issue, just like the description and other fields have. When I changed the SQL data type to TEXT, I got the following error:
“Changing SQL data type from 'VARCHAR(60)' to 'TEXT' for column 'AAT_REJECTION_REASON' in table 'KNOWNERRORM1' is not supported. Update cancelled.”
I read many articles on this error but none of them seemed to provide solution to my problem. I noticed that the other TEXT fields have been defined as an array and then as TEXT at level2. (screenshot attached).
Can anyone suggest anything so that users get enough space for this field.