SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


MySQL client ran out of memory issue in ssis package.


MySQL client ran out of memory issue in ssis package.

Author
Message
asranantha
asranantha
Ten Centuries
Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)

Group: General Forum Members
Points: 1000 Visits: 4717
Hi All i have small doubt in ssis please tell me how to solve error.
I have 80 databases from mysql side .
i split 3 same package first package load 1 to 40 database and 2nd package 41 to 70 datbases and 3 package 71 to 80 database .
package design mainly extract data from Mysql table data to sql server table using ssis package and table have data more than 1 core records .
i scheduled 3 same pacakges different times each package have 4 hours differes .first and seconde package ran successfuley and thired package fail.
that time i got Issue like below and i refferes some information mainly its happen when buffer issuse or network issuse happen. this type of issue i want avoid please tell me what i do this type of sistuation.

Error:System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver] [mysqld-5.5.30-abced3.7.6-log]MySQL client ran out of memory --- End of inner exception stack trace --- at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException) at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper ErrorBigGrinatafromMysql failed the pre-execute phase and returned error code 0x80131509..
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: General Forum Members
Points: 61375 Visits: 13297
Are you executing in 32-bit or 64-bit?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
asranantha
asranantha
Ten Centuries
Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)

Group: General Forum Members
Points: 1000 Visits: 4717
executing package with 32 bit.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: General Forum Members
Points: 61375 Visits: 13297
asranantha (7/30/2014)
executing package with 32 bit.


Try to get it in 64-bit, if you have a 64-bit ODBC client for MySQL.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
asranantha
asranantha
Ten Centuries
Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)

Group: General Forum Members
Points: 1000 Visits: 4717
hi 64-bit ODBC client for MySQL driver not support in ssis 2012 (BIDS)version .i tried one more way in
using the MyODBC driver, the configuration UI has an advanced tab for flags. Check "Do not cache result".
Now I got another errore like below

Error:ADO NET Source has failed to acquire the connection {058454B0-D4D6-457A-9E1D-91228BCF947A} with the following error message: "ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'nanikum'@'hadkeld.kumarder.lcl' (using password: YES)
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'nanikum'@'hadkeld.kumarder.lcl (using password: YES)".
-----
ErrorBigGrinatafromMysql failed validation and returned error code 0xC0208449..
please tell me how to avoid this type of errors in ssis packages.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: General Forum Members
Points: 61375 Visits: 13297
asranantha (7/31/2014)
hi 64-bit ODBC client for MySQL driver not support in ssis 2012 (BIDS)version .i tried one more way in
using the MyODBC driver, the configuration UI has an advanced tab for flags. Check "Do not cache result".
Now I got another errore like below

Error:ADO NET Source has failed to acquire the connection {058454B0-D4D6-457A-9E1D-91228BCF947A} with the following error message: "ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'nanikum'@'hadkeld.kumarder.lcl' (using password: YES)
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'nanikum'@'hadkeld.kumarder.lcl (using password: YES)".
-----
ErrorBigGrinatafromMysql failed validation and returned error code 0xC0208449..
please tell me how to avoid this type of errors in ssis packages.


Visual Studio is 32-bit.
If you want to try out if the memory issue is gone with 64-bit, you need to run the package outside of BIDS.

Regarding the new error: it seems pretty clear the access is denied. Make sure the correct credentials are passed.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search