Pipeline Issue

Question

Hello Team, I am trying to create a view in the SQL Server after uploading the data in csv format from one container(raw) to staging zone by entering the parameter for Company.it is working perfectly if I pass the parameter for Table name is like "Vendor". if i pass the parameter for the table name called "Vendor Amount" then it is giving below error in lookup(Drop View).I think because there is a space between Vendor and Amount . Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Incorrect syntax near 'Amount'.',Source=,''Type=System.Data.SqlClient.SqlException,Message=Incorrect syntax near 'Amount'.,Source=.Net SqlClient Data Provider,SqlErrorNumber=102,Class=15,ErrorCode=-2146232060,State=1,Errors=[{Class=15,Number=102,State=1,Message=Incorrect syntax near 'Amount'.,},],' But the view is getting created in . Please refer below my pipeline : ![73050-image.png][1] [1]: /api/attachments/73050-image.png?platform=QnA

Answer 1

Try giving view name in square brackets like CREATE VIEW [Vendor Amount]

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

Hello Vaibhav, I tried passing the parameter like [Vendor Amount].Please refer the below error in azure function: Call to provided Azure function 'CreateSynapseOnDemandViewFromModelJson' failed with status-'InternalServerError' and message - 'Invoking Azure function failed with HttpStatusCode - InternalServerError.'. ![73180-image.png][1] [1]: /api/attachments/73180-image.png?platform=QnA Regards RK

Answer 3

Thanks Vaibhav forgiving me hint.

There was a issue in the lookup Activity.

IF EXISTS (SELECT 1 FROM sys.objects o JOIN sys.schemas s on o.schema_id = s.schema_id WHERE o.type = 'V' AND o.name = '@{pipeline().parameters.EntityName}' AND s.name = '@{pipeline().parameters.TargetSchema}' ) DROP VIEW [@{pipeline().parameters.TargetSchema}].[@{pipeline().parameters.EntityName}]

SELECT 1;

I had used

Before :
DROP VIEW @{pipeline().parameters.TargetSchema}.@{pipeline().parameters.EntityName}

And after rectified and mentioned [] it got worked:

DROP VIEW [@{pipeline().parameters.TargetSchema}].[@{pipeline().parameters.EntityName}]

Regards
RK

Answer 4

I had made pipeline (custom batch) to invoke python script from blob storage. the execution is getting failed. and the error 2010 is showing up.
Error code : 2010
Failure type : User configuration issue
Details : Hit unexpected exception, please retry. If the problem persists, please contact Azure Support"
Source