Type change not allowed. Invalid type conversion for field 'System Name' on table 'Incident'. Cannot convert from 'Choice' to 'Reference'. There exists data records (26604) that are not a Sys ID.

peshwen
Giga Contributor

Hi All,

I was trying to change the type of field on Incident from 'choice' to 'Reference'. I got the error as 'Type change not allowed. Invalid type conversion for field 'System Name' on table 'Incident'. Cannot convert from 'Choice' to 'Reference'. There exists data records (26604) that are not a Sys ID.' Please help me out on this error.

Thanks in Advance.

Nikhil Peshwe

6 REPLIES 6

Deepa Srivastav
Kilo Sage

Hi Nikhil,



'Validate type change' Business rule is restricting this. You need to disable this and then try to do this.


Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy.


Deepa Srivastav
Kilo Sage

For your info, changing the type of a field may delete all the data for that column. So try that in some dev instance first before doing this in prod.


Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy.


Deepa Srivastav
Kilo Sage

Hi Nikhil,



Is it solved ? If yes pls mark Correct to close the thread and make it helpful for others who have same issue in future.


Hi Deepa,



I didnt find the Business rule which you mentioned.