July 30, 2014 at 12:37 am
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..
July 30, 2014 at 12:50 am
Are you executing in 32-bit or 64-bit?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 30, 2014 at 12:56 am
executing package with 32 bit.
July 30, 2014 at 1:09 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2014 at 12:05 am
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.
July 31, 2014 at 12:26 am
asranantha (7/31/2014)
hi 64-bit ODBC client for MySQL driver not support in ssis 2012 (BIDS)version .i tried one more way inusing 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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply