Copy QAM report which is using Data governance resource Access Data Provider

What version are you using?

Hi Markus,

our version is 9.2.

Can you please run the following SQL and post the results?

select 
   p.ParameterName, p.DataType, p.DateTimeDetail, ps.ObjectKeyUsedBy
from 
DialogParameterSet PS
join DialogParameter P on P.UID_DialogParameterSet = Ps.UID_DialogParameterSet
where (p.datatype<>5 AND p.Datatype >= 0) AND p.DateTimeDetail>-1

Hi Markus,

query result is empty (0 record found)

Okay. A workaround would be to execute this SQL. But I suggest you contact support as well. 

update 	DialogParameter 
	set DateTimeDetail = -1 
	from DialogParameter p
	where 
    isnull(p.DateTimeDetail,0) <> -1 
	and p.DataType=-1
    and Exists (Select Top 1 1 from DialogParameterSet ps where ps.UID_DialogParameterSet = p.UID_DialogParameterSet and ObjectKeyUsedBy like N'<Key><T>DialogReport</T>%')

Okay. A workaround would be to execute this SQL. But I suggest you contact support as well. 

update 	DialogParameter 
	set DateTimeDetail = -1 
	from DialogParameter p
	where 
    isnull(p.DateTimeDetail,0) <> -1 
	and p.DataType=-1
    and Exists (Select Top 1 1 from DialogParameterSet ps where ps.UID_DialogParameterSet = p.UID_DialogParameterSet and ObjectKeyUsedBy like N'<Key><T>DialogReport</T>%')

Hi Markus,

this workaround works well.

The strange thing is that version 9.2 with Data Governace is a clean new installation and error in copying report exist only for reporting that use Data Governance Resource Access Data Provider.

Thanks for support.

Best regards.