I created an external database to MySQL database, then created a schema to access the external database. I can see the data in the schema from the external database. But when I run the query activity in workflow, it will run for a long time, I can see the template table "wkf*****" was created in the MySQL data base, but the result will not return back to Adobe workflow. The query activity will run for a long time.
PS: I can get the data by create a queryDef in the Javascript code, only the query activity will not run successfully.
Do you know what is the reason of the issue? Is it the issue with Adobe or the external database?