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, List
1 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, Nullable
1 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, Nullable
1 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