Reply
Regular Visitor
Posts: 31
Registered: ‎03-28-2018
Accepted Solution

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 

 

 


Accepted Solutions
Community Support Team
Posts: 3,802
Registered: ‎07-09-2016

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.

View solution in original post

Highlighted
Established Member
Posts: 161
Registered: ‎01-02-2018

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

 

 

 

View solution in original post


All Replies
Community Support Team
Posts: 3,802
Registered: ‎07-09-2016

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.

Highlighted
Established Member
Posts: 161
Registered: ‎01-02-2018

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

 

 

 

Regular Visitor
Posts: 31
Registered: ‎03-28-2018

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