SQLPackage Error While Extracting Dedicated SQL Pool DB in Azure

Question

HiWe're in process of moving our Dedicated SQL Pool (DW) DBs across tenant (i.e., to a different Entra ID Tenant) in a newly built Azure subscription. We are using SQLPackage utility to extract (export) the data (BACPAC and DACPAC) files, so we can publish (import) them into the newly built target Azure SQL Servers. During the extraction process, we're seeing the following error:

.\SqlPackage : *** Error extracting database: At line:1 char:1 .\SqlPackage /Action:Extract /DiagnosticsFile:"C:\Users\tmccvv\Deskto ...     + CategoryInfo          : NotSpecified: (*** Error extracting database::String) [], RemoteException     + FullyQualifiedErrorId : NativeCommandError   Error SQL73068: 110802;An internal DMS error occurred that caused this operation to fail. Details: Exception: Microsoft.SqlServer.DataWarehouse.DataMovement.Common.ExternalAccess.HdfsAccessException, Message: Error occurred while accessing HDFS external file[/ser ver.database.windows.net/devdatawarehouse/02-08-2024_13-15-47/dbo.PCI_SAMap_Tables/QID161632907_20240208_21915_5.parq.snappy][0]: Java exception raised on call to HdfsBridge_CreateRecordWriter. Java exception message: HdfsBridge::createRecordWriter - Unexpected error encountered when creating a record writer: IllegalArgumentException: field ended by ';': expected ';' but got 'ID' at line 1:   optional binary Customer ID Time elapsed 0:08:13.19

---

I generated the diagnostic logs and it doesn't contains anything additional.

Tried the extracting process on one more DB and it generated the same error. Any pointers / guidance please? Thanks Taranjeet Singh

Answer 1

We were able to resolve this issue. Closely looking at the tables that were failing and comparing it with the ones that pass (extracted successfully by SQLPAckage), we found that the column name (as reported in the error) in those tables had a space in between. For example, column name was "Agent Name". We removed the spaces to make it "AgentName" and that fixed the issue.Hopefully this will help others who face the same issue. Thanks

Answer 2

Hi Taranjeet Malik,

Welcome to Microsoft Q&A forum.

As I understand, you are getting SQLPackage Error While Extracting Dedicated SQL Pool DB.

Could you please share what steps you are following and which Microsoft document you are referring for this?

Also, intended task could be done through Powershell as illustrated here:

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-active-paused-dw#restore-an-existing-dedicated-sql-pool-formerly-sql-dw-through-powershell

Awaiting your reply, thanks.

Answer 3

Hi
Taranjeet Malik,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Solution: Removal of Space from Column Name fixed the issue.

If you have any other questions or are still running into more issues, please let me know.

Thank you again for your time and patience throughout this issue. Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

Really appreciate your efforts in sharing the solution with the Microsoft Q&A community.

Thanks