• State Verified Answer
  • Replies 6 replies
  • Subscribers 95 subscribers
  • Views 620 views
  • Users 0 members are here
Options
Related

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

luca tenti
10 months ago

I try to copy from Report editor

VI_QAM_Resource_Access but its not working becouse an error appear:

[810025] Parameters: Write permission denied for value "Date add-on".

.....

....

Write permission for DateTimeDetail is denied because of: VI.Common.Customizer.DialogParameter

There is a workaround to manage copying it.

Thanks.

Parents Reply Children
  • +1 10 months ago in reply to luca tenti

    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>%')

  • 0 10 months ago in reply to Markus Weiss-Ehlers

    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.