Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

An entry with the same key already exists.

Hi Team,    We are refreshing the data for already built report. I am getting the error 'An entry with the same key already exists.' Below is the log for that. We have tried to clear the permission...
Need Help
gguille's avatar
gguille
New Member
3 years ago

I had the same issue and the cause was a table and a function with the same name.

In MySQL, you can get 4 lists with queries like this.

SHOW FUNCTION STATUS WHERE DB = 'your_db';
SHOW PROCEDURE STATUS WHERE DB = 'your_db';
SELECT TABLES.Table_Name FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'your_db';
SELECT VIEWS.Table_Name FROM information_schema.VIEWS WHERE TABLE_SCHEMA = 'your_db';

 Hope this helps.