Solved

Missing domains after upgrade to 2020.1.12

  • 11 March 2020
  • 2 replies
  • 38 views

Userlevel 2
Badge +5

After the upgrade of the IAM and SF from version 2019.1 to 2020.1.12 the validation of projects if failing with the following message:

Aren’t these included in the upgrade?

icon

Best answer by Frank Wijnhout 11 March 2020, 10:25

View original

2 replies

These datatypes are included in the upgrade of the SF and IAM. However, these datatypes are also needed on your own applications. After generating your application, they will be available as a domain in the SF. But they are still missing in your database(s). To fix this, you can run the following code on all of your application databases:

create type tsf_tab_id from varchar(100)
go

grant references on type::tsf_tab_id to public
go


create type tsf_success_ind from bit
go

grant references on type::tsf_success_ind to public
go

 

Userlevel 2
Badge +5

Found it out myself…

I needed to create these domains in all the product db's myself.

Reply