Cannot EXTRACT CSV file: exitcode=CsExitCode_StillActive Errorsnippet=


  • 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:

    VertexFailedFast. Vertex failure triggered quick job abort. Vertex failed: SV1_Extract[0][0] with error: Vertex user code error.
    Vertex failed with a fail-fast error
    Vertex failure triggered quick job abort. Vertex failed: SV1_Extract[0][0] with error: Vertex user code error.
    Vertex SV1_Extract[0][0].v1 {59B829BE-6582-4FC2-9088-E56098F17AD5} failed 
    Vertex user code error
    exitcode=CsExitCode_StillActive Errorsnippet=

    Friday, April 22, 2016 7:25 PM


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
  • 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.

    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
  • Info sent.
    Sunday, April 24, 2016 9:05 PM