After a little more digging I can see that the problem is in the Resource object and in the datawarehouse. The results of the queries run by the installer for this particular object are either no lines or '0'.
There seems to be a problem that unables the lookups attached to the resource object to migrate to the datawarehouse. Do you agree with me? Do you have any idea of what might be the problem?
Queries run by the installer at the time of error (They either return no lines or '0' (the number)):
declare @p1 int
--set @p1=8646
exec sp_prepexec @p1 output,N'@P1 nvarchar(4000)',N'select internal_name
from odf_custom_attributes
where object_name = @P1
and is_dw_enabled = 1
and is_custom = 1',N'resource'
go
declare @p1 int
--set @p1=8425
exec sp_prepexec @p1 output,N'@P1 int,@P2 nvarchar(4000)',N'select * from DWH_META_COLUMNS
where is_custom = @P1 and UPPER(object_code) = UPPER(@P2 )',0,N'resource'
go
declare @p1 int
--set @p1=8647
exec sp_prepexec @p1 output,N'@P1 nvarchar(4000),@P2 nvarchar(4000)',N'select count(1) dw_table_exists
from DWH_META_TABLES
where
UPPER(dwh_table_name) = UPPER(@P1 ) and UPPER(src_table_name) = UPPER(@P2 )',N'dwh_lkp_employment_type',N'DWH_LOOKUPS_V'
go
declare @p2 numeric(38,0)
--set @p2=5002000
exec CMN_ID_SP N'DWH_META_TABLES',@p2 output,1000,NULL
go
declare @p1 int
--set @p1=8649
exec sp_prepexec @p1 output,N'@P1 nvarchar(4000),@P2 nvarchar(4000)',N'select count(1) lookup_col_exists
from cmn_attributes ca,
CMN_LIST_OF_VALUES lov
where UPPER(ca.table_name) = ''CMN_LIST_OF_VALUES''
and ca.pk_id=lov.id
and UPPER(lov.LOOKUP_TYPE_CODE) = UPPER(@P1 )
and UPPER(COLUMN_NAME) = UPPER(@P2 )',N'LOOKUP_SEC_RESMGR',N'last_updated_date'
go
declare @p1 int
--set @p1=8650
exec sp_prepexec @p1 output,N'@P1 nvarchar(4000),@P2 nvarchar(4000)',N'select count(1) dw_table_exists
from DWH_META_TABLES
where
UPPER(dwh_table_name) = UPPER(@P1 ) and UPPER(src_table_name) = UPPER(@P2 )',N'dwh_res_resource',N'dwh_res_resource_v'
Thank you,
Gonçalo