Windows Azure Platform >
> 
> 
Error when importing a bacpac

質問 Error when importing a bacpac

  • Tuesday, October 25, 2011 5:10 PM
     
      Has Code
    Sign In to Vote
    0

    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.
     

All Replies

  • Tuesday, October 25, 2011 6:35 PM
     
     
    Sign In to Vote
    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.

    • Marked As Answer by Rodolphe Beck Wednesday, October 26, 2011 12:57 PM
    • Unmarked As Answer by Rodolphe Beck Monday, October 31, 2011 3:12 PM
    •  
     
  • Friday, October 28, 2011 1:11 AM
     
     
    Sign In to Vote
    0
    The update is live now, rodbeck, please try to import the same BACPAC again and let us know if you hit an issue.
     
  • Friday, October 28, 2011 5:42 AM
     
     
    Sign In to Vote
    0

    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.
     
  • Friday, October 28, 2011 9:36 AM
     
     
    Sign In to Vote
    0
    Also tried with a bacpac from yesterday, it failed as well.
    R.
     
  • Friday, October 28, 2011 11:11 PM
     
     
    Sign In to Vote
    0
    We'll need to take a closer look at your issue.  Could you provide a requestID to take a look at?
     
  • Saturday, October 29, 2011 8:12 AM
     
     
    Sign In to Vote
    0

    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.
     
  • Thursday, November 03, 2011 9:31 AM
     
     
    Sign In to Vote
    0

    Adrian,

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

    Thanks for your help.

    R.
     
  • Friday, November 18, 2011 7:16 PM
     
     
    Sign In to Vote
    0

    Rodolphe,

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

     
  • Friday, November 18, 2011 7:20 PM
     
     
    Sign In to Vote
    0

    Hi Adrian,

    As said earlier, everything works fine now.

    Thanks again for your help !

    R.