ADF Lookup activity - Issue with the user

Question

Hi - I am trying to run lookup activity in my data flow pipeline and it is failing with above mentioned error.

Note: Linked services and integration runtimes are configured and successfully validated.

1. Where i can get the user supermanadmin from(visible in attached screenshot)? Is it coming from my database?

Kindly guide.

greglow · Answer

Is it MySQL that you're trying to connect to? This might help: https://dba.stackexchange.com/questions/107536/the-user-specified-as-a-definer-root-does-not-exist

ronen_ariely · Answer

Hi,
I highly recommend you to get sued with using Google since such specific issues raise to many users and there are multiple reports and solutions published online

Basically this seems like MySQL error 1449: The user specified as a definer does not exist

You can find a few solutions and explanation in this post:
https://confluence.atlassian.com/confkb/mysql-error-1449-the-user-specified-as-a-definer-does-not-exist-1096092001.html

Good luck

Forum Discussion

ADF Lookup activity - Issue with the user

Share

Resources