Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Issue to access the external database data

Avatar

Avatar
Give Back
Level 2
felixsongfei
Level 2

Likes

11 likes

Total Posts

34 posts

Correct Reply

2 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile

Avatar
Give Back
Level 2
felixsongfei
Level 2

Likes

11 likes

Total Posts

34 posts

Correct Reply

2 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile
felixsongfei
Level 2

10-01-2018

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back
Level 2
felixsongfei
Level 2

Likes

11 likes

Total Posts

34 posts

Correct Reply

2 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile

Avatar
Give Back
Level 2
felixsongfei
Level 2

Likes

11 likes

Total Posts

34 posts

Correct Reply

2 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile
felixsongfei
Level 2

16-01-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.

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 1
shivab40639663
Level 1

Likes

3 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
shivab40639663
Level 1

Likes

3 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 3
Boost 1
View profile
shivab40639663
Level 1

11-02-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

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

15-01-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