cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shubs Regular Visitor
Regular Visitor

Failed to save modifications to server (mysql)


Hello,

 

Can anyone help me with this ?

errors.PNG

I am fetching data from mysql with the help of vpn and ssh tunnel(with help of PuTTY). I am able to have access to the database and can preview the tables. When I try to load it, then this throw this error to me. The required table have more than 4 million records.

 

Thanks
Shubs 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Failed to save modifications to server (mysql)

@Shubs,

 

Yoiu may try to specify Timeout parameter in Advanced Editor.

https://msdn.microsoft.com/en-us/library/mt742860.aspx

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jessica_Seiya Established Member
Established Member

Re: Failed to save modifications to server (mysql)

You can try to increase the timeout value and see if you can load the data successfully. By default, the timeout value is 10 minutes.

2018-11-22_15-58-12.png

 

 

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Failed to save modifications to server (mysql)

@Shubs,

 

Yoiu may try to specify Timeout parameter in Advanced Editor.

https://msdn.microsoft.com/en-us/library/mt742860.aspx

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jessica_Seiya Established Member
Established Member

Re: Failed to save modifications to server (mysql)

You can try to increase the timeout value and see if you can load the data successfully. By default, the timeout value is 10 minutes.

2018-11-22_15-58-12.png

 

 

 

Highlighted
Shubs Regular Visitor
Regular Visitor

Re: Failed to save modifications to server (mysql)

Hi @v-chuncz-msft and @Jessica_Seiya,

 

Thanks for your response. I finally resolved this error my adding durration in my query with your help.

 

Thanks

Shubs