Can you show us the code you're using in order for us to reproduce the issue? We will likely have some recommendations for you to possibly work around the immediate issue, and hopefully make some suggestions about the performance issue also.

This issue can't be strictly related to the upgrade - some other condition must be happening here. I can use the following successfully:

create table t1(
  c1 integer primary key default autoincrement,
  c2 integer,
);

insert into t1 (c2) select row_num from sa_rowgenerator( 1, 10000 );

create table t2(
  c1 integer primary key default autoincrement,
  c2 integer
);

And the code:

    static void Main(string[] args)
    {
        try
        {
            SAConnection conn = new SAConnection("uid=dba;pwd=sql;eng=bulkcopy");
            conn.Open();
            SACommand comm = new SACommand("select c1, c2 from t1", conn);
            SADataReader reader = comm.ExecuteReader();
            using (SABulkCopy saBulkCopy = new SABulkCopy(conn))
            {
                saBulkCopy.DestinationTableName = "t2";
                saBulkCopy.BulkCopyTimeout = 86400;
                saBulkCopy.BatchSize = 10000;
                saBulkCopy.NotifyAfter = 2500;
                saBulkCopy.WriteToServer(reader);
            }
            reader.Close();
            conn.Close();
        }
        catch (Exception ex)
        {
            Console.Out.WriteLine("Exception: " + ex.Message + "\n\nStack Trace:\n\n" + ex.StackTrace);
        }
    }

Can you change my code to reproduce your error?

Also, in terms of the performance issue, what happens if you get rid of all of the callbacks - don't do any notifications and remove the event handler?

Hi Jeff:

Thanks for your suggestion. I have tried your code, it does not crash; but within my project, it does crash with the error stack as per attached. It appears that the only difference is the DataReader is reading a MS SQL database rather than a SQL AnyWhere db. Also, in terms of the performance issue, with version, 12.0.1.34573, it does not make any difference after I remove the event notification, the more columns the copy table has, the slower, the table I am testing against has about 40 columns, with 10000 records, it takes around 30 mins, the table structure in your suggestion only takes few seconds. Anyhow, if the new version 12.0.1.39673 does not crash, i.e. when the reader is reading from the same SQL Anywhere db, the time it takes to do the bulkcopy does reduce significently. So the question is how can we get around this crash problem? i.e. we are copying from MS Sql db.

Hi Jeff:

I suspect that the stack error is not attached properly, so here is the message from the crash error:

at iAnywhere.Data.SQLAnywhere.SADataAdapter.FillSchema(DataTable dataTable, SchemaType schemaType, SADataReader dataReader, DataTableMapping tm) at iAnywhere.Data.SQLAnywhere.SABulkCopy.WriteToServer(IDataReader reader) at Converter.WinToMacDBManager.BulkCopy(IDataReader aDataReader, String aTargetTableName) in c:WinMacConverterConverterWinToMacWinToMacDBManager.cs:line 189 at Converter.WinToMacDBManager.BulkCopy(String aGetString, String aTargetTableName) in c:WinMacConverterConverterWinToMacWinToMacDBManager.cs:line 73 at Converter.WinToMacConverterController.CopyDirectTableRecordsToMac() in c:WinMacConverterConverterWinToMacWinToMacConverterController.cs:line 272 at Converter.WinToMacConverterController.Convert() in c:WinMacConverterConverterWinToMacWinToMacConverterController.cs:line 145 at Converter.ConverterController.StartConvert() in c:WinMacConverterConverterConverterController.cs:line 726 at Converter.ConverterController.Run(BackgroundWorker worker, DoWorkEventArgs e) in c:WinMacConverterConverterConverterController.cs:line 112