Issue to access the external database data | Community
Skip to main content
F
felixsongfei
Level 3
January 11, 2018
Solved

Issue to access the external database data

  • January 11, 2018
  • 3 replies
  • 3681 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by felixsongfei

    Thank you. The reason is that I use the MYSQL 5.7 as external database, but the campaign is an old version, I  just updated the Adobe campaign, the issue has been resolved.

    3 replies

    florentlb
    florentlb
    Level 10
    January 15, 2018

    Hi,

    Here are a few points to check to make sure everything is correctly set.

    Maybe you'll find some hints in the links above.

    If that does not help, please provide more details about your version of Campaign, your external database and the query you are running in Campaign.

    Thanks,

    Florent

    F
    felixsongfeiAuthorAccepted solution
    Level 3
    January 17, 2018

    Thank you. The reason is that I use the MYSQL 5.7 as external database, but the campaign is an old version, I  just updated the Adobe campaign, the issue has been resolved.

      S
      sboinala
      Level 2
      February 12, 2019

      Hi ,

      I am trying the above on Adobe Campaign Standard.

      do i need to enable "Remote connections to the server" on the database server?

      and how did you deploy the functions?

      thanks

      Shiva

        Terms & ConditionsAccessibility statement

        Loading footer...