Skip to main content
Solved

/* Rename changed datatype image */

  • November 13, 2024
  • 2 replies
  • 42 views

Mehran
Rookie
Forum|alt.badge.img


Hi, I'm seeking assistance regarding an issue I encountered during the creation process in Thinkwise Software Factory (SF) while executing source code. The error message I received is as follows:

An unknown error occurred while executing '
/* Rename changed datatype image */
exec sp_rename 'image', '__image__', 'userdatatype'
'.

Error: 'This action cannot be performed on a system type.'.

It seems that the error is related to attempting to rename a system-defined datatype, which isn't allowed in SQL Server. This occurred specifically in the "Creation Process" under "Execute Source Code."

Could you please provide guidance on how to resolve this issue and ensure that the creation process can be completed successfully?

Thank you for your support and assistance.

Best answer by Mark Jongeling

Hi Mehran,

You probably have created a domain called image. Apparently SQL Server does not like this when used with sp_rename. We can't do much about that I'm afraid.

I can recommend ensuring that all domains you create do not use any similar name to system types of SQL Server.

For now, I think you will need to run the Upgrade script manually, excluding this piece of code that now raises the error. Also furtherdown, ensure the datatype is not dropped. Your (new) tables will start using the new domain name you have chosen. 

I can recommend asking one of your direct colleagues for more help with this.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3936 replies
  • Answer
  • November 13, 2024

Hi Mehran,

You probably have created a domain called image. Apparently SQL Server does not like this when used with sp_rename. We can't do much about that I'm afraid.

I can recommend ensuring that all domains you create do not use any similar name to system types of SQL Server.

For now, I think you will need to run the Upgrade script manually, excluding this piece of code that now raises the error. Also furtherdown, ensure the datatype is not dropped. Your (new) tables will start using the new domain name you have chosen. 

I can recommend asking one of your direct colleagues for more help with this.


Mehran
Rookie
Forum|alt.badge.img
  • Author
  • Rookie
  • 1 reply
  • November 13, 2024

Hi Mark,

Thanks for your solution. My colleague helped me, and we ran the Upgrade script manually!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings