Cannot delete Datasources

Carsten Lempert shared this problem 11 months ago
Resolved

Hi when I delete a datasource I got this message im the attachment. After that the datasource is still there. There are no views/reports on it. What can I do?

Comments (5)

photo
1

Hey Carsten,

Hope you are well!

What build of 7.3 are you currently using?

Are you deleting the datasource as the administrator?

Thanks,

Lesley

photo
1

I'm sorry it is 7.4:


Application Version:7.4Build:20180104Java Version:1.8.0_121Operating System:Windows Server 2012 R2 6.3 (amd64)


Yes I'm deleting it as an admin

photo
1

Hey Carsten,

Ive tried replicating on your version and build however it has not been successful, after looking more into it and talking to the team about it, there is a query you can run against your yellowfin configuration database to delete the datasource.

Please backup your yellowfin config database before running the query provided below. this should delete your desired datasource!

UPDATE ReportViewsource

SET AccessCode = 'DELETED'

WHERE SourceName = <insert data source name here>

Let me know how it goes and i look forward to your response! :)

Best Wishes,

Lesley

photo
1

Hi Lesley,

yes it works.

photo
1

Thats great, Carsten! :)

I'm going to go ahead and close off this ticket but if you do have any further questions then I'm happy to help!

Best Wishes,

Lesley