Table Issue

DEEPAK KUMAR SI
Tera Contributor

‎12-20-2023 01:29 AM

Hi Dev's
Need solution

By mistake I have change the field type from "Reference " to "String". Now unable to revert it.

Any solutions will be helpful...

 

I have gone through one of the article :: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0695947  - But unable to understand much. If anyone can guide me a bit.

 

Error Message : Error Message Type change not allowed. Invalid type conversion for field 'Child' on table 'CI Relationship'. Cannot convert from 'String' to 'Reference'. There exists data records (74) that are not a Sys_id.

0 Helpfuls
  • 522 Views
4 REPLIES 4

AndersBGS
Tera Patron
Tera Patron

‎12-20-2023 01:46 AM

Hi @DEEPAK KUMAR SI ,

 

Which table and which field do you refer to? 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

0 Helpfuls

DEEPAK KUMAR SI
Tera Contributor
In response to AndersBGS

‎12-20-2023 03:49 AM

cmdb_rel_ci 

Field Name - Child

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to DEEPAK KUMAR SI

‎12-20-2023 05:09 AM

Hi @DEEPAK KUMAR SI 

 

Better is , take back and empty the values of field and change the data type. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Saurav11
Kilo Patron
Kilo Patron

‎12-20-2023 01:49 AM

Hello,

 

The error probably is because you have values populated in the field. What I would suggest is take a backup of the values stored in that field for each record then make the field which you want to convert as empty.

 

Then convert the field type save it. Then repopulate the values which you had taken the back up of.

 

Please mark my answer as correct based on Impact.