Spotify an Error Has Occurred Processing Your Request Please Try Again
Why Azure data manufacturing plant is throwing error when pulling data from on premise sql server?
Dear All,
I am new in Azure Information Factory, and trying to pull data from on premise SQL Server database AdwentureWorks2019 Employee Table.
When I loaded aforementioned Employee information into csv file on Azure Hulk storage, its get succeeded very easily. But when I am trying to load the same to Azure SQL Sever(Target) database, It is throwing error.
Error:
ErrorCode=SqlBulkCopyInvalidColumnLength,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=SQL Bulk Copy failed due to receive an **invalid cavalcade length from the bcp customer.,**Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Bulletin=The service has encountered an error processing your asking. Please effort once again. Error code 4815. A astringent mistake occurred on the electric current command. The results, if any, should be discarded.,Source=.Net SqlClient Data Provider,SqlErrorNumber=40197,Grade=xx,ErrorCode=-2146232060,State=i,Errors=[{Grade=20,Number=40197,Land=i,Message=The service has encountered an mistake processing your request. Delight try again. Error code 4815.,},{Class=20,Number=0,State=0,Message=A astringent error occurred on the electric current control. The results, if any, should be discarded.,},],'
Ensure all data types are mapped correctly and similar data types are available in target also the length.
Employee tabular array in Adv works 2019 DB has some columns having user defined data types. If you are using ADF for practice or test, I'd suggest you to attempt copy some simpler smaller table
Please don't forget to Have Respond and Up-vote if the response helped -- Vaibhav
Thank you Vaibhav,
I tried other table (Address) from on premise sql server to Azure SQL(target) and information technology loaded without whatever issue.
But when I am trying to load [HumanResources].[Employee] to Azure SQL db with verbal same structure, aforementioned datatype, it is failing.
Even I tried later on removing below 3 columns. Yet it is throwing the same error.
-
Columns
[OrganizationNode] [hierarchyid] NULL,
[OrganizationLevel] AS ([OrganizationNode].[GetLevel]()),
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT Nothing,
0 Votes 0 ·
I just tested this and it worked fine after removing the computed column from the destination table:
CREATE Tabular array [HumanResources].[Employee]( [BusinessEntityID] [int] Not NULL, [NationalIDNumber] [nvarchar](fifteen) Non NULL, [LoginID] [nvarchar](256) NOT Nada, [OrganizationNode] [hierarchyid] Zilch, [OrganizationLevel] smallint cipher, [JobTitle] [nvarchar](50) NOT NULL, [BirthDate] [date] NOT NULL, [MaritalStatus] [nchar](one) NOT Nada, [Gender] [nchar](ane) NOT NULL, [HireDate] [date] Non Nix, [SalariedFlag] [dbo].[Flag] NOT Aught, [VacationHours] [smallint] Not NULL, [SickLeaveHours] [smallint] Non Aught, [CurrentFlag] [dbo].[Flag] Not NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT Zippo, [ModifiedDate] [datetime] Non Zip, CONSTRAINT [PK_Employee_BusinessEntityID] PRIMARY Key CLUSTERED ( [BusinessEntityID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [Master] ) ON [Primary] Information technology'southward possible that this is a network issue. Is at that place any more data in the Integration runtime logs? What are the IR's proxy settings? If going through a proxy, try changing to direct connection.
Hi David,
I think, network is fine, as I when I am running few other tables, and its working admittedly fine.
Regards,
Sonu
0 Votes 0 ·
By the style, this same DDL can't be executed successfully as it has dbo.flag as datatype in information technology at 2 places.
Could yous please share the tabular array construction what you have created in Target DB ( Azure SQL Server)?
0 Votes 0 ·
The database I ran information technology in has that user-defined type:
CREATE Type [dbo].[Flag] FROM [scrap] Non Cipher 0 Votes 0 ·
Hullo @SonuOjha-3226,
This error because the length of the data coming into destination column is bigger than the column size defined. I suggest that you tin chose a data type that is large plenty for your destination.
Best regards,
Carrin
If the answer is helpful, please click "Take Answer" and upvote it.
Note: Please follow the steps in our documentation to enable eastward-mail notifications if you want to receive the related email notification for this thread.
Source: https://docs.microsoft.com/answers/questions/312155/why-azure-data-factory-is-throwing-error-when-pull.html
Did y'all create the table in Azure SQL manually or it was auto created?
0 Votes 0 ·
Tabular array created by DDL from on premise sql server.
0 Votes 0 ·
If yous generated create table script from on prem and used the aforementioned in Azure SQL, how is the information type different for 2 flag columns?
0 Votes 0 ·
How-do-you-do @SonuOjha-3226, Nosotros take not get a reply from you. Did the answers could help you? If in that location has an answer helped, do "Accept Answer". If information technology is non work, please permit us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
0 Votes 0 ·