none
Cannot EXTRACT CSV file: exitcode=CsExitCode_StillActive Errorsnippet=

    Question

  • I'm getting a generic error while trying to extract a CSV file, which I'm sure I've extracted successfully in the past. Also, the colour of the SV in the graph turns yellow, instead of the usual red when an error happens, so I'm not sure what's wrong:

    ERROR
    VertexFailedFast. Vertex failure triggered quick job abort. Vertex failed: SV1_Extract[0][0] with error: Vertex user code error.
    MESSAGE
    Vertex failed with a fail-fast error
    DESCRIPTION
    Vertex failure triggered quick job abort. Vertex failed: SV1_Extract[0][0] with error: Vertex user code error.
    RESOLUTION
    DETAILS
    
    Vertex SV1_Extract[0][0].v1 {59B829BE-6582-4FC2-9088-E56098F17AD5} failed 
    
    Error:
    Vertex user code error
    
    exitcode=CsExitCode_StillActive Errorsnippet=
    JOB URL
    https://brpxlaketest.azuredatalakeanalytics.net/jobs/ac3e1940-32de-4f1f-87a0-e9c8a50e1ccf?api-version=2015-11-01-preview

    Friday, April 22, 2016 7:25 PM

Answers

All replies

  • Yellow indicates that the job is retrying. So maybe the tool had not picked up yet that all retries failed.

    Until the portal is fixing its error display, I suggest to copy the job URL and open it from within the latest version of the Visual Studio tooling (2700 or later). That should show the error message.


    Michael Rys

    Friday, April 22, 2016 7:37 PM
    Moderator
  • I see. I use OSX, so I don't have access to visual studio, only the Code version, the xplat CLI, or the portal. Is there another way to look at the details of the error? Thanks for the help.
    Friday, April 22, 2016 8:10 PM
  • I managed to find the error through the CLI, but still this does not seem like a problem with the data. I've processed this file before with no error, and I have other files with the same structure that process with no problem.

    description: Invalid character is detected following the end text qualifier at line 1, column 1.
    A delimiter, row delimiter or EOF is expected.
    Delimiter{HEX}:2C
    HEX:222C3130342C312C382C2C223230383135222C22443136
                                  ^
    TEXT:",104,1,8,,"20815","D16
                      ^

    The line itself is:

    1459638008,"2016.04.03 00:00:08","2016.04.03 00:00:07",104,1,8,,"20815","D16DA1FF5F4015A1ECB5B8923A5261E0","35162006",30000,6300,23552

    I can't find any problem with the delimiters...

    Job ID: brpxlaketest ac3e1940-32de-4f1f-87a0-e9c8a50e1ccf


    Saturday, April 23, 2016 12:20 AM
  • Can you please send me a minimal repro of the file (what size is it? what is its encoding?) and the extract statement to my email (mrys at Microsoft). It looks like you should not have a problem from the sample above.

    Michael Rys

    Sunday, April 24, 2016 8:35 PM
    Moderator
  • Info sent.
    Sunday, April 24, 2016 9:05 PM