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

SOLVED

process missing from the processlist in external database when I run the Data Loading(RDBMS) activity

felixsongfei
Level 3
Level 3

I created a FDA connnection to a MySQL database. And then I use the activity "data loading(RDBMS)" to synchronize the data from the MySQL tables, the table has aout 30 million rows in it, after I run the activity for 10 mins, the SQL process in the MYSQL database missing from the processlist. How can I confirgure the FDA connnections and let the Adobe campaign can load the data from the external MySQL database?

 

felixsongfei_0-1614590337648.png

 

1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

 

Try setting session max_execution_time to 0 in External Account's PostConnect script?

 

Thanks,

-Jon

View solution in original post

2 Replies
wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

 

Try setting session max_execution_time to 0 in External Account's PostConnect script?

 

Thanks,

-Jon

View solution in original post

Sukrity_Wadhwa
Employee
Employee

Hi @felixsongfei,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!