Error when importing a bacpac

Question

Hi,

Each time I try to import a bacpac into my Azure server, I get this error :

Error encountered during the service operation. 
50001: Unable to import bacpac. Inner exception may have more details.
50001: Unable to import bacpac. Inner exception may have more details.
'ONLINE INDEX DDL WITH LARGE OBJECT' is not supported in this version of SQL Server.

The error occured on 25/10/2011 16:09:32 the request id is : f3a81753-f8b7-4bd9-a887-ee794d8aab5d

Many thanks.

---

R.

Answer 1

Hey rodbeck,

 

This error occurs when an index is built online over varbinary columns.  A fix for this will be deployed this week so that the index is not created online that should unblock you. You will not need to regenerate the BACPAC, simply resubmitting the request once the update is live should work.

Answer 2

The update is live now, rodbeck, please try to import the same BACPAC again and let us know if you hit an issue.

Answer 3

Hi Adrian,

I just tried a bacpac that was generated on 09/27, it failed with the same error.

I'm on North Europe datacenter for your information

Thanks.

---

R.

Answer 4

Also tried with a bacpac from yesterday, it failed as well.

---

R.

Answer 5

We'll need to take a closer look at your issue.  Could you provide a requestID to take a look at?

Answer 6

Hi Adrian,

Here are the details on my last try :

PRD***_RESTORED;Import;Failed;29/10/2011 08:08:27;f5a37d0a-aa25-482f-adca-bb22f0431f85;Error encountered during the service operation. 

50001: Unable to import bacpac. Inner exception may have more details.

50001: Unable to import bacpac. Inner exception may have more details.

'ONLINE INDEX DDL WITH LARGE OBJECT' is not supported in this version of SQL Server.

Thanks.

---

R.

Answer 7

Adrian,

I have another question : do you know approximately when the Import/Export CTP will become a production service ?

Thanks for your help.

---

R.

Answer 8

Rodolphe,

I trust you are no longer encountering issues when importing?  I'll post an update with a production timeline within a few weeks.

Answer 9

Hi Adrian,

As said earlier, everything works fine now.

Thanks again for your help !

---

R.