Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MySQL client ran out of memory issue in ssis package. Expand / Collapse
Author
Message
Posted Wednesday, July 30, 2014 12:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540

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 Error:DatafromMysql failed the pre-execute phase and returned error code 0x80131509..
Post #1597589
Posted Wednesday, July 30, 2014 12:49 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1597591
Posted Wednesday, July 30, 2014 12:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540
executing package with 32 bit.
Post #1597593
Posted Wednesday, July 30, 2014 1:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1597597
Posted Thursday, July 31, 2014 12:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540
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)".
-----
Error:DatafromMysql failed validation and returned error code 0xC0208449..
please tell me how to avoid this type of errors in ssis packages.
Post #1598096
Posted Thursday, July 31, 2014 12:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
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)".
-----
Error:DatafromMysql 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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1598099
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse