CODEWITHSUNDEEP
azureazure-data-lakeu-sql
david nadal
david nadal

Reputation: 279

U-SQL Job Failing

I have a USQL Script which works fine for a single file.

I put some ?? operators in the query to account for missing data cases too.

Now, when I ran it on about 900 JSON files:

TooManyVertexFailedInStage: Too many vertex failures in a stage
E_RUNTIME_USER_EXPRESSIONEVALUATION: Error while evaluating expression Microsoft.Analytics.Samples.Formats.Json.JsonFunctions.JsonTuple(tmp_0[0])["Value"] ?? "0"

Component
JobManager_User

Message
Too many vertex failures in a stage

Description
Many vertices in stage SV1_Extract failed due to Vertex user code error.
Details
Vertex SV1_Extract[4613].v0 {9199FFCE-F114-47D1-912E-D5FFBAC11E0C} failed 

Error:
Vertex user code error

exitcode=CsExitCode_StillActive Errorsnippet=

I am not getting the cause of the error?

And how could I resolve it?

Upvotes: 0

Views: 278

Answers (1)

Dave Bending
Dave Bending

Reputation: 171

If you run your script locally you should see more detailed error information in the console output. Without knowing what your code does, it's hard to infer the error but it could be that tmp_0 is null, or is of zero length, or has a zeroth element that doesn't have a property called value. Your ?? operator wouldn't help with any of these cases.

Upvotes: 1

Related Questions