Category
Data Sources
Product Version
7.4
Cannot delete Datasources
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?
Files:
error.PNG
The same problem 
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
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
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
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
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
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
Hi Lesley,
yes it works.
Hi Lesley,
yes it works.
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
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
Replies have been locked on this page!