Error in update set "Type change not allowed."Cannot covert from string to reference

Raghavendra · ‎11-10-2022

Hi

Actually, I had 2 fields namely "Application" &"Original request" on exceptions table. Both are string fields. Now I have deleted that both variables and created new variables with type reference field. And i captured that in update set. When I moved the update set from DEV to UAT. I'm getting error like TYPE CHANGE NOT ALLOWED.INVALID TYPE CONVERSION FOR FIELD "APPLICATION" ON TABLE "EXCEPTIONS". CANNOT CONVERT FROM STRING TO REFERENCE. THERE EXISTS DATA RECORDS (16) THAT ARE NOT A SYS ID

Can anybody help me on this

AnubhavRitolia · ‎11-10-2022

Hi @Raghavendra

As mentioned, find those 16 incident record on UAT instance which has String value in 'Application' field, and clear it's value.

Then again Preview your update set where you are getting error. This time error should not occur for Type conversion and you can commit the update set and verify field configuration.

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023

LinkedIn Profile

View solution in original post

AnubhavRitolia · ‎11-10-2022

Hi @Raghavendra

Little confusing. "Application" &"Original request" are fields or catalog variables?

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023

LinkedIn Profile

Raghavendra · ‎11-10-2022

Hi Anubhav,

Those both are fields on exception table.

AnubhavRitolia · ‎11-10-2022

Hi @Raghavendra

If you have created those 2 fields on same updates set as string type and then deleted them on same update set and then create 2 new fields on same Update Set as Reference Type. This issue should not have occurred. I hope you are moving it first time only, there is no existing update set with String type already in UAT.

If you have already moved update set where you created string fields, you have 16 records in UAT where string values are present in "Application" field. You need to first remove those field values and than try again to preview update set. I guess error won't be shown again.

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023

LinkedIn Profile

Raghavendra · ‎11-10-2022

Hi Anubhav

Yes, actually i have moved the earlier update set to UAT with string fields and there exists some data. Now i deleted those and created new fields in new update set in DEV.And while moving this one to UAT i'm getting this error. Now could you advise me what should i do?