Error code BadRequest Failure type User configuration issue

Annie Lu 1 Reputation point
2022-02-04T19:43:15.947+00:00

Hello, I have run this pipeline before successfully but now am receiving this error.

Error:
Error code
BadRequest
Failure type
User configuration issue
Details
Operation on target StatusFunction failed: Call to provided Azure function 'StatusFunction' failed with status-'InternalServerError' and message - '{"Status":{"Status":"Failed","Message":"Sql Error Number: 1911. Execution Time: 00:00:00.062. SQL operation failed. [Error Cause:Unspecified][User Error:False][Fatal Error:False][Target:Sql]","Details":" at Microsoft.Xbox.SQLizer.Common.Utilities.SqlStore.SqlStoreErrorHandler(Exception ex, Int32 remainingAttempts, TimeSpan attemptTime, Object state) in C:\source\src\Egress\Tools\SQLizer\DataMart\SQLizer.Common\Utilities\SqlStore.cs:line 1113\r\n at Microsoft.Xbox.SQLizer.Core.RetryPolicy.Evaluate(Exception ex, Int32 currentRetryCount, TimeSpan attemptTime) in C:\source\src\Egress\Tools\SQLizer\Common\SQLizer.Core\RetryPolicy.cs:line 82\r\n at Microsoft.Xbox.SQLizer.Core.Operation.HandleError(Exception ex, Int32 currentAttempt, TimeSpan attemptTime, RetryPolicy retryPolicy, CancellationToken ct, String logActionInfo) in C:\source\src\Egress\Tools\SQLizer\Common\SQLizer.Core\Operation.cs:line 179\r\n at Microsoft.Xbox.SQLizer.Core.Operation.ExecuteWithRetryT in C:\source\src\Egress\Tools\SQLizer\Common\SQLizer.Core\Operation.cs:line 129\r\n at Microsoft.Xbox.SQLizer.Processor.Sql.EntityStore.ExecuteSchemaOperation(String tableScript) in C:\source\src\Egress\Tools\SQLizer\DataMart\SQLizer\Processor\Sql\EntityStore.cs:line 519\r\n at Microsoft.Xbox.SQLizer.Processor.Sql.SqlEntitySetup.GenerateSchema(DataTable table, Entity entity, EntityStore entityStore, List1 columns, Boolean handleExtraColumns, List1 extraColumns) in C:\source\src\Egress\Tools\SQLizer\DataMart\SQLizer\Processor\Sql\SqlEntitySetup.cs:line 367\r\n at Microsoft.Xbox.SQLizer.Processor.Sql.SqlEntityProcessor.<>c__DisplayClass15_0.<GenerateTableSchema>b__0(CancellationToken ct) in C:\source\src\Egress\Tools\SQLizer\DataMart\SQLizer\Processor\Sql\SqlEntityProcessor.cs:line 250\r\n at Microsoft.Xbox.SQLizer.Core.Operation.ExecuteWithRetry(Action1 action, RetryPolicy retryPolicy, Nullable1 ct, String logActionInfo) in C:\source\src\Egress\Tools\SQLizer\Common\SQLizer.Core\Operation.cs:line 37\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at Microsoft.Xbox.SQLizer.Core.Operation.HandleError(Exception ex, Int32 currentAttempt, TimeSpan attemptTime, RetryPolicy retryPolicy, CancellationToken ct, String logActionInfo) in C:\source\src\Egress\Tools\SQLizer\Common\SQLizer.Core\Operation.cs:line 216\r\n at Microsoft.Xbox.SQLizer.Core.Operation.ExecuteWithRetry(Action1 action, RetryPolicy retryPolicy, Nullable1 ct, String logActionInfo) in C:\source\src\Egress\Tools\SQLizer\Common\SQLizer.Core\Operation.cs:line 37\r\n at Microsoft.Xbox.SQLizer.Processor.Sql.SqlEntityProcessor.GenerateTableSchema(IEnumerable`1 streamSetMetadata, Boolean filterColumns, Boolean disableColumnMapping) in C:\source\src\Egress\Tools\SQLizer\DataMart\SQLizer\Processor\Sql\SqlEntityProcessor.cs:line 249\r\n at Microsoft.Xbox.SQLizer.Processor.EntityProcessorBase.DoWork() in C:\source\src\Egress\Tools\SQLizer\DataMart\SQLizer\Processor\EntityProcessorBase.cs:line 468\r\n at Microsoft.Xbox.SQLizer.Coordinator.<>c__DisplayClass13_1.<RunEntityProcessors>b__0() in C:\source\src\Egress\Tools\SQLizer\DataMart\SQLizer\Coordinator.cs:line 428\r\n at System.Threading.Tasks.Task.InnerInvoke()\r\n at System.Threading.Tasks.Task.Execute()","FullLog":"https://bluetoothcstoragea5ci.file.core.windows.net/logs/Camera-Catalog-SQLizer-557b/2022_2_4_18_30.txt?sv=2019-02-02&sr=f&sig=xdBlLl1EhH9Di1zV5KUPF8GbHWtNRXy1SSeIQ4QCLOU%3D&st=2022-02-04T18%3A30%3A26Z&se=2023-02-04T18%3A30%3A26Z&sp=r","CreatedPipelines":[],"Version":"9.1.22020.126","PipelineActivityId":"557b4777-88fb-44fe-9afe-25e89edf3d81"},"ErrorMessage":"Sql Error Number: 1911. Execution Time: 00:00:00.062. SQL operation failed. [Error Cause:Unspecified][User Error:False][Fatal Error:False][Target:Sql]"}'.
Source
Pipeline
SQLizerPipeline with retry

Would you be able to provide any tips as to how I can resolve this? I've attached the pipeline json. 171515-camerapipeline.txt

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,508 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2022-02-08T00:40:25.22+00:00

    Hello @Annie Lu ,

    Welcome to the Microsoft Q&A platform and thanks for your query.

    As I understand the ask here is your ADF pipeline with Azure function activity which used to work in the past has been suddenly failing without any changes to it. Please correct if I'm not accurate.

    At this time, we don't know what your Azure function activity is doing. But based on the error message ( "Sql Error Number: 1911. Execution Time: 00:00:00.062. SQL operation failed ) it seems like a user configuration issue related to SQL server call which is resulting in time outs and hence the pipeline is failing. I would recommend checking if your azure function activity is properly configured as described in the public doc.

    If the issue not consistent or transient one, then I recommend setting up retry options in Azure Function activity settings and see if that helps to avoid this issue.

    There could be a possibility that your Function app code is having some issue in interacting with the actual endpoint and hence timing out which is resulting the ADF pipeline to fail.

    In case if you haven't made any changes to the pipeline or the activity (which used to work in the past) but it started failing all of sudden, then I recommend filing a support ticket for deeper analysis as the information provided is not very helpful to troubleshoot further or assist better.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators