Cassandra OLEDB Provider - Export MSSQL->Cassandra Error

More
2 years 1 week ago #13860 by raluca_ma
Hello,

I have installed the Cassandra OLEDB Provider and I am trying to export from SQL Server 2008 a table into my Cassandra cluster using the SSMS Export Wizard.
I have managed to successfully create my connection to the Cassandra cluster (as a destination) but I get a memory related error when I execute it.
After creating both connections successfully (SQL Server-source and Cassandra-destination), I check the mappings of my two tables, and both are ok, so there is no issues in seeing the Cassandra table.
Below I have posted my error along with the process.

[attachment=2:1ug0bt17]<!-- ia2 -->cass1.png<!-- ia2 -->[/attachment:1ug0bt17]
[attachment=1:1ug0bt17]<!-- ia1 -->cass2.png<!-- ia1 -->[/attachment:1ug0bt17]
[attachment=0:1ug0bt17]<!-- ia0 -->cass3.png<!-- ia0 -->[/attachment:1ug0bt17]

Please, if anybody has an idea on how I could solve this, it would be extremely appreciated, as I couldn't find anything online about this error either.
Thank you so much!
Attachments:

Please Log in or Create an account to join the conversation.

More
2 years 1 day ago #13864 by Moderator
Could you email the SQL Server table definition to our support (or place it here if it is not a secret)? How many rows are in the table?

We will try to reproduce, and fix the issue asap.

Please Log in or Create an account to join the conversation.

More
2 years 1 day ago #13867 by raluca_ma
The table has five columns:
id int
firstname varchar(500)
lastname varchar (500)
spouse_firstname varchar(500)
spouse_lastname varchar(500)

I tried with a table with 450 million records, and then created an identical table with 1 million records and I got the same error.

Thank you and looking forward to your reply!

Please Log in or Create an account to join the conversation.

Time to create page: 0.137 seconds
Powered by Kunena Forum