Skip to main content


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.

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.

Hi Mark,

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

Reply


Terms & ConditionsCookie settings